Sales reporting, dashboards & forecasting

The executive sales dashboard. What actually belongs on it.

An executive sales dashboard is a single screen built for leadership, not reps: revenue against target, weighted forecast against the committed number, pipeline coverage and win rate, refreshed automatically from the CRM and reviewed on a fixed weekly or monthly cadence. It answers one question, are we on track, and points to what needs attention when the answer is no.

The short answer. One screen, four numbers, a fixed cadence.

An executive sales dashboard is not the same tool as the operational dashboard a rep checks between calls. A sales dashboard in the general sense can show pipeline by stage, individual deal ages and rep activity, and that version earns its keep at the front line. An executive version strips almost all of that away and keeps four numbers: revenue booked against target for the period, weighted forecast against the number the business committed to, pipeline coverage ratio, and win rate. Everything else is detail an executive can ask for when a number looks wrong, not detail they need in front of them by default.

The cadence matters as much as the content. Sales leadership reviews the dashboard weekly, since a forecast that starts slipping is far cheaper to fix in week two of a quarter than in week ten. The wider executive team or the board reviews it monthly, usually alongside the same figures presented in the board pack, so there is one version of the truth rather than a dashboard number and a separate slide that quietly disagrees with it.

How it works in practice. Building it around a decision, not a data export.

Start from the decision the dashboard needs to support, not from a list of everything the CRM is capable of showing. A founder or a board member looking at a sales dashboard is usually trying to answer one of three questions: are we going to hit the number this quarter, is the pipeline healthy enough to hit next quarter's number too, and is any one deal or rep a risk large enough to need direct attention. Build the screen around those three questions and the metric list writes itself.

MetricWhat it answersReview cadence
Revenue vs targetAre we on pace for the period, quarter to date and year to dateWeekly
Weighted forecast vs committed numberIs the pipeline, adjusted for probability, still enough to hit what was promisedWeekly
Pipeline coverage ratioIs there enough open pipeline behind the forecast, most B2B teams target 3-4x coverageWeekly
Win rateIs deal quality holding steady, or is the team closing a shrinking share of what it worksMonthly
Average deal size and cycle lengthAre deals getting bigger or slower to close, an early warning for the quarter after nextMonthly

Confidence in the forecast line is the part most businesses get wrong, and it is not a small problem. Gartner's State of Sales Operations research found fewer than half of sales leaders and sellers, 45 per cent, had high confidence in their organisation's forecasting accuracy, and only 7 per cent hit 90 per cent accuracy or higher. A dashboard cannot manufacture confidence the underlying process has not earned, but it can make the gap visible early: showing weighted forecast next to the committed number, rather than just the committed number on its own, forces the conversation about a shortfall to happen in week three instead of week eleven. See our full approach to sales reporting, dashboards and forecasting for how this fits the wider reporting build.

Build the dashboard directly from CRM data wherever possible, rather than a spreadsheet somebody rebuilds each Friday. A manually assembled report is a snapshot of a moment that is already out of date by the time it reaches the meeting, and it introduces a second, human-maintained definition of each number that can quietly drift from what the CRM actually shows. For a broader set of layouts by team size and stage, our piece on CRM dashboard examples is a useful next step once the executive view above is built.

Role-based access is worth setting up from the start, not retrofitting later. A rep should see their own deals and quota progress; a sales manager should see their team's pipeline and coaching opportunities; an executive should see the company-level or region-level rollup with no individual deal names cluttering the view unless they choose to drill in. Most CRMs and BI tools support this through permission sets or shared dashboard views, so the same underlying data serves three audiences without three separate builds to maintain. Skipping this step is how a company ends up with an "executive dashboard" that is really just the sales manager's dashboard with a different tab name, still too detailed for the fifteen minutes a board member actually has for it.

What good looks like. The board trusts the number without asking where it came from.

A working executive dashboard passes a simple test: nobody in the review meeting feels the need to open a separate spreadsheet to check whether the number on screen is real. That trust is built by consistency, the same definition of "pipeline" and "forecast" every week, not a different filter applied depending on who pulled the report that day, and by showing a trend rather than a single snapshot. A revenue figure on its own tells you where you are; the same figure next to the last eight weeks tells you whether you are closing the gap or falling further behind, which is the number a board actually wants to see. This is the same discipline behind separating leading and lagging indicators, a forecast is a leading number, booked revenue is lagging, and a good dashboard makes clear which is which rather than presenting both as equally certain.

Take a 12-person SaaS sales team with a quarterly target of £600,000. Before an executive dashboard existed, the founder pieced together the number from a Friday export and a gut feeling about which deals were "probably fine." After building one around the five metrics above, the same founder can see, inside thirty seconds, that pipeline coverage has fallen to 2.1x against a 3.5x target three weeks before quarter end, long enough to act, either by pushing harder on the deals already in play or by being honest with the board about the risk, rather than finding out in the final week that the number was never really there.

