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 across any site in the realm. Includes orders placed in sessions with tracking disabled (dw_dnt = 1) where buyer status cannot be established | 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 |