Schema of tables with calculation results

Results of attribution model calculations are saved to Google BigQuery dataset selected during setup, by default the dataset is called Attribution_FunnelBased.

By default the dataset contains three tables: actions_ and probabilities_ with intermediate results of attribution and values_ with resultant data. And one view values_. Date prefix in the end of each table name is a date of the last session that was analyzed in “YYYYMMDD” format, e.g. “actions_20160601”.

Actions contains information about all sessions and users interactions with site.

Probabilities is based on table Actions and contains data about probability of users get thought each step of sales funnel.

Table Values contains information about sessions that were attributed and value assigned to them.

View Values contains information about attributed values that was created as result of regular model calculations grouped by months. 

Structure of table Actions

Google BigQuery alias Google BigQuery data type Description
session_id STRING Session ID
active_step INTEGER Order number of the deepest step of funnel that user visited during current session
user_id STRING User ID
transaction_id STRING Transaction ID
time INTEGER Session start time in unix time format with microseconds
date STRING Session date in format “YYYY-MM-DD”
is_attributed BOOLEAN Shows if the session didn't get value because of the model settings.
False — when the value was assigned to another source
device STRING Device category
user_type STRING User type
region STRING Region
data_source STRING Source of information about session: OWOX BI Pipeline, Google Analytics export to BigQuery or custom transactions data source

Structure of table Probabilities

Google BigQuery alias Google BigQuery data type Description
step…_probability FLOAT Step probability that was used in model calculation
region_s…_conf_interval FLOAT Confidence interval in the segment grouped by all the dimensions: Device category, User type and Region
region_s…_probability FLOAT Probability in the segment grouped by all the dimensions
region_s…_prev_sessions INTEGER Number of sessions on the previous step in the segment grouped by all the dimensions
region_s…_sessions INTEGER Number of sessions on the step in the segment grouped by all the dimensions
user_type_s…_conf_interval FLOAT Confidence interval in the segment grouped by the dimensions: Device category and User type
user_type_s…_prev_sessions INTEGER Number of sessions on the previous step in the segment grouped by the dimensions: Device category and User type
user_type_s…_sessions INTEGER Number of sessions on the step in the segment grouped by the dimensions: Device category and User type
user_type_s…_probability FLOAT Probability in the segment grouped by the dimensions: Device category and User type
device_s…_conf_interval FLOAT Confidence interval in the segment grouped by Device category/td>
device_s…_prev_sessions INTEGER Number of sessions on the previous step in the segment grouped by Device category
device_s…_sessions INTEGER Number of sessions on the step in the segment grouped by Device category
device_s_probability FLOAT Probability in the segment grouped by Device category
global_s…_probability FLOAT Average probability without any segmentation
global_s…_sessions INTEGER Total number of sessions on the step
global_s…_prev_sessions INTEGER Total number of sessions on the previous step
device STRING Device category
region STRING Region
user_type STRING User type

Structure of table Values

Sample of a table in Google BigQuery

Google BigQuery alias Google BigQuery data type Description
session_id STRING Session ID
value_from_sid STRING  
source STRING Source
medium STRING Medium
campaign STRING Campaign
date STRING The latest date within calculation period in format “YYYYMMDD”
user_id STRING User ID
product_id STRING Product ID (if a model attributed value of product, not transaction)
transaction_id STRING Transaction ID
time INTEGER Session time in unix time format with microseconds
value FLOAT Total value of a session
step…_value INTEGER Value of a session for a particular funnel step
revenue FLOAT Revenue of a product
data_source STRING Source of information about session: OWOX BI Pipeline, Google Analytics export to BigQuery or custom transactions data source
user_type  STRING User type: new or returned.
device  STRING Device category: desktop only, tablet only, mobile only or cross-device.
region  STRING Region
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.