--- schema_version: "1" id: 4123be1f72872126653b6d14cc722b7e288aabb0c40f8a3e657c1b6d2e78ea3b title: ccdw_aggr_promotion_sales_summary 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_sales_summary.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_promotion_sales_summary.html source_site: developer.salesforce.com content_type: documentation content_hash: 00cc7f3f07d760e86c80233c7f31677ea5867cccc4bc75f6e99d1a89b6b76ead products: - Composable Storefront - Salesforce APIs --- # ccdw_aggr_promotion_sales_summary This table summarizes sales attributed to promotions by various dimensions. This table is aggregated from [`ccdw_fact_promotion_line_item`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_fact_promotion_line_item.md). | Column Alias | Data Type | Key | Description | Index? | | ----------------------- | --------- | ------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | `submit_date` | DATE | | Date of the sales submission. | Yes | | `business_channel_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_business_channel`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_business_channel.md). | Yes | | `registered` | BOOLEAN | | Boolean indicating if the customer was registered. | Yes | | `site_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_site`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.md). | 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 | | `campaign_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_campaign`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_campaign.md). | Yes | | `coupon_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_coupon`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_coupon.md). | Yes | | `device_class_code` | VARCHAR | | Device class code from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | 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 | | `num_orders` | INTEGER | | Total number of orders involving the promotion. | No | | `num_units` | INTEGER | | Total number of units sold with the promotion. | No | | `std_revenue` | NUMERIC | | Total revenue involving the promotion. This column is aggregated from `std_li_gross_merchandise_value`. | No | | `std_tax` | Numeric | | Total tax in standard currency attributed to the promotion. | No | | `std_shipping` | NUMERIC | | Total shipping cost in standard currency attributed to the promotion. | No | | `num_promotion_uses` | INTEGER | | Number of times the promotion was used. | No | | `std_total_discount` | NUMERIC | | Total discount in standard currency from the promotion. | No | | `std_item_discount` | NUMERIC | | Item-level discount in standard currency from the promotion. | No | | `std_order_discount` | NUMERIC | | Order-level discount in standard currency from the promotion. | No | | `std_shipping_discount` | NUMERIC | | Shipping discount in standard currency from the promotion. | No | | `std_order_net` | NUMERIC | | Net order value in standard currency after promotions. | No | | `std_shipping_net` | NUMERIC | | Net shipping value in standard currency after promotions. | No | | `std_discount` | NUMERIC | | Total discount in standard currency. | No | | `num_order_units` | INTEGER | | Number of units associated with orders. | 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 |