What Is Customer Health Score? Building and Tracking the Metric

Customer health score is a composite retention metric that combines multiple signals — product usage, support ticket volume, NPS, and contract tenure — into a single score that predicts whether a customer is likely to renew, expand, or churn.

Learn what signals go into a reliable customer health score, how to build a weighted scoring model in a spreadsheet, what score ranges predict churn risk, and how to act on the results.

What this export contains

Customer ID
Health Score
Product Usage %
NPS
Tickets (30d)
Last Login (Days Ago)
Contract Value
Renewal Date
Segment
CSM Owner

What usually goes wrong with it

  • Health scores built from too few signals are unreliable predictors of churn

    A health score based only on login frequency misses customers who log in but don't use key features — and misses the CRM and support signals that often precede churn by weeks before usage visibly drops.

    DataMimi Start with four to six signals: product usage rate, days since last login, support ticket volume, NPS, and days until renewal — weight them based on which correlated with actual churn in your historic

  • Weighting signals correctly requires historical data on what actually predicted churn

    Giving equal weight to NPS and product usage without knowing which one correlates more strongly with actual churn in your customer base produces a score that feels rigorous but isn't predictive.

    DataMimi Build a weighted score in a spreadsheet using SUMPRODUCT to combine normalized signal values with your weights, then assign thresholds: above 70 is healthy, 40–70 is at risk, below 40 needs immediate

  • A health score is only useful if CSMs act on it before the renewal window closes

    A health score that isn't reviewed until 30 days before renewal gives CSMs almost no time to address the underlying issues — the score needs to trigger action 90 to 120 days out when there's still time to change the trajectory.

    DataMimi Upload your customer data spreadsheet to Datamimi and ask 'which customers have a health score below 50 with renewals in the next 90 days' to get a prioritized at-risk list without building manual fil

Common questions

What is customer health score and what signals should it include?

Customer health score is a composite metric that predicts renewal or churn likelihood. Strong signals to include are product usage rate (vs expected), days since last meaningful action, support ticket volume (high volume is a warning sign), NPS from recent surveys, and days until renewal. Weight each signal based on its historical correlation with churn in your customer base.

What is a good customer health score range?

Most CS teams use a 0–100 scale with thresholds like: above 70 = healthy (renew likely), 40–70 = neutral or at risk (needs monitoring), below 40 = high churn risk (needs immediate CSM intervention). The thresholds should be calibrated to your own historical churn data.

How do I build a customer health score in a spreadsheet?

Create one column per signal (normalized to 0–100), then use SUMPRODUCT to calculate a weighted total. For example: =(0.35*UsageScore + 0.25*NPSScore + 0.20*TicketScore + 0.20*LoginScore). Track the composite score and its components monthly per customer to spot deteriorating accounts early.

What does Datamimi cost for customer success analytics?

Datamimi is free to start at $0/month with 40 credits. Paid plans: Lite at $9/month (400 credits), Starter at $24/month (1,500 credits, 3 files), Pro at $59/month (5,000 rollover credits), Team at $199/month (20,000 credits, 5 users).

Try it with your own file

DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.

Ask about your file

More in AI spreadsheet analysis