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. |
geo.continent |
STRING | The continent from which events were reported, based on IP address. |
geo.sub_continent |
STRING | The subcontinent from which events were reported, based on IP address. |
geo.country |
STRING | The country from which events were reported, based on IP address. |
geo.region |
STRING | The region from which events were reported, based on IP address. |
geo.metro |
STRING | The metro from which events were reported, based on IP address. |
geo.city |
STRING | The city from which events were reported, based on IP address. |
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. |
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. |
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