Analytics, Insights, Reports (CAIR)
- Sylvain Paillard
This section describes the Reports (or Analytics) Dataset.
Tables Overview
Boxalino analytics tables are stored in the [ACCOUNT_NAME]_reports dataset.
Tables:
Group | Table | Granularity | Description |
|---|---|---|---|
Order | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351324 order_primary_analytics | one row per:
| This table contains the key columns about orders and statistical information about order products (avg_list_crncy_amt, avg_discount_crncy_amt). This table can be used freely without risks of over-counting. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16318584 order_product_analytics | one row per:
| This table contains all the columns from order_primary (duplicated values along the different products of the same order) and contains additional columns about the product ordered (product_status_cd, product_qty, product_list_crncy_amt, product_discount_crncy_amt, product_margin_crncy_amt). As the columns of the order_primary table are duplicated along the different products of the same order it is important not to sum them while grouping by order only, which would cause over-counting. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351341 (deprecated) | one row per:
| This table contains all the columns from order_primary (duplicated values along the different product properties and values of the same order) and contains additional columns about the product properties and values ordered (product_status_cd, product_qty, product_list_crncy_amt, product_discount_crncy_amt, product_margin_crncy_amt). In addition, if a product property value is present in several products of the same order they will appear several times (e.g.: buying 3 products of the same brand will make the brand appear 3 times, once per product). As the columns of the order_primary table are duplicated along the different product properties and values of the same order, it is important not to sum them while grouping by order only, which would cause over-counting. |
Customer | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253042 | one row per:
| This table contains information about the performance of each customer (de-duplicated from accounts and guest purchases based on a hash key which is typically the e-mail address) for each month. Some columns (like the lifetime_* columns) are not specific to the month and are duplicated along months, it is important not to sum them while grouping by customer only, which would cause over-counting. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16285749 | one row per:
| This table contains information about the performance of each product for each customer (de-duplicated from accounts and guest purchases based on a hash key which is typically the e-mail address) for each month. Only products bought during that month by that customer are considered. Some columns (like the lifetime_* columns) are neither specific to the month nor to the product and are duplicated along months, it is important not to sum them while grouping by customer only, which would cause over-counting. Some columns provide information about the global values of the orders the product was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351358 | one row per:
| This table contains information about the performance of each product property and value for each customer (de-duplicated from accounts and guest purchases based on a hash key which is typically the e-mail address) for each month. Only product properties and values bought during that month by that customer are considered. Some columns (like the lifetime_* columns) are neither specific to the month nor to the product and are duplicated along months, it is important not to sum them while grouping by customer only, which would cause over-counting. Some columns provide information about the global values of the orders the product property and value was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16285766 | one row per:
| This table contains information about the performance of each customer property and value for each month. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351365 | one row per:
| This table contains information about the performance of each product for each customer property and value for each month. Only products bought during that month by that customer property and value are considered. Some columns provide information about the global values of the orders the product was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16286038 | one row per:
| This table contains information about the performance of each product property and value for each customer property and value for each month. Only product properties and values bought during that month by that customer property and value are considered. Some columns provide information about the global values of the orders the product property and valuewas included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). The month column is a date field always set with the first day of the month. |
Product / Content | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16318591 | one row per:
| This table contains information about the performance of each product for each month. All products (bought or not during the month) are considered. Some columns provide information about the global values of the orders the product was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16318598 | one row per:
| This table contains information about the performance of each product property and value for each month. All product properties and values (bought or not during the month) are considered. Some columns provide information about the global values of the orders the product property and value was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). The month column is a date field always set with the first day of the month. |
Bought together | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253049 | one row per:
| This table contains information about the orders containing a combination of two products (source and target products) for each month. Only products which have been bought together during that month are considered. There is no logic in the source and target products, therefore, the combination are duplicated (each source → target is also appearing with the target being the source and the source being the target) Additional information (like viewed together or put together in the same baskets) are also provided, but the table does not include any product viewed together or added to the basket together which have not also been bought at least once during that month. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16285792 | one row per:
| This table contains information about the customers having bought a combination of two products (source and target products) for each month (the order date of the source product is considered as the month). There is no logic in the source and target products, therefore, the combination are duplicated (each source → target is also appearing with the target being the source and the source being the target) The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253066 | one row per:
| This table contains information about the orders containing a combination of two product property and values (source and target products) for each month. Only product property and values which have been bought together during that month are considered. There is no logic in the source and target product property and values, therefore, the combination are duplicated (each source → target is also appearing with the target being the source and the source being the target) Additional information (like viewed together or put together in the same baskets) are also provided, but the table does not include any product property and values viewed together or added to the basket together which have not also been bought at least once during that month. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351619 | one row per:
| This table contains information about the customers having bought a combination of two product property and values (source and target products) for each month (the order date of the source product property and value is considered as the month). There is no logic in the source and target products, therefore, the combination are duplicated (each source → target is also appearing with the target being the source and the source being the target) The month column is a date field always set with the first day of the month. |
Session | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253073 | one row per:
| This table contains information about each session. All robots and crawler which are present in the core tables are filtered out. |
Widget | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351395 | one row per:
| This table contains information about each session and for each widget. As the columns of the session_primary table are duplicated along the different products of the same order it is important not to sum them while grouping by session only, which would cause over-counting. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16318627 | one row per:
| This table contains information about the performance of each widget for each product for every week (and for each test variant, channel, country and device category). Some columns provide information about the global values of the orders the product was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). Instead, use product specific columns giving you the specific product performance like display_requests, weighted_display_requests, total_product_order_num, viewed_cnt, basketed_cnt, bought_orders, bought_order_products, bought_order_product_qty and bought_order_product_discount_crncy_amt. The week column is a date field always set with the first day of the week. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351402 | one row per:
| This table contains information about the performance of each widget for each product property and value for every week (and for each test variant, channel, country and device category). Some columns provide information about the global values of the orders the product property and value was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in).Instead, use product specific columns giving you the specific product performance like display_requests, weighted_display_requests, total_product_order_num, viewed_cnt, basketed_cnt, bought_orders, bought_order_products, bought_order_product_qty and bought_order_product_discount_crncy_amt. The week column is a date field always set with the first day of the week. |
Search term | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351409 | one row per:
| This table contains information about each session and for each search term (the query searched by the user in the web-site) and for each widget (you have several different search widget, starting by the difference between ‘autocomplete’ (each request made to the auto-completion while the user is typing his search and ‘search’ (the search page)) As the columns of the session_primary table are duplicated along the different products of the same order it is important not to sum them while grouping by session only, which would cause over-counting. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253080 | one row per:
| This table contains information about each month and for each search term (the query searched by the user in the web-site) and for each widget and test variant (you have several different search widget, starting by the difference between ‘autocomplete’ (each request made to the auto-completion while the user is typing his search and ‘search’ (the search page)) and for each product. Some columns provide information about the global values of the orders the product was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). Instead, use product specific columns giving you the specific product performance like display_requests, weighted_display_requests, total_product_order_num, viewed_cnt, basketed_cnt, bought_orders, bought_order_products, bought_order_product_qty and bought_order_product_discount_crncy_amt. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16285842 | one row per:
| This table contains information about each month and for each search term (the query searched by the user in the web-site) and for each widget and test variant (you have several different search widget, starting by the difference between ‘autocomplete’ (each request made to the auto-completion while the user is typing his search and ‘search’ (the search page)) and for each product property and value. Some columns provide information about the global values of the orders the product property and value was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). Instead, use product specific columns giving you the specific product performance like display_requests, weighted_display_requests, total_product_order_num, viewed_cnt, basketed_cnt, bought_orders, bought_order_products, bought_order_product_qty and bought_order_product_discount_crncy_amt. The month column is a date field always set with the first day of the month. |
Facet | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253099 | one row per:
| This table contains information about each session and for each facet type, name and value (the refinement / filtering option selected by the user in the web-site) and for each widget. As the columns of the session_primary table are duplicated along the different products of the same order it is important not to sum them while grouping by session only, which would cause over-counting. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16318658 | one row per:
| This table contains information about each month and for each facet type, name and value (the refinement / filtering option selected by the user in the web-site), for each widget and for each product. Some columns provide information about the global values of the orders the product property and value was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). Instead, use product specific columns giving you the specific product performance like display_requests, weighted_display_requests, total_product_order_num, viewed_cnt, basketed_cnt, bought_orders, bought_order_products, bought_order_product_qty and bought_order_product_discount_crncy_amt. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253106 | one row per:
| This table contains information about each month and for each facet type, name and value (the refinement / filtering option selected by the user in the web-site), for each widget and for each product property and value. Some columns provide information about the global values of the orders the product property and value was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in). Instead, use product specific columns giving you the specific product performance like display_requests, weighted_display_requests, total_product_order_num, viewed_cnt, basketed_cnt, bought_orders, bought_order_products, bought_order_product_qty and bought_order_product_discount_crncy_amt. The month column is a date field always set with the first day of the month. |
Context item | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351425 | one row per:
| This table contains one row per session, per widget (i.e.: choice_id), per product id appearing in the context of a query (Product Detail Page, Basket, ...) 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 product id and subtype separately (the subtype is mainProduct when there is one product or if it is the highest value item in the basket and subProduct otherwise). The requests and orders and other session metrics are specific for each product id. The contect 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.
|
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351441 | one row per:
| 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. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351441 | one row per:
| This table contains one row per session key dimension, per widget (i.e.: choice_id), per context product property name and value (in the PDP or the basket) and per displayed/bought product property name and value 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 property name and value and subtype separately but not per product property name and value, however, the display_requests and bought_orders are specific to each product property name and value. The requests and orders and other session metrics are specific for each context product property name and value and subtype and products. The widget, the context product property name and value and subtype and the product property name and value 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. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16253123 | one row per:
| This table contains one row per session, per widget (i.e.: choice_id), per product id appearing in the context of a query (Product Detail Page, Basket, ...) 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 product id and subtype separately (the subtype is mainProduct when there is one product or if it is the highest value item in the basket and subProduct otherwise). The requests and orders and other session metrics are specific for each product id. The contect 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. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16318691 | one row per:
| This table contains one row per session, per widget (i.e.: choice_id), per product id appearing in the context of a query (Product Detail Page, Basket, ...) 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 product id and subtype separately (the subtype is mainProduct when there is one product or if it is the highest value item in the basket and subProduct otherwise). The requests and orders and other session metrics are specific for each product id. The contect 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. The month column is a date field always set with the first day of the month. |
| https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16318691 | one row per:
| This table contains one row per session key dimension, per widget (i.e.: choice_id), per context product property name and value (in the PDP or the basket) and per displayed/bought product property name and value 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 property name and value and subtype separately but not per product property name and value, however, the display_requests and bought_orders are specific to each product property name and value. The requests and orders and other session metrics are specific for each context product property name and value and subtype and products. The widget, the context product property name and value and subtype and the product property name and value 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. |
Position | https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/16351479 | one row per:
| 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.
|