Skip to content

Instantly share code, notes, and snippets.

@cgi-ace

cgi-ace/AppAnalytics-01.sql Secret

Created June 15, 2021 08:54
Show Gist options
  • Save cgi-ace/299fc67f51b7275d548e263574f58f62 to your computer and use it in GitHub Desktop.
Save cgi-ace/299fc67f51b7275d548e263574f58f62 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AppAnalytics-01.sql
select Count(distinct user_pseudo_id) AUD, PARSE_DATE('%Y%m%d', event_date) as event_date,geo.country,device.operating_system
from `firebase-public-project.analytics_153293282.events_*`
where event_name = 'user_engagement'
and _TABLE_SUFFIX = '20180821'
group by event_date,geo.country,device.operating_system
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment