5 CRM Reports Every Business Owner Should Read

A CRM can produce a hundred reports. Most vendors will show you all of them in the demo. An owner of a small business has time to read about five, and only if each one answers a question they would otherwise have to guess at.

These are the five. One screen, five numbers, read weekly. Each comes with what to do when it moves, because a report nobody acts on is decoration.

01Report 1: New Enquiries by Source

The question it answers: where do our customers come from, and is the marketing money going to the right place?

A count of new enquiries this month, split by source: website, portal, WhatsApp, referral, walk-in, each ad campaign. Next to it, how many from each source became customers. The second column matters more than the first. A source that sends fifty enquiries and no customers is costing you time twice.

When it moves: a source that converts well and is cheap gets more budget. A source that sends volume with no conversions gets a harder look at the enquiry form or the ad targeting before it gets cut. Referrals growing is the best news this report can give you.

02Report 2: Conversion by Stage

The question it answers: where do we lose deals?

Of every hundred enquiries, how many reach each stage. A manufacturing distributor’s looked like this:

100 enquiries → 72 quoted → 31 sample sent → 24 negotiating → 19 orders — biggest drop: quote to sample (41 lost)

The biggest drop is the stage to work on, and it is almost never the one the team talks about. This distributor assumed the problem was price at negotiation. The report said the problem was that quotes went out and nobody asked for the sample order. One follow-up rule later, the quote-to-sample number improved more than any discount would have managed.

When it moves: a drop that widens at one stage means a process problem there, not a market problem. Look at that stage’s follow-up rule and time limit first.

03Report 3: Response Time

The question it answers: how long does a new enquiry wait before someone replies?

The average, and the share answered within your target from Module 2, by person and by channel. This is the number that predicts next month’s sales better than any other, because the customer who messaged you also messaged two competitors, and the first useful reply usually wins.

An immigration consultancy watched this number fall from “about a day” to under an hour after moving enquiries to a connected business number with auto-assignment. Bookings for eligibility calls rose in the same month with no change in marketing.

When it moves: up means someone is overloaded, a channel is not connected, or a new person has not been added to the rotation. Fix the person or the door, not the target.

04Report 4: Revenue by Customer Type

The question it answers: which kind of customer is the business actually built on?

Revenue for the month and the year, split by whatever “type” means for you: industry, product line, project, service, city, new versus repeat. The split most owners find surprising is new versus repeat. A real estate agency discovered that a third of its bookings came from past buyers and their referrals, which changed where the after-sale follow-ups sat on the priority list.

When it moves: a type that grows quietly deserves a campaign aimed at it. A type that shrinks for two months in a row deserves a conversation with three of those customers.

05Report 5: Overdue Follow-Ups

The question it answers: what is being dropped right now?

A count of follow-up tasks past their date, by owner, with the oldest at the top. This is the only one of the five that is read daily rather than weekly, because it is the only one you can act on today. It is also the health check for the whole CRM: if this number is zero and the pipeline is full, the rules are working. If it is zero and the pipeline is empty, nobody is entering anything.

When it moves: up for one person means a backlog to clear together. Up for everyone means the rules are asking for more touches than the team has hours, so cut touches rather than let them slip.

06One Screen, Not Five Tabs

The five numbers belong together on one page the owner opens on Monday morning before the pipeline review. Enquiries by source and conversion by stage across the top, response time and revenue by type in the middle, overdue follow-ups at the bottom in red if anything is there.

Each number shows this month next to last month. No charts for their own sake. A number that moved is the only thing worth a chart, and the chart is the trend of that number over six months.

If building this screen in your current tool means exporting to a spreadsheet, the tool is doing the easy part and leaving you the hard part.

07Reports You Can Skip

Some reports look like management and are not.

• Activity counts. Calls made, emails sent, per person. They measure effort, not results, and they teach the team to log activities rather than close deals.
• Pipeline value as a forecast. Adding up every open deal says what might happen if everything closed. Use the named list from the weekly review instead.
• Email open rates. Covered in the last lesson. Replies and deals, not opens.
• Anything the owner cannot explain in one sentence. If you cannot say what question a report answers, it is not a report, it is a table.

08Why These Five Need a Real CRM

Every one of the five is built from fields you decided to collect in Module 2: source, stage, timestamps, customer type, task dates. A spreadsheet can hold the fields but cannot keep them current, and a generic CRM can report on its own fields but not on “sample sent” or “visa decision”. The five reports on one screen, from your own stages, filled in every Monday, is exactly the kind of thing a CRM built around your business does on day one.

Next lesson, the last in this module: what the CRM does after the sale, where customer service, renewals and referrals live.