Skip to content

Instantly share code, notes, and snippets.

@ToddKerpelman

ToddKerpelman/cohort1.sql

Created May 16, 2019 20:23
Show Gist options
  • Save ToddKerpelman/284bd0caabb8d2a3686841ca0399ef12 to your computer and use it in GitHub Desktop.
Save ToddKerpelman/284bd0caabb8d2a3686841ca0399ef12 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cohort1.sql
SELECT DISTINCT user_pseudo_id
FROM `firebase-public-project.analytics_153293282.events_*`
WHERE event_name = 'first_open'
AND _TABLE_SUFFIX BETWEEN '20180801' AND '20180807'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment