Dashboards should drive decisions
A sales dashboard is only useful if it helps you make better decisions. Too many dashboards are packed with metrics that look impressive but do not inform action. Focus on the numbers that tell you what to do next.
The essential metrics
Revenue (actual vs target)
Your most important number. Display current month revenue against your target. Show the trend over the last 6 to 12 months to reveal whether you are growing, flat, or declining.
Pipeline value (weighted)
The total value of all active deals, weighted by their probability of closing based on pipeline stage. This is your forward looking revenue indicator. If weighted pipeline drops two months in a row, you have a future revenue problem regardless of current performance.
Conversion rate by stage
Show the percentage of deals that progress from each stage to the next. This reveals bottlenecks. If your lead to discovery conversion is 50% but your proposal to close conversion is only 15%, focus your improvement efforts on the proposal stage.
Average deal size
Track this monthly. A declining average deal size might indicate discounting pressure or a shift in customer mix. A rising average suggests you are moving upmarket.
Sales cycle length
Average days from first contact to close. This helps with forecasting and identifies agents or deal types that are taking longer than expected.
Agent performance summary
A simple table showing each agent's revenue, deals closed, pipeline value, and conversion rate. Rank by revenue to quickly identify top and bottom performers.
What to leave off
Resist the urge to add every available metric. Vanity metrics like total leads generated, emails sent, or website visits do not help you manage sales. They might indicate marketing health, but they do not tell you whether deals will close.
Design principles
One page. If your dashboard requires scrolling, it has too much on it.
Real time or daily updates. Weekly or monthly dashboards are too stale to drive daily decisions.
Colour coding. Use red, yellow, and green indicators to highlight metrics that need attention versus those that are on track.
Comparison. Show current numbers against targets and previous periods. Absolute numbers without context are hard to interpret.
Building the dashboard
If you are using Zepys, the platform provides built in dashboards for pipeline and commission tracking. For more customised views, tools like Google Data Studio (free), Tableau, or even a well structured Google Sheet can work.
The tool matters less than the discipline of reviewing it daily and acting on what it tells you.
The bottom line
A good sales dashboard shows you six to eight metrics that directly inform decisions. Keep it simple, keep it current, and review it daily. The businesses that manage by data consistently outperform those that manage by gut feel.