Page MenuHomePhabricator

Add performer_pageview_id contextual attribute to web base stream
Closed, ResolvedPublic1 Estimated Story Points

Description

The generic CTR metric "Clickthrough per page visit" (established in T394841) depends on pageview ID:

WITH per_page_interactions AS (
  SELECT
    IF(experiment.assigned = 'control', 'control', 'treatment') AS variation,
    experiment.subject_id,
    performer.pageview_id,
    CAST(SUM(IF(action = 'click', 1, 0)) > 0 AS INT) AS clicked_through
  FROM {table}
  WHERE action IN('impression', 'click')
    AND {where_boilerplate}
  GROUP BY 1, 2, 3
)
SELECT
  variation,
  subject_id,
  AVG(clicked_through) AS outcome
FROM per_page_interactions
GROUP BY 1, 2

In order for teams to use it in their experiments, we need the performer_pageview_id contextual attribute collected in product_metrics.web_base stream.

Event Timeline

Milimetric triaged this task as Medium priority.Jun 10 2025, 3:27 PM
Milimetric moved this task from READY TO GROOM to BACKLOG on the Test Kitchen board.
Milimetric lowered the priority of this task from Medium to Low.Jun 10 2025, 3:29 PM
Milimetric moved this task from BACKLOG to Backlog on the Test Kitchen board.

Per @mpopov: This blocks the calculation of the click-throughs per pageview metric. We're not aware of any experiments that require this metric now and in the near future.

Change #1156872 had a related patch set uploaded (by Phuedx; author: Phuedx):

[operations/mediawiki-config@master] ext-EventStreamConfig: Update product_metrics.web_base stream

https://gerrit.wikimedia.org/r/1156872

Change #1156872 merged by jenkins-bot:

[operations/mediawiki-config@master] ext-EventStreamConfig: Update product_metrics.web_base stream

https://gerrit.wikimedia.org/r/1156872

Mentioned in SAL (#wikimedia-operations) [2025-06-16T13:08:46Z] <phuedx@deploy1003> Started scap sync-world: Backport for [[gerrit:1156872|ext-EventStreamConfig: Update product_metrics.web_base stream (T395692)]], [[gerrit:1127960|Set $wgCentralAuthAutomaticGlobalGroups for global IP reveal group (T376315)]], [[gerrit:1153307|Enable temporary accounts onboarding dialog on WMF wikis (T395933)]], [[gerrit:1139808|Change citoid config for test wiki (T361576)]]

Mentioned in SAL (#wikimedia-operations) [2025-06-16T13:10:40Z] <phuedx@deploy1003> phuedx, mvolz, dreamyjazz, tchanders: Backport for [[gerrit:1156872|ext-EventStreamConfig: Update product_metrics.web_base stream (T395692)]], [[gerrit:1127960|Set $wgCentralAuthAutomaticGlobalGroups for global IP reveal group (T376315)]], [[gerrit:1153307|Enable temporary accounts onboarding dialog on WMF wikis (T395933)]], [[gerrit:1139808|Change citoid config for test wiki (T361576)]] synced to t

phuedx raised the priority of this task from Low to High.Jun 16 2025, 2:13 PM
phuedx set the point value for this task to 1.

I've been bold and bumped the priority of this task to High as Moderator Tools will be running their first experiment within the next two weeks.