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.

As of now the WDQM is using sitelink information that comes from this wiki page. The calculation that's included there is potentially not representative of the exact metric we want to include in the Wikidata Quality Metric, so we should develop a version that matches it and can also be included in a global metric based on data lake data.

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.

• Create a pipeline to calculate the proportion of items with a sitelink to all items
• Add this metric to the WDQM

By When (Timing & Priority)

Provide a clear deadline, any key milestones (e.g. launch, leadership review), and note if timing is flexible or fixed.

DD.MM.YYYY

---

Information below this point is filled out by the analyst.

Sub Tasks

A breakdown of the steps to complete this task.

Data Pipeline Creation

• Define metric(s) to be derived from the new / updated data pipeline
• Define output table columns with stakeholder(s)
• Write job queries or code
• Test job queries or code
• Write Airflow DAG
• Test and deploy Airflow DAG
• Create Superset dashboard

Finishing Up

• Required documentation is written
• The task is moved to Delivered with the stakeholder being assigned and CCed in a comment

Data

The tables that will be referenced in this task and the sample sizes from them that will be used.

• wmf.wikidata_entity