# Design a customer health score that actually predicts churn

A practical health score model with weighted signals, thresholds, and a plan to test whether it predicts renewals.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Health & Wellness, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/design-a-customer-health-score-that-actually-predicts-churn

## Prompt

```text
Help me design a customer health score for my book of business.

**Product and business model:** [e.g. "B2B SaaS, annual contracts", "agency retainer", "usage-based"]
**Data I can access:** [e.g. logins, feature usage, seats used vs. purchased, support tickets, NPS/CSAT, invoices paid late, exec engagement, CRM notes]
**Number of accounts and typical contract size:** [DETAILS]
**What churn or downgrade has looked like historically:** [EXAMPLES OR PATTERNS, if known]
**Tool I'll build it in:** [spreadsheet / CRM / CS platform]

Give me:
1. Recommended signals grouped into categories (product usage, relationship, support, financial, outcomes), and why each predicts risk. Drop any signal that's easy to measure but unlikely to matter.
2. A weighting scheme and scoring method (e.g. 0-100), with simple formulas I can implement.
3. Thresholds for Green / Yellow / Red, and what action each color triggers.
4. Overrides: situations that should force an account to Red regardless of score (e.g. champion left, open escalation, failed payment).
5. How to validate it: back-test against past renewals and churns, what accuracy to look for, and how often to recalibrate.
6. Common mistakes (too many signals, lagging indicators only, scores no one acts on) and how to avoid them.

Do not invent benchmarks. If a threshold depends on my data, say how to set it from my historical numbers.
```

## What to fill in

- DETAILS
- EXAMPLES OR PATTERNS, if known
- spreadsheet / CRM / CS platform

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.