Gets the app opens for the app over the past few weeks

app_opens_past_six_weeks.sql

SELECT 
    DATE(DATE_TRUNC(TIMESTAMP_MICROS(event_timestamp), WEEK)) as week,
    COUNT(DISTINCT(user_pseudo_id)) as users
FROM `<project>.events_*`
WHERE event_name = 'app_open'
-- past six weeks
AND DATE(DATE_TRUNC(TIMESTAMP_MICROS(event_timestamp), WEEK)) > DATE_SUB(DATE_TRUNC(CURRENT_DATE(), WEEK), INTERVAL 6 WEEK)
GROUP BY week
ORDER BY week