ccdw_aggr_promotion_couse
This table identifies promotions that are frequently used together.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
submit_date | DATE | Date of the co-use event. | Yes | |
promotion_one_id | INTEGER | FK | Foreign key to ccdw_dim_promotion for the first promotion. | Yes |
promotion_two_id | INTEGER | FK | Foreign key to ccdw_dim_promotion for the second promotion. | Yes |
promotion_one_class | VARCHAR | Class of the first promotion. | No | |
promotion_two_class | VARCHAR | Class of the second promotion. | No | |
order_channel | VARCHAR | Order channel (from ccdw_dim_business_channel). | No | |
nsite_id | VARCHAR | Normalized site ID (from ccdw_dim_site). | Yes | |
registered | BOOLEAN | Boolean indicating if the customer was registered. | Yes | |
first_time_buyer | BOOLEAN | Boolean indicating if the customer was a first-time buyer. | Yes | |
device_class_code | VARCHAR | Device class code from ccdw_dim_user_agent. | Yes | |
locale_code | VARCHAR | Locale code from ccdw_dim_locale. | Yes | |
frequency_count | INTEGER | Number of times these two promotions were used together. | No |