widget_position
Description
This table contains one row per session key dimension, per widget (i.e.: choice_id) and per product id with all the key information about the sessions FROM the session view, AS well all the key informations about the orders of the sessions, and this for each product separately. While the requests and orders and other session metrics are not specific for each product, the display_requests and bought_orders are specific to each product. The widget and the product id should always be set with otherwise risks of overcounting, especially for the metrics of the sessions, LIKE orders, order_qty and total_crncy_amt AS well AS the product metrics, LIKE bought_orders.
Granularity
one row per:
page position (product_order_num)
page offset
widget
test variant
channel
country
device category
Columns
Field name | Type | Mode | Description |
---|---|---|---|
position | INTEGER | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the position in the page |
offset | INTEGER | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the offset of the page |
widget | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the widget name: search, navigation, basket, ... |
tpo | STRING | NULLABLE | the tpo of this widget |
journey_step | STRING | NULLABLE | the journey step of this widget (awareness, consideration, evaluation, purchase, re-buy, relationship) |
variant_id | STRING | NULLABLE | the test variant name |
variants | INTEGER | NULLABLE | the total number of test variants currently in this widget |
requests | INTEGER | NULLABLE | total number of requests, UNIQUE PER REQUEST, NO RISK OF OVERCOUNT |
landing_requests | INTEGER | NULLABLE | the number of requests which were landing page requests |
exit_requests | INTEGER | NULLABLE | the number of requests which were exit page requests |
avg_nth_page | FLOAT | NULLABLE | the average nth page view the request takes place at |
landing_sessions | INTEGER | NULLABLE | 1 if the session has at least one request being a landing page requests 0 otherwise |
exit_sessions | INTEGER | NULLABLE | 1 if the session has at least one request being an exit page requests 0 otherwise |
day | DATE | NULLABLE | PK - first day of the month |
sessions | INTEGER | NULLABLE | number of sessions |
visitor_personas | INTEGER | NULLABLE | number of visitors (cookie-based) |
user_personas | INTEGER | NULLABLE | number of users (only set for logged in sessions) |
returnings | INTEGER | NULLABLE | number of returning sessions, based ON prior existence of the visitor_persona_id |
page_view_cnt | INTEGER | NULLABLE | total number of page views in this session |
page_view_1 | INTEGER | NULLABLE | 1 if page_view_cnt = 1 0 otherwise |
page_view_2 | INTEGER | NULLABLE | 1 if page_view_cnt = 2 0 otherwise |
page_view_3 | INTEGER | NULLABLE | 1 if page_view_cnt = 3 0 otherwise |
page_view_4 | INTEGER | NULLABLE | 1 if page_view_cnt = 4 0 otherwise |
page_view_5plus | INTEGER | NULLABLE | 1 if page_view_cnt >= 5 0 otherwise |
product_view_cnt | INTEGER | NULLABLE | total number of product detail page view in this session |
product_view_1 | INTEGER | NULLABLE | 1 if product_view_cnt = 1 0 otherwise |
product_view_2 | INTEGER | NULLABLE | 1 if product_view_cnt = 2 0 otherwise |
product_view_3 | INTEGER | NULLABLE | 1 if product_view_cnt = 3 0 otherwise |
product_view_4 | INTEGER | NULLABLE | 1 if product_view_cnt = 4 0 otherwise |
product_view_5plus | INTEGER | NULLABLE | 1 if product_view_cnt >= 5 0 otherwise |
add_to_basket_cnt | INTEGER | NULLABLE | total number of products added to the basket in this session |
add_to_basket_1 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 1 0 otherwise |
add_to_basket_2 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 2 0 otherwise |
add_to_basket_3 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 3 0 otherwise |
add_to_basket_4 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 4 0 otherwise |
add_to_basket_5plus | INTEGER | NULLABLE | 1 if add_to_basket_cnt >= 5 0 otherwise |
basket_crncy_amt | FLOAT | NULLABLE | currency amount of the items added to the baskets during the sessions |
basket_qty | INTEGER | NULLABLE | quantity of items in the baskets |
channel | STRING | NULLABLE | referrer channel: paid search, organic search, e-mail, referral, display, direct, social, other |
country | STRING | NULLABLE | the country of the session based ON the ip of the session |
device_category | STRING | NULLABLE | the type of device: Smartphone, Personal computer, Tablet, ... |
session_duration | INTEGER | NULLABLE | the number of seconds between the first and last event of the session in seconds |
session_orders | INTEGER | NULLABLE | the number of orders in this session |
orders | INTEGER | NULLABLE | the number of orders FROM the sessions found in the order export |
order_products | INTEGER | NULLABLE | the number of product in the orders FROM the sessions found in the order export |
order_qty | INTEGER | NULLABLE | the total quantity of products in the orders FROM the sessions found in the order export |
total_crncy_amt | FLOAT | NULLABLE | the total value of the orders FROM the sessions found in the order export |
total_margin_crncy_amt | FLOAT | NULLABLE | the total margin value of the orders FROM the sessions found in the order export |
order_products_list_crncy_amt | FLOAT | NULLABLE | the total value of the products before discount in the orders FROM the sessions found in the order export |
order_products_discount_crncy_amt | FLOAT | NULLABLE | the total value of the products after discount in the orders FROM the sessions found in the order export |
order_products_avg_list_crncy_amt | FLOAT | NULLABLE | the average value of the products before discount in the orders FROM the sessions found in the order export |
order_products_avg_discount_crncy_amt | FLOAT | NULLABLE | the average value of the products after discount in the orders FROM the sessions found in the order export |
scenarios | INTEGER | NULLABLE | the number of different strategy scenarios |
total_offsets | INTEGER | NULLABLE | the total sum of the offset (0 when first page) |
request_total_seconds | INTEGER | NULLABLE | the total number of seconds between the start of the sessions and the request time stamp |
display_requests | INTEGER | NULLABLE | the number of requests displaying this product |
weighted_display_requests | FLOAT | NULLABLE | Display request * the weight for this order_num |
total_product_order_num | INTEGER | NULLABLE | the total order position number of this product over the requests |
viewed_cnt | INTEGER | NULLABLE | the number of pdp views in which this product was viewed in this session |
basketed_cnt | INTEGER | NULLABLE | the number of basket in which this product was added in this session, typically 0 or 1 |
bought_orders | INTEGER | NULLABLE | the number of orders in which this product was bought in this session, typically 0 or 1 |
bought_order_products | INTEGER | NULLABLE | the number of times this product was bought in this session, typically 0 or 1 |
bought_order_product_qty | INTEGER | NULLABLE | the quantity of this product bought in this session |
bought_order_product_list_crncy_amt | FLOAT | NULLABLE | the potential sales value with the list price without discount (hypothetitical) product bought in this session |
bought_order_product_discount_crncy_amt | FLOAT | NULLABLE | the value of the products bought in this session (price after discount * quantity) |
bought_order_product_margin_crncy_amt | FLOAT | NULLABLE | the value of the products bought in this session (price after discount * quantity) |
account | STRING | NULLABLE | the account |
parameters | RECORD | REPEATED | general structure of parameters and values |
parameters. name | STRING | NULLABLE | parameters. name |
parameters. value | STRING | NULLABLE | parameters. value |