A CRM sales dashboard is a small set of measures drawn from leads, opportunities, and activities. The picture is useful when every number has a definition, a time window, and a person who acts on it. A dashboard full of undefined totals is decoration.
This page defines common sales KPIs. It does not set targets for your company. A target without a definition is an argument.
Measures worth agreeing
Lead conversion rate. Qualified leads that became an account or an opportunity, divided by leads created in the period. Exclude junk you never intended to work, but write down what “junk” means. If assignment is slow, conversion will look low for reasons that belong in lead assignment, not in salesperson skill.
Opportunity win rate. Won opportunities divided by won plus lost in the period. Use count and value separately. Winning many tiny deals and losing one large tender tells two stories. Open deals are not in the denominator. A team that never marks Lost will show a fantasy win rate.
Average sales cycle. The average days from opportunity created, or from a defined start stage, to Won. State the start. Measuring from first website visit is a different metric and usually needs data the CRM does not have.
Pipeline value. The sum of open opportunity amounts, optionally weighted. Unweighted and weighted figures must be labelled. Forecasting detail sits in how CRM sales forecasting works.
Follow-up performance. Open tasks overdue, or leads with no activity after the response deadline. This measures behaviour. It is not revenue. It explains revenue problems earlier.
Make the definition visible
Put the formula in the dashboard subtitle or a linked note:
- Time zone and whether “this month” is created date or close date
- Whether lost reasons of “duplicate” are excluded
- Currency, if you quote in more than one
- Which pipeline, if you have more than one
A chart that changes meaning when someone filters a branch is fine. A chart that changes meaning because two people built it differently is not.
From raw CRM rows to a KPI
- Pick the question a manager will ask weekly
- Write the numerator, denominator, and date field
- Exclude duplicates and test data
- Show the number next to the list of records behind it
- Review the definition when the process changes
What usually misleads
- Counting leads and opportunities together as “deals”
- A win rate that ignores losses
- Pipeline value with no close-date filter, so next year’s tender sits in this month
- Averages pulled by one outlier, with no median or top-deal list
- Activity counts that reward logging junk tasks
If a salesperson can move a number without a real customer event, the metric will be gamed. Stage evidence, described in pipeline stages, is what keeps win rate and cycle time honest.
A practical example
Each Monday a branch manager looks at four figures for the last 30 days: new leads, percent with a first activity inside one business day, open pipeline closing this month (weighted), and win rate by value. The win-rate tile opens the list of won and lost records. A deal marked won without a quotation number is sent back. The meeting does not add a fifth chart until these four are trusted.
Key takeaways
- Define numerator, denominator, and date before you design the chart.
- Keep win rate, pipeline, and follow-up as separate questions.
- Let people open the records behind the number.
- Change the definition openly when the sales process changes.
FAQ
How many KPIs should be on the first dashboard?
Four or five that someone reviews every week. Extra charts can live on a second page for analysis.
Should marketing and sales share one conversion rate?
Only if they share the definition. Marketing often measures enquiry to qualified lead. Sales measures qualified lead to won. Label both.
Are dashboard targets stored in the CRM?
They can be, as a quota field. The target is still a management input. The CRM does not know the “right” win rate for your market.