"We have a CRM. It has fifty reports. I don't open any of them." Owners say this more often than they admit it. The CRM gets bought to fix lead chaos, the team uses it, and the reporting tab stays unopened because nobody has said which numbers matter.
That's a waste of the most valuable thing a CRM gives you, which is a weekly, honest picture of where money comes from and where it leaks.
Short answer: An owner needs about nine CRM reports each week: lead source ROI, conversion by stage, lost reasons, follow-up compliance, response time, pipeline value and forecast, rep performance, repeat and renewal business, and lead ageing. Each one drives a specific decision on budget, process, people or pricing, and together they take about 30 minutes to review.
Why it happens
Reports go unread for predictable reasons:
- Too many default reports. CRMs ship with dozens of standard reports. Without a shortlist, owners open none.
- Dirty data. If the lead source isn't captured or reps skip the "lost reason" field, the reports show nonsense and people stop trusting them.
- No decision attached. A report that doesn't lead to an action ("move ad budget", "change the script") feels like homework.
- No fixed review slot. Reporting happens "when there's time", which means during a crisis.
What it costs your growth
Imagine a hypothetical real-estate broker in Noida spending ₹3,00,000 a month across two property portals, Facebook ads and a Google campaign, and getting 900 leads.
Without source-level reporting, the budget stays split the same way every month. Suppose a lead source ROI report shows that one portal delivers 40% of the leads but only 10% of site visits that lead to bookings, while referrals bring 5% of leads and a quarter of bookings. Those two numbers alone justify moving budget and starting a referral programme. Without the report, that money keeps flowing to the weaker channel month after month.
The same pattern repeats across the business. Lost deals nobody analyses, follow-ups nobody checks, renewals nobody chases. Each is a small, invisible leak.
How a CRM solves it: the 9 reports to read weekly
1. Lead source ROI
What it shows: leads, conversions and revenue by source (portal, ads, referral, walk-in, website), set against what each source costs. Decision it drives: where to put next month's marketing budget. Cut or renegotiate channels with a high cost per conversion, and double down on the ones that close.
2. Conversion by stage (funnel report)
What it shows: how many leads move from new to contacted, to qualified, to demo or site visit, to proposal, to won. Decision it drives: which stage to fix. A big drop between "contacted" and "site visit" is a pitch or scheduling problem. A drop between "proposal" and "won" is often pricing or follow-up.
3. Lost-reason analysis
What it shows: why deals were lost, grouped by reason: price, chose a competitor, no response, budget postponed, wrong fit. Decision it drives: pricing, offers and targeting. If "price" dominates, test an EMI option or a smaller package. If "wrong fit" dominates, tighten your ad targeting. This only works if the lost-reason field is mandatory and uses a fixed dropdown list.
4. Follow-up compliance
What it shows: tasks and follow-ups due versus done, and overdue follow-ups by rep. Decision it drives: whether the process is being followed. Overdue follow-ups are the most direct revenue leak in most Indian SMBs. See CRM task management for sales teams for how to set them up.
5. First response time
What it shows: time from lead creation to first call or message, by source and by rep. Decision it drives: staffing and assignment rules. If weekend or evening leads wait until Monday, you need a rota, an auto-reply or WhatsApp automation.
6. Pipeline value and forecast
What it shows: the total value of open deals by stage and expected close date, weighted by the probability of each stage. Decision it drives: cash planning and hiring. A thin pipeline for next quarter is a signal to push lead generation now, not in three months.
7. Rep performance
What it shows: for each rep, the leads assigned, activities done, stage conversions, revenue won and average deal size. Decision it drives: coaching, lead allocation and incentives. Our sibling guide on sales team efficiency tracking explains how to read this fairly, without turning it into surveillance.
8. Repeat and renewal business
What it shows: renewals due in the next 30, 60 and 90 days, renewal rate, and repeat purchases by customer. Decision it drives: retention effort. For an insurance agency, AMC-based service firm or distributor in Surat, renewals and reorders are the cheapest revenue you'll ever earn. Assign renewal owners and start 60 days early.
9. Lead ageing
What it shows: open leads grouped by how long they've been sitting untouched. Decision it drives: clean-up and reassignment. Leads untouched for more than a fortnight should be reassigned, put on an automated nurture sequence or closed as lost with a reason.
Optional 10th: Activity trend
A simple weekly chart of calls, meetings and messages per rep. It's useful as an early warning, because a drop in activity usually shows up in revenue a few weeks later.
Making it stick
- Make lead source and lost reason mandatory fields with fixed dropdown values.
- Build one owner dashboard containing these nine widgets.
- Schedule it to arrive by email every Monday morning. Most CRMs can schedule reports.
- Review it in a fixed 30-minute slot with the sales head, and write down one decision per report.
Reading the reports together
No single report tells the whole story. The value comes from reading them side by side. Here's a hypothetical Monday review at a B2B services firm in Pune:
- Lead source ROI shows that LinkedIn leads cost the most but convert best.
- Conversion by stage shows that most LinkedIn leads stall between "demo done" and "proposal sent".
- Follow-up compliance shows that one rep, who handles most LinkedIn leads, has 40 overdue follow-ups.
- Rep performance confirms that the same rep has the highest pipeline value and the lowest close rate.
Read separately, each number looks like a minor issue. Read together, they show that the best channel is being wasted by one overloaded rep. The fix isn't more ad spend. It's reassigning half of that rep's leads and adding a proposal template. That's the kind of decision that grows revenue without adding cost.
Write down the decision, the owner and the number you expect to move, then check it at the next review. Over a quarter, those small corrections compound.
Which CRMs on App Advisor do this well
These are listed CRMs whose official sites describe the relevant reporting. App Advisor does not sell them, and nothing here is paid placement.
- Pipedrive: Pipedrive lists conversion reports that track the lead-to-deal rate by lead source, creator and time period, as well as revenue forecasts, deal tracking, goal tracking and performance reports.
- Freshsales: Freshworks lists standard and custom reports, attribution and conversion reports, and sales forecasting.
- Zoho CRM: Zoho describes dynamic dashboards, report generation, proactive anomaly detection and forecasting.
- Kylas CRM: Kylas lists dashboards for leads, deals, emails, tasks and goals, plus revenue projections and team productivity reports.
- LeadSquared: LeadSquared describes dashboards for leads, follow-ups and conversions, and real-time pipeline visibility.
For a broader view, read our round-up of the best CRM software in India.
A 30-day rollout plan
Week 1: Fix the data. Make lead source, stage and lost reason mandatory. Clean up duplicate and dead leads.
Week 2: Build the dashboard. Create the nine reports and put them on one owner dashboard. Enter monthly spend per channel for the ROI report.
Week 3: Schedule and review. Schedule the Monday email and hold the first 30-minute review. Expect to find data gaps, and fix them.
Week 4: Act. Make one decision from each report, such as moving budget, reassigning aged leads or starting renewal calls. Track whether those numbers move the following month.
Find the right fit
Compare shortlisted tools on /compare, browse the CRM category, or ask the free AI advisor for a shortlist that fits your reporting needs.
FAQs
What reports should a sales manager check weekly?
Lead source ROI, conversion by stage, lost reasons, follow-up compliance, first response time, pipeline forecast, rep performance, renewals and lead ageing. Together they cover budget, process, people and retention.
How do I calculate lead source ROI in a CRM?
Tag every lead with its source, record the revenue from won deals, and enter each channel's monthly spend. Then compare revenue and cost per conversion by source.
Why are my CRM reports inaccurate?
Usually because key fields are optional or free-text, so reps skip them or type inconsistent values. Make source, stage and lost reason mandatory dropdowns, and clean up duplicates.
What is a sales pipeline forecast?
It's the expected revenue from open deals, based on their value, stage and expected close date. Many CRMs weight each deal by the probability of its stage to give a more realistic figure.
How often should a business owner review CRM reports?
Weekly works for most SMBs: a fixed 30-minute review of one dashboard. Do a deeper monthly review for budget and hiring decisions.
Can I get CRM reports automatically by email?
Most CRMs let you schedule reports or dashboards to be emailed on a set day. Check the specific CRM's help docs for how scheduling works on your plan.
