Data schema for 'events_intraday_' table

NoteThis table schema is fully compatible with the table schema from native GA4 → BigQuery export.

Tables. Streamed data is separated into tables by days. The table naming is 'events_intraday_YYYYMMDD'.

Rows. Each event is written in a separate row.

Columns. The table contains all of the following columns.

 

App

ImportantThe algorithm will fill the ‘app_info’ fields with NULL. The OWOX BI event-based web streaming only processes Web and Measurement Protocol requests.

Field name Type Description
app_info RECORD A record of information on the app.
app_info.id STRING The package name or bundle ID of the app.
app_info.firebase_app_id STRING The Firebase App ID associated with the app
app_info.install_source STRING The store that installed the app.
app_info.version STRING The app's versionName (Android) or short bundle version.

 

Device

Field name Type Description
device RECORD A record of device information.
device.category STRING The device category (mobile, tablet, desktop).
device.mobile_brand_name STRING The device brand name.
device.mobile_model_name STRING The device model name.
device.mobile_marketing_name STRING The device marketing name.
device.mobile_os_hardware_model STRING The device model information retrieved directly from the operating system.
device.operating_system STRING The operating system of the device.
device.operating_system_version STRING The OS version.
device.vendor_id STRING IDFV (present only if IDFA is not collected).
device.advertising_id STRING Advertising ID/IDFA.
device.language STRING The OS language.
device.time_zone_offset_seconds INTEGER The offset from GMT in seconds.
device.is_limited_ad_tracking BOOLEAN The device's Limit Ad Tracking setting.
On iOS14+, returns false if the IDFA is non-zero.
device.web_info.browser STRING The browser in which the user viewed content.
device.web_info.browser_version STRING The version of the browser in which the user viewed content.
device.web_info.hostname STRING The hostname associated with the logged event.

 

Stream and platform

Field name Type Description
stream_id STRING The numeric ID of the stream
platform STRING The platform on which the app was built.

 

User

Field name Type Description
user_first_touch_timestamp INTEGER The time (in microseconds) at which the user first opened the app or visited the site.
user_id STRING The user ID set via the setUserId API.
user_pseudo_id STRING The pseudonymous id (e.g., app instance ID) for the user.
user_properties RECORD A repeated record of user properties set with the setUserProperty API.
user_properties.key STRING The name of the user property.
user_properties.value RECORD A record for the user property value.
user_properties.value.string_value STRING The string value of the user property.
user_properties.value.int_value INTEGER The integer value of the user property.
user_properties.value.double_value FLOAT The double value of the user property.
user_properties.value.float_value FLOAT This field is currently unused.
user_properties.value.set_timestamp_micros INTEGER

The time (in microseconds) at which the user property was last set.

This field is not populated in intraday tables.

user_ltv RECORD A record of Lifetime Value information about the user. This field is not populated in intraday tables.
user_ltv.revenue FLOAT The Lifetime Value (revenue) of the user. This field is not populated in intraday tables.
user_ltv.currency STRING The Lifetime Value (currency) of the user. This field is not populated in intraday tables.

 

Campaign

Note:This field is not populated in intraday tables. However, any custom logic can be applied to calculate it at any time with OWOX BI Transformation.

Field name Type Description
traffic_source RECORD Name of the traffic source. This field is not populated in intraday tables.
traffic_source.name STRING Name of the marketing campaign. This field is not populated in intraday tables.
traffic_source.medium STRING Name of the medium (organic, cpc, email, etc). This field is not populated in intraday tables.
traffic_source.source STRING Name of the network. This field is not populated in intraday tables.

 

Geo

Field name Type Description
geo RECORD A record of the user's geographic information. Geodata is determined based on visitors' IP addresses, which we receive only from those who have consented to share this data.
geo.continent STRING The continent from which events were reported.
geo.sub_continent STRING The subcontinent from which events were reported. This field remains unfilled.
geo.country STRING The country from which events were reported.
geo.region STRING The region from which events were reported.
geo.metro STRING The metro from which events were reported. This field remains unfilled.
geo.city STRING The city from which events were reported.

 

Event

Field name Type Description
event_date STRING The date on which the event was logged (YYYYMMDD format in the registered timezone of your app).
event_timestamp INTEGER The time (in microseconds, UTC) at which the event was logged on the client.
event_previous_timestamp INTEGER The time (in microseconds, UTC) at which the event was previously logged on the client.
event_name STRING The name of the event. The table clustering is configured based on this field.
event_params RECORD A repeated record of the parameters associated with this event.
event_params.key STRING The event parameter's key.
event_params.value RECORD A record of the event parameter's value.
event_params.value.string_value STRING The string value of the event parameter.
event_params.value.int_value INTEGER The integer value of the event parameter.
event_params.value.double_value FLOAT The double value of the event parameter.
event_params.value.float_value FLOAT The float value of the event parameter. This field is currently unused.
event_value_in_usd FLOAT The currency-converted value (in USD) of the event's "value" parameter.
event_bundle_sequence_id INTEGER

The sequential ID of the bundle in which these events were uploaded.

This field is not populated in intraday tables.

event_server_timestamp_offset INTEGER Timestamp offset between collection time and upload time in micros.

 

