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 |