WMDE Analytics Request
This task was generated using the WMDE Analytics request form. Please use the task templates linked on our project page to create tasks for the team. Thank you!
Why (Context & Decision)
What problem are you trying to solve, and what decision will this analysis inform? Briefly explain the organisational or strategic context, why this matters now, and what action will be taken based on the outcome.
We need to better understand trends in the creation of non-notable Items to support admins and patrollers more. This is important for our KR work with users with extended rights and the work on combating promotional editing (editing to ensure edits are featuring highly for SEO / availability for Gen AI - which is unsustainable).
Additional context for this task: it relates to the wider Data Governance support WMDE wants to provide. Specifically supporting notability guidelines. https://docs.google.com/document/d/1XksiQ_8UUbo9g4vJfiHCpC07LzOwzfjSAB3IPy9jdcg/edit?tab=t.0#heading=h.cwk2ngiagshf && https://docs.google.com/spreadsheets/d/1_SWgeoRQAbJQCiQ-IuYeZH26u7nbVCzz8WVgbr3Qfds/edit?gid=0#gid=0
What (Scope & Output)
Describe the specific question(s), metrics, segments, or deliverables (e.g., dashboard, deep dive, experiment analysis), including any relevant definitions or constraints.
Questions:
For a given month...
- How many new Items were created in that time period?
- How many new Items were created by new accounts/accounts with few edits/... (Do we have a good standard criteria here?) in that time period?
- How many of the new Items created that month have already been deleted since then?
- How many of the new Items created by new accounts/.../... have already been deleted since then?
- Output: dashboard with a graph of the above metrics over time with absolute and relative numbers
Example output as table:
| month | Items created (total) | Items created by new accounts | Items deleted | Items created by new accounts deleted | Percentage of Items that were deleted | Percentage of Items created by new accounts that were deleted |
| Jan 2026 | 100 | 50 | 25 | 25 | 50 | 100 |
Note: Item creations by IP should probably be treated as if they were coming from a registered account for this.
Note (i): New accounts we will define as <50 edits. We discussed also to potentially break this edit count down further / create edit groupings.
Note (ii): We ideally want a lookback / data showing 2025-2026. Please be aware though that the Google AI summaries were ramped up March 2025, so we might (if possible) also extend back to 2024...
By When (Timing & Priority)
Provide a clear deadline, any key milestones (e.g. launch, leadership review), and note if timing is flexible or fixed.
ASAP but no later than 2026-07-15
Information below this point is filled out by the analyst.
Sub Tasks
A breakdown of the steps to complete this task.
- Ticket refinement / check with requester.
- Table / source data check: wmf.mediawiki_history - any others?
- Query prepared.
- Query run... Will not be a DAG, so check best way to build the table / or just run in Superset?
- Dashboard / output prepared.
- Discussion with Lydia about the output / data.
Estimation
Estimate:
Actual:
Data
The tables that will be referenced in this task and the sample sizes from them that will be used.
- wmf.mediawiki_history
