events_ & events_intraday_ tables in BigQuery for GA4 (Google Analytics 4)
Last Updated: November 15, 2022
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 the imported GA4 data in your BigQuery project.
To find the imported GA4 data in BigQuery, follow the steps below:
Step-1: Navigate to your BigQuery account: https://console.cloud.google.com/bigquery
Step-2: Select the BigQuery project you are using for collecting the GA4 data.
Step-3: Click on the project ID of the project:
You should now be able to see a data set named in the following format: “analytics_<property_id>“:
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 298851313
That’s why the name of my data set is ‘analytics_298851313‘
This data set contains the following two data tables:
- events_(<number of days>)
- events_intraday_<current date>
What is ‘events_ data table’ in BigQuery for GA4?
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 of the GA4 event data from the previous day are available in this data table.
events_(2) means all of the GA4 event data from the previous two days are available in this data table.
events_(3) means all of the GA4 event data from the previous three days are available in this data table.
events_(4) means all of the GA4 event data from the previous four days are available in this data table.
Similarly,
events_(567) means all of the GA4 event data from the previous 567 days are available in this data table.
The ‘events_’ data table corresponds to the ‘Daily’ frequency setting of ‘BigQuery Links’ in your GA4 property:
Clicking on the ‘events_’ data table will show you the structure of that table (also known as ‘Schema’):
The ‘events_’ data tables are named as “events_YYYYMMDD” where “YYYYMMDD” refers to the date, the table was imported to BigQuery.
YYYY denotes a year. For example, 2022
MM denotes a month. For example, 07 (July)
DD denotes a day. For example, 27
So the data table that was imported to BigQuery on July 27, 2022 would be named as events_20220727
Click on the drop-down menu to see the ‘events_’ data table for a particular date:
Click on the ‘Details’ tab to get details (like ‘Table Size’) of the ‘events_’ data table:
Click on the ‘Preview’ tab to view the data in the ‘events_’ data table without running a single query:
Click on the ‘QUERY’ button if you want to query the ‘events_’ data table
Click on ‘In new Tab‘:
You would now see the SQL query window where you can run SQL queries:
Following is an example of an SQL query:
This query is pre-populated for you and is ready to be used.
Just click on the ‘Run‘ button:
You should now be able to see the query results:
That’s how you can query the GA4 data in BigQuery.
What is ‘events_intraday_’ data table in BigQuery for GA4?
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.
The ‘events_intraday_’ data table corresponds to the ‘Streaming’ frequency setting of ‘BigQuery Links’ in your GA4 property:
Clicking on the ‘events_intraday_’ data table will show you the structure of that table (also known as ‘Schema’):
The ‘events_intraday_’ data tables are named as “events_intraday_YYYYMMDD” where “YYYYMMDD” refers to the date, the table was imported to BigQuery.
YYYY denotes a year. For example, 2022
MM denotes a month. For example, 07 (July)
DD denotes a day. For example, 28
So the data table that was imported to BigQuery on July 28, 2022 would be named as events_intraday_20220728
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_’ data table without running a single query:
Click on the ‘QUERY’ button if you want to query the ‘events_intraday_’ data table
Other articles on Google Analytics BigQuery
- Advantages of using Google BigQuery for Google Analytics
- Cost of using BigQuery for Google Analytics
- Guide to BigQuery Cost optimization
- What is Google BigQuery Sandbox and how to use it
- Understanding the BigQuery User Interface
- Sending data from Google Analytics to BigQuery without 360
- How to connect GA4 (Google Analytics 4) with BigQuery
- Using Google Cloud pricing calculator for BigQuery
- How to access BigQuery Public Data Sets
- How to use Google Analytics sample dataset for BigQuery
- Connect and transfer data from Google Sheets to BigQuery
- How to query Google Analytics data in BigQuery
- How to send data from Google Ads to BigQuery
- What is BigQuery Data Transfer Service & how it works.
- How to send data from Facebook ads to BigQuery
- How to send data from Google Search Console to BigQuery
- How to pull custom data from Google Analytics to BigQuery
- Best Supermetrics Alternative – Dataddo
- Google Analytics BigQuery Tutorial
- How to backfill Google Analytics data in BigQuery
- How to connect and export data from GA4 to BigQuery
Other articles related to GA4 (Google Analytics 4)
#1 Google Analytics 4 Intro
- What is GA4 (Google Analytics 4) – The Apps + Web Property?
- Key Benefits of Using Google Analytics 4 (GA4)
- Setup GA4 – Upgrade to GA4 – Implementation Guide
- Google Analytics 4 (GA4) vs Universal Analytics – What is the Difference?
- GA4 vs GA4 360 – Pricing, Limits, Billing and More
- Google Analytics 4 Training & Tutorial with FREE GA4 ebook
#2 Google Analytics 4 Property
- Google Analytics Account Hierarchy (Structure Explained)
- Understanding Google Analytics Measurement ID (GA4)
- Google Signals GA4 – See Demographics (Gender, Age) in Google Analytics 4
- Using the GA4 (Google Analytics 4) Test Property
- Google Analytics 4 Sub Properties Tutorial
- Roll up Property in Google Analytics 4 (GA4) – Tutorial
#3 Google Analytics 4 Integrations
- How to connect GA4 (Google Analytics 4) with Google Data Studio
- How to link GA4 (Google Analytics 4) with Google Ads
- How to link Google Search Console to Google Analytics 4 (GA4)
- How to Install Google Analytics 4 on Shopify
- GA4 Firebase Integration – Correctly Add App Data Streams to GA4 Property
#4 Google Analytics 4 Events
- GA4 (Google Analytics 4) Event Tracking Setup Tutorial
- Understanding Event Parameters in Google Analytics 4 (GA4)
- Recommended Events in Google Analytics 4 (GA4)
- Enhanced Measurement Events in Google Analytics 4 (GA4)
- Automatically Collected Events in Google Analytics 4 (GA4)
- How to Set Up GA4 Custom Events via Google Tag Manager
- Events Report in Google Analytics 4 (GA4)
- How to Rename Events in Google Analytics 4 (GA4)
- How to Use Google Analytics 4 Event Builder
- GA4 Form Interactions Tracking – Enhanced Measurement
#5 Google Analytics 4 Conversions
- Google Analytics 4 Conversion Tracking Guide – GA4 Goals
- How to Import Conversions from GA4 Property to Your Google Ads account
- GA4 Conversion Rate – How to find it and use it
#6 Google Analytics 4 Dimensions
- GA4 (Google Analytics 4) Dimensions Tutorial
- GA4 (Google Analytics 4) Custom Dimensions Tutorial
- GA4 User Properties (User Scoped Custom Dimensions) – Tutorial
- Event Scoped Custom Dimensions in GA4 – Tutorial
#7 Google Analytics 4 Metrics
- GA4 (Google Analytics 4) Metrics Tutorial with Free Google Analytics 4 Ebook
- GA4 (Google Analytics 4) Custom Metrics Tutorial
- What are Predictive Metrics in Google Analytics 4 (GA4)
#8 Google Analytics 4 Ecommerce
#9 Google Analytics 4 Specialized Tracking
- GA4 (Google Analytics 4) Enhanced Measurement Tracking Tutorial
- Cross Domain Tracking in GA4 (Google Analytics 4) Setup Guide
- GA4 Site Search – Tracking Site Search in Google Analytics 4
- GA4 (Google Analytics 4) Scroll Tracking Tutorial
- Self-referral Google Analytics 4 – Referral exclusion GA4
- GA4 (Google Analytics 4) Data Import Tutorial
- Google Analytics 4 Content Grouping – Create Content Groups in GA4
- How to Track Single Page Apps in Google Analytics 4 (GA4)
- utm_source, utm_medium, utm_campaign Parameters – GA4 (Google Analytics 4)
#10 Google Analytics 4 filters
- GA4 filters – Understanding Data Filters in Google Analytics 4
- How to Create and Test Filters in Google Analytics 4 (GA4)?
- Exclude Internal Traffic in GA4 (Google Analytics 4) via IP Filter
#11 Google Analytics 4 Explorations
- Free Form Report in GA4 (Google Analytics 4) – Exploration Report
- How to Use the User Lifetime Report in Google Analytics 4 (GA4)
- How to Use Path Exploration Report in GA4 (Google Analytics 4) – Path Analysis
- How to Use Segment Overlap Report in Google Analytics 4 (GA4)
- How to Use the Funnel Exploration Report in GA4 (Google Analytics 4) – Funnel Analysis
- Cohort Exploration Report in Google Analytics 4 (GA4)
- How to Create Landing Pages Report in GA4 (Google Analytics 4)
- How to Create Google Ads report in GA4 (Google Analytics 4)
- How to Segment GA4 Data by Data Stream
- Organic Search Traffic Analysis in GA4 – Complete Guide
- Google Analytics 4 (GA4) Outbound Links Tracking
- How to Track Email Campaigns and Traffic in GA4
#12 Google Analytics 4 Advanced
- Understanding Google Analytics 4 Sessions
- GA4 (Google Analytics 4) Measurement Protocol Tutorial
- How to Build Comparisons (Advanced Segments) in Google Analytics 4 (GA4)
- Understanding Automated Insights in Google Analytics 4 (GA4)
- Understanding Channel Groupings in Google Analytics 4 (GA4)
- Understanding Data Sampling in Google Analytics 4 (GA4)
#13 Google Analytics 4 Reports
- How to Create Custom Insights in Google Analytics 4 (GA4)
- How to Use Debug View Report in Google Analytics 4 (GA4)
#14 Google Analytics 4 Attribution
- Guide to Attribution Models in GA4 (Google Analytics 4)
- How to Change Attribution Models in GA4 (Google Analytics 4)?
- GA4 (Google Analytics 4) Conversion Paths Report in Attribution
- GA4 (Google Analytics 4) Model Comparison Report in Attribution
- Advertising Snapshot in GA4 (Google Analytics 4) Attribution
- GA4 Attribution Modelling Tutorial
#15 Google Analytics 4 Audiences
- GA4 Audiences – Creating Custom Audience in Google Analytics 4
- How to Create a Remarketing Audience in Google Analytics 4 (GA4)
- Understanding Audience Triggers in Google Analytics 4 (GA4)
- Google Analytics 4 (GA4) Predictive Audiences – Tutorial
#16 Google Analytics 4 BigQuery
Last Updated: November 15, 2022
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 the imported GA4 data in your BigQuery project.
To find the imported GA4 data in BigQuery, follow the steps below:
Step-1: Navigate to your BigQuery account: https://console.cloud.google.com/bigquery
Step-2: Select the BigQuery project you are using for collecting the GA4 data.
Step-3: Click on the project ID of the project:
You should now be able to see a data set named in the following format: “analytics_<property_id>“:
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 298851313
That’s why the name of my data set is ‘analytics_298851313‘
This data set contains the following two data tables:
- events_(<number of days>)
- events_intraday_<current date>
What is ‘events_ data table’ in BigQuery for GA4?
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 of the GA4 event data from the previous day are available in this data table.
events_(2) means all of the GA4 event data from the previous two days are available in this data table.
events_(3) means all of the GA4 event data from the previous three days are available in this data table.
events_(4) means all of the GA4 event data from the previous four days are available in this data table.
Similarly,
events_(567) means all of the GA4 event data from the previous 567 days are available in this data table.
The ‘events_’ data table corresponds to the ‘Daily’ frequency setting of ‘BigQuery Links’ in your GA4 property:
Clicking on the ‘events_’ data table will show you the structure of that table (also known as ‘Schema’):
The ‘events_’ data tables are named as “events_YYYYMMDD” where “YYYYMMDD” refers to the date, the table was imported to BigQuery.
YYYY denotes a year. For example, 2022
MM denotes a month. For example, 07 (July)
DD denotes a day. For example, 27
So the data table that was imported to BigQuery on July 27, 2022 would be named as events_20220727
Click on the drop-down menu to see the ‘events_’ data table for a particular date:
Click on the ‘Details’ tab to get details (like ‘Table Size’) of the ‘events_’ data table:
Click on the ‘Preview’ tab to view the data in the ‘events_’ data table without running a single query:
Click on the ‘QUERY’ button if you want to query the ‘events_’ data table
Click on ‘In new Tab‘:
You would now see the SQL query window where you can run SQL queries:
Following is an example of an SQL query:
This query is pre-populated for you and is ready to be used.
Just click on the ‘Run‘ button:
You should now be able to see the query results:
That’s how you can query the GA4 data in BigQuery.
What is ‘events_intraday_’ data table in BigQuery for GA4?
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.
The ‘events_intraday_’ data table corresponds to the ‘Streaming’ frequency setting of ‘BigQuery Links’ in your GA4 property:
Clicking on the ‘events_intraday_’ data table will show you the structure of that table (also known as ‘Schema’):
The ‘events_intraday_’ data tables are named as “events_intraday_YYYYMMDD” where “YYYYMMDD” refers to the date, the table was imported to BigQuery.
YYYY denotes a year. For example, 2022
MM denotes a month. For example, 07 (July)
DD denotes a day. For example, 28
So the data table that was imported to BigQuery on July 28, 2022 would be named as events_intraday_20220728
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_’ data table without running a single query:
Click on the ‘QUERY’ button if you want to query the ‘events_intraday_’ data table
Other articles on Google Analytics BigQuery
- Advantages of using Google BigQuery for Google Analytics
- Cost of using BigQuery for Google Analytics
- Guide to BigQuery Cost optimization
- What is Google BigQuery Sandbox and how to use it
- Understanding the BigQuery User Interface
- Sending data from Google Analytics to BigQuery without 360
- How to connect GA4 (Google Analytics 4) with BigQuery
- Using Google Cloud pricing calculator for BigQuery
- How to access BigQuery Public Data Sets
- How to use Google Analytics sample dataset for BigQuery
- Connect and transfer data from Google Sheets to BigQuery
- How to query Google Analytics data in BigQuery
- How to send data from Google Ads to BigQuery
- What is BigQuery Data Transfer Service & how it works.
- How to send data from Facebook ads to BigQuery
- How to send data from Google Search Console to BigQuery
- How to pull custom data from Google Analytics to BigQuery
- Best Supermetrics Alternative – Dataddo
- Google Analytics BigQuery Tutorial
- How to backfill Google Analytics data in BigQuery
- How to connect and export data from GA4 to BigQuery
Other articles related to GA4 (Google Analytics 4)
#1 Google Analytics 4 Intro
- What is GA4 (Google Analytics 4) – The Apps + Web Property?
- Key Benefits of Using Google Analytics 4 (GA4)
- Setup GA4 – Upgrade to GA4 – Implementation Guide
- Google Analytics 4 (GA4) vs Universal Analytics – What is the Difference?
- GA4 vs GA4 360 – Pricing, Limits, Billing and More
- Google Analytics 4 Training & Tutorial with FREE GA4 ebook
#2 Google Analytics 4 Property
- Google Analytics Account Hierarchy (Structure Explained)
- Understanding Google Analytics Measurement ID (GA4)
- Google Signals GA4 – See Demographics (Gender, Age) in Google Analytics 4
- Using the GA4 (Google Analytics 4) Test Property
- Google Analytics 4 Sub Properties Tutorial
- Roll up Property in Google Analytics 4 (GA4) – Tutorial
#3 Google Analytics 4 Integrations
- How to connect GA4 (Google Analytics 4) with Google Data Studio
- How to link GA4 (Google Analytics 4) with Google Ads
- How to link Google Search Console to Google Analytics 4 (GA4)
- How to Install Google Analytics 4 on Shopify
- GA4 Firebase Integration – Correctly Add App Data Streams to GA4 Property
#4 Google Analytics 4 Events
- GA4 (Google Analytics 4) Event Tracking Setup Tutorial
- Understanding Event Parameters in Google Analytics 4 (GA4)
- Recommended Events in Google Analytics 4 (GA4)
- Enhanced Measurement Events in Google Analytics 4 (GA4)
- Automatically Collected Events in Google Analytics 4 (GA4)
- How to Set Up GA4 Custom Events via Google Tag Manager
- Events Report in Google Analytics 4 (GA4)
- How to Rename Events in Google Analytics 4 (GA4)
- How to Use Google Analytics 4 Event Builder
- GA4 Form Interactions Tracking – Enhanced Measurement
#5 Google Analytics 4 Conversions
- Google Analytics 4 Conversion Tracking Guide – GA4 Goals
- How to Import Conversions from GA4 Property to Your Google Ads account
- GA4 Conversion Rate – How to find it and use it
#6 Google Analytics 4 Dimensions
- GA4 (Google Analytics 4) Dimensions Tutorial
- GA4 (Google Analytics 4) Custom Dimensions Tutorial
- GA4 User Properties (User Scoped Custom Dimensions) – Tutorial
- Event Scoped Custom Dimensions in GA4 – Tutorial
#7 Google Analytics 4 Metrics
- GA4 (Google Analytics 4) Metrics Tutorial with Free Google Analytics 4 Ebook
- GA4 (Google Analytics 4) Custom Metrics Tutorial
- What are Predictive Metrics in Google Analytics 4 (GA4)
#8 Google Analytics 4 Ecommerce
#9 Google Analytics 4 Specialized Tracking
- GA4 (Google Analytics 4) Enhanced Measurement Tracking Tutorial
- Cross Domain Tracking in GA4 (Google Analytics 4) Setup Guide
- GA4 Site Search – Tracking Site Search in Google Analytics 4
- GA4 (Google Analytics 4) Scroll Tracking Tutorial
- Self-referral Google Analytics 4 – Referral exclusion GA4
- GA4 (Google Analytics 4) Data Import Tutorial
- Google Analytics 4 Content Grouping – Create Content Groups in GA4
- How to Track Single Page Apps in Google Analytics 4 (GA4)
- utm_source, utm_medium, utm_campaign Parameters – GA4 (Google Analytics 4)
#10 Google Analytics 4 filters
- GA4 filters – Understanding Data Filters in Google Analytics 4
- How to Create and Test Filters in Google Analytics 4 (GA4)?
- Exclude Internal Traffic in GA4 (Google Analytics 4) via IP Filter
#11 Google Analytics 4 Explorations
- Free Form Report in GA4 (Google Analytics 4) – Exploration Report
- How to Use the User Lifetime Report in Google Analytics 4 (GA4)
- How to Use Path Exploration Report in GA4 (Google Analytics 4) – Path Analysis
- How to Use Segment Overlap Report in Google Analytics 4 (GA4)
- How to Use the Funnel Exploration Report in GA4 (Google Analytics 4) – Funnel Analysis
- Cohort Exploration Report in Google Analytics 4 (GA4)
- How to Create Landing Pages Report in GA4 (Google Analytics 4)
- How to Create Google Ads report in GA4 (Google Analytics 4)
- How to Segment GA4 Data by Data Stream
- Organic Search Traffic Analysis in GA4 – Complete Guide
- Google Analytics 4 (GA4) Outbound Links Tracking
- How to Track Email Campaigns and Traffic in GA4
#12 Google Analytics 4 Advanced
- Understanding Google Analytics 4 Sessions
- GA4 (Google Analytics 4) Measurement Protocol Tutorial
- How to Build Comparisons (Advanced Segments) in Google Analytics 4 (GA4)
- Understanding Automated Insights in Google Analytics 4 (GA4)
- Understanding Channel Groupings in Google Analytics 4 (GA4)
- Understanding Data Sampling in Google Analytics 4 (GA4)
#13 Google Analytics 4 Reports
- How to Create Custom Insights in Google Analytics 4 (GA4)
- How to Use Debug View Report in Google Analytics 4 (GA4)
#14 Google Analytics 4 Attribution
- Guide to Attribution Models in GA4 (Google Analytics 4)
- How to Change Attribution Models in GA4 (Google Analytics 4)?
- GA4 (Google Analytics 4) Conversion Paths Report in Attribution
- GA4 (Google Analytics 4) Model Comparison Report in Attribution
- Advertising Snapshot in GA4 (Google Analytics 4) Attribution
- GA4 Attribution Modelling Tutorial
#15 Google Analytics 4 Audiences
- GA4 Audiences – Creating Custom Audience in Google Analytics 4
- How to Create a Remarketing Audience in Google Analytics 4 (GA4)
- Understanding Audience Triggers in Google Analytics 4 (GA4)
- Google Analytics 4 (GA4) Predictive Audiences – Tutorial
#16 Google Analytics 4 BigQuery
Register for the FREE TRAINING...
"How to use Digital Analytics to generate floods of new Sales and Customers without spending years figuring everything out on your own."
Here’s what we’re going to cover in this training…
#1 Why digital analytics is the key to online business success.
#2 The number 1 reason why most marketers are not able to scale their advertising and maximize sales.
#3 Why Google and Facebook ads don’t work for most businesses & how to make them work.
#4 Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.
#5 The number 1 reason why conversion optimization is not working for your business.
#6 How to advertise on any marketing platform for FREE with an unlimited budget.
#7 How to learn and master digital analytics and conversion optimization in record time.
My best selling books on Digital Analytics and Conversion Optimization
Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.
Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.
Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.
Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.
About the Author
Himanshu Sharma
