Weekly KPI Scorecard: A One-Page Dashboard for Service Businesses

Most service businesses do not have a data problem. They have a rhythm problem. The numbers exist in the ad account, the CRM, the calendar, and the bank, but nobody looks at them together until the month closes, and by then the damage is five weeks old. A KPI scorecard fixes that: one page, 10 to 15 numbers, one owner per number, reviewed every week against a target.

I have seen founders run multi-million dollar service businesses off gut feel and a monthly profit and loss statement. Show rate slides from 72% to 55%, nobody notices for six weeks, and the business quietly loses a deal or two every week. On a $6,000 offer that is $36,000 to $72,000 gone. Nothing broke dramatically. Nothing forced the number in front of the person who owns it.

Here is the scorecard structure we run across our companies: which metrics to pick, how to set targets and thresholds, how to read a 13-week trailing view, and how to run the 30-minute review that turns red numbers into assigned fixes.

What a KPI Scorecard Is, and What It Is Not

A dashboard is a place you explore: 40 charts, filters, date pickers. A scorecard is a short, fixed list of numbers that tells you in under five minutes whether the business is on track this week and exactly where it is not.

Every line on a working scorecard has five parts:

Metric: one number with a written definition, such as "shown calls divided by calls scheduled this week."
Owner: one named person who reports it and is accountable for it.
Target: the weekly number the plan requires.
Direction: whether higher or lower is better.
13 weeks of actuals: the trailing quarter, so you see trends instead of snapshots.

Missing any of the five, the line is decoration. A metric without an owner gets discussed and never fixed. A metric without a target can never be red, so it never triggers action.

Leading and Lagging Metrics: Balancing Your KPI Scorecard

Lagging metrics tell you what already happened: cash collected, churn, profit. You cannot change them this week. Leading metrics are the activities and conversion rates that produce those results: booked calls, show rate, onboarding speed. You can move those by Friday.

My rule of thumb: at least 60% of the scorecard should be leading metrics. A scorecard of lagging numbers is a weekly autopsy. Pair every lagging metric with a leading metric upstream of it, so when the lagging number goes red you already know where to look. New cash is driven by shown calls and close rate. Churn is predicted four to eight weeks early by at-risk clients and missed milestones. If you have not mapped that chain, start by reverse-engineering your revenue goal into department KPIs.

The 13-Metric Starter Scorecard for a Service Business

Below ten metrics, a department has no visibility. Above fifteen, the review becomes a reading exercise. Here is the starter set I give any high-ticket service business selling through calls. Swap metrics to fit your model, but keep the coverage.

Marketing (owner: head of acquisition)

Qualified applications (leading): applications that meet your qualification criteria, not raw opt-ins.
Cost per booked call (leading, lower is better): weekly ad spend divided by qualified calls booked.

Sales (owner: sales manager or setter lead)

Calls booked (leading).
Show rate (leading): 65% to 75% is healthy for qualified calls with a real pre-call sequence. Below 60%, look at booking lead time first.
Close rate on shown calls (leading): 20% to 35% is the normal band for a well-qualified high-ticket offer.
New cash collected (lagging): cash in the bank from new deals, not contract value.

Fulfillment (owner: head of delivery)

Onboarded within 7 days (leading): share of new clients fully onboarded within a week of payment. Target 90% or higher.
Capacity utilization (leading): active clients divided by delivery capacity. Green between 75% and 90%. Above 90% quality slips.
First result hit rate (leading): share of clients in their first 30 days who hit the first promised milestone on schedule.

Retention (owner: customer success lead)

At-risk clients (leading, lower is better): count of clients flagged red on your client health score.
Revenue churned (lagging, lower is better): recurring revenue lost to cancellations or non-renewals.

Finance (owner: founder)

Total cash collected (lagging): all cash in, new and recurring.
Cash runway in weeks (lagging): cash on hand divided by average weekly expenses. I want 12 or more.

That is 13 metrics, 9 of them leading. Impressions, open rates, and hours logged belong on department dashboards. The company scorecard only holds numbers that move cash or retention.

Owners, Targets, and Red/Green Thresholds

One owner per metric, and it is a name

"Sales" does not own show rate. Your setter lead does. The owner reports the number weekly, explains it when it is red, and brings the fix. If two people share a metric, nobody owns it. If one person owns more than four, they are a bottleneck or the metrics are too granular.

Targets come from the model, not from ambition

Need 6 new clients a week at a 25% close rate? The shown-call target is 24. At a 70% show rate, the booked-call target is 35. At $340 per booked call, the weekly ad budget is about $11,900. When targets connect mathematically, hitting every leading target delivers the lagging one. The break-even math for call funnels shows how to build that model.

Red or green, no yellow

Each weekly cell is green if it hits target and red if it misses. I do not use yellow. Yellow is a hiding place where a number sits "almost fine" for two months while it costs you a deal a week. To control noise, use two trigger rules:

Two reds in a row: the metric goes on the issues list.
One week more than 20% off target: it goes on the list immediately.

A single red within 20% of target gets a one-line note from the owner and nothing more.

Building the 13-Week Trailing View

Lay the scorecard out as a grid. Rows are metrics. The first columns are metric, owner, direction, and target, followed by 13 weekly columns, newest on the right, and a 13-week average. Thirteen weeks is one quarter: long enough to separate a trend from a bad week, short enough to fit on one screen. Watch for three patterns:

