This will be used:
- on the Product page
- in the quarterly report
- in our quarterly review
The task for the previous quarter was T113824.
Monthly active editors
New active editors
New active editors: uses an editor month dataset. Unfortunately, when constructing the table, I didn't tag bot editors, so we can't exclude bot edits. However, since we're counting editors, not edits, the impact should be fairly minor.
SELECT month, COUNT(DISTINCT user_name) as "new active editors" FROM staging.editor_month WHERE month = LEFT(user_registration, 6) AND revisions >= 5 AND month >= "201001" GROUP BY month;
Wikipedia article edits, total and mobile
Total from Wikistats.
Mobile from these queries:
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.MobileWebEditing_8599025
WHERE
event_action = "success" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%" AND
event_namespace = 0
GROUP BY month;SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile app edits"
FROM MobileWikiAppEdit_9003125
WHERE
event_action = "saved" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%" AND
event_pageNS IS NULL
GROUP BY month;SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.`Edit_13457736`
WHERE
event_platform = "phone" AND
event_action = "saveSuccess" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%" AND
`event_page.ns` = 0
GROUP BY month;