[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. Yes, please look into this. The list of user agents will help us understand. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE, Manuel Cc:

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. @Manuel, the numbers have been updated in the description for the task :) The discrepancy is pretty dramatic, so I'm unsure if you have some info on why that could be or if we can attribute it to an overall adoption trend. Happy to look a bit more into it

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE, Manuel Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. Hi Andrew, if it's only code and non-sensitive aggregates it seems okay to document our work in progress here for now. We should however work on setting up a proper repository instead to avoid accidents. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Note that the above notebook is just aggregates and the queries used to get them. In those regards I felt like it was ok to share it via Phabricator for documentation of this task. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. The following is the current rendition of the quarterly reporting notebook. As the general plan is to shift to Grafana, I'd say that we're fine for now with this file. We can chat about this tomorrow, @Manuel! F37088074: quarterly_reporting.ipynb

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Note for a task to be done: [ ] I need to change the active editors query to be only based on an end date where the start date would be 30 days before. I'm unsure how exactly to do this in Presto. TASK DETAIL https://phabricator.wikimedia.org/T337245

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. @Manuel, the notebook's generally all ready. I'm not getting data results for one year ago for pages or admins for the current tables (I'm assuming this is the case for other rights metrics as well). We can check the output tomorrow and in that time I'll do

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Ultimately what needs to happen for the page data query: - The notebook needs to be changed over to a process that assumes that it is being ran at the start of the next quarter - We need to query information for specific snapshots only and not for all

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. My assumption would be that we need to use `page_namespace = 0` and `page_is_redirect = False`. Using the April snapshot, this gives us 101.785.388 which is very close to what we get on the Grafana data

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. @Manuel, current query is: SELECT COUNT(DISTINCT page_id) AS total_pages FROM wmf_raw.mediawiki_page WHERE wiki_db = 'wikidatawiki' -- Main namespace for wikibase-items. AND page_namespace

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. The numbers from above were using `wmf_raw.mediawiki_page`. What are you using to query? I can't access `wikidatawiki.page` via Presto. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. Are you looking for the same point in time? For `page_namespace = 0` the following should currently be 103,391,050 if executed on the Wikidata db. SELECT page_namespace AS namespace, page_is_redirect AS redirect, COUNT(*) AS count FROM

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. We're back to the `103,612,928` from before then :) Let me know if there are any other ways of subsetting that you can think of. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Thanks for the tip! Ya I was just using that at the start as I wasn't aware of namespaces :) TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. If this is about the "number of items per active editor" then it's only about Items. If this would have said entities instead, we would also include the other types of entities. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Accounting for namespaces brings us back up as we need `0` for main content, `120` for properties and `146` for lexemes. Current query: SELECT COUNT(DISTINCT page_id)

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. > We seem to be on the right path! :)  TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Generally in terms of content though we want wikibase-items, wikibase-properties and wikibase-lexemes for this, correct? TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. We seem to be on the right path! :) TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE, Manuel Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. The namespaces are project specific. You can find the the namespaces and IDs for Wikidata here: https://www.wikidata.org/wiki/Help:Namespaces#Table_of_Namespaces > And beyond that we'd also want page_is_redirect = 0? I do not know how the official metrics

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. I'm down to `103,612,928` with the value on the stats page again being `103,384,803` :) TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc:

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. And beyond that we'd also want `page_is_redirect = 0`? TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. So in looking at namespaces you mean we'd also subset by `namespace = 0` for the main namespace? TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. > Does the above distinction make sense to you? It may be better to go by page_namespace (we only want the content pages and not the discussion pages). Also, you could check what role redirects play. TASK DETAIL https://phabricator.wikimedia.org/T337245

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Current query: SELECT COUNT(DISTINCT page_id) AS total_pages FROM wmf_raw.mediawiki_page WHERE wiki_db = 'wikidatawiki' -- wikibase-item, wikibase-property, wikibase-lexeme AND

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Even with just `wikibase-item` we're getting `106,507,044` 樂 So there's some other kind of subsetting that needs to happen apparently. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. H and it's still overestimating given a subset on the above mentioned three 樂 Currently getting `107,609,517` instead of `103,384,803`. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. @Manuel, I'm getting the baseline query of all the items on Wikidata working well, but the issue is that I'm getting too many results based on the Wikidata statistics page . I think that the results from

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. Active editor notes via conversation with @Manuel: - There is a standard for active editors: "Registered, non-bot editors who have made five or more edits" is the specific definition. On a daily basis we're using a 30 day rolling average. What this

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Manuel added a comment. Great questions, let's discuss this in out session! Notes for myself: - aggregation - sanitization TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To:

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. I'm assuming that this is the case, but also wanted to check to make sure that for periods of more than 30 days we'd check to see if they'd edited five times in 30 days in that period rather than in any given month in that period. TASK DETAIL

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE added a comment. @Manuel, checking how to apply a definition of active editors in this case. We say that it's five edits in a month and specifically not a 30 day period, which makes this a bit more easy. From the perspective of a quarter (again so I can keep it in mind),

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T337245: Wikidata Quarterly Reporting Milestone 2 Aggregations

Maintenance_bot added a project: Wikidata. TASK DETAIL https://phabricator.wikimedia.org/T337245 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE, Maintenance_bot Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1,