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

[Manuel]

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: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 to see where the new traffic is coming from :)

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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 PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE, Manuel
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 


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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 some more deep dives into the data to see if I can 
figure out where more long term data is kept :) Looks like we have a fair 
number of people in SWE Data now (🙌🙌), so we can also check in there after a 
discussion tomorrow.

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 
pages
- This has been causing an overestimate because of the inclusion of pages 
that are deleted in recent snapshots given that we're querying based on 
`DISTINCT page_id`
  - I also need to add the information for one year ago (depending on 
availability)
  - I need to calculate values for active users
  - I need to make the final table by doing the needed arithmetic

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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 

 (101.777.563 for 30. April 2023). So I believe this number should be fine.
  
query = """
SELECT 
  page_namespace AS namespace,
  page_is_redirect AS redirect,
  COUNT(*) AS count
FROM 
wmf_raw.mediawiki_page
WHERE 
wiki_db = 'wikidatawiki'
AND snapshot = '2023-04'
AND
(page_namespace = 0
OR page_namespace = 1
OR page_namespace = 120
OR page_namespace = 146
OR page_namespace = 640)

GROUP BY page_namespace, page_is_redirect
"""
df = wmf.presto.run(commands=query)
df.head()
  
  gives me
  
namespace   redirectcount
0   120 False   10977
1   146 False   1077831
2   0   True4031149
3   0   False   101785388
4   1   True52
5   146 True13533
6   1   False   36683
7   640 False   367

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 = 0
AND page_is_redirect = false

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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 wikidatawiki.page
WHERE page_namespace = 0
OR page_namespace = 1
OR page_namespace = 120
OR page_namespace = 146
OR page_namespace = 640
GROUP BY page_namespace, page_is_redirect

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE, Manuel
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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) AS total_pages

FROM 
wmf_raw.mediawiki_page

WHERE 
wiki_db = 'wikidatawiki'
-- wikibase-item, wikibase-property, wikibase-lexeme
AND page_content_model LIKE 'wikibase%'
AND (
page_namespace = 0
OR page_namespace = 120 
OR page_namespace = 146
)
AND page_is_redirect = false
  
  Current value: `104,702,674`

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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 are defined without seeing their SQL 
queries. Wikidata itself seems to do a split by that variable: 
  
https://phabricator.wikimedia.org/diffusion/ADES/browse/master/src/wikidata/site_stats/sql/select_pages_by_namespace.sql
  
  So for reverse engineering, you could compare the numbers. ;)

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE, Manuel
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 page_content_model LIKE 'wikibase%'

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 mediawiki_page 
 need to be subsetted based 
on `page_content_model`, with the general idea being that I'd only query pages 
with the following content models:
  
  - wikibase-item
  - wikibase-property
  - wikibase-lexeme
  
  The other options in this column are:
  
  - wikitext
  - flow-board
  - EntitySchema
  - javascript
  - css
  - Scribunto
  - sanitized-css
  - json
  
  Does the above distinction make sense to you?

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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 would be on a monthly and 
quarterly basis is still not defined.
- We need to check Data_Lake/Edits/Metrics 
 to see 
if there is some precomputed data
- Ideally we'd be working from sanitized tables (processed data) if they 
are available (`wmf` tables rather than `wmf_raw`)
- It would be interesting to find the code that generates the Wikimedia 
Statistics pages 
, 
specifically the precomputed values

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Manuel]

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: AndrewTavis_WMDE, Manuel
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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
  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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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), would someone be counted as being an active editor if 
they had been an active editor in any of the months in the quarter?

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[AndrewTavis_WMDE]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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

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

[Maintenance_bot]

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, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
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