ccdw_aggr_product_cobuy
This table identifies products that are frequently bought together.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
submit_date | DATE | Date of the co-buy event. | Yes | |
product_one_id | INTEGER | FK | Foreign key to ccdw_dim_product for the first product. | Yes |
product_two_id | INTEGER | FK | Foreign key to ccdw_dim_product for the second product. | Yes |
order_channel | VARCHAR | Order channel (from ccdw_dim_business_channel). | No | |
nsite_id | VARCHAR | Normalized site ID (from ccdw_dim_site). | Yes | |
registered | BOOLEAN | Boolean indicating if the customer was registered. | Yes | |
first_time_buyer | BOOLEAN | Boolean indicating if the customer was a first-time buyer. | Yes | |
device_class_code | VARCHAR | Device class code from ccdw_dim_user_agent. | Yes | |
locale_code | VARCHAR | Locale code from ccdw_dim_locale. | Yes | |
frequency_count | INTEGER | Number of times these two products were co-bought. | No | |
std_cobuy_revenue | NUMERIC | Total revenue generated from co-bought products in standard currency. | No |