Skip to content

Instantly share code, notes, and snippets.

@ddikman

ddikman/filter_last_month.sql

Created August 1, 2022 02:31
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 ddikman/92ba111c101e6a53677bb5dca8fd3f40 to your computer and use it in GitHub Desktop.
Save ddikman/92ba111c101e6a53677bb5dca8fd3f40 to your computer and use it in GitHub Desktop.
Download ZIP
Efficient filtering of tables in google analytics
Raw
filter_last_month.sql
SELECT
count(*)
FROM
`<your_project>.analytics_196169157.events_*`
WHERE
event_name = 'event_name'
AND _TABLE_SUFFIX >= format_date('%Y%m%d', CURRENT_DATE() - 30)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment