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!
0 Comments