Most small business owners know their monthly revenue and roughly how busy they feel. That’s not enough to run the business well. By the time revenue drops, the problem started weeks earlier, usually in sales activity, delivery or cash collection.
You don’t need a complicated dashboard. For a service business, eight numbers reviewed every week will tell you almost everything. Here they are, with how to track each one and what to do when it moves.
Sales: is work coming in?
1. New qualified leads
What it is: the number of new enquiries that fit your ideal client, not every form submission.
Where to get it: your CRM or enquiry form, filtered by a “qualified” tag or stage.
What to watch: a drop for two or more weeks in a row. Leads are your earliest warning signal; a quiet month in leads becomes a quiet quarter in revenue.
2. Sales calls held
What it is: discovery or sales calls that actually happened, not just booked.
Where to get it: your calendar or CRM pipeline stage.
What to watch: the gap between leads and calls. If leads are steady but calls are falling, the problem is follow-up speed or your booking process.
3. Proposals won (and win rate)
What it is: how many proposals were accepted, and the percentage of proposals sent that were won. Track win rate over a rolling month, since weekly numbers are small.
Where to get it: your CRM, Dubsado or proposal tool.
What to watch: a falling win rate often points to pricing, positioning or the quality of your discovery calls.
Delivery: is work going out well?
4. Overdue tasks
What it is: the number of tasks past their due date across the business.
Where to get it: your project tool. In ClickUp or Notion, a saved “overdue” filter takes seconds.
What to watch: a rising trend means you’re overloaded, priorities are unclear, or deadlines are unrealistic. Look at who owns the overdue tasks; it’s often concentrated in one person.
5. Client issues raised
What it is: complaints, escalations, revision requests beyond scope, or anything a client flagged as a problem.
Where to get it: keep a simple log in your hub. It only takes a line per issue.
What to watch: patterns. Three issues about the same step in your process is a process problem, not bad luck.
Money: is cash coming in?
6. Revenue invoiced
What it is: the total value of invoices sent this week.
Where to get it: your accounting or invoicing tool.
What to watch: compare against your monthly target. If you’re halfway through the month at a quarter of target, you know early enough to act.
7. Cash outstanding (and how overdue)
What it is: the total of unpaid invoices, split into “not yet due”, “under 30 days overdue” and “30+ days overdue”.
Where to get it: your accounting tool’s receivables or aged debtors report.
What to watch: anything over 30 days. Late payments are the most common cash flow problem for small service businesses, and the easiest to improve with consistent reminders.
Capacity: can the team handle it?
8. Team capacity used
What it is: how full your team is, as a rough percentage. You can estimate it from hours booked against hours available, or from active projects per person against a sensible maximum.
Where to get it: your project tool’s workload view, a time tracker, or a simple weekly check-in.
What to watch: consistently above about 85% means burnout and slipping quality are coming. Consistently below 60% means you can take on more work, or you have more capacity than you need.
How to set it up in an afternoon
- Create a simple Google Sheet with the eight numbers as columns and one row per week.
- Decide where each number comes from and who records it. Write it at the top of each column.
- Fill in the last four weeks if you can, so you start with a trend instead of a single point.
- Automate what you can. Zapier or Make can pull leads from your CRM, overdue tasks from ClickUp and invoices from your accounting tool into the sheet every Monday morning.
- Review it in your weekly operations meeting. Five minutes is enough. Only discuss the numbers that moved unexpectedly.
Once the sheet is working, you can turn it into a dashboard in ClickUp, Notion, Looker Studio or your CRM. But start with the sheet. A simple sheet you actually review beats a beautiful dashboard nobody opens.
Using AI with your numbers
Paste the last eight weeks into ChatGPT or Claude and ask:
Here are eight weeks of business metrics. Identify the three most important trends, explain what might be driving each one, and suggest one question I should investigate this week. Don’t speculate beyond the data.
It’s a useful second opinion, especially for spotting connections, such as a dip in leads three weeks before a dip in revenue. Always check its reasoning against what you know about the business.
When to add more metrics
Add a number only when it would change a decision. Common additions as a business grows:
- Client retention or renewal rate for retainer businesses
- Average project margin if pricing or scope creep is a concern
- Lead source to see which marketing channels work
- Response time to new enquiries
Keep the core list short. The goal is clarity in five minutes, not a full report.
What happens next
Tracking numbers only helps if someone acts on them. That’s where a weekly rhythm comes in: review the numbers, decide what to do and assign an owner. Setting up and running that rhythm is part of my monthly retainers.