Skip to content

Instantly share code, notes, and snippets.

@ToddKerpelman

ToddKerpelman/cohort11-snippet.sql

Created May 16, 2019 20:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ToddKerpelman/382d09d975a1cac3f3aed6a706971468 to your computer and use it in GitHub Desktop.
Save ToddKerpelman/382d09d975a1cac3f3aed6a706971468 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cohort11-snippet.sql
WITH analytics_data AS (
SELECT user_pseudo_id, event_timestamp, event_name,
device.mobile_model_name, -- This parameter is new
UNIX_MICROS(TIMESTAMP("2018-08-01 00:00:00", "-7:00")) AS start_day,
3600*1000*1000*24*7 AS one_week_micros
FROM `firebase-public-project.analytics_153293282.events_*`
WHERE _table_suffix BETWEEN '20180731' AND '20180829'
AND device.mobile_model_name LIKE "iPad Pro%" -- This is also new
)
... Rest of the query goes here
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment