ccdw_aggr_source_code_sales

This table summarizes sales attributed to source codes.

Column AliasData TypeKeyDescriptionIndex?
submit_dateDATEDate of the sales submission.No
business_channel_idSMALLINTFKForeign key to ccdw_dim_business_channel.No
registeredBOOLEANBoolean indicating if the customer was registered.No
site_idSMALLINTFKForeign key to ccdw_dim_site.No
first_time_buyerBOOLEANBoolean indicating if the customer was a first-time buyer.No
device_class_codeVARCHARFKDevice class code from ccdw_dim_user_agent.No
source_code_group_idINTEGERFKForeign key to ccdw_dim_source_code_group.No
source_code_statusVARCHARStatus of the source code.No
num_ordersINTEGERTotal number of orders attributed to the source code.No
num_unitsINTEGERTotal number of units sold attributed to the source code.No
std_revenueNUMERICTotal revenue in standard currency attributed to the source code.No