4. Pageviews

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  

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.