Skip to content

Instantly share code, notes, and snippets.

@markrittman

markrittman/ga4_list_events_params.sql

Last active November 5, 2021 16:43
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save markrittman/b7a580b57c241a3b7445c6d0c9406e19 to your computer and use it in GitHub Desktop.
Save markrittman/b7a580b57c241a3b7445c6d0c9406e19 to your computer and use it in GitHub Desktop.
Download ZIP
List out all GA4 events and parameters
Raw
ga4_list_events_params.sql
SELECT
event_name,
event_params.key AS event_params_key
FROM
`ra-development.analytics_277223877.events_*` AS t
CROSS JOIN UNNEST (t.event_params) AS event_params
group by 1,2
order by 1,2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment