Give an owner a dashboard with twenty tiles and they will look at it twice and never again. Not because the numbers are wrong, but because nothing on it tells them what to do differently before Friday.
A useful report has a threshold and an action. If a number goes past a certain point, somebody does something specific. Numbers without that are decoration.
One: open quotes and their total value
The single most useful number in a service business, and the one most often uncounted. How many quotes are outstanding, what are they worth, and how old is the oldest?
The action is immediate: anything past your follow-up window gets contacted today. Most businesses discover on first look that they have considerably more money sitting in un-followed quotes than they expected.
Two: median first response time
Not average — median, because one enquiry answered three days late will drag an average and hide an otherwise healthy picture.
The action is structural rather than a nudge. If the median is creeping up, it is nearly always because a new place for leads to land has appeared and nobody is watching it.
Three: jobs completed but not invoiced
The gap between doing the work and asking for the money is where cash flow quietly dies. This report should ideally show nothing.
Anything on it more than a few days old is a process failure rather than an oversight, and it is usually the same technician or the same job type each time — which makes it fixable.
Four: customers with no contact in twelve months
A list, not a number. These are people you already earned who are drifting toward whoever contacts them first.
The action is a short personal message. Re-engagement consistently converts better than cold acquisition, and this report is the only way most businesses ever see the list.
Five: lead source against booked revenue
Not leads by source — revenue by source. The channel producing the most enquiries is frequently not the one producing the most money, and budget follows whichever number you look at.
The action is quarterly rather than weekly: shift spend toward what converts to revenue and away from what converts to enquiries.
| Report | Check | Trigger for action |
|---|---|---|
| Open quotes and value | Weekly | Anything past your follow-up window |
| Median first response | Weekly | Trend rising two weeks running |
| Completed not invoiced | Weekly | Anything older than three days |
| No contact in 12 months | Monthly | Any name on the list |
| Revenue by lead source | Quarterly | A channel whose cost per booked job has moved |
What to ignore
- Total contacts in the database. Grows on its own, means nothing.
- Emails sent. Activity, not outcome.
- Website sessions in isolation. Only useful next to enquiries.
- Average job value on its own. Moves with job mix and rarely implies an action by itself.
- Anything you have looked at three times without changing a decision. The most reliable test there is.
Common questions
How often should I look at CRM reports?
Weekly for the operational three — open quotes, response time, uninvoiced work. Monthly for re-engagement. Quarterly for channel performance. Daily checking of most metrics produces noise rather than insight.
What is the most important CRM report?
Open quotes and their total value. It is the closest thing to money sitting on the table, and acting on it produces revenue the same week rather than next quarter.
Should I share reports with my team?
Share the ones they can act on. Response time and uninvoiced jobs are team metrics. Revenue by lead source is generally an owner metric and tends to distract rather than help if shared broadly.
What if the numbers look bad?
That is the point of looking. The first review nearly always turns up more un-followed quotes and uninvoiced work than expected. Those are the easiest wins available, precisely because nobody was watching them.