Once you have successfully connected your Google Analytics 4 account with BigQuery and more than 24 hrs have elapsed, you should be able to see a new data set named “analytics_<property_id>” in your BigQuery project:

For each Google Analytics 4 property that is linked to BigQuery, a single dataset named “analytics_<property_id>” is added to your BigQuery project.

Property ID refers to your Analytics Property ID, which you can find in the property settings for your GA4 property.

In my case, the property ID is 207472454. That’s why the name of my data set is ‘analytics_207472454‘

This data set contains the following two data tables:

1. events_(<number of days>)
2. events_intraday_<current date>

 
Get the E-Book (50 Pages)

 
Get the FREE E-Book (50+ Pages)

events_ data table

All the GA4 event data from the previous day(s) is available in the ‘events_’ data table. This table is automatically imported for each day of export.

events_(1) means all the GA4 event data from the previous day is available in this data table.

events_(2) means all the GA4 event data from the previous two days is available in this data table.

events_(3) means all the GA4 event data from the previous three days is available in this data table.

events_(4) means all the GA4 event data from the previous four days is available in this data table.

events_(5) means all the GA4 event data from the previous five days is available in this data table.

Note: The ‘events_’ data tables are named as “events_YYYYMMDD” where “YYYYMMDD” refers to the date the table was imported to BigQuery:

The ‘events_’ data table corresponds to the ‘Daily’ frequency setting in GA4:

Clicking on the ‘events_’ data table will show you the structure of that table:

Click on the drop-down menu to see GA4 events data for a particular date:

Click on the ‘Details’ tab to get details (like table size) of the ‘events_’ table:

Click on the ‘Preview’ tab to view the data in the ‘events_’ table without running a single query:

Click on the ‘QUERY TABLE’ button if you want to query the ‘events_’ data table

events_intraday_ data table

All the GA4 event data from the current day is available in the ‘events_intraday_’ data table. This table is automatically updated throughout the day. That’s why it is called ‘events_intraday’ table.

Note: The ‘events_intraday_’ data table is named as “events_intraday_YYYYMMDD” where “YYYYMMDD” refers to the current date:

The ‘events_intraday_’ data table corresponds to the  ‘streaming’ frequency setting in GA4:

Clicking on the ‘events_intraday_’ table will show you the structure of that table:

Click on the ‘Details’ tab to get details (like table size) of the ‘events_intraday_’ table:

Click on the ‘Preview’ tab to view the data in the ‘events_intraday_’ table without running a single query:

Click on the ‘QUERY TABLE’ button if you want to query the ‘events_intraday_’ table:

Other articles on Google Analytics BigQuery

1. Advantages of using Google BigQuery for Google Analytics
2. Cost of using BigQuery for Google Analytics
3. Guide to BigQuery Cost optimization
4. What is Google BigQuery Sandbox and how to use it
5. Understanding the BigQuery User Interface
6. Sending data from Google Analytics to BigQuery without 360
7.  How to connect GA4 (Google Analytics 4) with BigQuery
8. Using Google Cloud pricing calculator for BigQuery
9. How to access BigQuery Public Data Sets
10. How to use Google Analytics sample dataset for BigQuery
11. Connect and transfer data from Google Sheets to BigQuery
12. How to query Google Analytics data in BigQuery
13. How to send data from Google Ads to BigQuery
14. What is BigQuery Data Transfer Service & how it works.
15. How to send data from Facebook ads to BigQuery
16. How to send data from Google Search Console to BigQuery
17. How to pull custom data from Google Analytics to BigQuery
18. Best Supermetrics Alternative – Dataddo
19. Google Analytics BigQuery Tutorial
20. How to backfill Google Analytics data in BigQuery