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

Related Posts

BigQuery Launches Vector Search and Vector Index Features

BigQuery Launches Vector Search and Vector Index Features

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
Google Analytics 4 Introduces New Features and Interface Improvements Trending ️‍🔥

Google Analytics 4 Introduces New Features and Interface Improvements

Josh Silverbauer
Josh Silverbauer

Top Creator

Top Analytics Creator

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

Top Analytics Creator
Automate Your GA4 Audit - Say Goodbye to Manual Checks!

Automate Your GA4 Audit - Say Goodbye to Manual Checks!

Sponsored
GA4 Auditor
GA4 Auditor

Verified Sponsor

Verified Sponsor

GA4 Auditor is a Verified Sponsor. Want to get featured here? Contact us.

Verified Sponsor
BigQuery Data Transfer Now Supports Incremental Teradata Migrations

BigQuery Data Transfer Now Supports Incremental Teradata Migrations

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
Google Analytics 4 Introduces Plot Rows Feature for Line Charts

Google Analytics 4 Introduces Plot Rows Feature for Line Charts

Google Expands Tag Diagnostics and Introduces Integrated Consent Management Setup Trending ️‍🔥

Google Expands Tag Diagnostics and Introduces Integrated Consent Management Setup

Google
Google

Official Source

Official Source

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

Official Source

Related Tools

Featured
GA4 Auditor logo

GA4 Auditor

Automated GA4 audits with actionable insights

Data Analysis
PostHog logo

PostHog

All-in-one platform for product analytics and testing

Analytics
easyTag.io logo

easyTag.io

Effortless GA4 server-side tracking

Tracking & Attribution
Plausible Analytics logo

Plausible Analytics

Lightweight, privacy-friendly web analytics

Analytics
GA4 SQL logo

GA4 SQL

Generate GA4 BigQuery queries easily

Data Analysis
TapClicks logo

TapClicks

Automated marketing solutions powered by your data

Data Engineering
Stitch logo

Stitch

Automated cloud data pipelines, no coding needed

Data Engineering
Akkio logo

Akkio

AI-powered analytics for agencies

Data Analysis
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering