# 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_product.md) for the first product.                                                                                   | Yes    |
| `product_two_id`    | INTEGER   | **FK** | Foreign key to [`ccdw_dim_product`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_product.md) for the second product.                                                                                  | Yes    |
| `order_channel`     | VARCHAR   |        | Order channel (from [`ccdw_dim_business_channel`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_business_channel.md)).                                                                                 | No     |
| `nsite_id`          | VARCHAR   |        | Normalized site ID (from [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md)).                                                                                                    | 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md).                                                                                                         | 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_traffic_source.md) `medium` (for example, "organic", "paid"). Historical rows can be null.           | No     |