quick-ability-87647
08/13/2025, 11:47 PMRUN_VISUAL_EXPERIMENTS @ edge vs browser is?strong-mouse-55694
08/14/2025, 7:53 PMaloof-piano-56796
08/18/2025, 11:15 PMhappy-autumn-40938
08/19/2025, 5:11 PMaloof-piano-56796
08/20/2025, 5:01 AMhappy-autumn-40938
08/20/2025, 6:04 AM__experimentUnits AS (
-- One row per user
SELECT
e.ga_user_pseudo_id AS ga_user_pseudo_id,
(
CASE
WHEN count(distinct e.variation) > 1 THEN '__multiple__'
ELSE max(e.variation)
END
) AS variation,
MIN(e.timestamp) AS first_exposure_timestamp
FROM
__experimentExposures e
GROUP BY
e.ga_user_pseudo_id
),
The "GROUP BY" ensures that only the first event is considered (and that multiple exposed users are excluded from analysis).happy-autumn-40938
08/20/2025, 6:08 AMaloof-piano-56796
08/27/2025, 1:37 AM