This ticket is about creating a query to fetch the names of editors that are related to the improvements made to articles during the event.
Organizers want to motivate participants by giving credit. So the 'Pages Improved' report lists the usernames of each editor who improved a given article.
'Editors' metrics defined
The Pages Improved reports (T210775 and T210898) present lists of articles; for each article, we aim to provide the usernames of all qualifying users who worked on the story.
- Editors: Usernames of all editors who made edits to the page, consistent with all filters (e.g, if a Participants list is supplied, Editors must be on that list). In the Wikitext version of Pages Improved, the names are combined with URLs of the users' userpages (on the same wiki as the Page Improved), so that the names are links. On the CSV version, no links are provided
- Pages Improved: Main space pages edited during the event in the specified wikis and consistent with whichever filters are active (Participant and/or Category and/or Worklist). Note: Pages Improved and Pages Created are mutually exclusive categories; Pages Improved does not include Pages Created, and the total of the two would equal all pages worked on during the event.
Note on fixed vs. continuing metrics.
- The 'Editors' metric remains fixed once the event period ends. I.e., after the close of the event, subsequent editors are not of interest.
Related ticket
Please see T208546, which seeks a method that seems highly related to this one.
NOTE: there was some concern expressed during Estimation about how difficult it might be to get and present this data. If getting the usernames and putting them into a table turns out to be very challenging, then let's talk about alternative approaches.