Request details
- WMDE would like to release metrics on how many users are coediting Wikidata on a monthly basis
- For now the data would go to the published datasets directory for WMDE Analytics as CSV files that are a select all from the resulting table of an Airflow DAG
- We'd eventually like this to be displayed in a public dashboard, but this is later
- Data would include one table with the total distinct coeditors across all projects
- Assumption is that since this is user data, we need to have the select statement that creates the check to see if any of the resulting values are <25 and replace them with "<25" if that's the case
- We've done something similar in T365699
- Related deployment tasks is T369117
Questions
Are you collecting and/or sharing data (with volunteers, grantees, or other external third party or the general public)?
- Yes
Who currently has access to this data?
- Individuals with private data access
How long are you retaining data or planning on retaining data?
- There is no plan to set a retention limit
Are you planning on using data in a new way or collecting more data than we already do?
- Yes
Describe what the data is, how it will be used, and any technical integrations required to use it.
An output of the data table would be along the lines of:
- wmde.wd_coeditors_distinct_monthly
| month | total_casual_wd_coeditors | total_casual_content_wd_coeditors | total_casual_non_content_wd_coeditors | total_active_wd_coeditors | total_active_content_wd_coeditors | total_active_non_content_wd_coeditors | total_very_active_wd_coeditors | total_very_active_content_wd_coeditors | total_very_active_non_content_wd_coeditors |
|---|---|---|---|---|---|---|---|---|---|
| datetime | int | int | int | int | int | int | int | int | int |
The columns above are:
- month: The month for which the metrics are computed over
- total_casual_wd_coeditors: The total number of users editing content pages on Wikidata and the given project (or all projects) with >=1 and < 5 edits in either project
- total_casual_content_wd_coeditors: The total number of users editing content pages on Wikidata and the given project (or all projects) with >=1 and < 5 edits in either project
- total_casual_non_content_wd_coeditors: The total number of users editing content pages on Wikidata and the given project (or all projects) with >=1 and < 5 edits in either project
- The same for the above with active editors and very active editors with >= 5 and < 100 edits and >= 100 edits respectively
Is this request urgent?
- No