ccdw_aggr_payment_sales_summary
This table summarizes payment-related sales metrics by various dimensions.
| 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 | |
locale_code | VARCHAR | Locale code from ccdw_dim_locale. | Yes | |
payment_method_id | SMALLINT | FK | Foreign key to ccdw_dim_payment_method. | Yes |
num_payments | INTEGER | Total number of payments. | No | |
num_orders | INTEGER | Total number of orders associated with payments. | No | |
std_captured_amount | NUMERIC | Total captured amount in standard currency. | No | |
std_refunded_amount | NUMERIC | Total refunded amount in standard currency. | No | |
std_transaction_amount | NUMERIC | Total transaction amount in standard currency. | No |