The CRM Reports and KPIs Every Sales Team Should Track
Implementing a CRM is only the first step.
The real value comes from using the data inside the system to understand what is happening across your sales process, where opportunities are being lost, which activities are generating results, and how reliable your forecast actually is.
A CRM should help leadership answer questions such as:
Do we have enough pipeline to hit the target?
Which opportunities are most likely to close?
Where are deals getting stuck?
Which reps are converting pipeline effectively?
How accurate is our forecast?
Which lead sources are generating revenue?
How long does it take to close a deal?
Are sales teams actually using the CRM correctly?
The reports below are a strong starting point for most sales organizations using Salesforce, HubSpot, or another CRM.
1. Pipeline Coverage
Pipeline coverage compares the value of your open pipeline against your sales target.
A common calculation is:
Pipeline Coverage = Open Qualified Pipeline ÷ Revenue Target
For example, if your sales team has a quarterly target of $1 million and $3 million in qualified pipeline, your pipeline coverage is 3x.
The correct coverage ratio varies by business. A company with a 50% win rate may require less coverage than one closing only 20% of qualified opportunities.
The purpose of this report is not simply to show pipeline value. It is to determine whether the organization has enough realistic pipeline to achieve the revenue target.
2. Pipeline Quality
A large pipeline does not necessarily mean a healthy pipeline.
Pipeline quality should evaluate whether opportunities are active, properly qualified, progressing through the sales process, and supported by realistic close dates.
Useful indicators include:
Opportunities with no recent activity
Opportunities sitting too long in one stage
Close dates repeatedly pushed forward
Opportunities without defined next steps
Deals missing required qualification information
Opportunities with unusually low engagement
This report helps separate real pipeline from opportunities that are unlikely to convert.
3. Opportunity Stage Conversion
Stage conversion measures the percentage of opportunities that successfully move from one sales stage to the next.
For example:
Discovery → Demo → Proposal → Negotiation → Closed Won
If a large percentage of opportunities reach discovery but very few progress to a proposal, there may be a problem with qualification, positioning, pricing, or the sales process itself.
Tracking stage conversion helps identify where revenue is leaking from the funnel.
4. Win Rate
Win rate measures how many closed opportunities become customers.
A basic calculation is:
Win Rate = Closed Won Opportunities ÷ Total Closed Opportunities × 100
This can also be segmented by:
Sales representative
Industry
Lead source
Product
Region
Deal size
Campaign
Customer segment
A company-wide win rate provides useful context, but the real value usually comes from understanding why some segments, reps, or lead sources convert better than others.
5. Sales Cycle Length
Sales cycle length measures how long it takes an opportunity to move from creation or qualification to Closed Won.
This report helps answer questions such as:
Are deals taking longer to close?
Which products have the longest sales cycles?
Which representatives move opportunities faster?
Are larger deals taking significantly longer?
Which stages create the most delay?
A growing sales cycle can be an early warning that the sales process is becoming less efficient.
6. Stage Aging
Stage aging measures how long an opportunity remains in each stage.
This is different from overall sales cycle length.
A deal may have been open for 60 days, but the more important question may be whether it spent 40 of those days sitting in the proposal stage.
Stage aging can help identify stalled opportunities and process bottlenecks.
It can also be used to create alerts when opportunities exceed an expected number of days in a particular stage.
7. Sales Velocity
Sales velocity estimates how quickly your existing pipeline generates revenue.
A common formula is:
Sales Velocity = Number of Opportunities × Average Deal Value × Win Rate ÷ Average Sales Cycle
This metric combines several parts of the sales process into one measurement.
Improving sales velocity does not always require generating more leads. It may come from increasing win rate, shortening the sales cycle, or increasing average deal value.
8. Average Deal Size
Average deal size measures the average value of Closed Won opportunities.
A basic formula is:
Average Deal Size = Closed Won Revenue ÷ Number of Closed Won Opportunities
Tracking this over time can help identify changes in customer profile, pricing, product mix, or sales behavior.
It is also useful when comparing performance across representatives, industries, or acquisition channels.
9. Forecast Accuracy
A sales forecast should not simply show what the CRM says will close.
You should also measure whether previous forecasts were accurate.
A simple approach is to compare forecasted revenue against actual Closed Won revenue for the same period.
For example:
Forecast Accuracy = 1 - |Forecast - Actual Revenue| ÷ Actual Revenue
The exact calculation can vary depending on the organization.
The important point is that forecast accuracy should be measured historically.
Without that feedback loop, leadership has no way of knowing whether the forecast can actually be trusted.
10. Close-Date Movement
Repeatedly changing an opportunity's expected close date is one of the clearest indicators of weak pipeline quality.
Your CRM should track:
Original close date
Current close date
Number of close-date changes
Number of days pushed
Opportunities pushed into a future quarter
A high level of close-date movement can artificially inflate the forecast and hide problems with qualification.
11. Lead-to-Opportunity Conversion
This report measures how many qualified leads eventually become sales opportunities.
It can be segmented by:
Lead source
Marketing campaign
Geography
Industry
Representative
Product or service
A high volume of leads means very little if those leads rarely create pipeline.
This report helps determine which sources are actually generating sales opportunities rather than simply producing names in the CRM.
12. Opportunity-to-Customer Conversion
Once an opportunity has been created, the next question is how efficiently those opportunities convert into customers.
This report should be reviewed together with lead-to-opportunity conversion.
A lead source may generate fewer opportunities but significantly higher win rates, making it more valuable than a source producing large volumes of low-quality pipeline.
13. Revenue by Lead Source
Marketing attribution should eventually connect acquisition activity to revenue.
A basic revenue-by-source report can show how much Closed Won revenue originated from:
Organic search
Paid search
Events
Referrals
Outbound prospecting
Partner channels
Social media
Direct traffic
Marketing campaigns
This moves the conversation away from lead volume and toward commercial outcomes.
14. Revenue by Campaign
For organizations running structured marketing campaigns, campaign reporting should connect spend, leads, opportunities, and revenue.
Useful campaign KPIs include:
Campaign cost
Leads generated
Opportunities created
Pipeline generated
Closed Won revenue
Cost per opportunity
Customer acquisition cost
Return on marketing investment
This is particularly important when deciding where marketing budget should be increased, reduced, or eliminated.
15. Rep Performance
Sales performance should not be evaluated using revenue alone.
A complete rep performance report may include:
Pipeline created
Pipeline coverage
Win rate
Revenue closed
Average deal size
Sales cycle
Stage conversion
Meetings completed
Opportunities created
Forecast accuracy
The objective is not to create a surveillance dashboard.
It is to identify where representatives are performing well, where coaching is required, and whether performance differences are caused by behavior, territory, account quality, or process design.
16. Sales Activity
Activity reports can provide useful operational visibility when interpreted correctly.
Examples include:
Calls completed
Meetings held
Emails sent
Tasks completed
Follow-up activity
Opportunities with no activity
Average activities before Closed Won
Activity volume alone should not be treated as a performance metric.
The important question is whether activity is contributing to pipeline progression and revenue.
17. Lead Response Time
Lead response time measures how quickly sales follows up with a new inbound lead.
For businesses where prospects are comparing multiple providers, response speed can materially affect conversion.
A useful report should show:
Average response time
Median response time
Percentage responded to within SLA
Response time by representative
Response time by lead source
Automations can also be used to escalate leads that have not received a response within the expected time.
18. CRM Adoption
A CRM cannot provide reliable reporting if the underlying data is incomplete.
CRM adoption metrics can include:
Active users
Opportunities updated recently
Required fields completed
Activities logged
Opportunities without next steps
Records missing critical information
Usage by representative or team
Low adoption should not automatically be treated as an employee problem.
It can also indicate that the CRM is too complicated, poorly configured, or disconnected from how the sales team actually works.
19. Data Quality
Reporting quality depends directly on data quality.
Useful CRM data-quality reports include:
Duplicate records
Missing required fields
Invalid email addresses
Opportunities without close dates
Accounts without industries
Leads without sources
Opportunities without contact roles
Incomplete ownership information
These reports should be reviewed regularly rather than only during large CRM cleanup projects.
20. Stale Opportunities
A stale opportunity is one that remains open without meaningful progression.
Companies should define what “stale” means based on their normal sales cycle.
For example:
An opportunity with no activity for 30 days and no stage movement for 45 days.
A stale-opportunity report helps sales managers focus on pipeline that requires action and prevents unrealistic opportunities from remaining indefinitely in the forecast.
The Goal Is Not More Dashboards
A common mistake is to create dozens of reports because the CRM makes reporting easy.
That usually creates more noise rather than more visibility.
Every report should help someone make a decision.
Before building a dashboard, ask:
What question does this report answer?
Who needs the information?
What action should happen when the metric changes?
Is the underlying data reliable?
How frequently should the report be reviewed?
If there is no clear answer, the report may not be necessary.
Build Reporting Around Decisions
The best CRM reporting architecture usually connects three layers:
Executive reporting provides visibility into revenue, pipeline, forecast, and overall performance.
Management reporting helps sales leaders understand conversion, pipeline quality, team performance, and process bottlenecks.
Operational reporting helps individual representatives identify which leads, opportunities, and tasks require attention.
Together, these reports turn the CRM from a database into a management system.
Start With the Metrics That Matter
You do not need to build every report at once.
A strong starting point for most sales teams is:
Pipeline coverage
Pipeline quality
Win rate
Sales cycle
Stage conversion
Forecast accuracy
Revenue by source
Lead response time
CRM adoption
Data quality
From there, reporting can become more sophisticated as the organization improves its data structure and operating processes.
The objective is not to measure everything.
It is to create enough visibility to understand what is happening, identify problems early, and make better commercial decisions.
At Source Trade, we work with Salesforce and HubSpot environments to design reporting architectures, improve CRM data quality, and build the dashboards and automations required to give sales and leadership teams clearer visibility into performance.