---
schema_version: "1"
id: bae5910d1c2136c411c1260c2b11ef273d922797b345ec9dab2aa3af96209854
title: ccdw_aggr_promotion_activation
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_activation.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_promotion_activation.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: d743a5afd1841f4526c5c782bee7771010fa1e10abe493c982376a39e0f0b3ab
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_aggr_promotion_activation

This table summarizes promotion activation metrics.

| Column Alias        | Data Type | Key    | Description                                                                  | Index? |
| ------------------- | --------- | ------ | ---------------------------------------------------------------------------- | ------ |
| `activation_date`   | DATE      |        | Date of promotion activation.                                                | No     |
| `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).                     | No     |
| `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). | No     |
| `registered`        | BOOLEAN   |        | Boolean indicating if the user was registered.                               | No     |
| `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).               | No     |
| `promotion_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).           | No     |
| `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).             | No     |
| `num_visits`        | INTEGER   |        | Number of visits associated with the promotion activation.                   | No     |
| `num_activations`   | INTEGER   |        | Total number of promotion activations.                                       | No     |

<!-- **Indices**: None listed -->