Lydia_Pintscher added a comment.
In T281356#7095576 <https://phabricator.wikimedia.org/T281356#7095576>, @Michael wrote: > In T281356#7094642 <https://phabricator.wikimedia.org/T281356#7094642>, @Ladsgroup wrote: > >> [...] >> >> Notable differences I noticed: >> >> - [...] >> - The values of talk namespaces differ a lot. The old script says only 20 edits happened on talk pages for that day, while the new script says 1K edits happened. >> - [...] > > The existing SQL of the old script <https://github.com/wikimedia/analytics-wmde-scripts/blob/8a5b0a2cb0d5ed38b8c323f58f704239c288947b/src/wikidata/site_stats/sql/recent_changes_by_namespace.sql> includes this line in its `WHERE` clause: > > AND rc_source = 'mw.edit' > > I'm not perfectly sure what it does, but maybe that explains the lower numbers? > > Edit: rc_source <https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_source> records the type of the change. So it would seem to make sense to, for example, exclude log actions. Though that documentation is somewhat vague on the set of possible values and whether we maybe want to record more than only `mw.edit`? Hmmm I'd say we don't want to count log actions as edits for the purpose of the stats required here. TASK DETAIL https://phabricator.wikimedia.org/T281356 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, Lydia_Pintscher Cc: Lydia_Pintscher, Michael, DVrandecic, Aklapper, amy_rc, Invadibot, Lalamarie69, maantietaja, Alter-paule, Hazizibinmahdi, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, Kent7301, alaa_wmde, joker88john, CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org