Schema for session collection based on OWOX BI algorithm

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 'owoxbi_sessions_YYYYMMDD'.

Session data are generated within 24 hours (for example data for 13.09.2017 will be available not earlier than 14.09.2017).

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 This section contains user info.
user.id STRING Overridden User ID.
user.phone STRING The user phone number. Available only in OWOX BI tables, use parameter &tel.
user.email STRING The user email. Available only in OWOX BI tables, use parameter &email.
clientId STRING This anonymously identifies a particular user, device, or browser instance. For the web, this is generally stored as a first-party cookie with a two-year expiration. For mobile apps, this is randomly generated for each particular instance of an application install.
date STRING Record date in "YYYY-MM-DD" format.
sessionId STRING An identifier for this session.
visitNumber INTEGER "The session number for this user. If this is the first session, then this is set to 1.
Currently unavailable. This field will be added in the next product update for session streaming tables."
device RECORD This section contains information about the user devices.
device.deviceCategory STRING The type of device (Mobile, Tablet, Desktop etc).
device.browser STRING The browser used.
device.browserVersion STRING The version of the browser used.
device.operatingSystem STRING The operating system of the device.
device.operatingSystemVersion STRING The version of the operating system.
device.mobileDeviceInfo STRING The branding, model, and marketing name used to identify the mobile device.
geoNetwork RECORD This section contains information about the geography of the user.
geoNetwork.country STRING The country from which sessions originated, based on IP address.
geoNetwork.region STRING The region from which sessions originate, derived from IP addresses.
geoNetwork.city STRING Users' city, derived from their IP addresses.
trafficSource RECORD This section contains information about the Traffic Source from which the session originated.
trafficSource.channelGrouping STRING The Default Channel Group associated with an end user's session.
Currently unavailable."
trafficSource.source STRING The source of the traffic source. Could be the name of the search engine, the referring hostname, or a value of the utm_source URL parameter.
trafficSource.medium STRING The medium of the traffic source from the utm_medium URL parameter. Could be "organic", "cpc", "referral" etc.
trafficSource.campaign STRING The campaign value. Usually set by the utm_campaign URL parameter.
trafficSource.keyword STRING "The keyword of the traffic source, usually set when the trafficSource.medium is "organic" or "cpc". Can be set by the utm_term URL parameter.
For AdWords campaigns may be descriptive string for the targeting criterion."
trafficSource.adContent STRING The ad content of the traffic source. Can be set by the utm_content URL parameter.
trafficSource.adGroup STRING The value of an ad group for one or more ads which target a shared set of keywords.
trafficSource.keywordMatchType STRING The type of searching trigger that controls how your ads will appear.
trafficSource.adwordsClickInfo RECORD Currently unavailable. This section will contain information about the Adwords click info if there is any associated with this session.
trafficSource.adwordsClickInfo.adNetworkType STRING Currently unavailable. The network (Content, Search, Search partners, etc.) used to deliver the ads.
trafficSource.adwordsClickInfo.adMatchedQuery STRING Currently unavailable. The match type (Phrase, Exact, Broad, etc.) applied for users' search term. Ads on the content network are identified as "Content network".
trafficSource.adCost FLOAT The Total adCost / Total sessions.
trafficSource.attributedAdCost FLOAT The sessions costs, that are uniformly attributed between all sessions accordingly to UTM-tags: source, medium, campaign, term and content.
totalsStreaming RECORD This section contains aggregate values across the session.
totalsStreaming.hits INTEGER Total number of hits within the session.
totalsStreaming.events INTEGER Total number of events within the session.
totalsStreaming.transactions INTEGER Total number of ecommerce transactions within the session.
totalsStreaming.pageviews INTEGER Total number of pageviews within the session.
totalsStreaming.screenviews INTEGER Total number of screenviews within the session.
totalsStreaming.isInteraction BOOLEAN This value is TRUE for sessions with interaction events. The value is FALSE if there are no interaction events in the session.
customDimensions RECORD This section contains any user-level or session-level custom dimensions that are set for a session. This is a repeated field and has an entry for each dimension that is set.
customDimensions.index INTEGER The index of the custom dimension.
customDimensions.value STRING The value of the custom dimension.
hits RECORD This row and nested fields are populated for any and all types of hits.
hits.hitId STRING An identifier for this hit.
hits.isEntrance INTEGER If this hit was the first pageview or screenview hit of a session, this is set to true.
hits.isExit INTEGER If this hit was the last pageview or screenview hit of a session, this is set to true.
hits.time INTEGER The time in which the hit occurred (in seconds).
hits.hour INTEGER The hour in which the hit occurred (0 to 23).
hits.minute INTEGER The minute in which the hit occurred (0 to 59).
hits.type STRING The type of hit.
hits.isInteraction BOOLEAN If this hit was an interaction, this is set to true. If this was a non-interaction hit (i.e., an event with interaction set to false), this is false.
hits.currency STRING The code of local currency for all transaction currency values.
hits.referer STRING The referring page, if the session has a goal completion or transaction. If this page is from the same domain, this is blank.
hits.dataSource STRING The data source of a hit. By default, hits sent from analytics.js are reported as "web" and hits sent from the mobile SDKs are reported as "app".
hits.device RECORD This section contains information about the user devices.
hits.device.ip STRING The device IP address
hits.customGroups RECORD  
hits.customGroups.index INTEGER  
hits.customGroups.value STRING  
hits.social RECORD This section is populated for each hit with type = "social".
hits.social.socialInteractionAction STRING The social action passed with the social tracking code (Share, Tweet, etc.).
hits.social.socialInteractionNetwork STRING The the network passed with the social tracking code (Google+, Twitter, etc.).
hits.social.socialInteractionTarget STRING For social interactions, this is the URL (or resource) which receives the social network action.
hits.page RECORD This section is populated for each hit with type = pageview.
hits.page.pagePath STRING The URL path of the page.
hits.page.hostname STRING The hostname of the URL.
hits.page.pageTitle STRING The page title.
hits.eCommerceAction RECORD This section contains all of the hits that occurred during the session. This is a repeated field and has an entry for each hit that was collected.
hits.eCommerceAction.action_type STRING The action type. Click through of product lists = 1, Product detail views = 2, Add product(s) to cart = 3, Remove product(s) from cart = 4, Check out = 5, Completed purchase = 6, Refund of purchase = 7, Checkout options = 8, Unknown = 0. Usually, this action type applies to all the products in a hit, with the following exception: when hits.product.isImpression = TRUE, the corresponding product is a product impression that is seen while the product action is taking place (i.e., a "product in list view").
hits.eCommerceAction.option STRING This field is populated when a checkout option is specified. For example, a shipping option such as option = 'Fedex'.
hits.eCommerceAction.step INTEGER This field is populated when a checkout step is specified with the hit.
hits.eCommerceAction.list STRING The list or collection to which a product belongs
hits.experiment RECORD This row and the nested fields are populated for each hit that contains data for an experiment.
hits.experiment.experimentId STRING The ID of the experiment.
hits.experiment.experimentVariant STRING The variation or combination of variations present in a hit for an experiment.
hits.product RECORD This row and nested fields will be populated for each hit that contains Enhanced Ecommerce PRODUCT data.
hits.product.isImpression BOOLEAN TRUE if at least one user viewed this product (i.e., at least one impression) when it appeared in the product list.
hits.product.impressionList STRING The name of the product list in which the product appears.
hits.product.productBrand STRING The brand associated with the product.
hits.product.productPrice FLOAT The price of the product, expressed as the value passed to Analytics.
hits.product.productQuantity INTEGER The quantity of the product purchased.
hits.product.productSku STRING Product SKU.
hits.product.productVariant STRING Product Variant.
hits.product.productCategory STRING Product Category.
hits.product.productName STRING Product Name.
hits.product.position INTEGER The product's position in a list or collection.
hits.product.coupon STRING Code for the product-level coupon (Enhanced Ecommerce).
hits.product.customDimensions RECORD This section is populated for all hits containing product scope Custom Dimensions.
hits.product.customDimensions.index INTEGER The product scope Custom Dimensions index.
hits.product.customDimensions.value STRING The product scope Custom Dimensions value.
hits.product.customMetrics RECORD This section is populated for all hits containing product scope Custom Metrics.
hits.product.customMetrics.index INTEGER The product scope Custom Metrics index.
hits.product.customMetrics.value STRING The product scope Custom Metrics value.
hits.promotion RECORD This row and nested fields are populated for each hit that contains Enhanced Ecommerce PROMOTION information.
hits.promotion.promoCreative STRING The text or creative variation associated with the promotion.
hits.promotion.promoId STRING Promotion ID.
hits.promotion.promoName STRING Promotion Name.
hits.promotion.promoPosition STRING Promotion position on site.
hits.transaction RECORD This section is populated for each hit with type = transaction.
hits.transaction.transactionId STRING The transaction ID of the ecommerce transaction.
hits.transaction.transactionRevenue FLOAT Total transaction revenue, expressed as the value passed to Analytics.
hits.transaction.localTransactionRevenue FLOAT Total transaction revenue in local currency, expressed as the value passed to Analytics.
hits.transaction.transactionTax FLOAT Total transaction tax, expressed as the value passed to Analytics.
hits.transaction.localTransactionTax FLOAT Total transaction revenue in local currency, expressed as the value passed to Analytics.
hits.transaction.transactionShipping FLOAT Total transaction shipping cost, expressed as the value passed to Analytics.
hits.transaction.localTransactionShipping FLOAT Total transaction shipping cost in local currency, expressed as the value passed to Analytics.
hits.transaction.transactionCoupon STRING The coupon code associated with the transaction.
hits.transaction.affiliation STRING The affiliate information passed to the ecommerce tracking code.
hits.contentInfo RECORD This section will be populated for each hit with type = "appview".
hits.contentInfo.contentDescription STRING The description of the content being viewed as passed to the SDK.
hits.appInfo RECORD This section will be populated for each hit with type = "appview" or "exception".
hits.appInfo.name STRING The application name.
hits.appInfo.version STRING The application version.
hits.appInfo.id STRING The application ID.
hits.appInfo.installerId STRING ID of the installer (e.g., Google Play Store) from which the app was downloaded. By default, the app installer ID is set based on the PackageManager#getInstallerPackageName method.
hits.eventInfo RECORD This section is populated for each hit with type = "event".
hits.eventInfo.eventCategory STRING The event category.
hits.eventInfo.eventAction STRING The event action.
hits.eventInfo.eventLabel STRING The event label.
hits.eventInfo.eventValue STRING The event value.
hits.timingInfo RECORD This section contains all user timing variables.
hits.timingInfo.timingCategory STRING For easier reporting purposes, this is used to categorize all user timing variables into logical groups.
hits.timingInfo.timingVariable STRING Used to add flexibility to visualize user timings in the reports.
hits.timingInfo.timingLabel STRING The name of the resource's action being tracked.
hits.timingInfo.timingValue INTEGER Total number of milliseconds for user timing.
hits.timingInfo.pageLoad INTEGER Total time (in milliseconds), from pageview initiation (e.g., a click on a page link) to page load completion in the browser, the pages in the sample set take to load.
hits.timingInfo.DNS INTEGER The total time (in milliseconds) all samples spent in DNS lookup for this page.
hits.timingInfo.pageDownload INTEGER The total time (in milliseconds) to download this page among all samples.
hits.timingInfo.redirectResponse INTEGER The total time (in milliseconds) all samples spent in redirects before fetching this page. If there are no redirects, this is 0.
hits.timingInfo.TCPConnect INTEGER Total time (in milliseconds) all samples spent in establishing a TCP connection to this page.
hits.timingInfo.serverResponse INTEGER The total time (in milliseconds) the site's server takes to respond to users' requests for all samples; this includes the network time from users' locations to the server.
hits.timingInfo.DOMInteractive INTEGER The time (in milliseconds), including the network time from users' locations to the site's server, the browser takes to parse the document (DOMInteractive). At this time, users can interact with the Document Object Model even though it is not fully loaded.
hits.timingInfo.contentLoad INTEGER The time (in milliseconds), including the network time from users' locations to the site's server, the browser takes to parse the document and execute deferred and parser-inserted scripts (DOMContentLoaded). When parsing of the document is finished, the Document Object Model (DOM) is ready, but the referenced style sheets, images, and subframes may not be finished loading. This is often the starting point of Javascript framework execution, e.g., JQuery's onready() callback.
hits.customDimensions RECORD This section contains any hit-level custom dimensions. This is a repeated field and has an entry for each dimension that is set.
hits.customDimensions.index INTEGER The index of the custom dimension.
hits.customDimensions.value STRING The value of the custom dimension.
hits.customMetrics RECORD This section contains any hit-level custom metrics. This is a repeated field and has an entry for each metric that is set.
hits.customMetrics.index INTEGER The index of the custom metric.
hits.customMetrics.value INTEGER The value of the custom metric.

 

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.