NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.
OWOX BI Streaming
New fields were added to the session streaming schema.
Please note:
Fields hits.eCommerceActionType, hits.pageType and hits.pagePath are still available but will be depricated in future, so please use hits.eCommerceActionType.action_type, hits.page.pageType and hits.page.pagePath instead of them.
| Google BigQuery alias | Google BigQuery data type | Google Analytics dimension or metric |
|---|---|---|
visitNumber |
INTEGER | Count of Sessions |
trafficSource.adwordsClickInfo |
RECORD | |
trafficSource.adwordsClickInfo.adNetworkType |
STRING | Ad Distribution Network (adDistributionNetwork) |
trafficSource.adwordsClickInfo.adMatchedQuery |
STRING | Search Query (adMatchedQuery) |
hits.isInteraction |
BOOLEAN | Non-Interaction Hit |
hits.currency |
STRING | Currency Code |
hits.referer |
STRING | Full Referrer |
hits.dataSource |
STRING | Data Source |
hits.device |
RECORD | |
hits.device.ip |
STRING | IP Override |
hits.contentGroups |
RECORD | |
hits.contentGroups.index |
INTEGER | Page Group XX |
hits.contentGroups.value |
STRING | Page Group XX |
hits.social |
RECORD | |
hits.social.socialInteractionAction |
STRING | Social Action |
hits.social.socialInteractionNetwork |
STRING | Social Source |
hits.social.socialInteractionTarget |
STRING | Social Entity |
hits.page |
RECORD | |
hits.page.pageType |
STRING | Content grouping or a hit scope custom dimension (to collect the data set a parameter on Page type parameter on «Settings» tab of your Streaming pipeline) |
hits.page.pagePath |
STRING | Page |
hits.page.hostname |
STRING | Hostname |
hits.page.pageTitle |
STRING | Page Title |
hits.eCommerceAction |
RECORD | |
hits.eCommerceAction.action_type |
STRING | Product Action |
hits.eCommerceAction.option |
STRING | Checkout Options |
hits.eCommerceAction.step |
INTEGER | Checkout Step |
hits.eCommerceAction.list |
STRING | Product Action List |
hits.product.impressionList |
STRING | Product List Name |
hits.product.productBrand |
STRING | Product Brand |
hits.product.productVariant |
STRING | Product Variant |
hits.product.productQuantity |
INTEGER | Quantity |
hits.product.productCategory |
STRING | Product Category |
hits.product.coupon |
STRING | Product Coupon Code |
hits.promotion |
RECORD | |
hits.promotion.promoCreative |
STRING | Internal Promotion Creative |
hits.promotion.promoId |
STRING | Internal Promotion ID |
hits.promotion.promoName |
STRING | Internal Promotion Name |
hits.promotion.promoPosition |
STRING | Internal Promotion Position |
hits.transaction.hits.transactionTax |
FLOAT | Tax |
hits.transaction.hits.transactionShipping |
FLOAT | Shipping |
hits.transaction.hits.transactionCoupon |
STRING | Order Coupon Code |
hits.transaction.affiliation |
STRING | Affiliation |
hits.contentInfo |
RECORD | |
hits.contentInfo.contentDescription |
STRING | Screen Name |
hits.appInfo |
RECORD | |
hits.appInfo.name |
STRING | App Name |
hits.appInfo.version |
STRING | App Version |
hits.appInfo.id |
STRING | App ID |
hits.appInfo.installerId |
STRING | App Installer ID |
hits.timingInfo |
RECORD | |
hits.timingInfo.timingCategory |
STRING | Timing Category |
hits.timingInfo.timingVariable |
STRING | Timing Variable |
hits.timingInfo.timingLabel |
STRING | Timing Label |
hits.timingInfo.timingValue |
INTEGER | User Timing |
hits.timingInfo.pageLoad |
INTEGER | Page Load Time |
hits.timingInfo.DNS |
INTEGER | Domain Lookup Time |
hits.timingInfo.pageDownload |
INTEGER | Page Download Time |
hits.timingInfo.redirectResponse |
INTEGER | Redirection Time |
hits.timingInfo.TCPConnect |
INTEGER | Server Connection Time |
hits.timingInfo.serverResponse |
INTEGER | Server Response Time |
hits.timingInfo.DOMInteractive |
INTEGER | Document Interactive Time |
hits.timingInfo.contentLoad |
INTEGER | Document Content Loaded Time |
0 Comments