product_bought_together
- Sylvain Paillard
Description
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.
Granularity
one row per:
month
source product
target product
Columns
Field name | Type | Mode | Description |
source_product_id | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the source product id |
target_product_id | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the target product id |
day | DATE | NULLABLE | each month of the product performance |
source_title_en | STRING | NULLABLE | title of the source product in English |
source_title_de | STRING | NULLABLE | title of the source product in German |
source_title_fr | STRING | NULLABLE | title of the source product in French |
source_title_it | STRING | NULLABLE | title of the source product in Italian |
source_category_1 | STRING | NULLABLE | 1st-level category id of the source product |
source_category_2 | STRING | NULLABLE | 2nd-level category id of the source product |
source_category_3 | STRING | NULLABLE | 3rd-level category id of the source product |
source_category_4 | STRING | NULLABLE | 4th-level category id of the source product |
source_category_5 | STRING | NULLABLE | 5th-level category id of the source 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_list_crncy_amt | FLOAT | NULLABLE | the total value of the source product before discount in the orders FROM the sessions found in the order export |
source_discount_crncy_amt | FLOAT | NULLABLE | the total value of the source product after discount in the orders FROM the sessions found in the order export |
target_title_en | STRING | NULLABLE | title of the target product in English |
target_title_de | STRING | NULLABLE | title of the target product in German |
target_title_fr | STRING | NULLABLE | title of the target product in French |
target_title_it | STRING | NULLABLE | title of the target product in Italian |
target_category_1 | STRING | NULLABLE | 1st-level category id of the target product |
target_category_2 | STRING | NULLABLE | 2nd-level category id of the target product |
target_category_3 | STRING | NULLABLE | 3rd-level category id of the target product |
target_category_4 | STRING | NULLABLE | 4th-level category id of the target product |
target_category_5 | STRING | NULLABLE | 5th-level category id of the target product |
target_exact_margin | FLOAT | NULLABLE | the exact product margin |
target_rounded_margin | FLOAT | NULLABLE | the rounded product margin |
target_exact_price | FLOAT | NULLABLE | the exact product price |
target_rounded_price | FLOAT | NULLABLE | the rounded product price |
target_product_owners | STRING | REPEATED | the product owners |
target_list_crncy_amt | FLOAT | NULLABLE | the total value of the target product before discount in the orders FROM the sessions found in the order export |
target_discount_crncy_amt | FLOAT | NULLABLE | the total value of the target product after discount in the orders FROM the sessions found in the order export |
common_orders | INTEGER | NULLABLE | the number of orders FROM the sessions found in the order export |
common_source_product_qty | FLOAT | NULLABLE | the quantity of purchase of the source product |
common_target_product_qty | FLOAT | NULLABLE | the quantity of purchase of the target product |
common_sessions_product_views | INTEGER | NULLABLE | the number of sessions with both product views |
common_sessions_baskets | INTEGER | NULLABLE | the number of baskets with both product views |
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 |