Sales reporting, dashboards & forecasting

CRM dashboard examples. Six that founder-led teams actually use.

A CRM dashboard turns pipeline, activity and forecast data into one live screen instead of a spreadsheet rebuilt every Monday. The six examples below cover what a founder-led team actually needs: pipeline coverage, rep activity, deal velocity, forecast versus quota, account renewals and an executive summary, plus how to use each one and where teams go wrong building them.

Why this matters. The cost of not having one.

Without a dashboard, sales visibility usually means someone exporting the CRM to a spreadsheet on a Friday afternoon, an exercise that eats into time a rep should be spending selling and is out of date again by Monday morning. Salesforce's 2026 State of Sales report puts a number on the underlying problem: reps report spending only 40% of the average workweek on selling itself, with the rest absorbed by admin, internal meetings and the kind of manual reporting a live dashboard removes.

A dashboard's job is not to look impressive in a board deck. It is to answer one question fast: are we going to hit the number, and if not, exactly where is the gap. That only works if the numbers on screen are the CRM's live numbers, not last week's export, and if the dashboard is built for one specific audience rather than trying to be everything to everyone at once.

HubSpot's 2025 State of Sales report, based on a survey of over 1,000 sales professionals, found 68% saying lead quality had improved year on year and 91% reporting stable or improving win rates. Numbers like these are only useful operationally if a team can see its own version of them without waiting for someone to compile a report, which is exactly the gap a well-built dashboard closes.

The list, with how to apply each. Six dashboards worth building.

1. The pipeline coverage dashboard. Are we carrying enough pipeline?

This shows total open pipeline value against quota, broken down by stage, for a rep, a team or the whole business. The number that matters most is the coverage ratio: pipeline value divided by the target it needs to cover. Many teams start by treating roughly three to four times quota as a rough marker of healthy coverage, then adjust that figure once they have a few quarters of their own conversion data to work from, since the right ratio depends heavily on how the business's own funnel actually converts. Use it as an early warning: a rep or team falling below their own historical coverage ratio needs a pipeline-generation conversation well before the quarter ends, not after.

2. The rep activity dashboard. Is effort happening upstream of results?

This tracks calls, emails and meetings booked per rep against a baseline, not to police individuals but to catch an effort problem before it shows up as a pipeline gap six weeks later. Activity dropping off is usually visible two or three weeks before the pipeline consequence is. Use it as a coaching tool with individual reps rather than a leaderboard broadcast to the whole team, which tends to encourage logging activity for its own sake rather than activity that actually moves deals forward.

3. The deal velocity dashboard. Where do deals actually stall?

This tracks average days spent in each pipeline stage and the conversion rate from one stage to the next, which together show exactly where deals are getting stuck rather than just how many are open. A deal-velocity view often surfaces a single stage, commonly proposal-to-close, quietly eating far more time than the rest of the pipeline combined. Use it to target process fixes at the specific stage causing the delay, instead of a general push to "move faster" that does not address where the actual bottleneck sits.

4. The forecast versus quota dashboard. Are we on track, updated live?

This rolls up committed, best-case and total pipeline against the period's target, refreshed automatically rather than manually collated into a spreadsheet once a week. The value is less in the headline number and more in the trend line: a forecast that has been sliding for three weeks running tells a manager something a single snapshot cannot. Use it in weekly pipeline reviews as the starting point for the conversation, not the whole conversation.

5. The renewal and account health dashboard. What is coming up for renewal, and how healthy is it?

For any CRM tracking post-sale relationships, this surfaces upcoming renewal dates alongside simple health signals: usage or engagement level, support ticket volume, or time since last meaningful contact. It exists to stop a renewal being a surprise, which is exactly the failure mode described earlier when contract and renewal data lives outside the CRM rather than inside it. Use it to flag accounts needing proactive outreach a full quarter before renewal, not the week before.

6. The executive summary dashboard. The five-minute version.

