January 23, 2025 — OWOX BI Streaming. 97 New Fields Added to the 'events_intraday_' Table

changelog-2025-01-23-new-fields-added-into-owox-bi-streaming(opt).png

We’re excited to announce an expansion of fields in GA4 event-based OWOX BI Streaming! 97 new fields have been added to all ‘events_intraday_’ tables in active Streamings beginning from January 1, 2024. 

Key Benefits

  • Backward Compatibility: The expanded schema ensures full compatibility with Google Analytics 4’s native BigQuery exports.
  • Seamless Transition: Users can easily switch to OWOX BI Streaming data in their existing reports without rewriting SQL queries.
  • Enhanced Reporting: The additional fields provide greater flexibility and granularity for advanced analytics.

What’s Included?

The updated schema now includes 97 new fields designed to provide deeper insights and support more comprehensive reporting.

Note: Starting January 22, 2025, actual values from received events are parsed and saved into the fields: batch_page_id, batch_ordering_id, batch_event_index, and collected_traffic_source.

 

List of added fields with actual values populated

Field name Type Description
batch_page_id INTEGER A sequential number assigned to a page that increases for each subsequent page within an engagement.
batch_ordering_id INTEGER A monotonically increasing number that is incremented each time a network request is sent from a given page.
batch_event_index INTEGER A number indicating the sequential order of each event within a batch based on their order of occurrence on the device.
collected_traffic_source RECORD The collected_traffic_source RECORD contains the traffic source data that was present within the events that were collected.
collected_traffic_source.manual_campaign_id STRING The manual campaign id (utm_id) that was collected with the event.
collected_traffic_source.manual_campaign_name STRING The manual campaign name (utm_campaign) that was collected with the event.
collected_traffic_source.manual_source STRING The manual campaign source (utm_source) that was collected with the event. Also includes parsed parameters from referral params, not just UTM values.
collected_traffic_source.manual_medium STRING The manual campaign medium (utm_medium) that was collected with the event. Also includes parsed parameters from referral params, not just UTM values.
collected_traffic_source.manual_term STRING The manual campaign keyword/term (utm_term) that was collected with the event.
collected_traffic_source.manual_content STRING The additional manual campaign metadata (utm_content) that was collected with the event.
collected_traffic_source.manual_source_platform STRING The manual campaign source platform (utm_source_platform) that was collected with the event.
collected_traffic_source.manual_creative_format STRING The manual campaign creative format (utm_creative_format) that was collected with the event.
collected_traffic_source.manual_marketing_tactic STRING The manual campaign marketing tactic (utm_marketing_tactic) that was collected with the event.
collected_traffic_source.gclid STRING The Google click identifier that was collected with the event.
collected_traffic_source.dclid STRING The DoubleClick Click Identifier for Display and Video 360 and Campaign Manager 360 that was collected with the event.
collected_traffic_source.srsltid STRING The Google Merchant Center identifier that was collected with the event.

 

List of added fields that remain unpopulated

