GA4SQL: a no-code builder for GA4 BigQuery queries

The first obstacle in querying the GA4 BigQuery export is not analytics, it is SQL: the event table is nested and repeated, so even a simple "sessions by channel last month" question needs UNNEST before it needs any actual thinking. GA4SQL sidesteps that. Pick the metrics and dimensions you want from a form, set a date range, and it writes the query for you.

Why it made the cut

It is the fastest route from "I want this number out of the export" to a working query, without first learning UNNEST. For anyone who knows what they want to measure but not yet how the nested schema behaves, this is the shortest path to a first correct result, and a reasonable way to learn the query shapes by reading what it generates.

How to run it

1. Open the tool and select your metrics and dimensions from the builder.
2. Set the date range and any filters the form exposes.
3. Copy the generated SQL into the BigQuery console, swapping in your own project and dataset ID.
4. Run it, check the row count against what you expect, and keep the query as a starting template for variations.

Worth knowing

It is a free web tool with no account layer described on the site, so treat generated queries as a starting point, not a certified report: check the logic against your own understanding of the schema before it goes into a client deliverable. It will not replace learning the export properly if you query GA4 data often, but as the on-ramp for a first working query it earns its place on the shelf.