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
- Score each area by its worst open problem. One serious issue outweighs ten small ones.
- 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.
- 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.
- Mark missing data. If you can't score an area, the account is "Insufficient data", not Green.
- 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.
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
- Change the weights by segment. Enterprise accounts may weight Relationship higher; self-serve accounts may weight Adoption higher.
- Change the time windows to fit your contract length: shorter for monthly plans, longer for annual and multi-year deals.
- If you run NPS or CSAT surveys, count a detractor response from a key contact as a Relationship problem rather than adding a fifth area. The person answering often isn't the one who decides the renewal.
- Rescore every week before your renewal review. The account owner owns each score and the evidence behind it.
- Store the score and band as fields on the account in your CRM (Salesforce or HubSpot), so renewal forecasts and reports can use them.
- Backtest it: score last year's renewals as they looked 90 days before the date, then check how many of the churned accounts the score would have flagged, and how many renewed accounts it flagged by mistake.
Try the rule with the health score calculator, or let Horizon score every account automatically from your calls, tickets, usage and CRM.
More on this topic: customer health, definitions, guides and tools.
Updated November 3, 2026