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 |
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 | 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.
0 Comments