Wikimedia Product/Data dictionary

This page collects definitions of core metrics and quantitative annual plan goals of the Wikimedia Product department which are tracked by the Product Analytics team.

Core metrics
A set of key metrics designed to give a high-level picture of the movement's health. These are reported monthly to the Wikimedia Foundation board and at Wikimedia_Product, with further analysis in the quarterly metrics & insights presentations.

Content
The code that calculates these metrics can be found in the Editing-movement-metrics repository on Github.

Editors
The code that calculates these metrics can be found in the Editing-movement-metrics repository on Github.

Readers
The code that calculates these metrics can be found in the readers-movement-metrics repository on Github.

Diversity
A set of contributors and readers metrics (defined above), restricted to:


 * Established Market (Global North Countries) and Emerging Market (Global South Countries) : definition
 * Mobile-heavy wikis: definition

Annual plan metrics and targets
Team-level and department-level goals derived from the 2018/19 Audiences annual plan.

Web team
Objective: Advanced mobile contributions (AMC) (cf. annual plan)


 * Mobile web edit rate on target wikis: 10% increase
 * List of target wikis
 * Mobile web edits are defined using the existing edit tag (example)
 * Increase is measured using new AMC edit tag (example)
 * Retention rate for opt-in advanced mobile mode amongst medium and high-volume editors (100+ edits previous month): At least 60% retention
 * via instrumenting opt-in/opt-out button (data recorded in the PrefUpdate schema)
 * Retention period TBD
 * Moderation actions on mobile web on target wikis: 10% increase
 * Definition of "moderation action": T213461
 * Definition of target wikis: see above

For more links to implementation tasks and technical details, see this overview task.

iOS team

 * Total iOS app edit count: 10% increase
 * Editor retention (exact definition TBD as of March 2019): 10% increase

See Wikimedia_Apps/Team/iOS/Editing_program for details.

Android team

 * Total Android app edit count (mirroring iOS definition): 10% increase
 * Android Contributor Retention Rate (exact definition TBD as of March 2019): 10% increase
 * New Editor Acquisitions, defined as first-time edits on the Android app: 10% increase

Anti-Harassment Tools team
The AHT team is part of the cross-department Community health initiative.

Selection of annual plan metrics is being revisited as of March 2019 (for the original draft version, see Community_health_initiative/Annual_plan_FY18-19, Outcome 1)

Language team
Objective: Content translation (cf. annual plan):
 * Surviving translations by newcomers: metric defined in T194650, target TBD as of April 2019
 * Newcomers using Content Translation: metric defined in T194641, target TBD as of April 2019
 * Success and failure rates for newcomers using Content Translation: metric defined in T194647, target TBD as of April 2019
 * Newcomer retention after their first translation: metric defined in T195949, target TBD as of April 2019

Objective: Improve Translate extension & translatewiki.net process (cf. annual plan)

Growth team
Objective: Human-to-human help (cf. annual plan)
 * Main metric: Second-month(?) new contributor retention in Czech and Korean Wikipedias (see T201656). Target: 10% increase (as in original annual plan), measured using A/B tests

Editing Team
Objective: Simpler editing on mobile web + apps (cf. annual plan)


 * Mobile visual editing edit completion rate: 10% increase
 * Metric definition: T202134
 * Number of mobile visual edits: 10% increase
 * Metric definition: number of saved edits tagged with and
 * Number of editors using the mobile visual editor: 10% increase
 * Metric definition: number of distinct editors making mobile web visual edits in a month.

See this overview task for more details.

Datasets in Superset/Turnilo

 * edit_hourly : Table contains edits data, aggregated hourly
 * mediawiki_history_reduced : A light version of mediawiki_history. Table only contains data of revisions which is not deleted by page deletion.
 * virtualpageviews_hourly : Table contains virtual pageviews data, aggregated hourly.
 * pageviews_hourly : Table contains pageviews data, aggregated hourly.
 * pageviews_daily : Table contains pageviews data, aggregated daily.
 * unique_devices_per_domain_daily : Table contains unique devices counts per domain, aggregated daily.
 * unique_devices_per_domain_monthly : Table contains unique devices counts per domain, aggregated monthly.
 * unique_devices_per_project_family_daily : Table contains unique devices counts per project family, aggregated daily.
 * unique_devices_per_project_family_monthly : Table contains unique devices counts per project family, aggregated monthly.
 * mediawiki_geoeditors_monthly : Table contains private data of editors counts by country region, aggregated monthly.