We're talking about an update that will make our lives much easier. How many times have I listed all the arguments for grouping, and darn it, it was inconvenient.
It's time to breathe a sigh of relief – now, when using BigQuery aggregate functions, instead of those annoying "GROUP BY 1, 2, 3, 4, 5, 6...", you can simply use GROUP BY ALL.
If you work with GA4 to BigQuery exports, be sure to check out my SQL 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.
