--- schema_version: "1" id: c45e148adb6086be5d7392fb7184e2d34bfd6f01b11384a9744f869a0b23ed04 title: ccdw_aggr_product_cobuy collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_aggr_product_cobuy.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_product_cobuy.html source_site: developer.salesforce.com content_type: documentation content_hash: 61b1471509986ce71d337d458d794e127a7ab80b274b685f8af154974d80db50 products: - Composable Storefront - Salesforce APIs --- # 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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_product.md) for the first product. | Yes | | `product_two_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_product`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_product.md) for the second product. | Yes | | `order_channel` | VARCHAR | | Order channel (from [`ccdw_dim_business_channel`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_business_channel.md)). | No | | `nsite_id` | VARCHAR | | Normalized site ID (from [`ccdw_dim_site`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_traffic_source.md) `medium` (for example, "organic", "paid"). Historical rows can be null. | No |