product_property_bought_same_customer
- Sylvain Paillard
Description
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.
Granularity
one row per:
month
source product property name
source product property value
target product property name
target product property value
Columns
Field name | Type | Mode | Description |
|---|---|---|---|
source_product_property_name | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the source product name |
source_product_property_label | STRING | NULLABLE | the source product property label |
source_product_property_value | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the source product value |
source_product_property_value_label | STRING | NULLABLE | the product property value label |
source_product_owners | STRING | REPEATED | the product owners |
target_product_property_name | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the target product name |
target_product_property_label | STRING | NULLABLE | the target product property label |
target_product_property_value | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the target product value |
target_product_property_value_label | STRING | NULLABLE | the product property value label |
target_product_owners | STRING | REPEATED | the product owners |
day | DATE | NULLABLE | each month of the product performance |
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_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 |