product_bought_same_customer
- Sylvain Paillard
Description
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.
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 |
personas | INTEGER | NULLABLE | the number of different personas making the orders |
orders | INTEGER | NULLABLE | the number of orders by same client of both products |
orders_before | INTEGER | NULLABLE | the number of orders by same client of target product before source product |
orders_after | INTEGER | NULLABLE | the number of orders by same client of target product after source product |
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 |