A CRM generates dozens of reports. Most of them are interesting but not actionable. This guide cuts through the noise and identifies the five reports that actually drive business decisions for a Mumbai SMB owner and tells you honestly what each one is trying to tell you.
The reporting principle
Every report worth building answers one of three questions: Where are we? Where are we losing? What should we do next?
The five reports every Mumbai SMB owner needs weekly
Report 1: Pipeline by stage (the weekly heartbeat)
What it shows: The number of deals and their total value at each pipeline stage, updated in real time.
What it tells you: Whether your pipeline is healthy or anemic. If 80% of your pipeline value is stuck in "Proposal Sent," you have a closing problem. If 60% is in "Initial Contact," you have a qualification problem. The distribution tells you where to focus.
Red flag: A stage with disproportionate deal count and low movement. Deals stuck in the same stage for more than 2 your average sales cycle need immediate attention.
Report 2: Lead source performance (the marketing spend guide)
What it shows: How many leads came from each source (Google Ads, organic, WhatsApp, Instagram, referral) and critically how many of those leads closed, and at what revenue.
What it tells you: Where to spend your next marketing rupee. If Google Ads generates 40% of your leads but only 10% of your revenue, and referrals generate 15% of leads but 45% of revenue you know where to invest.
Common mistake: Most businesses track leads by source but not revenue by source. Track both.
Report 3: Activity log by rep (the accountability report)
What it shows: How many calls, messages, and meetings each rep logged per week.
What it tells you: Who is active and who is coasting. A rep with 5 open deals and 3 activities logged last week either has very long sales cycles or is not working the pipeline. Confronted with data, most reps self-correct.
Important caveat: This report is only as accurate as your team's logging discipline. If the CRM-for-commission rule is enforced, this data is reliable.
Report 4: Sales cycle length by deal size (the forecasting tool)
What it shows: The average number of days from enquiry to close, broken down by deal value range.
What it tells you: How long your pipeline takes to convert at different sizes and therefore how long your current pipeline will take to close. This is your cash flow forecast tool.
Practical use: If deals in the ?1 5 lakh range close in 14 days on average and you have ?25 lakhs in that range today, you can forecast roughly how much of that closes this month.
Report 5: Lost deal analysis (the improvement engine)
What it shows: Why deals were lost, categorised by loss reason, with rep and deal size context.
What it tells you: The most common reasons you lose business. If 40% of lost deals cite price, that is a pricing or value communication issue. If 30% cite timing, you may have a qualification problem you are pitching too early.
How to make it useful: Require a loss reason field before a deal can be closed as lost. Review this report monthly with the team.
Ready to take the next step?
Let Perceptra scope the right approach for your business.
Book a Free Strategy Session ?What to stop tracking
Most CRM platforms generate reports on: total contacts, emails sent, calls made, deals created. These activity metrics feel like progress but rarely drive a specific decision. Prioritise outcome metrics conversion rates, pipeline velocity, loss reasons over activity metrics.
Frequently asked questions
Weekly pipeline review (Reports 1 and 3). Monthly lead source and lost deal analysis (Reports 2 and 5). Quarterly sales cycle analysis (Report 4). Do not review all five at once weekly it becomes a reporting exercise, not a decision session.
Fix the data first. A 2-hour data cleaning session deduplicating contacts, updating stale deal stages, adding missing source attribution pays back in reliable reporting immediately.
Yes. HubSpot, Zoho, and Freshsales all support custom report builders. If you need a report the platform cannot build natively, we can create it via CRM API + Google Data Studio. Contact us.