MarquinSmith

-- Description:
-- Count page views in Adobe Analytics click stream data export

SELECT
    DATE(date_time) AS date,
    SUM( CASE WHEN post_page_event = '0' THEN 1 END) AS pageviews
FROM `adobe_click_stream_table`

-- only look at data for June 2022
WHERE 
    DATE(date_time) >= '2022-06-01'
    AND DATE(date_time) < '2022-07-01'

GROUP BY date
ORDER BY date ASC;