GA4 SQL

O que é GA4 SQL?

GA4 SQL is a free browser-based query builder for Google Analytics 4 data exported to BigQuery. Choose a table, date range, metrics, and dimensions to generate SQL, then copy and review the query for use in your own BigQuery project.

The builder includes field definitions, compatible-selection controls, filters, sorting, and custom event parameters. It is useful for creating an initial reporting query without composing all of the SQL by hand; running that query and interpreting its results remain part of your BigQuery workflow.

O que GA4 SQL pode fazer?

Analytics field selection

Select sessions, users, engagement, revenue, or ecommerce measures alongside compatible traffic, page, device, and item dimensions.

Dates, filters, and sorting

Use preset or custom dates, specify a table, add field conditions, and choose how the result should be ordered.

Custom events and parameters

Define event-scoped custom metrics or parameter-based dimensions. The chosen metrics affect dimension scope, and filters need parameters actually present in the events.

Definitions and SQL output

Read help definitions while configuring fields, then copy the generated SQL and customize it when additional logic is needed.

Casos de uso

“Create a reporting query”

Build an initial SQL query for a chosen reporting period and fields, then review it before execution in BigQuery.

“Inspect traffic or ecommerce”

Combine compatible source, campaign, page, or item dimensions with the corresponding sessions, events, purchase, or revenue measures.

“Analyze a custom event”

Set up a metric or dimension around an event name and its parameters instead of limiting the query to standard fields.

Perguntas frequentes

What setup is required?

Your GA4 property needs to be linked to a Google Cloud project with its data exported to BigQuery. Enter the appropriate table name in the builder; GA4 SQL generates the query rather than setting up the export or running a report for you.

Is query generation free?

Yes. GA4 SQL currently offers free, unlimited query generation. BigQuery query processing and data storage have their own Google Cloud pricing and can incur separate charges.

Why are some field selections unavailable?

Some metrics and dimensions cannot be combined. The builder disables incompatible choices; select a different combination that matches the analysis you need.

Do I need SQL knowledge, and will totals match GA4 reports?

SQL knowledge is not required to build an initial query, but it helps when customizing or reviewing it. BigQuery-export results can differ from the GA4 interface because the interface applies additional processing. Check field definitions and reporting assumptions before comparing totals.