The slow slide: close rate at 31%, 30%, 29%, 27% against a 25% target is green every week and heading for red. Treat four straight declines as a red.
The sawtooth: a metric alternating red and green, usually one closer's calendar or a capacity gap swinging the number.
The step change: a metric that drops and stays down. Find what changed that week: creative, a hire, pricing, or tracking.

Set data rules once and freeze them for the quarter. The week closes Sunday at midnight. Owners enter their own numbers by Monday at noon from the agreed source. If your numbers come from five tools with five definitions, fix that first by building a single source of truth for funnel data. Disputed numbers produce arguments, not decisions.

How to Run the Weekly KPI Scorecard Review

Thirty minutes, same day, same time, every week. Monday afternoon or Tuesday morning works best: fresh data and a full week left to act. It sits inside your broader meeting cadence for service businesses, but it is the one meeting you never cancel.

Lock the scorecard. Numbers are due Monday at noon, then the sheet locks. A missing number shows as red.
Read-through (5 minutes). Each owner reads their line in one sentence: "Show rate, 57%, target 70%, off." No stories.
Build the issues list (3 minutes). Anything that hit a trigger rule or a slow slide goes on. Unresolved issues from last week stay on.
Prioritize (2 minutes). Pick the top three by cash impact. Three solved issues beat eight discussed ones.
Solve (15 minutes). For each issue: root cause, action, owner, due date. If the cause is unknown, the action is a diagnosis with a deadline. Funnel bottleneck analysis traces a red lagging number back to the stage that is leaking.
Recap (5 minutes). Read back every action, owner, and due date. Next week opens by checking completion. Under 80% means the team is overcommitting or not taking the meeting seriously.

Worked Example: Catching a Leak in Two Weeks

A service business sells a $6,000 program, paid in full. The plan calls for 6 new clients and $36,000 in new cash per week. Targets: 35 booked calls, 70% show rate, 25% close rate, $340 cost per booked call. Weeks 1 through 8 run close to plan. Week 9 comes in:

Calls booked: 35 (green)
Show rate: 57%, 20 shown calls (red, 19% off target)
Close rate: 25%, 5 deals (green)
New cash collected: $30,000 (red)

Show rate is red but within 20%, so the owner adds a note. Week 10: 54%, 19 shown from 35 booked, 5 deals, $30,000. Second consecutive red and more than 20% off target, so it becomes the top issue.

Size the cost. At 70%, 35 booked calls produce about 24 shown calls and 6 deals. At 54% to 57%, they produce 19 or 20 shown calls and 5 deals. One lost deal a week is $6,000, or $78,000 over a quarter. Marketing is all green. Without the scorecard, the fix would have been new ads.

In the solve step, the setter lead pulls booking lead time: the gap between booking and call went from 1.9 days to 4.4 days because a closer was out and the calendar pushed bookings nearly a week out. The actions:

Cap the booking window at 72 hours. Owner: setter lead. Live by Wednesday.
Add a backup closer for overflow days. Owner: sales manager. Done by Friday.
Tighten the pre-call sequence that drives show rate for calls booked more than 48 hours out. Owner: setter lead. Done by Thursday.

Week 11, show rate recovers to 68%. Week 12, 72%. The scorecard surfaced a $78,000 quarterly leak in 14 days, and the fix never touched the ads.

Common KPI Scorecard Mistakes

Too many metrics. Thirty lines means nobody holds the picture. Cut to 15.
Only lagging metrics. Every red week becomes a surprise.
Shared owners. "The team" owns nothing. One name per line.
Targets from thin air. If targets do not connect to the revenue plan, the team can hit all of them and still miss the month.
Changing definitions mid-quarter. It makes the 13-week trend worthless.
Debating during the read-through. Thirty minutes become 90 and the top issues never get solved.
Reviewing monthly. A leak runs four weeks before anyone sees it.

Frequently Asked Questions

What should be on a KPI scorecard for a service business?

Cover marketing, sales, fulfillment, retention, and finance. For a call-funnel business: applications, cost per booked call, show rate, close rate, cash collected, onboarding speed, capacity, at-risk clients, churn, and runway, mostly leading.

How many KPIs should a weekly scorecard have?

Between 10 and 15. Fewer leaves a department unmeasured, and more turns the review into a reading exercise. Keep extra metrics on department dashboards.

What is the difference between a KPI scorecard and a dashboard?

A dashboard is for exploring data with many charts and filters. A KPI scorecard is for accountability: a fixed set of numbers, each with an owner and a target, reviewed weekly.

How do you set red and green thresholds for KPIs?

Set each target from your revenue model, then mark each week green if it hits and red if it misses. Skip yellow. Escalate a metric after two consecutive reds or one week more than 20% off target.

How long should a weekly scorecard meeting take?

Thirty minutes: 5 on the read-through, 5 on the issues list, 15 solving the top three issues, and 5 recapping commitments. If it runs long, the read-through has turned into a discussion.

Next Steps: Build Your KPI Scorecard This Week

A spreadsheet works fine for the first quarter.

List 10 to 15 metrics across all five departments, at least 60% leading.
Write a definition and data source for each.
Put one name next to every metric.
Set weekly targets from your revenue model.
Backfill the last 13 weeks so the trend is visible on day one.
Book a recurring 30-minute review and run the six-step agenda.

Run it for a full quarter before changing the format. By week 13 you will know which numbers actually predict your cash.