[DE 1.1.9] Include edit count in experiment_assignment_v1
Closed, ResolvedPublic2 Estimated Story Points
Actions

Assigned To

Authored By

	mpopov
	Jul 28 2026, 2:33 PM

Project Tags

Referenced Files

None

Subscribers

Aklapper

mpopov

Description

Once experiment_exposure events start including performer_edit_count contextual attribute, we need to alter wmf_experiment.experiment_assignment_v1 table to include that information so it can be used in GrowthBook.

CREATE TABLE query: https://gitlab.wikimedia.org/repos/product-analytics/data-pipelines/-/blob/main/growthbook/create_experiment_assignment_table_iceberg.hql?ref_type=heads
INSERT INTO query: https://gitlab.wikimedia.org/repos/product-analytics/data-pipelines/-/blob/main/growthbook/experiment_assignment_query_iceberg.hql?ref_type=heads
DAG: https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/blob/main/analytics_product/dags/growthbook/growthbook_hourly_dag.py?ref_type=heads

Acceptance criteria

experiment_assignment_v1 table includes and populates column local_edit_count (using values from performer.edit_count)

Related Objects
Search...

Status	Assigned	Task
Open	None	T429961 [EPIC] Convert TK UI Experiment interface to read-only
Open	None	T433646 [Epic] Experiment-Ready Metrics
Open	mpopov	T433380 [DE 1.1.9] Constructive edit metric in GrowthBook
Resolved	mpopov	T433322 [DE 1.1.9] Define constructive edit-based metrics in GrowthBook
Invalid	Ahoelzl	T433379 [DE 1.1.9] Iceberg table of constructive edits
Resolved	cjming	T431493 [DE 1.1.9] An instrument that produces edit_survived events
Resolved	mpopov	T434576 [Spike] Evaluate incremental MWH for use in GB
Resolved	mpopov	T433381 [DE 1.1.9] Add edit count-based dimensions in GB
Resolved	mpopov	T433384 [DE 1.1.9] Include edit count in experiment_assignment_v1
Resolved	cjming	T433386 [DE 1.1.9] Include performer_edit_count in exposure events
Resolved	mpopov	T434733 [DE 1.1.9] Run A/A tests
Resolved	cjming	T436175 [DE 1.1.9] Decommission constructive-edits instrument
Open	None	T437654 Constructive Activation metric in GrowthBook

Event Timeline

mpopov created this task.Jul 28 2026, 2:33 PM

mpopov created subtask T433386: [DE 1.1.9] Include performer_edit_count in exposure events.Jul 28 2026, 2:36 PM

mpopov triaged this task as Medium priority.Jul 28 2026, 2:56 PM

mpopov set the point value for this task to 2.

JVanderhoop-WMF raised the priority of this task from Medium to High.Jul 28 2026, 3:39 PM

KReid-WMF edited projects, added: Test Kitchen (Experiment Platform Sprint 27); removed: Test Kitchen.Jul 29 2026, 3:16 PM

mpopov claimed this task.Jul 29 2026, 3:18 PM

JVanderhoop-WMF added a parent task: T433646: [Epic] Experiment-Ready Metrics.Jul 30 2026, 10:19 PM

KReid-WMF closed subtask T433386: [DE 1.1.9] Include performer_edit_count in exposure events as Resolved.Aug 6 2026, 8:09 PM

KReid-WMF edited projects, added: Test Kitchen (Experiment Platform Sprint 28); removed: Test Kitchen (Experiment Platform Sprint 27).Aug 6 2026, 8:26 PM

mpopov moved this task from Ready for Development to In Progress on the Test Kitchen (Experiment Platform Sprint 28) board.Aug 11 2026, 3:13 PM

bearloga opened https://gitlab.wikimedia.org/repos/product-analytics/data-pipelines/-/merge_requests/57

Resolve T433384

bearloga merged https://gitlab.wikimedia.org/repos/product-analytics/data-pipelines/-/merge_requests/57

growthbook: Add user_edit_count to experiment assignment query

bearloga opened https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2536

analytics_product/growthbook: update HQL URIs

$ sudo -u analytics-product kerberos-run-command analytics-product spark3-sql \
 -e "ALTER TABLE wmf_experiments.experiment_assignment_v1 ADD COLUMN user_edit_count bigint COMMENT 'Total number of local wiki edits'"

$ spark3-sql -e "DESCRIBE wmf_experiments.experiment_assignment_v1"
col_name	data_type	comment
subject_id	string	Experiment subject identifier
timestamp	timestamp	Event time (year-month-day hour:00:00.000)
experiment_id	string	Experiment enrolled (experiment identifier)
variation_id	string	Experiment assigned variation
user_auth_status	string	User authentication status (Bot, Temporary user, Permanent user, Logged-out user, or Unknown)
user_platform	string	Desktop or Mobile
mediawiki_skin	string	MediaWiki skin
wiki_name	string	English name of wiki (e.g. Bangla Wikipedia)
wiki_id	string	Database code of wiki (e.g. bnwiki)
language	string	Language of wiki (e.g. Bangla)
project_family	string	Wiki group (e.g. wikipedia)
user_edit_count	bigint	Total number of local wiki edits
		
# Partitioning		
Part 0	days(timestamp)

bearloga merged https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2536

analytics_product/growthbook: update HQL URIs

Maintenance_bot removed a project: Patch-For-Review.Aug 17 2026, 9:30 PM

mpopov updated the task description. (Show Details)Tue, Aug 18, 2:43 PM

mpopov moved this task from In Progress to Done on the Test Kitchen (Experiment Platform Sprint 28) board.

KReid-WMF closed this task as Resolved.Mon, Aug 24, 3:07 PM

[DE 1.1.9] Include edit count in experiment_assignment_v1Closed, ResolvedPublic2 Estimated Story PointsActions

Description

Acceptance criteria

Related ObjectsSearch...

Event Timeline

[DE 1.1.9] Include edit count in experiment_assignment_v1
Closed, ResolvedPublic2 Estimated Story Points
Actions

Related Objects
Search...