# 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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_campaign.md).                                                                                                       | Yes    |
| `coupon_id`             | INTEGER   | **FK** | Foreign key to [`ccdw_dim_coupon`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_coupon.md).                                                                                                           | Yes    |
| `device_class_code`     | VARCHAR   |        | Device class code from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md).                                                                                           | Yes    |
| `locale_code`           | VARCHAR   |        | Locale code from [`ccdw_dim_locale`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_traffic_source.md) `medium` (for example, "organic", "paid"). Historical rows can be null.           | No     |