---
title: "Customer health score template (free, copy into Sheets)"
url: https://renewalfix.com/guides/customer-health-score-template/
description: "A free customer health score template with four areas, a scoring rubric, weights, working formulas and a rule that stops one weak area hiding."
updated: 2026-11-03
---

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.

By [John Beckett](https://renewalfix.com/about/#john-beckett) · Updated November 3, 2026

## 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

- 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](https://renewalfix.com/glossary/customer-satisfaction-score/) 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](https://renewalfix.com/integrations/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](https://renewalfix.com/tools/customer-health-score-calculator/), or let [Horizon](https://renewalfix.com/product/customer-health-score/) score every account automatically from your calls, tickets, usage and CRM.

More on this topic: [customer health, definitions, guides and tools](https://renewalfix.com/topics/customer-health/).

---

Horizon is renewal risk software for Customer Success teams. Book a call: https://calendar.chilipiper.com/book/me/serban-goanta
