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 across any site in the realm. Includes orders placed in sessions with tracking disabled (dw_dnt = 1) where buyer status cannot be established | Yes | |
first_time_buyer |
BOOLEAN | Boolean indicating if the customer was a first-time buyer across any site in the realm. Includes orders placed in sessions with tracking disabled (dw_dnt = 1) where buyer status cannot be established. | 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 | |
traffic_medium |
VARCHAR | The traffic medium from ccdw_dim_traffic_source medium (for example, "organic", "paid"). Historical rows can be null. |
No |