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 |