Page MenuHomePhabricator

Global Editor Metrics - backfill pageview metric data
Closed, ResolvedPublic

Description

Once we are able to compute ongoing daily editor metrics for WE3.3.7 in T405039: Global Editor Metrics - Data Pipeline, we will need to backfill data in Cassandra from 2025-01-01.

We have mediawiki.page_change.v1 events in the event_sanitized database since late 2024. However, the user_central_id field added in T403664: EventBus - Add central user id to MediaWiki events is not available before 2025-09-19. This field is required to compute global editor metrics.

Once T365648: Add user_central_id to mediawiki_history and mediawiki_history_reduced Hive tables is done, we can backfill from mediawiki_history.

Done is

  • Editor metrics tables in Cassandra are backfilled starting 2025-01-01.

Event Timeline

Ottomata renamed this task from Global Editor Metrics - backfill data to Global Editor Metrics - backfill pageview metric data.Nov 3 2025, 5:16 PM
Ottomata updated the task description. (Show Details)
amastilovic updated the task description. (Show Details)