Calculator Inputs
The page keeps a single-column flow, while input fields use a responsive 3-column, 2-column, and 1-column grid.
Example Data Table
Use these sample records to understand how stronger margins, retention, advocacy, and lower service burden raise the total score.
| Customer | Annual Revenue | Margin % | Retention % | Engagement % | Upsell % | Service Burden % | Illustrative Score | Segment |
|---|---|---|---|---|---|---|---|---|
| NorthPeak Health | $95,000 | 68 | 94 | 88 | 61 | 18 | 89.40 | Elite |
| Vista Trade Co. | $58,000 | 57 | 82 | 71 | 39 | 30 | 73.15 | High Value |
| Atlas Supplies | $33,000 | 51 | 69 | 63 | 27 | 42 | 58.60 | Growth |
| Metro Services | $18,500 | 39 | 46 | 40 | 14 | 67 | 35.90 | At Risk |
Formula Used
Net Contribution = (Annual Revenue × Gross Margin%) − Annual Support Cost
Financial Score = clamp((Net Contribution ÷ Benchmark Annual Value) × 100, 0, 100)
Advocacy Score = Advocacy Rating × 10Service Score = 100 − Service Burden
Customer Value Score = Σ(Dimension Score × Weight) ÷ ΣWeights
Expected Annual Value = Max(0, Net Contribution) × Retention Rate × (1 + Upsell Probability × 0.35)
How to Use This Calculator
- Enter the customer name and financial inputs first.
- Add retention, engagement, upsell, payment, advocacy, strategic fit, and service burden values.
- Set the benchmark annual value that represents a strong account in your business.
- Adjust weights to match your revenue strategy, renewal model, or customer success priorities.
- Press the calculate button to show the result above the form.
- Review the summary cards, breakdown table, and Plotly graph for decision support.
- Download the report as CSV or PDF for pipeline reviews, QBRs, or account planning.
FAQs
1) What does the customer value score represent?
A higher score means the customer combines profit, stickiness, expansion potential, and lower service drag. It helps teams rank accounts for retention, upsell, and strategic attention.
2) Why does the calculator need a benchmark annual value?
The benchmark sets the reference point for the financial component. When a customer’s net contribution reaches that benchmark, the financial score can approach 100 before other dimensions are blended in.
3) Can I change the scoring weights?
Yes. Weights let sales, finance, and customer success reflect current strategy. The calculator normalizes weights automatically, so the total does not need to equal 100.
4) Is this the same as customer lifetime value?
No. Lifetime value focuses on longer-term money flows. This score mixes money, behavior, advocacy, and service effort into a practical CRM ranking for current decision-making.
5) How often should I refresh the inputs?
Use current CRM, billing, and product data. Quarterly updates suit stable books, while fast-moving pipelines or usage-based accounts usually benefit from monthly refreshes.
6) What usually causes a low score?
Low scores often come from weak retention, low engagement, limited upsell potential, heavy service burden, or poor margin. The breakdown table reveals which factor is dragging value most.
7) Can different segments use different benchmarks or weights?
Yes. Separate settings for SMB, mid-market, and enterprise accounts can make scoring more realistic. That keeps comparisons fair when revenue patterns and support models differ widely.
8) Should teams rely on this score alone?
It is a prioritization aid, not absolute truth. Combine it with contract context, product history, executive relationships, and human judgment before making major account decisions.