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. | No |
device_class_code | VARCHAR | Device class code from ccdw_dim_user_agent. | No | |
registered | BOOLEAN | Boolean indicating if the user was registered. | No | |
locale_code | VARCHAR | Locale code from ccdw_dim_locale. | No | |
promotion_id | INTEGER | FK | Foreign key to ccdw_dim_promotion. | No |
campaign_id | INTEGER | FK | Foreign key to ccdw_dim_campaign. | No |
num_visits | INTEGER | Number of visits associated with the promotion activation. | No | |
num_activations | INTEGER | Total number of promotion activations. | No |