GA4 SQL

Verified Tool

GA4 SQL is a Verified Tool. Want to get this badge? Contact us.

GA4 SQL is a free and user-friendly tool that simplifies the querying process for Google Analytics 4 data in BigQuery. It enables users to generate GA4 BigQuery queries without requiring any SQL knowledge. By selecting the desired metrics, dimensions, date range, and the name of the BigQuery table to query, the tool automatically generates a SQL query to retrieve the relevant data from BigQuery. Best of all, GA4 SQL is free to use.

Making decisions based on inaccurate data can have costly consequences. To ensure the accuracy of your GA4 data, we've built GA4 Auditor, an advanced GA4 audit tool that can help you identify data quality issues in your analytics account. Try it out now for free.

Developing a universal query template for all metrics and dimensions using CTEs (Common Table Expressions) with the syntax WITH table AS (...) can be challenging, as it can lead to longer queries with multiple joins. While sub-queries may be less readable, we decided to prioritize functionality over readability. It's worth noting that there is no difference in performance between CTEs and sub-queries.

To customize the generated queries, it is beneficial to have some SQL knowledge. A valuable resource for learning SQL is GA4BigQuery.com—check it out! If you don't feel like learning SQL, you can use our Custom GPT on ChatGPT and ask any questions you have about the queries.

The data in the GA4 UI goes through several processing stages, including value additions like Google Signals, modeling, traffic attribution, and prediction, before it is displayed. However, the data exported to BigQuery is typically collected data and does not contain these value additions. You can find more information about this on the Google Analytics developer website.

In some cases, certain metrics or dimensions may be disabled and cannot be selected because they are not compatible with each other. This is to ensure that the generated query provides accurate results. If you encounter this issue, try selecting different combinations of metrics and dimensions that are compatible with each other.

To use GA4 SQL, you need to have a Google Analytics 4 property connected to your Google Cloud project. You can connect your GA4 property to your Google Cloud project by following the steps in this link to link GA4 to BigQuery.

If you're unsure about the definitions of any metrics or dimensions in GA4 SQL, simply hover over the help icon next to each field to view its definition. This can help you better understand what data is being pulled and how it relates to your analysis.