Skip to content

Instantly share code, notes, and snippets.

@Osiyuks

Osiyuks/BigQuery Insights

Created August 19, 2020 09:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Osiyuks/845875d252cc9c4ee92d7ea62cea2aae to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Osiyuks/845875d252cc9c4ee92d7ea62cea2aae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
BigQuery Insights
SELECT event_name, count(*) as n
FROM `gemini-ios.analytics_163264845.events_*`
WHERE _TABLE_SUFFIX between "20200801" and "20200805"
group by 1
SELECT distinct cid
FROM `analytics-176911.datahub.actions`
WHERE DATE(ngtime) between "2020-08-01" and "2020-08-05"
and an='CleanMyMac X'
and ec='Malware Removal'
and ea='Alert Shown'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment