GA4BigQuery.com: tutorials built specifically for the raw export

Most SQL tutorials teach generic syntax; almost none teach the specific, repeated shape of the GA4 export. GA4BigQuery.com is one of the few resources built around that export specifically, working through example queries and the reasoning behind them, session logic, ecommerce parameters, user-property extraction, rather than the GA4 interface itself.

Why it made the cut

There is a real gap between "knows SQL" and "knows how to unnest a GA4 events table correctly", and this site is built to close exactly that gap. It also carries interviews with practitioners from the dbt-GA4 ecosystem, which is useful context for anyone deciding whether to hand-roll queries or adopt a package like dbt-ga4 instead.

How to run it

1. Start with the site's introductory lessons on the export's table structure before jumping to example queries.
2. Work through the example SQL for the metric you need, sessions, ecommerce, user properties, adapting the query to your own dataset naming.
3. Use the practitioner interviews as orientation if you are deciding between writing your own SQL and adopting a modelling package.
4. Note that a paid SQL course also exists on the site for anyone who wants a structured path beyond the free tutorials.

Worth knowing

The free tutorials cover a lot of ground but are not exhaustive documentation, treat them as a course, not a reference manual. The paid course is a commercial upsell from the same author; the free content stands on its own and is where we point people first.