Ecommerce

Field name Type Description
ecommerce RECORD A record of information about ecommerce.
ecommerce.total_item_quantity INTEGER Total number of items in this event, which is the sum of items.quantity.
ecommerce.purchase_revenue_in_usd FLOAT Purchase revenue of this event, represented in USD with standard unit. Populated for purchase event only.
ecommerce.purchase_revenue FLOAT Purchase revenue of this event, represented in local currency with standard unit. Populated for purchase event only.
ecommerce.refund_value_in_usd FLOAT The amount of refund in this event, represented in USD with standard unit. Populated for refund event only.
ecommerce.refund_value FLOAT The amount of refund in this event, represented in local currency with standard unit. Populated for refund event only.
ecommerce.shipping_value_in_usd FLOAT The shipping cost in this event, represented in USD with standard unit.
ecommerce.shipping_value FLOAT The shipping cost in this event, represented in local currency.
ecommerce.tax_value_in_usd FLOAT The tax value in this event, represented in USD with standard unit.
ecommerce.tax_value FLOAT The tax value in this event, represented in local currency with standard unit.
ecommerce.transaction_id STRING The transaction ID of the ecommerce transaction.
ecommerce.unique_items INTEGER The number of unique items in this event, based on item_id, item_name, and item_brand.

 

Items

Field name Type Description
items RECORD A repeated record of items included in this event.
items.item_id STRING The ID of the item.
items.item_name item_name The name of the item.
items.item_brand STRING The brand of the item.
items.item_variant STRING The variant of the item.
items.item_category STRING The category of the item.
items.item_category2 STRING The sub category of the item.
items.item_category3 STRING The sub category of the item.
items.item_category4 STRING The sub category of the item.
items.item_category5 STRING The sub category of the item.
items.price_in_usd FLOAT The price of the item, in USD with standard unit.
items.price FLOAT The price of the item in local currency.
items.quantity INTEGER The quantity of the item. Quantity set to 1 if not specified.
items.item_revenue_in_usd FLOAT The revenue of this item, calculated as price_in_usd * quantity. It is populated for purchase events only, in USD with standard unit.
items.item_revenue FLOAT The revenue of this item, calculated as price * quantity. It is populated for purchase events only, in local currency with standard unit.
items.item_refund_in_usd FLOAT The refund value of this item, calculated as price_in_usd * quantity. It is populated for refund events only, in USD with standard unit.
items.item_refund FLOAT The refund value of this item, calculated as price * quantity. It is populated for refund events only, in local currency with standard unit.
items.coupon STRING Coupon code applied to this item.
items.affiliation STRING A product affiliation to designate a supplying company or brick and mortar store location.
items.location_id STRING The location associated with the item.
items.item_list_id STRING The ID of the list in which the item was presented to the user.
items.item_list_name STRING The name of the list in which the item was presented to the user.
items.item_list_index STRING The position of the item in a list.
items.promotion_id STRING The ID of a product promotion.
items.promotion_name STRING The name of a product promotion.
items.creative_name STRING The name of a creative used in a promotional spot.
items.creative_slot STRING The name of a creative slot.
items.item_params RECORD This field was added starting from January 1, 2023, initially set to 'NULL'. Actual values from received events started being parsed and saved into these fields beginning on March 13, 2024. More details
items.item_params.key STRING  
items.item_params.value RECORD  
items.item_params.value.string_value STRING  
items.item_params.value.int_value INTEGER  
items.item_params.value.float_value FLOAT  
items.item_params.value.double_value FLOAT  

 

Web

Field name Type Description
web_info RECORD A record of information for web data.

 

Privacy info

The following fields are based on the consent status of your users when you are using consent mode.

Field name Type Description
privacy_info.ads_storage STRING Whether ad targeting is enabled for a user.
Possible values: Yes, No, Unset
privacy_info.analytics_storage STRING Whether Analytics storage is enabled for the user.
Possible values: Yes, No, Unset
privacy_info.uses_transient_token STRING Whether a web user has denied Analytics storage and the developer has enabled measurement without cookies based on transient tokens in server data.
Possible values: Yes, No, Unset

 

OWOX custom fields

Field name Type Description
owox.event_id STRING Unique ID of each event set by OWOX BI.

It includes the sequence number of how the event actually happened. See how to use it.

owox.user_id STRING OWOX BI user identifier taken from the custom cookie file ouid that contains a unique anonymous ID.
owox.request_source STRING The source of the incoming request to OWOX BI access point. Possible values: Measurement Protocol, Client Side.
owox.is_bot BOOLEAN The field would get a ‘true’ value if the event was generated by a bot. Or returns 'false' if a real user generates the event.

 

Debug

Field name Type Description
debug_info RECORD  
debug_info.pipeline_id STRING Unique ID of pipeline in OWOX BI.
debug_info.request_id STRING Unique ID of each request set by OWOX BI. May contain more than 1 event.
debug_info.timezone STRING The selected timezone in the pipeline.
debug_info.raw_request STRING Contains technical info. It helps OWOX BI specialists fix technical issues in case they occur. PII data were excluded according to Consent Mode.



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.