= Request =
Wikipedia's preferences offer you due to historical reasons under the Preferences > Appearance tab four skins to choose from besides the default Vector.
**Why it's requested:**
We're still offering CologneBlue, Modern, MonoBook options aside of Vector and it would be great to have a better understanding of our users.
I'm aware of the statistics provided by https://wikiapiary.com/wiki/Skin:Skins but from my understanding there are just installed skins counted. It would be interesting to get the number of active users (maybe something like skin setting and being repeatedly logged in during last 12 months)
**When it's requested:**
No current deadline to fulfill here.
**Other helpful information:**
= Results =
The skins listed are what the users actually //see//, which will be one of the four installed—old values like 'chick' that fall back to the default skin have been modified to reflect that. The users in each section are //all// the users who met the edit threshold when their edits from the past year were summed across all projects. Each user's skin was checked on the wiki where they made the most edits during the year (for both the edit threshold and home wiki identification, Wikidata edits were each treated as 1/10th of an edit to account for the greater granularity of edits there). Full data is in [this spreadsheet](https://docs.google.com/spreadsheets/d/1RgQCL3Z4SLTkhcDJxTYULJ1GcCgX7GtlKLKUCiKFkkg/edit#gid=0).
== Very active editors ==
Users with at least 600 edits during the past year.
| skin | users | % of total
| ---- | ---- | ----
| vector | 21 253 | 88.2%
| monobook | 2 544 | 10.6%
| modern | 243 | 1.0%
| cologneblue | 49 | 0.2%
| **total** | 24 089 | 100.0%
== Active editors ==
Users with at least 30 edits during the past year.
| skin | users | % of total
| vector | 150 903 | 94.5%
| monobook | 7 475 | 4.7%
| modern | 1 035 | 0.6%
| cologneblue | 324 | 0.2%
| **total** | 159 737 | 100.0%
== All editors ==
Users with at least 1 edit during the past year.
| skins | users | % of total
| vector |1 885 390 | 97.5%
| monobook | 39 898 | 2.1%
| modern | 6 219 | 0.3%
| cologneblue | 2 544 | 0.1%
| **total** | 1 934 051 | 100.0%
== Methods =
Created an intermediate table using the following query:
create table staging.neilpquinn_editor_year
# wiki relies on the DB system taking the first value in each group
wiki as home_wiki,
local_user_id as home_user_id,
sum(edits) as adjusted_edits
# special case to avoid unexpected choices of Wikidata as home wiki
if(wiki = 'wikidatawiki', sum(edits) * 0.1, sum(edits)) as edits
month >= '2015-11-01' and month < '2016-11-01' and
local_user_id != 0 and
bot = 0
group by user_name, wiki
order by user_name asc, edits desc
group by user_name;
Ran the following query on all wikis using multiquery:
database() as wiki,
up_value as skin,
count(*) as users
left join user_properties
on home_user_id = up_user and up_property = "skin"
where home_wiki = database()
group by up_value;
multiquery ~/queries/skins_all_editors.sql -d ~/dblists/all_wikis.tsv -h analytics-store.eqiad.wmnet --defaults-file=~/.my.cnf > ~/data/skins_all_editors.tsv
Then repeated the multiquery, filtering first for >= 30 and then >= 600 edits.