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

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