Use the SQL code below and change {{projectId}}
and {{datasetName}}
to your own.
#Pageviews object
WITH
#Set the date range for the calculation
dates as
(
SELECT
'20220901' AS date_start,
'20220930' AS date_end,
)
SELECT
pageviews.*
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 pageviews.date IS NOT null
You will get the data in the table 'pageviews' with the schema below:
Field name | Type | |
---|---|---|
date |
DATE | |
sessionId |
STRING | |
hitId |
STRING | |
time |
INTEGER | |
pageview |
INTEGER | |
pageHash |
STRING |
0 Comments