ccdw_aggr_source_code_sales
This table summarizes sales attributed to source codes.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
submit_date | DATE | Date of the sales submission. | No | |
business_channel_id | SMALLINT | FK | Foreign key to ccdw_dim_business_channel . | No |
registered | BOOLEAN | Boolean indicating if the customer was registered. | No | |
site_id | SMALLINT | FK | Foreign key to ccdw_dim_site . | No |
first_time_buyer | BOOLEAN | Boolean indicating if the customer was a first-time buyer. | No | |
device_class_code | VARCHAR | FK | Device class code from ccdw_dim_user_agent . | No |
source_code_group_id | INTEGER | FK | Foreign key to ccdw_dim_source_code_group . | No |
source_code_status | VARCHAR | Status of the source code. | No | |
num_orders | INTEGER | Total number of orders attributed to the source code. | No | |
num_units | INTEGER | Total number of units sold attributed to the source code. | No | |
std_revenue | NUMERIC | Total revenue in standard currency attributed to the source code. | No |