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

BigQuery Enhances Resource Utilization Charts with New Metrics and Configuration Options

BigQuery Enhances Resource Utilization Charts with New Metrics and Configuration Options

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
Automate Your Marketing Audits - Say Goodbye to Manual Checklists

Automate Your Marketing Audits - Say Goodbye to Manual Checklists

Featured
Meta Expands Google Analytics Integration to More Advertisers Trending ️‍🔥

Meta Expands Google Analytics Integration to More Advertisers

Bram Van der Hallen
Bram Van der Hallen

Top Creator

Top Meta Ads Creator

Bram Van der Hallen is a Top Meta Ads Creator. Part of Swipe Insight Select, a curated list of top creators.

Top Meta Ads Creator
Google Launches Gemini AI-Powered Join Operations in BigQuery Data Preparation

Google Launches Gemini AI-Powered Join Operations in BigQuery Data Preparation

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 JavaScript User-Defined Aggregate Functions

BigQuery Introduces JavaScript User-Defined Aggregate Functions

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 Updates Guidelines for Combining Google Analytics 4 and Search Console Data Trending ️‍🔥

Google Updates Guidelines for Combining Google Analytics 4 and Search Console Data

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
BigQuery Enhances ML Bucketing Function and Set Operation Features

BigQuery Enhances ML Bucketing Function and Set Operation 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 Reduces Required Fields for Cost Data Import

Google Analytics Reduces Required Fields for Cost Data Import

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