Data schema for hit tables ("streaming") – OWOX Help Center

Tables

Streamed data is separated into tables by days, according to a time zone of a view selected during the streaming setup.

The table naming is 'streaming_YYYYMMDD'.

Hit data is available for processing within 2-5 minutes after sending.

A new table for collecting hits is created 24 hours before the start of a new day. For example, on April 1 at 00:00, the 'streaming_20220402' table is created to collect the hits that will be sent on April 2 between 00:00 and 23:59. This logic ensures a smooth collection of hits without loss.

Note! Never delete a new table for the next day.

Rows

Each hit is written in a separate row.

Columns

Tables contain all the fields that are sent using The Enhanced Ecommerce plug-in in Google Analytics.

Google BigQuery alias	Google BigQuery data type	Google Analytics dimension or metric
`hitId`	STRING	Hit identifier represented as UUID (version 4)
`userId`	STRING	User ID
`userPhone`	STRING	available only in Streaming, use parameter `&tel=%2B1234567890`
`userEmail`	STRING	available only in Streaming, use parameter `&email=mail%40example.com`
`userOwoxId`	STRING	Additional user identifier that lets you track audience overlapping across domains without sending the Client ID parameter. Read more
`clientId`	STRING	Client ID
`trackingId`	STRING	Tracking ID / Web Property ID
`date`	STRING	Date
`traffic`	RECORD
`traffic.referralPath`	STRING	Referral Path
`traffic.campaign`	STRING	Campaign
`traffic.source`	STRING	Source
`traffic.medium`	STRING	Medium
`traffic.keyword`	STRING	Keyword
`traffic.adContent`	STRING	Ad Content
`traffic.campaignId`	STRING	Campaign ID
`traffic.gclid`	STRING	Google Ads ID
`traffic.dclid`	STRING	Google Display Ads ID
`device`	RECORD
`device.ip`	STRING	IP Override
`device.userAgent`	STRING	User Agent Override
`device.flashVersion`	STRING	Flash Version
`device.javaEnabled`	BOOLEAN	Java Support
`device.language`	STRING	Language
`device.screenColors`	STRING	Screen Colors
`device.screenResolution`	STRING	Screen Resolution
`geo`	RECORD
`geo.id`	STRING	Geographical Override
`geoNetwork`	RECORD	This section contains information about the geography of the user.
`geoNetwork.country`	STRING	The users' country, derived from their IP addresses.
`geoNetwork.countryIsoCode`	STRING	The user's country code. Example: US.
`geoNetwork.region`	STRING	The users' region, derived from their IP addresses.
`geoNetwork.regionIsoCode`	STRING	The region code in the user's country. Example: USUT.
`geoNetwork.city`	STRING	The users' city, derived from their IP addresses.
`geoNetwork.latitude`	FLOAT	The approximate latitude of the user's city. Derived from IP address. Locations north of the equator are represented by positive values and locations south of the equator by negative values.
`geoNetwork.longitude`	FLOAT	The approximate longitude of the user's city. Derived from IP address. Locations east of the prime meridian are represented by positive values and locations west of the prime meridian by negative values.
`customDimensions`	RECORD
`customDimensions.index`	INTEGER	Custom Dimension XX
`customDimensions.value`	STRING	Custom Dimension XX
`customMetrics`	RECORD
`customMetrics.index`	INTEGER	Custom Metric XX Value
`customMetrics.value`	FLOAT	Custom Metric XX Value
`customGroups`	RECORD
`customGroups.index`	INTEGER	Page Group XX
`customGroups.value`	STRING	Page Group XX
`hour`	INTEGER	Hour
`minute`	INTEGER	Minute
`time`	INTEGER	The time on the server according to the time zone when the hit occurred (in seconds). Note: If `hits.queueTime` not empty, then `hits.time` will contain the result of calculating the formula: (`hits.timestamp` - `hits.queueTime`) / 1000 in seconds. For example, if you send hits from the call tracking system, then `hits.queueTime` will save the time in the queue, and `hits.timestamp` will save the time when the operator accepted the call. Therefore `hits.time` will get the time when the user made a call (calculated by the formula).
`timestamp`	INTEGER	Time, when OWOX BI access point receives the hit. Measured in milliseconds passed since January 1, 1970.
`queueTime`	INTEGER	Queue Time Used to collect offline / latent hits.
`isSecure`	BOOLEAN	hits.isSecure
`isInteraction`	BOOLEAN	Non-Interaction Hit
`currency`	STRING	Currency Code
`referer`	STRING	Full Referrer
`dataSource`	STRING	Data Source
`social`	RECORD
`social.socialInteractionAction`	STRING	Social Action
`social.socialInteractionNetwork`	STRING	Social Source
`social.socialInteractionTarget`	STRING	Social Entity
`type`	STRING	The type of hit
`page`	RECORD
`page.pagePath`	STRING	Page
`page.hostname`	STRING	Hostname
`page.pageTitle`	STRING	Page Title
`eCommerceAction`	RECORD
`eCommerceAction.action_type`	STRING	Product Action
`eCommerceAction.option`	STRING	Checkout Options
`eCommerceAction.step`	INTEGER	Checkout Step
`eCommerceAction.list`	STRING	Product Action List. A list where action on product occurred (`product.isImpression=FALSE`).
`experiment`	RECORD	Content experiments. The value can be submitted in several ways: using parameter exp, where the experiment id and variation id are defined and separated with a dot (exp=4KxxxFg.1); using parameters expid and expvar, where the experiment id and variation id are defined (expid=4KxxxFg&expvar=1); using parameters xid and xvar, where the experiment id and variation id are defined (xid=4KxxxFg&xvar=1); using parameter utm_expid in URL, where the experiment id is defined (https:/site.com/xxx/?utm_expid=4KxxxFg); using parameter utm_expid in URL, where the experiment id and variation id are defined (https:/site.com/xxx/?utm_expid=.4KxxxFg.1, where 4KxxxFg is experiment id and 1 is variation id). Applied automatically in Google Optimize.
`experiment.experimentId`	STRING	Experiment ID
`experiment.experimentVariant`	STRING	Experiment variant
`product`	RECORD
`product.isImpression`	BOOLEAN	hits.product.isImpression
`product.impressionList`	STRING	Product List Name. A list where a product was shown (`product.isImpression=TRUE`).
`product.productBrand`	STRING	Product Brand
`product.productPrice`	FLOAT	Product Revenue
`product.productQuantity`	INTEGER	Quantity
`product.productSku`	STRING	Product SKU
`product.productVariant`	STRING	Product Variant
`product.productCategory`	STRING	Product Category
`product.productName`	STRING	Product
`product.position`	INTEGER	Product List Position
`product.coupon`	STRING	Product Coupon Code
`product.customDimensions`	RECORD
`product.customDimensions.index`	INTEGER	Product Custom Dimension
`product.customDimensions.value`	STRING	Product Custom Dimension
`product.customMetrics`	RECORD
`product.customMetrics.index`	INTEGER	Product Custom Metric
`product.customMetrics.value`	STRING	Product Custom Metric
`promotion`	RECORD
`promotion.promoCreative`	STRING	Internal Promotion Creative
`promotion.promoId`	STRING	Internal Promotion ID
`promotion.promoName`	STRING	Internal Promotion Name
`promotion.promoPosition`	STRING	Internal Promotion Position
`promotionActionInfo`	STRING	Promotion Action
`transaction`	RECORD
`transaction.transactionId`	STRING	Transaction ID
`transaction.transactionRevenue`	FLOAT	Revenue
`transaction.transactionTax`	FLOAT	Tax
`transaction.transactionShipping`	FLOAT	Shipping
`transaction.transactionCoupon`	STRING	Order Coupon Code
`transaction.affiliation`	STRING	Affiliation
`contentInfo`	RECORD
`contentInfo.contentDescription`	STRING	Screen Name
`appInfo`	RECORD
`appInfo.name`	STRING	App Name
`appInfo.version`	STRING	App Version
`appInfo.id`	STRING	App ID
`appInfo.installerId`	STRING	App Installer ID
`exceptionInfo`	RECORD
`exceptionInfo.description`	STRING	Exception Description
`exceptionInfo.isFatal`	BOOLEAN	Is Exception Fatal?
`eventInfo`	RECORD
`eventInfo.eventCategory`	STRING	Event Category
`eventInfo.eventAction`	STRING	Event Action
`eventInfo.eventLabel`	STRING	Event Label
`eventInfo.eventValue`	STRING	Event Value
`timingInfo`	RECORD
`timingInfo.timingCategory`	STRING	Timing Category The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.timingVariable`	STRING	Timing Variable The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.timingLabel`	STRING	Timing Label The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.timingValue`	INTEGER	User Timing The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.pageLoad`	INTEGER	Page Load Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.DNS`	INTEGER	Domain Lookup Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.pageDownload`	INTEGER	Page Download Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.redirectResponse`	INTEGER	Redirection Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.TCPConnect`	INTEGER	Server Connection Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.serverResponse`	INTEGER	Server Response Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.DOMInteractive`	INTEGER	Document Interactive Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.
`timingInfo.contentLoad`	INTEGER	Document Content Loaded Time The field is automatically filled in for the hit types 'timing' and 'adtiming'.

Tables contain repeated records. When selecting data, tables will be flattened over nested fields.

Tables

Rows

Columns

0 Comments

Related articles