worried-yacht-64692
05/17/2023, 2:13 PMfresh-football-47124
worried-yacht-64692
05/17/2023, 2:30 PMvalue_param.value.int_value as value
fresh-football-47124
worried-yacht-64692
05/17/2023, 2:51 PMfresh-football-47124
worried-yacht-64692
05/17/2023, 3:43 PMSELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
value_param.value.int_value as value
FROM
`GOOGLE_CLOUD_PROJECT_ID`.`BIG_QUERY_DATA_ID`.`events_*`,
UNNEST(event_params) AS value_param
WHERE
event_name = 'add_to_cart'
AND value_param.key = 'value'
AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
fresh-football-47124