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