This table summarizes sales attributed to promotions by various dimensions. This table is aggregated from ccdw_fact_promotion_line_item.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
submit_date |
DATE | Date of the sales submission. | Yes | |
business_channel_id |
SMALLINT | FK | Foreign key to ccdw_dim_business_channel. |
Yes |
registered |
BOOLEAN | Boolean indicating if the customer was registered. | Yes | |
site_id |
SMALLINT | FK | Foreign key to ccdw_dim_site. |
Yes |
first_time_buyer |
BOOLEAN | 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 | 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 | |
campaign_id |
INTEGER | FK | Foreign key to ccdw_dim_campaign. |
Yes |
coupon_id |
INTEGER | FK | Foreign key to ccdw_dim_coupon. |
Yes |
device_class_code |
VARCHAR | Device class code from ccdw_dim_user_agent. |
Yes | |
locale_code |
VARCHAR | Locale code from ccdw_dim_locale. |
Yes | |
num_orders |
INTEGER | Total number of orders involving the promotion. | No | |
num_units |
INTEGER | Total number of units sold with the promotion. | No | |
std_revenue |
NUMERIC | Total revenue involving the promotion. This column is aggregated from std_li_gross_merchandise_value. |
No | |
std_tax |
Numeric | Total tax in standard currency attributed to the promotion. | No | |
std_shipping |
NUMERIC | Total shipping cost in standard currency attributed to the promotion. | No | |
num_promotion_uses |
INTEGER | Number of times the promotion was used. | No | |
std_total_discount |
NUMERIC | Total discount in standard currency from the promotion. | No | |
std_item_discount |
NUMERIC | Item-level discount in standard currency from the promotion. | No | |
std_order_discount |
NUMERIC | Order-level discount in standard currency from the promotion. | No | |
std_shipping_discount |
NUMERIC | Shipping discount in standard currency from the promotion. | No | |
std_order_net |
NUMERIC | Net order value in standard currency after promotions. | No | |
std_shipping_net |
NUMERIC | Net shipping value in standard currency after promotions. | No | |
std_discount |
NUMERIC | Total discount in standard currency. | No | |
num_order_units |
INTEGER | Number of units associated with orders. | No | |
traffic_medium |
VARCHAR | The traffic medium from ccdw_dim_traffic_source medium (for example, "organic", "paid"). Historical rows can be null. |
No |