--- schema_version: "1" id: 5c7a09e16bf97a4e00705f7e23a5f0ea5dd55cf14818b1dc935db77811a6b421 title: ccdw_aggr_promotion_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_promotion_cobuy.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_promotion_cobuy.html source_site: developer.salesforce.com content_type: documentation content_hash: 4918f77b0a27ad7f17dee99fc165a63738ec4003d3ec900ce6a0afb7cd374980 products: - Composable Storefront - Salesforce APIs --- # ccdw_aggr_promotion_cobuy Each row in this table represents a pair of promotions in the same purchases. | Column Alias | Data Type | Key | Description | Index? | | --------------------- | --------- | ------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | `submit_date` | DATE | **PK** | The date the orders were submitted. | Yes | | `promotion_one_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_promotion`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_promotion.md) for first promotion. | Yes | | `promotion_two_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_promotion`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_promotion.md) for second promotion. | Yes | | `promotion_one_class` | VARCHAR | **PK** | The class of the first promotion (ex 'Shipping'). | Yes | | `promotion_two_class` | VARCHAR | **PK** | The class of the second promotion (ex 'Shipping'). | Yes | | `order_channel` | VARCHAR | **PK** | Order channel designation. | Yes | | `nsite_id` | VARCHAR | **PK** | Natural site identifier. | Yes | | `registered` | BOOLEAN | **PK** | true for records that represent register users, false otherwise. | Yes | | `first_time_buyer` | BOOLEAN | **PK** | 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 | **PK** | 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 | **PK** | Locale code for language/region. | Yes | | `frequency_count` | BIGINT | | The frequency of occurrences between the two promotions. | 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 |