Pitfalls to avoid. Where executive dashboards go stale.

The first pitfall is loading the dashboard with metrics because the CRM makes them easy to show, not because leadership acts on them. A 2024 Gartner survey found that sales analytics tools deliver less influence over actual sales performance than leadership expects them to, largely because teams build dashboards full of numbers that look impressive without connecting any of them to a decision someone is actually accountable for. If a metric would not change what happens in the review meeting, whether it goes up or down, it does not belong on the executive screen; it can live in the operational dashboard instead. Our guide to SaaS KPIs covers the wider metric set worth tracking beyond the executive view.

The second is letting the dashboard drift out of sync with how the business actually defines its numbers. A pipeline stage gets renamed, a new product line is added, or a rep starts logging deals differently, and if nobody owns checking the dashboard's definitions against reality, it keeps reporting a number that technically runs but no longer means what it says. Assign one person to own the dashboard's definitions, not necessarily the most senior person in the room, and have them confirm monthly that "committed" still means committed and "pipeline" still excludes the deals everyone privately knows are dead.

The third is building it once and treating it as finished. A dashboard designed for a five-person team showing early traction needs a different shape once the team is thirty people across two regions; keeping the original four metrics when the business has outgrown them just means leadership is flying on instruments built for a smaller aircraft. Revisit the metric set every two to three quarters, not because the numbers should change often, but because the business the numbers describe usually has.

The fourth is confusing a dashboard with a dashboard tool. Buying a business intelligence licence does not, by itself, produce an executive dashboard; it produces a blank canvas that still needs someone to decide which four numbers matter, agree the definitions behind them, and connect it properly to the CRM. Businesses that skip straight to the tool purchase, expecting the software to supply the judgement, usually end up with a screen full of charts nobody asked for and none of the ones leadership actually needed. Decide the metrics and the cadence first, on paper if necessary, then pick the tool that can show them cleanly, rather than the other way round.

Finally, watch for a dashboard that only ever shows good news. If win rate or coverage never dips, either the business is performing unusually consistently or, more often, the definitions have been quietly loosened somewhere to keep the numbers looking healthy, a deal marked "committed" that should still be "likely," a stage boundary redrawn after the fact. A trustworthy executive dashboard shows red as readily as it shows green, and a leadership team should be more suspicious of a dashboard that never disappoints than one that occasionally does.

Common questions.

What is the difference between an executive sales dashboard and a sales dashboard for reps?

A rep dashboard is operational: it shows individual deals, tasks due today and personal quota progress, and reps check it several times a day. An executive dashboard is strategic: it shows revenue against target, weighted forecast, pipeline coverage and win rate at a company or team level, and leadership checks it weekly or monthly, not hourly. Building one from the other usually fails, since an executive does not want forty open deals, they want four numbers and a trend line.

How often should an executive sales dashboard be reviewed?

Weekly by sales leadership, monthly by the wider executive team or board. A weekly cadence catches a slipping forecast early enough to act on it; reviewing only monthly means a quarter can be half gone before a leadership team notices coverage has fallen away. The dashboard itself should refresh continuously from the CRM, the review meeting is what sets the cadence, not the data.

What KPIs should be on an executive sales dashboard?

Four numbers cover most founder-led businesses well: revenue booked against target for the period, weighted forecast against the committed number, pipeline coverage ratio, and win rate. Average deal size and sales cycle length are useful as a second row once the first four are trusted. Anything beyond six to eight metrics on one screen usually means the dashboard is trying to be a report as well as a dashboard, and it stops getting read properly.

Should an executive dashboard live in the CRM or in a separate BI tool?

Start in the CRM's native reporting. It updates automatically as deals move, so there is one definition of each number and no separate export to keep in sync. Move to a dedicated BI tool such as Power BI or Tableau once you need to blend CRM data with finance or marketing data on the same screen, not before, since that step adds a second system that also needs maintaining.

How do I know if my executive dashboard is actually being used?

Watch what happens in the review meeting. If the dashboard drives the conversation, whoever owns a red number explains why and what they are doing about it, it is working. If someone opens a separate spreadsheet to check the real numbers, or the meeting starts with rebuilding a chart from scratch, the dashboard has already been quietly abandoned and the fix is usually a trust problem with the data, not a design problem with the screen.

Want a dashboard your board actually trusts? Let's build it around your real numbers.

Get in touch and we'll audit what your CRM can already show you, and design the executive reporting layer around the decisions your leadership team needs to make.

Let's talk