jolly-raincoat-49731
11/16/2023, 2:45 PMpurchase
event AND get what experiment it was tied to.
So far, I have this query which pulls the experiment_viewed
and what experiment it is along with what variation. What I can't figure out is how to tie that to the purchase
event.
SELECT
user_id,
user_pseudo_id AS anonymous_id,
TIMESTAMP_MICROS(event_timestamp) AS timestamp,
(SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'experiment_id') AS experiment_id
FROM
`events_*`
WHERE
event_name = 'experiment_viewed'
AND
(SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'experiment_id') = 'products-aa'
AND
(SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'variation_id') = 0
;
I can just get the purchase event by itself too using event_name = 'purchase'
.
I feel I'm close, thanks for any help you can offer!brief-honey-45610
11/16/2023, 3:05 PMrhythmic-agent-34208
11/17/2023, 12:16 AMfresh-football-47124
jolly-raincoat-49731
11/17/2023, 2:04 PMfresh-football-47124
jolly-raincoat-49731
11/20/2023, 2:20 PMfresh-football-47124
jolly-raincoat-49731
11/27/2023, 2:13 PMrhythmic-agent-34208
11/28/2023, 1:25 AM