Last Updated: October 25, 2023

What is GA4 BigQuery SQL generator?

GA4 SQL is a free tool through which you can quickly create SQL queries for your GA4 data.

The GA4 SQL tool is not as powerful as ChatGPT for creating SQL queries, but it is still a good tool for creating decent queries (the ones which do not require a lot of customization) faster.

Consider the following data table:

This data table is for June 18, 2023 which is denoted by 20230618.

Let us suppose you want to query the data which meets the following requirements:

1. You want to query data between the date range June 1, 2023 and June 18, 2023
2. You want to retrieve the ‘event_date’ and ‘event_name’ columns of the data table.
3. You want to sort the values of the ‘event_date’ column in ascending order.
4. You want to see only those rows where the value of the ‘event_name’ column is ‘page_view’
5. You want to see the values of the ‘event_name’ columns as count of ‘page_views’ event.

The end result should be a data table which shows the total pageviews count for each day from June 1 to June 18, 2023.

Get this 70 page detailed checklist containing screenshots, step-by-step instructions and links to articles

Do you want to set up Google Analytics 4 (GA4) fast and correctly?

Yes I want the ebook

Follow the steps below:

#1 Navigate to https://www.ga4sql.com/ 

#2 Enter your table ID without the * character in the table name field:

#3 Click on the Date Range drop-down menu:

#4 Click on custom date range:

#5 Set the Start Date to 01/06/2023 and the End Date to 18/06/2023:

#6 Remove the Sessions metric by clicking on the cross button next to it:

#7 Select the ‘Event Count‘ metric from the ‘Metrics‘ drop-down menu:

#8 Remove the ‘Session Source Medium‘ dimension by clicking on the cross button next to it:

#9 Select the ‘Date‘ and ‘Event Name‘ dimensions from the ‘Dimensions‘ drop-down menu:

#10 Click on the ‘Filters‘ drop-down menu:

You should now see a screen like the one below:

#11 Set the following filter:

#12 Click on the ‘Sort by‘ drop-down menu:

You should now see a screen like the one below:

#13 Click on the ‘Select Field‘ drop-down menu and then select ‘Date‘:

#14 Click on the ‘Generate Query‘ button:

You should now see the generated query on the right-hand side of your window:

#15 Copy the generated SQL code by clicking on the ‘Copy‘ button:

#16 Paste the copied code in the SQL editor and then click on the ‘Run‘ button:

You should now see the query results in the bottom window, like the one below:

#17 Check the accuracy of this data by navigating to your GA4 property.

Let’s see how many pageviews GA4 reported on June 3, 2023:

From the screenshot above, we can conclude that GA4 reported 3,157 pageviews on June 3, which matches the data in our data table:

So we can safely conclude that our SQL query is correct.