Google Analytics 4 Expands BigQuery Export Schema with New Fields

July 12, 2024 at 11:01:02 AM

TL;DR New “batch_event_index” spotted in the Google Analytics 4 export schema to BigQuery. Batch_page_id and batch_ordering_id have also been elevated out of the event_params field. Looks like we might get the sequence number of GA4 events within a batch, finally.

Google Analytics 4 Expands BigQuery Export Schema with New Fields

Google Analytics 4 (GA4) has introduced new parameters in its BigQuery export schema, enhancing data analysis capabilities for users. These additions cover attribution insights and improve event sequencing capabilities.

New Traffic Sources

  1. manual_source_platform: The manual campaign source platform (utm_source_platform) that was collected with the event.
  2. manual_creative_format: The manual campaign source platform (utm_source_platform) that was collected with the event.
  3. manual_marketing_tactic: The manual campaign marketing tactic (utm_marketing_tactic) that was collected with the event.

These parameters may provide more detailed information for attribution analysis, allowing for better understanding of marketing efforts.

Event Sequencing Parameters

  1. batch_event_index: A number indicating the sequential order of each event within a batch based on their order of occurrence on the device.
  2. batch_page_id: A sequential number assigned to a page that increases for each subsequent page within an engagement.
  3. batch_ordering_id: A monotonically increasing number that is incremented each time a network request is sent from a given page.

Key updates for event sequencing:

  • A new "batch_event_index" field has been added to the export schema.
  • "batch_page_id" and "batch_ordering_id" have been moved out of the event_params field, making them more accessible.
  • These parameters are useful for identifying the order in which events are sent when transmitted in clusters or batches.
  • These changes suggest that users might now be able to determine the sequence number of GA4 events within a batch.

The new parameters added to BigQuery are not retroactive. They will only have values from the date of their inclusion in the schema. This means historical data will not include these new fields. The relocation of "batch_page_id" and "batch_ordering_id" out of the event_params field may require updates to existing queries that reference these fields.

Have more questions on this topic? Ask our AI assistant for in-depth insights.

Read more from sources 👇

Brais Calvo
Brais Calvo

Top Creator

Top Analytics Creator

Brais Calvo is a Top Analytics Creator. Part of Swipe Insight Select, a curated list of top creators.

Top Analytics Creator
- GA4 has added new parameters to its BigQuery export schema, enhancing data analysis. New traffic sources include manual_... Visit Source Open external source URL

The Only Digital Marketing Feed You'll Ever Need.

Stay informed your way. Tailored updates when and how you want them. 100% Free.

10,000+ Users

500+ Sources

1000+ Tools

Or

Related Posts

GA4 Introduces New Consent Settings Section for Enhanced Compliance Monitoring

GA4 Introduces New Consent Settings Section for Enhanced Compliance Monitoring

Google Cloud Code Extension Adds BigQuery Support in VS Code

Google Cloud Code Extension Adds BigQuery Support in VS Code

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Introduces Commercial Data Sharing via Cloud Marketplace

BigQuery Introduces Commercial Data Sharing via Cloud Marketplace

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Top-Notch Google Ads Audit Tool

Top-Notch Google Ads Audit Tool

Featured
Google Search Console Insights Removes Google Analytics Integration Trending ️‍🔥

Google Search Console Insights Removes Google Analytics Integration

Google Search Central
Google Search Central

Official Source

Official Source

Google Search Central is a Official Source. The source has been verified by Swipe Insight team.

Official Source
GA4 Launches New Key Event Tracking Recommendations for Enhanced Insights

GA4 Launches New Key Event Tracking Recommendations for Enhanced Insights

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
GA4 Implements Mandatory Configuration for Custom Events to Ensure Proper Attribution

GA4 Implements Mandatory Configuration for Custom Events to Ensure Proper Attribution

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
 Google Analytics Expands Custom Channel Groups with Manual Ad Content Support Trending ️‍🔥

Google Analytics Expands Custom Channel Groups with Manual Ad Content Support

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source

Related Tools

Marketing Auditor logo

Marketing Auditor

Verified Tool

Verified Tool

Marketing Auditor is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Automated audits for Google Ads and Analytics.

Get Featured Here

Showcase your tool in this list.

Contact Us
GA4 Auditor logo

GA4 Auditor

Verified Tool

Verified Tool

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

Verified Tool

Automated GA4 audits with actionable insights

Data Analysis
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering
GA4 SQL logo

GA4 SQL

Verified Tool

Verified Tool

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

Verified Tool

Generate GA4 BigQuery queries easily

Data Analysis
Matomo logo

Matomo

Web analytics with full data ownership

Analytics
PostHog logo

PostHog

All-in-one platform for product analytics and testing

Analytics
easyTag.io logo

easyTag.io

Effortless GA4 server-side tracking

Plausible Analytics logo

Plausible Analytics

Lightweight, privacy-friendly web analytics

Analytics
TapClicks logo

TapClicks

Automated marketing solutions powered by your data

Data Engineering
Stitch logo

Stitch

Automated cloud data pipelines, no coding needed

Data Engineering

Get Featured Here

Showcase your tool in this list.

Contact Us