Guide

Customer health score template

This customer health score template scores each account from 0 to 100 on four areas (product, adoption, relationship and commercial), weights them equally, and caps the total at the weakest area plus 25, so one weak area can't hide behind good ones. Copy it into Google Sheets or Excel in one click.

The template

Copy it and paste into cell A1 of a new sheet. The columns split automatically.

Area	What to look at	Good (80)	Concerning (60)	Poor (35)	Weight
Product	Bugs, urgent tickets, incidents (last 60 days)	No open serious issues	An open issue with a workaround	A blocker, or escalations on a renewing account	25%
Adoption	Seat and product usage (last 60 days)	Usage steady or growing	Usage down, or licenses unused	Usage down 15+ percentage points in 4 weeks, or a paid product unused	25%
Relationship	Champions, sponsors, contact (last 90 days)	Champion and sponsor engaged	No conversation in 45 days	Champion or sponsor left, or no conversation in 90 days	25%
Commercial	Budget, competitors, renewal terms (last 120 days)	No commercial risk	ROI questioned, or renewal within 90 days with little contact	Budget cut, competitor evaluated, or cancellation notice	25%

Rule: score = the smaller of (weighted average) and (weakest area + 25), then any event cap (30 after a cancellation notice, 50 for 60 days after a champion or sponsor leaves). Red under 40, Yellow 40–79, Green 80+.

Example account	Product	Adoption	Relationship	Commercial	Event cap	Score	Band
Example A	80	80	35	80		60	Yellow
Example B	80	60	80	80		75	Yellow
Example C	35	35	60	35	30	30	Red
Example D	80	80	80	80		80	Green

How to use it

  1. Score each area by its worst open problem. One serious issue outweighs ten small ones.
  2. Apply the cap. Take the weighted average, but never more than the weakest area plus 25. Example A averages 69, but its Relationship score of 35 caps it at 60.
  3. Apply event caps. Some events override the other scores: cap the score at 30 after a cancellation notice, and at 50 for 60 days after a champion or sponsor leaves. Example C is Poor in three areas and averages 41, which on its own would be Yellow; its cancellation notice caps it at 30, so it's Red.
  4. Mark missing data. If you can't score an area, the account is "Insufficient data", not Green.
  5. Write down the evidence for every Concerning or Poor score: the ticket, the quote, the chart.

Spreadsheet formulas

After you paste the template, the examples sit in rows 10–13. Put these formulas in G10 and H10 and fill them down to row 13; they reproduce the scores and bands above.

Score (G10): =ROUND(MIN(AVERAGE(B10:E10),MIN(B10:E10)+25,IF(F10="",100,F10)),0)
Band (H10): =IF(G10<40,"Red",IF(G10<80,"Yellow","Green"))

Leave the event cap blank when no event applies. For unequal weights, replace AVERAGE(B10:E10) with SUMPRODUCT(B10:E10,W)/SUM(W), where W is a row of four cells holding the weights in the same order as the areas.

Adjust it to your business

Try the rule with the health score calculator, or let Horizon score every account automatically from your calls, tickets, usage and CRM.

Updated November 3, 2026

See which of your renewals are at risk.

A 30-minute call on a demo book, or on your own top 25 accounts.

Book a call