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.

Client health checks: who does each stepStarts when: Friday 3:00 pm. Step 1, Friday schedule: done by a rule. Step 2, Collect six signals: done by a rule. Step 3, Score each signal: done by a rule. Step 4, Read message tone: done by Claude AI. Step 5, Log the scorecard: done by an app (Google Sheets). Step 6, Alert on red: done by an app (Slack). You get: Weekly score, red flags first.WHO DOES EACH STEPRule, no AIClaude AIA person (none)An appSTARTS WHENFriday 3:00 pm1 · RULEFriday schedulen8n2 · RULECollect six signalsn8n3 · RULEScore each signaln8n4 · CLAUDE AIRead message toneClaude5 · APPLog the scorecardGoogle Sheets6 · APPAlert on redSlackYOU GETWeekly score, red flags first

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.

What are the six signals in a client health scorecard?
SignalWeightWhat it measuresWhere the data comes from
Payment20Overdue invoicesQuickBooks or Stripe
Responsiveness20Days since the last client replyGmail
On-time delivery20Tasks that are lateClickUp
Results vs goal15Main KPI against its targetGoogle Analytics 4
Budget burn15Hours used against the monthly hours budgetHarvest
Message tone10Tone of the last five client emailsClaude, 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.

What do the green, amber and red bands mean?
BandScoreWhat happens
Green80 and upHealthy. No alert.
Amber55 to 79Watch. The sheet shows the weakest signals.
RedUnder 55Slack 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.

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.

Free to request. No payment on this form. Continuing opens our Calendly calendar, which sets cookies from calendly.com. Calendly privacy. We use your email only to reply about this call. No spam.

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.