Request Status: New Request
Request Type: project support request
Related OKRs: Systems to succeed: Data
Request Title: New Data Pipeline for Unique Editor metrics by Country
- Request Description: We currently depend on the mediawiki_geoeditors_monthly table (or similarly calculated metrics) to determine the number of active editors on wiki projects each month. However, this table calculates unique editors at the project-level, which means that any editor who is active in multiple geographies or in multiple projects will be counted multiple times in any aggregated reporting. We’re interested in standing up a data pipeline for new aggregated tables that would enable accurate unique editor counts and editor retention metrics by country, regardless of project. GDI hopes to build these metrics into the public-facing DE&I dashboard that we plan to launch early next fiscal year.
- Indicate Priority Level: Medium
- Main Requestors: @CMacholan, @JAnstee_WMF, @KCVelaga_WMF, @ntsako
- Ideal Delivery Date: July 2022
- Stakeholders: Metrics that Matter working group, Regional Learning Session working group, Foundation and Movement leadership
Request Documentation
| Document Type | Required? | Document/Link |
| Related PHAB Tickets | Yes | https://phabricator.wikimedia.org/T304995 |
| Product One Pager | Yes | https://docs.google.com/document/d/1ciSyL-MT81anUS1jLmMa8e_4c9lmb_Ebs_-yQVLw_jY/edit |
| Product Requirements Document (PRD) | Yes | https://docs.google.com/document/d/1ciSyL-MT81anUS1jLmMa8e_4c9lmb_Ebs_-yQVLw_jY/edit |
| Product Roadmap | No | <add link here> |
| Product Planning/Business Case | No | <add link here> |
| Product Brief | No | <add link here> |
| OKR Execution Plan | No | https://docs.google.com/document/d/1rndxSGTDsKfqkHDXVPd9LyApJxRGvhl249uKErj8slM/edit#heading=h.g0dw83gghmc9 |