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 streaming setup.

Tables naming is 'streaming_YYYYMMDD'.

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

Rows

Each hit is written to a separate row.

Columns

The columns within the table are listed below.

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	Hit time on the server according to the time zone
`timestamp`	INTEGER	Hit time in milliseconds passed since January 1, 1970
`queueTime`	INTEGER	Queue Time
`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
`timingInfo.timingVariable`	STRING	Timing Variable
`timingInfo.timingLabel`	STRING	Timing Label
`timingInfo.timingValue`	INTEGER	User Timing
`timingInfo.pageLoad`	INTEGER	Page Load Time
`timingInfo.DNS`	INTEGER	Domain Lookup Time
`timingInfo.pageDownload`	INTEGER	Page Download Time
`timingInfo.redirectResponse`	INTEGER	Redirection Time
`timingInfo.TCPConnect`	INTEGER	Server Connection Time
`timingInfo.serverResponse`	INTEGER	Server Response Time
`timingInfo.DOMInteractive`	INTEGER	Document Interactive Time
`timingInfo.contentLoad`	INTEGER	Document Content Loaded Time

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

Tables

Rows

Columns

0 Comments

Related articles