tall-branch-42668
11/15/2023, 8:53 PMrhythmic-agent-34208
11/15/2023, 8:54 PMtall-branch-42668
11/15/2023, 8:55 PMbrief-honey-45610
11/15/2023, 8:56 PMtall-branch-42668
11/15/2023, 10:16 PMbrief-honey-45610
11/15/2023, 10:39 PMdataset.table
-- let me know if that doesn't work for you thoughtall-branch-42668
11/15/2023, 10:50 PMevent_params
is query logic that GrowthBook had set already, not something I had input..brief-honey-45610
11/15/2023, 11:22 PMtall-branch-42668
11/16/2023, 8:08 PMSELECT
user_id as user_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
experiment_name,
experiment_variation AS variation_name,
geo.country as country,
traffic_source.source as source,
traffic_source.medium as medium,
device.category as device,
device.web_info.browser as browser,
device.operating_system as os
FROM
``puck-data-platform`.analytics
.`int_fct_ga_events*``
WHERE
-- ((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
-- (_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))
event_name = 'experiment-viewed'
-- AND experiment_id_param.key = 'experiment_id'
-- AND variation_id_param.key = 'variation_id'
AND user_id is not null
experiment_id_param.value.string_value AS experiment_id
and
<http://variation_id_param.value.int|variation_id_param.value.int>_value AS variation_id
in lines 4 and 5
But, we're unsure why these are important / and/or what they should be insteadrhythmic-agent-34208
11/16/2023, 10:27 PMbrief-honey-45610
11/16/2023, 11:40 PMtall-branch-42668
11/16/2023, 11:40 PMfresh-football-47124
tall-branch-42668
11/17/2023, 4:56 PMfresh-football-47124
tall-branch-42668
11/17/2023, 4:58 PMfresh-football-47124
tall-branch-42668
11/17/2023, 5:00 PMfresh-football-47124
SELECT
user_id as user_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
experiment_id_param.value.string_value AS experiment_id,
variation_id_param.value.int_value AS variation_id,
geo.country as country,
traffic_source.source as source,
traffic_source.medium as medium,
device.category as device,
device.web_info.browser as browser,
device.operating_system as os
FROM
`puck-data-platform`.`analytics`.`int_fct_ga_events*`,
UNNEST(event_params) AS experiment_id_param,
UNNEST(event_params) AS variation_id_param
WHERE
((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
(_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))
AND event_name = 'experiment_viewed'
AND experiment_id_param.key = 'experiment_id'
AND variation_id_param.key = 'variation_id'
AND ${userCol} is not null
tall-branch-42668
11/17/2023, 6:43 PMfresh-football-47124