5. Events

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: