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.
Important!This algorithm works with Google Analytics Universal data format only.
Tables
Streamed data is separated into tables by days, according to a time zone of a Google Analytics view selected during streaming setup.
Tables naming is 'session_streaming_YYYYMMDD'.
Session data are generated within 24 hours (for example data for 13.04.2016 will be available not earlier than 14.04.2016).
Rows
Each session is written to a separate row.
Columns
The columns within the table are listed below.
| Google BigQuery alias | Google BigQuery data type | Google Analytics dimension or metric |
|---|---|---|
user |
RECORD | |
user.Id |
STRING | User ID |
user.phone |
STRING | available only in Streaming, use parameter &tel=%2B1234567890 |
user.email |
STRING | available only in Streaming, use parameter &email=mail%40example.com |
clientId |
STRING | Client ID |
date |
STRING | Record date in "YYYY-MM-DD" format |
sessionId |
STRING | Session ID (value of custom dimension chosen on «Settings» tab of your Streaming pipeline) |
visitNumber |
INTEGER | Count of Sessions |
newVisits |
INTEGER | Visitor type(1 - new || NULL - returned) |
device |
RECORD | |
device.deviceCategory |
STRING | deviceCategory |
device.browser |
STRING | browser |
device.browserVersion |
STRING | browserVersion |
device.operatingSystem |
STRING | operatingSystem |
device.operatingSystemVersion |
STRING | operatingSystemVersion |
device.mobileDeviceInfo |
STRING | Data from mobileDeviceBranding, mobileDeviceModel и mobileDeviceMarketingName. |
geoNetwork |
RECORD | |
geoNetwork.city |
STRING | city |
geoNetwork.region |
STRING | region |
geoNetwork.country |
STRING | country |
trafficSource |
RECORD | |
trafficSource.source |
STRING | Source |
trafficSource.medium |
STRING | Medium |
trafficSource.campaign |
STRING | Campaign |
trafficSource.keyword |
STRING | Keyword |
trafficSource.adContent |
STRING | |
trafficSource.channelGrouping |
STRING | channelGrouping |
trafficSource.adwordsClickInfo |
RECORD | |
trafficSource.adwordsClickInfo.adNetworkType |
STRING | Ad Distribution Network (adDistributionNetwork) |
trafficSource.adwordsClickInfo.adMatchedQuery |
STRING | Search Query (adMatchedQuery) |
trafficSource.adCost |
FLOAT | The total sessions cost attributed evenly between sessions according to the UTM tags 'source', 'medium', 'campaign', 'keyword', and 'content' if the tags perfectly match in all sessins |
trafficSource.attributedAdCost |
FLOAT | When one or more tags are unknown, the total session cost is attributed evenly between the sessions according to the known tags More on attributed ad cost |
totals |
RECORD | All totals data is taken from GA |
totals.hits |
INTEGER | Total number of hits by the session |
totals.pageviews |
INTEGER | Total number of pageviews by the session |
totals.events |
INTEGER | Total number of events by the session |
totals.transactions |
INTEGER | Total number of transactions by the session |
totals.visits |
INTEGER | The total number of visits by the session |
totals.screenviews |
INTEGER | Total number of screenviews by the session |
totalsStreaming |
RECORD | All streaming totals data is taken from Hit Streaming |
totalsStreaming.hits |
INTEGER | SUM(rows) |
totalsStreaming.events |
INTEGER | SUM(rows) where type='event' |
totalsStreaming.transactions |
INTEGER | SUM(rows) where action='purchase' |
totalsStreaming.pageviews |
INTEGER | SUM(rows) where type='pageview' |
totalsStreaming.screenviews |
INTEGER | SUM(rows) where type='screenview' |
hits |
RECORD | |
hits.hitId |
STRING | Hit identifier represented as UUID (version 4) |
hits.isEntrance |
INTEGER | The first pageview or screenview hit in the session (1 || NULL) |
hits.isExit |
INTEGER | The last pageview or screenview hit in the sesiion (1 || NULL) |
hits.time |
INTEGER | Hits time |
hits.type |
STRING | The type of hit |
hits.pagePath |
STRING | The field is deprecated, please use hits.page.pagePath instead of it. |
hits.pageType |
STRING | TThe field is deprecated, please use hits.page.pageType instead of it. |
hits.eCommerceActionType |
STRING | The field is deprecated, please use hits.eCommerceAction.action_type instead of it. |
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. A list where an action on product occurred ( product.isImpression=FALSE). |
hits.experiment |
RECORD | Content experiments |
hits.experiment.experimentId |
STRING | Experiment ID |
hits.experiment.experimentVariant |
STRING | Experiment variant |
hits.product |
RECORD | |
hits.product.isImpression |
BOOLEAN | hits.product.isImpression |
hits.product.impressionList |
STRING | Product List Name. A list where a product was shown ( product.isImpression=TRUE). |
hits.product.productListName |
STRING | productListName |
hits.product.productBrand |
STRING | Product Brand |
hits.product.productSku |
STRING | Product SKU |
hits.product.productVariant |
STRING | Product Variant |
hits.product.productPrice |
FLOAT | Product Price |
hits.product.localProductPrice |
FLOAT | Local Product Price converted via Yahoo Currecy Converter |
hits.product.productQuantity |
INTEGER | Quantity |
hits.product.productCategory |
STRING | Product Category |
hits.product.productName |
STRING | Product |
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.promotionActionInfo |
STRING | Promotion Action |
hits.transaction |
RECORD | |
hits.transaction.transactionId |
STRING | Transaction ID |
hits.transaction.transactionRevenue |
FLOAT | Revenue |
hits.transaction.localTransactionRevenue |
FLOAT | Local Revenue converted via Yahoo Currecy Converter |
transaction.transactionTax |
FLOAT | Tax |
hits.transaction.localTransactionTax |
FLOAT | Local Tax converted via Yahoo Currecy Converter |
transaction.transactionShipping |
FLOAT | Shipping |
hits.transaction.localTransactionShipping |
FLOAT | Local Shipping converted via Yahoo Currecy Converter |
transaction.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.eventInfo |
RECORD | |
hits.eventInfo.eventCategory |
STRING | Event Category |
hits.eventInfo.eventAction |
STRING | Event Action |
hits.eventInfo.eventLabel |
STRING | Event Label |
hits.eventInfo.eventValue |
INTEGER | Event Value |
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 |
Tables contain repeated records. When selecting data, tables will be flattened over nested fields.
0 Comments