product_property_bought_together

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

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

parametersname

STRING

NULLABLE

parameters. name

parametersvalue

STRING

NULLABLE

parameters. value