Just a touch of magic.
Ali Izadi opened my eyes to Google's biggest secret - the Query Explorer tool for GA4 and Universal Analytics. It resides within my beloved Dimension & Metrics Explorer and is accessed by clicking on the corresponding item in the sidebar.
What can it do?
Firstly, validate your API requests. You can receive ready-made JSON for your request similar to Event Builder.
Secondly, provide the results of your query directly in the web interface.
Thirdly, export archived data from a disabled Universal Analytics account. Right here and right now - in tsv format.
Want to try it yourself? Then head over to https://lnkd.in/gKztGbyM.
Wanna know BigQuery and GA4? Try My Free GA4-BigQuery Cheat Sheet.
Want all my best GA4-BQ queries in one place? I turned them into a Chrome extension — top SQL queries you can search and copy in seconds.
Go here to install it for FREE.
Prefer the web version? It's here.
