ccdw_aggr_promotion_sales_summary

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