Each row in this table represents a pair of promotions in the same purchases.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
submit_date |
DATE | PK | The date the orders were submitted. | Yes |
promotion_one_id |
INTEGER | FK | Foreign key to ccdw_dim_promotion for first promotion. |
Yes |
promotion_two_id |
INTEGER | FK | Foreign key to ccdw_dim_promotion for second promotion. |
Yes |
promotion_one_class |
VARCHAR | PK | The class of the first promotion (ex 'Shipping'). | Yes |
promotion_two_class |
VARCHAR | PK | The class of the second promotion (ex 'Shipping'). | Yes |
order_channel |
VARCHAR | PK | Order channel designation. | Yes |
nsite_id |
VARCHAR | PK | Natural site identifier. | Yes |
registered |
BOOLEAN | PK | true for records that represent register users, false otherwise. | Yes |
first_time_buyer |
BOOLEAN | PK | Boolean indicating if the customer was a first-time buyer across any site in the realm. Includes orders placed in sessions with tracking disabled (dw_dnt = 1) where buyer status cannot be established | Yes |
first_time_buyer |
BOOLEAN | PK | Boolean indicating if the customer was a first-time buyer across any site in the realm. Includes orders placed in sessions with tracking disabled (dw_dnt = 1) where buyer status cannot be established. | Yes |
locale_code |
VARCHAR | PK | Locale code for language/region. | Yes |
frequency_count |
BIGINT | The frequency of occurrences between the two promotions. | No | |
traffic_medium |
VARCHAR | The traffic medium from ccdw_dim_traffic_source medium (for example, "organic", "paid"). Historical rows can be null. |
No |