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 |