cchen added a comment.
The draft dashboard <https://superset.wikimedia.org/superset/dashboard/310/> have the following monthly metrics available from Jun 2020 - Dec 2021: Captions - Number of files with captions added monthly - Number of files with non-English/English captions added monthly - Number of files with both captions added monthly - How quickly after creation do non-English captions get added? SDC edits - Number of SDC and non-SDC edits monthly - Time to edit for SDC For caption-related metrics, we use `mediawiki_history` table to calculate the captions added per month. For a total number of files with captions, we decide to calculate it after the entity table is created. For SDC edits metrics, I chose to ignore whether these edits were reverted as I've previously found that reverts of these are rare (as are removals). For wikitext edits, they have to also not be a revert nor be reverted (within the common timeframe of 48 hours) as those are either reinstating an old version of the page or an unproductive edit. In addition, these are all non-bot edits, and we only count edits to files that have not been deleted. TASK DETAIL https://phabricator.wikimedia.org/T252443 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: cchen Cc: kzimmerman, nettrom_WMF, GFontenelle_WMF, Abit, Ramsey-WMF, CBogen, EChetty, toberto, ldelench_wmf, Invadibot, maantietaja, Y.ssk, FRomeo_WMF, Muchiri124, Nintendofan885, Akuckartz, Nandana, JKSTNK, Lahi, Gq86, E1presidente, Cparle, Anoop, SandraF_WMF, GoranSMilovanovic, QZanden, Tramullas, Acer, LawExplorer, Salgo60, Silverfish, Poyekhali, _jensen, rosalieper, 4nn1l2, Taiwania_Justo, Scott_WUaS, Susannaanas, Ixocactus, Wong128hk, Jane023, Wikidata-bugs, Base, matthiasmullie, aude, El_Grafo, Dinoguy1000, Ricordisamoa, Wesalius, Lydia_Pintscher, Raymond, Steinsplitter, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org