jolly-raincoat-4973111/16/2023, 2:45 PM
event AND get what experiment it was tied to. So far, I have this query which pulls the
and what experiment it is along with what variation. What I can't figure out is how to tie that to the
I can just get the purchase event by itself too using
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 feel I'm close, thanks for any help you can offer!
event_name = 'purchase'
brief-honey-4561011/16/2023, 3:05 PM
rhythmic-agent-3420811/17/2023, 12:16 AM
jolly-raincoat-4973111/17/2023, 2:04 PM
jolly-raincoat-4973111/20/2023, 2:20 PM
jolly-raincoat-4973111/27/2023, 2:13 PM
rhythmic-agent-3420811/28/2023, 1:25 AM