Agency automation 19 of 25
Client Health Scorecard: Score Every Agency Client Out of 100
A client health scorecard gives every client one score out of 100, so you can see trouble before the client cancels. Ours uses six signals: payment, responsiveness, on-time delivery, results against goal, budget burn and message tone. Each signal earns full, half or zero points, and the total lands in a green, amber or red band. Rules compute the score. Claude only reads the tone of recent client emails, which is worth 10 of the 100 points. The weights on this page are our suggested starting design. They are not an industry standard and not a tested benchmark. Change them to match how your agency loses clients. The same check can run every Friday in n8n, write one row per client to a sheet, and alert you in Slack when a client turns red.
How the automation runs
A client health scorecard scores every active client out of 100 each Friday from six signals. Plain rules do the math, Claude only reads email tone, and Slack warns you when a client turns red.
What are the six signals in a client health scorecard?
Each signal scores full, half or zero points, and the weights add up to 100. Three signals carry 20 points each, two carry 15, and tone carries 10. Tone is the smallest weight, and it is the only one Claude reads.
Check this first: we have not confirmed that Harvest exposes a project budget field for the budget burn signal, so test it. If you use Toggl, read it through n8n's HTTP Request node.
| Signal | Weight | What it measures | Where the data comes from |
|---|---|---|---|
| Payment | 20 | Overdue invoices | QuickBooks or Stripe |
| Responsiveness | 20 | Days since the last client reply | Gmail |
| On-time delivery | 20 | Tasks that are late | ClickUp |
| Results vs goal | 15 | Main KPI against its target | Google Analytics 4 |
| Budget burn | 15 | Hours used against the monthly hours budget | Harvest |
| Message tone | 10 | Tone of the last five client emails | Claude, reading Gmail |
What do the green, amber and red bands mean?
The total score decides the band. A client also triggers an alert if the score falls 15 points in two weeks, even when it is still amber or green.
Missing data needs a rule. If you score no data as zero, a healthy client with no invoice this month shows red, and your alerts lose trust. Score no data as half points, mark that signal n/a in the sheet, and only alert when at least four of the six signals have data.
| Band | Score | What happens |
|---|---|---|
| Green | 80 and up | Healthy. No alert. |
| Amber | 55 to 79 | Watch. The sheet shows the weakest signals. |
| Red | Under 55 | Slack tells you the score, the weakest signals and a suggested check-in. |
Do rules or AI calculate the client health score?
Rules calculate the score. A Code step in n8n scores each signal and adds them up, so the number is the same every time you run it.
Claude does one job. It reads the last five client emails and returns positive, neutral or negative with one short reason. The email text goes in as data, never as instructions. Reading a mailbox needs access to the shared inbox or the account managers' mailboxes, with the client's consent where needed.
How do you adjust the weights for your agency?
Write your thresholds down before you switch the alerts on. Then run the scorecard for 90 days. Compare the scores with the clients who complained or left, and move weight to the signals that warned you first.
Also watch clients who left while green. That means a signal is missing, so add one. If payment is never a problem for your clients, lower its weight and raise the signals that do move.
What does it take to run a client health scorecard weekly?
n8n runs it every Friday at 3 pm. You need a client sheet with the ID for each tool, a monthly hours budget per client, and a main KPI with a target for each client. You also need the tools in the table above, Slack for alerts, and an Anthropic API key for the tone read.
Our estimate: 10 to 16 hours to build, based on five data connections at 1 to 2 hours each plus the scoring step, the tone prompt and the alert. We also estimate about 2 hours a month saved at 12 clients, based on roughly 10 minutes per client to check five tools by hand. If you want this built for your agency, book a free call.
Frequently asked questions
What is a client health scorecard?
It is one score out of 100 for each client, built from signals such as payment, replies and late work. You read it weekly to spot clients who may leave. Green is 80 and up, amber is 55 to 79, and red is under 55.
Are these weights an industry standard?
No. They are our suggested starting design, not a published standard or a tested benchmark. Adjust them after you compare scores with the clients who complained or left.
Does AI calculate the score?
No. Plain rules score the signals and add them up. Claude only reads the tone of recent client emails, which is worth 10 of the 100 points.
What should I do when a client turns red?
Slack sends you the client, the score, the weakest signals and a suggested next step. Use the weakest signal to start the check-in, such as a late invoice or a quiet inbox. Then watch whether the client returns to green within 60 days.
Related automations
Weekly client report
Report draft waits in Gmail
Missed deadline alerts
Late tasks reach your PM first
Payment reminders
Late invoices get a reminder
Renewal reminders
Renewal prep starts 60 days out
Referral asks
Referral asked after a win
Want these running in your agency?
Book a free call. We look at your process, pick the automations that fit and tell you what the build involves. There is no price on this page, because it depends on what you need.
Book your free call
Tell us a little about your agency. After you send it, you pick a time on the calendar.
Build times and time saved are estimates, tool plans and features change, so test every automation on your own plan before you rely on it.