This deliberately strips everything back to four or five headline numbers: bookings against target, pipeline coverage, win rate trend and forecast accuracy over recent quarters. It exists for founders and boards who need a fast, honest read on trajectory, not the operational detail a sales manager needs day to day. Use it to keep the board conversation focused on trajectory rather than getting pulled into rep-level detail that belongs in a different dashboard entirely.

For a broader introduction to how these dashboards fit together and what a CRM should be tracking in the first place, see What is a sales dashboard?, and for the distinction that decides which metrics belong on which of the dashboards above, our piece on leading versus lagging indicators is worth reading alongside this one.

Where teams go wrong. Common dashboard mistakes.

The most common mistake is building one dashboard trying to serve reps, managers and the board at once. A screen designed for everyone ends up genuinely useful to nobody, because a rep's daily pipeline view and a board's quarterly trajectory view need different numbers, different time frames and a different level of detail entirely. Build the audience-specific views above instead of one that tries to compress all of them into a single screen.

A second mistake is tracking vanity metrics, activity volume in particular, without pairing them to an outcome metric like conversion or revenue. A rep can log fifty calls a week and still miss quota if none of them are moving the right deals forward; activity data is only useful alongside the result it is supposed to produce.

A third is building a dashboard on top of CRM data nobody has cleaned up: duplicate records, deals sitting in the wrong stage, or activities logged inconsistently from rep to rep. No amount of dashboard design fixes a trust problem that actually lives in the underlying data, and a dashboard nobody trusts gets ignored within a month regardless of how it looks.

A fourth is building the dashboard on a weekly export rather than connecting it live to the CRM. It quietly reintroduces the exact problem the dashboard was meant to solve: a screen that looks current but is already a week stale by the time anyone reads it. If your sales reporting and dashboard work is going to earn the time it takes to build, it needs to be live, audience-specific, and built on data the team already trusts or is actively fixing.

Common questions.

What is the difference between a CRM dashboard and a CRM report?

A report is a static or scheduled pull of data for a specific question, such as last month's closed deals by rep. A dashboard is live: it sits in front of the CRM data and updates as the data changes, so the same screen answers the same question every day without anyone rebuilding it.

How many dashboards does a sales team actually need?

Usually three to four: one for reps to manage their own pipeline day to day, one for managers tracking the team's coverage and forecast, and one summary view for founders or the board. Building more than that tends to fragment attention rather than add insight, and each extra dashboard is another view that can go stale.

Can I build a CRM dashboard without extra software?

Yes. HubSpot, Salesforce, Zoho, Pipedrive and most mainstream CRMs include native dashboard and reporting tools that cover pipeline, activity and forecast views without a separate business intelligence tool. A dedicated tool like Power BI or Tableau is usually only worth the extra cost once you are blending CRM data with finance or product data the CRM does not hold.

How often should a CRM dashboard update?

In real time, or as close to it as the CRM allows, for pipeline and activity dashboards that reps and managers use daily. A dashboard that only refreshes overnight from an export defeats the purpose: the whole point is that anyone can check current status without waiting for someone to run a report.

What metrics should an executive sales dashboard show?

A small number of headline numbers rather than operational detail: bookings against target, pipeline coverage ratio, win rate trend, and forecast accuracy over the last few quarters. The point of an executive view is a five-minute read that answers whether the business is on track, not a full breakdown a manager would need.

Why doesn't anyone on my team trust the CRM dashboard?

Almost always a data quality problem underneath it, duplicate records, deals left in the wrong stage, or activities logged inconsistently between reps. A dashboard built on unreliable input will always be distrusted regardless of how well it is designed, so fixing the underlying CRM hygiene comes before rebuilding the dashboard itself.

Still exporting pipeline to a spreadsheet every Friday? Let's build a dashboard that stays live.

Get in touch and we'll work out which of these six views your team actually needs, then build it directly on your CRM's live data so it never goes stale.

Let's talk