Use the SQL code below and change {{projectId}}
and {{datasetName}}
to your own.
#Events object
WITH
#Set the date range for the calculation
dates as
(
SELECT
'20220901' AS date_start,
'20220930' AS date_end,
)
SELECT
events.*
FROM dates as d, `{{projectId}}.{{datasetName}}._temp_objects`
WHERE
date BETWEEN PARSE_DATE('%Y%m%d', d.date_start) AND PARSE_DATE('%Y%m%d', d.date_end)
AND events.date IS NOT null
You will get the data in the table 'events' with the schema below:
Field name | Type | |
---|---|---|
date |
DATE | |
sessionId |
STRING | |
hitId |
STRING | |
time |
INTEGER | |
events |
INTEGER | |
pageHash |
STRING |
0 Comments