ccdw_aggr_sales_summary

This table provides a daily summary of sales metrics aggregated by various dimensions. This table is aggregated from ccdw_fact_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.	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.	No
`num_units`	INTEGER		Total number of units sold.	No
`std_revenue`	NUMERIC		Total revenue in standard currency. This column is aggregated from `std_li_gross_merchandise_value`	No
`std_tax`	NUMERIC		Total tax in standard currency.	No
`std_shipping`	NUMERIC		Total shipping cost in standard currency.	No
`std_total_discount`	NUMERIC		Total discount in standard currency.	No
`std_promotional_order_discount`	NUMERIC		Promotional discount applied at the order level in standard currency.	No
`std_promotional_shipping_discount`	NUMERIC		Promotional discount applied to shipping in standard currency.	No
`std_promotional_product_discount`	NUMERIC		Promotional discount applied to products in standard currency.	No
`std_manual_order_discount`	NUMERIC		Manual discount applied at the order level in standard currency.	No
`std_manual_shipping_discount`	NUMERIC		Manual discount applied to shipping in standard currency.	No
`std_manual_product_discount`	NUMERIC		Manual discount applied to products in standard currency.	No