Page MenuHomePhabricator

Request Android and iOS counts for users in sysop and rollbacker groups
Open, MediumPublic

Description

Background

The Android team is planning to bring Patroller tasks into the apps. To start defining this feature and understanding pay points of our prospective users we want to understand which languages should be our target languages for this project starting out.

The Task
[ x ] Answer how many Android and iOS editors in the top 20 edited wikis have sysop or rollbacker permissions?
[ x ] # of sysop / rollbackers by wiki
[ x ] Overlap of unique users that have sysops or rollback permissions across multiple languages and what those languages are

Event Timeline

Using editor data from mediawiki_history from 2022-04-01 to 2022-09-31 we have determined the following sysop/rollbacker uniques counts:

Android Editor Count:
371 Unique Editors

iOS Editor Count:
176 Unique Editors

Android Top 20 Wikis:

WikiCount Sysop/Rollbacker Editors
English181
Spanish13
German5
Italian7
French20
Russian41
Japanese1
Chinese16
Indonesian11
Arabic8
Turkish0
Hebrew3
Korean4
Persian5
Portuguese8
Polish3
Ukrainian18
Bangla10
Malay0
Dutch0

iOS Top 20 Wikis:

WikiCount Sysop/Rollbacker Editors
English143
Japanese2
French4
German0
Italian1
Chinese8
Russian12
Korean0
Spanish2
Turkish1
Dutch2
Arabic0
Swedish4
Hebrew1
Vietnamese0
Kyrgyz0
Ukrainian3
Portuguese5
Polish3
Persian3
Finnish1

The methodology for collecting this data was first collecting every editor who made an Android or iOS edit on the Top 20 most edited wikis by OS first - from 2022-04-01 to 2022-09-31.

The second step was to then match those users with ANY revisions made where the same user was in the sysops or rollbacker group (field is event_user_groups_historical), on any wiki. The tables that show active sysops/rollbackers only include the Top 20 wikis, there were many other wikis where editors had permissions not listed here.

Anonymized data:
https://docs.google.com/spreadsheets/d/18bfzozUf-bid7vN8a-1l4MtPpc1_23hHhgJybGRowCU/edit#gid=1191879366

Thanks to @Samwalton9 for guidance on locating the sysop/rollbacker designation.

Android Editor Wiki Overlap:
189 Android sysop/rollbackers showed activity in more than one Wiki during the time period queried.
See https://docs.google.com/spreadsheets/d/18bfzozUf-bid7vN8a-1l4MtPpc1_23hHhgJybGRowCU/edit#gid=1476605349

iOS Editor Wiki Overlap:
35 iOS sysop/rollbackers showed activity in more than one Wiki during the time period queried.
See: https://docs.google.com/spreadsheets/d/18bfzozUf-bid7vN8a-1l4MtPpc1_23hHhgJybGRowCU/edit#gid=1476605349

Next step is for @SNowick_WMF and @Seddon to do a quality check on the query to account for conventions related to having the rollbacker designation on Non-EN wiki (Ex. German) and for @SNowick_WMF to consider proportionally who has higher rollbackers iOS vs Android.

Enabled editor distribution by Platform comparison:

PlatformTotal EditorsEnabled Editors% Enabled
Android806933720.46%
iOS398941760.44%

Of the Android and iOS editors polled who later appeared in mediawiki_history with membership in sysop or rollbacker group status.

Note these numbers may change once we revise counts based on German Wikipedia group status queries since they do not use rollbacker group distinction.