Field name Type Description
session_traffic_source_last_click RECORD [This field is not populated]
The session_traffic_source_last_click RECORD contains the last-click attributed session traffic source data across Google ads and manual contexts, where available.
session_traffic_source_last_click.manual_campaign RECORD  
session_traffic_source_last_click.manual_campaign.campaign_id STRING The ID of the last clicked manual campaign
session_traffic_source_last_click.manual_campaign.campaign_name STRING The name of the last clicked manual campaign
session_traffic_source_last_click.manual_campaign.source STRING The specific source within the platform of the last clicked manual campaign
session_traffic_source_last_click.manual_campaign.medium STRING The medium of the last clicked manual campaign (e.g., paid search, organic search, email)
session_traffic_source_last_click.manual_campaign.term STRING The keyword/search term of the last clicked manual campaign
session_traffic_source_last_click.manual_campaign.content STRING Additional metadata of the last clicked manual campaign
session_traffic_source_last_click.manual_campaign.source_platform STRING The platform of the last clicked manual campaign (e.g., search engine, social media)
session_traffic_source_last_click.manual_campaign.creative_format STRING The format of the creative of the last clicked manual campaign
session_traffic_source_last_click.manual_campaign.marketing_tactic STRING The marketing tactic of the last clicked manual campaign
session_traffic_source_last_click.google_ads_campaign RECORD  
session_traffic_source_last_click.google_ads_campaign.customer_id STRING The customer ID associated with the Google Ads account
session_traffic_source_last_click.google_ads_campaign.account_name STRING The name of the Google Ads account
session_traffic_source_last_click.google_ads_campaign.campaign_id STRING The ID of the Google Ads campaign
session_traffic_source_last_click.google_ads_campaign.campaign_name STRING The name of the Google Ads campaign
session_traffic_source_last_click.google_ads_campaign.ad_group_id STRING The ID of the ad group within the Google Ads campaign
session_traffic_source_last_click.google_ads_campaign.ad_group_name STRING The name of the ad group within the Google Ads campaign
session_traffic_source_last_click.cross_channel_campaign RECORD  
session_traffic_source_last_click.cross_channel_campaign.campaign_id STRING The ID of the last clicked cross-channel campaign
session_traffic_source_last_click.cross_channel_campaign.campaign_name STRING The name of the last clicked cross-channel campaign
session_traffic_source_last_click.cross_channel_campaign.source STRING The specific source within the platform of the last clicked cross-channel campaign
session_traffic_source_last_click.cross_channel_campaign.medium STRING The medium of the last clicked cross-channel campaign
session_traffic_source_last_click.cross_channel_campaign.source_platform STRING The platform of the last clicked cross-channel campaign
session_traffic_source_last_click.cross_channel_campaign.default_channel_group STRING  
session_traffic_source_last_click.cross_channel_campaign.primary_channel_group STRING  
session_traffic_source_last_click.sa360_campaign RECORD  
session_traffic_source_last_click.sa360_campaign.campaign_id STRING The ID of the last clicked SA360 campaign
session_traffic_source_last_click.sa360_campaign.campaign_name STRING The name of the last clicked SA360 campaign
session_traffic_source_last_click.sa360_campaign.source STRING The specific source within the platform of the last clicked SA360 campaign
session_traffic_source_last_click.sa360_campaign.medium STRING The medium of the last clicked SA360 campaign
session_traffic_source_last_click.sa360_campaign.ad_group_id STRING The ID of the ad group within the SA360 campaign
session_traffic_source_last_click.sa360_campaign.ad_group_name STRING The name of the ad group within the SA360 campaign
session_traffic_source_last_click.sa360_campaign.creative_format STRING The format of the creative of the last clicked SA360 campaign
session_traffic_source_last_click.sa360_campaign.engine_account_name STRING The name of the SA360 engine account
session_traffic_source_last_click.sa360_campaign.engine_account_type STRING The type of engine account containing the SA360 campaign
session_traffic_source_last_click.sa360_campaign.manager_account_name STRING The name of the SA360 manager account
session_traffic_source_last_click.cm360_campaign RECORD  
session_traffic_source_last_click.cm360_campaign.campaign_id STRING The ID of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.campaign_name STRING The name of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.source STRING The specific source of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.medium STRING The medium of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.account_id STRING The ID of the CM360 account
session_traffic_source_last_click.cm360_campaign.account_name STRING The name of the CM360 account
session_traffic_source_last_click.cm360_campaign.advertiser_id STRING The ID of the CM360 advertiser
session_traffic_source_last_click.cm360_campaign.advertiser_name STRING The name of the CM360 advertiser
session_traffic_source_last_click.cm360_campaign.creative_id STRING The ID of the creative of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.creative_format STRING The format of the creative of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.creative_name STRING The name of the creative of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.creative_type STRING The creative type of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.creative_type_id STRING The creative type ID of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.creative_version STRING The creative version of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.placement_id STRING The ID of the placement of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.placement_cost_structure STRING The placement cost structure of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.placement_name STRING The name of the placement of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.rendering_id STRING The rendering ID of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.site_id STRING The site ID of the last clicked CM360 campaign
session_traffic_source_last_click.cm360_campaign.site_name STRING The site name of the last clicked CM360 campaign
session_traffic_source_last_click.dv360_campaign RECORD  
session_traffic_source_last_click.dv360_campaign.campaign_id STRING The ID of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.campaign_name STRING The name of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.source STRING The specific source within the platform of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.medium STRING The medium of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.advertiser_id STRING The ID of the DV360 advertiser
session_traffic_source_last_click.dv360_campaign.advertiser_name STRING The name of the DV360 advertiser
session_traffic_source_last_click.dv360_campaign.creative_id STRING The ID of the creative of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.creative_format STRING The format of the creative of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.creative_name STRING The name of the creative of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.exchange_id STRING The exchange ID of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.exchange_name STRING The exchange name of the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.insertion_order_id STRING The ID of the insertion order in the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.insertion_order_name STRING The name of the insertion order in the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.line_item_id STRING The ID of the line item in the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.line_item_name STRING The name of the line item in the last clicked DV360 campaign
session_traffic_source_last_click.dv360_campaign.partner_id STRING The ID of the DV360 partner
session_traffic_source_last_click.dv360_campaign.partner_name STRING The name of the DV360 partner
publisher RECORD [This field is not populated]
The publisher RECORD contains information about events sourced from a publisher integration related to the display of ads, that is, AdMob.
publisher.ad_revenue_in_usd STRING Estimated ad revenue resulting from this event, represented in USD.
publisher.ad_format STRING Describes the way ads appeared and where they were located.
publisher.ad_source_name STRING The source network that served an ad.
publisher.ad_unit_id STRING The name you chose to describe this Ad unit. Ad units are containers that you place in your apps to show ads to users.

 

You can view the complete schema of the ‘events_intraday_’ table, including the newly added fields, in our documentation.

 

Our support team is here to help! For any questions or assistance, reach out to bi@owox.com.

Thank you for choosing OWOX BI for your analytics needs!

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.