Financial
Unit: currency
About This Metric
Calculated by dividing total balance by the number of active customers. Useful for understanding typical customer payment patterns and identifying pricing opportunities.
Formula
Total Balance / Number of Active CustomersCode Expression
totalBalance / activeCustomerCountData Sources
- diamond-customers
balancestatusText
Caveats & Limitations
- •Can be skewed by high-balance outliers
- •Compare with median balance for better distribution insight
Derived From
This metric is calculated using the following metrics as inputs:
Total Balance
The sum of all outstanding balances across all active customer accounts.
Active Customers
The count of customers currently receiving service with an active status.
Tags
#revenue
#customer value
#pricing
Calculation Source
Real-time (Cosmos DB)