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>

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:

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: