ccdw_aggr_payment_sales_summary

This table summarizes payment-related sales metrics by various dimensions.

Column AliasData TypeKeyDescriptionIndex?
submit_dateDATEDate of the sales submission.Yes
business_channel_idSMALLINTFKForeign key to ccdw_dim_business_channel.Yes
registeredBOOLEANBoolean indicating if the customer was registered.Yes
site_idSMALLINTFKForeign key to ccdw_dim_site.Yes
first_time_buyerBOOLEANBoolean indicating if the customer was a first-time buyer.Yes
device_class_codeVARCHARDevice class code from ccdw_dim_user_agent.Yes
locale_codeVARCHARLocale code from ccdw_dim_locale.Yes
payment_method_idSMALLINTFKForeign key to ccdw_dim_payment_method.Yes
num_paymentsINTEGERTotal number of payments.No
num_ordersINTEGERTotal number of orders associated with payments.No
std_captured_amountNUMERICTotal captured amount in standard currency.No
std_refunded_amountNUMERICTotal refunded amount in standard currency.No
std_transaction_amountNUMERICTotal transaction amount in standard currency.No