jolly-raincoat-49731
11/06/2023, 7:56 PMSELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp
FROM
`database`.`analytics_12345`.`events_*`
WHERE
event_name = 'purchase'
AND ((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
(_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))
Then I have view_cart
as my denominator. This is trying to setup the one in the docs, % checkout / % viewed cart
. We use GA4/BigQuery as our data source.
Is this correct?rhythmic-agent-34208
11/06/2023, 7:56 PMbrief-honey-45610
11/06/2023, 9:46 PMjolly-raincoat-49731
11/06/2023, 9:46 PMrhythmic-agent-34208
11/06/2023, 11:29 PMjolly-raincoat-49731
11/07/2023, 2:06 PMbrief-honey-45610
11/07/2023, 5:16 PMjolly-raincoat-49731
11/07/2023, 5:17 PMrhythmic-agent-34208
11/07/2023, 9:08 PMjolly-raincoat-49731
11/08/2023, 2:00 PMrhythmic-agent-34208
11/08/2023, 7:38 PM