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 dispatch. More about Google Analytics to BigQuery streaming SLA.

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
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 AdWords 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
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 available only in Streaming, hit time on the server according to the time zone
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 Hit type
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 an action on product occurred (product.isImpression=FALSE).
experiment RECORD Content experiments
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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.