widget_context_item_product
- Sylvain Paillard
Description
This table contains one row per session key dimension, per widget (i.e.: choice_id), per context product id (in the PDP or the basket) and per displayed/bought product with all the key information about the session FROM the session view, AS well all the key informations about the orders of the session, and this for each context product id and subtype separately but not per product, however, the display_requests and bought_orders are specific to each product. The requests and orders and other session metrics are specific for each context product id and subtype and products. The widget, the context product id and subtype and the product should always be set with otherwise risks of overcounting, especially for the metrics of the sessions, LIKE orders, order_qty and total_crncy_amt.
The month column is a date field always set with the first day of the month.
Granularity
one row per:
month
widget
context sub-type
context item
product
test variant
Columns
Field name | Type | Mode | Description |
|---|---|---|---|
product_id | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the displayed / bought product id |
groupby_field | STRING | NULLABLE | the GROUP BY field name |
title_en | STRING | NULLABLE | title of the product in English |
title_de | STRING | NULLABLE | title of the product in German |
title_fr | STRING | NULLABLE | title of the product in French |
title_it | STRING | NULLABLE | title of the product in Italian |
category_1 | STRING | NULLABLE | 1st-level category id of the product |
category_2 | STRING | NULLABLE | 2nd-level category id of the product |
category_3 | STRING | NULLABLE | 3rd-level category id of the product |
category_4 | STRING | NULLABLE | 4th-level category id of the product |
category_5 | STRING | NULLABLE | 5th-level category id of the product |
exact_margin | FLOAT | NULLABLE | the exact product margin |
rounded_margin | FLOAT | NULLABLE | the rounded product margin |
exact_price | FLOAT | NULLABLE | the exact product price |
rounded_price | FLOAT | NULLABLE | the rounded product price |
product_owners | STRING | REPEATED | the product owners |
source_product_id | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the product in the context |
source_groupby_field | STRING | NULLABLE | the GROUP BY field name |
source_title_en | STRING | NULLABLE | title of the product in English |
source_title_de | STRING | NULLABLE | title of the product in German |
source_title_fr | STRING | NULLABLE | title of the product in French |
source_title_it | STRING | NULLABLE | title of the product in Italian |
source_category_1 | STRING | NULLABLE | 1st-level category id of the product |
source_category_2 | STRING | NULLABLE | 2nd-level category id of the product |
source_category_3 | STRING | NULLABLE | 3rd-level category id of the product |
source_category_4 | STRING | NULLABLE | 4th-level category id of the product |
source_category_5 | STRING | NULLABLE | 5th-level category id of the product |
source_exact_margin | FLOAT | NULLABLE | the exact product margin |
source_rounded_margin | FLOAT | NULLABLE | the rounded product margin |
source_exact_price | FLOAT | NULLABLE | the exact product price |
source_rounded_price | FLOAT | NULLABLE | the rounded product price |
source_product_owners | STRING | REPEATED | the product owners |
source_subtype | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the role of the product in the context |
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 |
avg_page_size | FLOAT | NULLABLE | the number of results displayed |
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 - starting timestamp (date time) of the session |
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 |
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) |
total_viewed_cnt | INTEGER | NULLABLE | the number of pdp views in which this product was viewed in this session |
total_basketed_cnt | INTEGER | NULLABLE | the number of basket in which this product was added in this session, typically 0 or 1 |
total_bought_orders | INTEGER | NULLABLE | the number of orders in which this product was bought in this session, typically 0 or 1 |
total_bought_order_products | INTEGER | NULLABLE | the number of times this product was bought in this session, typically 0 or 1 |
total_bought_order_product_qty | INTEGER | NULLABLE | the quantity of this product bought in this session |
total_bought_order_product_list_crncy_amt | FLOAT | NULLABLE | the potential sales value with the list price without discount (hypothetitical) product bought in this session |
total_bought_order_product_discount_crncy_amt | FLOAT | NULLABLE | the value of the products bought in this session (price after discount * quantity) |
total_bought_order_product_margin_crncy_amt | FLOAT | NULLABLE | the value of the products bought in this session (price after discount * quantity) |
KPI_list | RECORD | REPEATED | list of KPIs, each KPI is technically represented by a STRUCT of (kpi_name string,kpi_val_num numeric,kpi_val_text string) |
KPI_list. kpi_name | STRING | REQUIRED | KPI_list. kpi_name |
KPI_list. kpi_val_num | INTEGER | NULLABLE | KPI_list. kpi_val_num |
KPI_list. kpi_val_text | STRING | NULLABLE | KPI_list. kpi_val_text |
KPI_defined | RECORD | NULLABLE | list of KPIs, each KPI is technically represented by a STRUCT of (kpi_name string,kpi_val_num numeric,kpi_val_text string) |
KPI_defined. guidedProductView | FLOAT | NULLABLE | KPI_defined. guidedProductView |
KPI_defined. guidedAddToBasket | FLOAT | NULLABLE | KPI_defined. guidedAddToBasket |
KPI_defined. guidedByProductViewAddToBasket | FLOAT | NULLABLE | KPI_defined. guidedByProductViewAddToBasket |
KPI_defined. guidedPurchase | FLOAT | NULLABLE | KPI_defined. guidedPurchase |
KPI_defined. guidedBannerClick | FLOAT | NULLABLE | KPI_defined. guidedBannerClick |
KPI_defined. guidedRevenue | FLOAT | NULLABLE | KPI_defined. guidedRevenue |
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 |
global_sessions | FLOAT | NULLABLE | global_sessions |
global_requests | FLOAT | NULLABLE | global_requests |
global_viewed_cnt | FLOAT | NULLABLE | global_viewed_cnt |
global_basketed_cnt | FLOAT | NULLABLE | global_basketed_cnt |
global_bought_orders | FLOAT | NULLABLE | global_bought_orders |
global_bought_order_products | FLOAT | NULLABLE | global_bought_order_products |
global_bought_order_product_qty | FLOAT | NULLABLE | global_bought_order_product_qty |
global_bought_order_product_list_crncy_amt | FLOAT | NULLABLE | global_bought_order_product_list_crncy_amt |
global_bought_order_product_discount_crncy_amt | FLOAT | NULLABLE | global_bought_order_product_discount_crncy_amt |
global_bought_order_product_margin_crncy_amt | FLOAT | NULLABLE | the value of the products bought in this session (price after discount * quantity) |
global_total_sessions | FLOAT | NULLABLE | global_total_sessions |
global_total_product_view_cnt | FLOAT | NULLABLE | global_total_product_view_cnt |
global_total_add_to_basket_cnt | FLOAT | NULLABLE | global_total_add_to_basket_cnt |
global_total_orders | FLOAT | NULLABLE | global_total_orders |
global_total_order_products | FLOAT | NULLABLE | global_total_order_products |