Request
What's requested:
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.
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
select
user_name,
# 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
from
(select
user_name,
wiki,
local_user_id,
# special case to avoid unexpected choices of Wikidata as home wiki
if(wiki = 'wikidatawiki', sum(edits) * 0.1, sum(edits)) as edits
from staging.editor_month
where
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
) user_wiki
group by user_name;Ran the following query on all wikis using multiquery:
select database() as wiki, up_value as skin, count(*) as users from staging.neilpquinn_editor_year 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.