The Revenue Operations Dashboard That Answers Board Questions Without the Spreadsheet Hunt

Your CEO asks: "Are we on track to hit plan?"

Your sales leader pulls up a spreadsheet. Current pipeline, by stage, with probability. It takes 15 minutes to assemble. The data is from three different sources. Two of them haven't been updated since Tuesday.

By the time you have an answer, you're already 2–3 days into the week you needed to make a decision.

A RevOps dashboard solves this. Not a vanity dashboard with 47 metrics and pretty colors. A focused dashboard that answers the 5 questions your CEO and board actually care about.

The Five Board Questions Your Dashboard Must Answer

Every board meeting, some version of these five questions comes up:

1. "Will we hit revenue plan this quarter?"
2. "How is our sales team progressing?"
3. "Where are we losing deals and why?"
4. "Are our customers staying or leaving?"
5. "What's our unit economics trend?"

Build your dashboard to answer these five. Nothing else matters.

The Dashboard Architecture

Dashboard 1: Revenue Forecast (answers Q1)

Shows:

• Quarterly revenue target: £2M
• Current quarter pipeline: £2.1M
• Expected close rate (by stage): Discovery 15%, Proposal 35%, Verbal 80%
• Probability-weighted forecast: £1.8M
• Gap to plan: £200K (90% of target)
• Days remaining: 23

Key insight: You're not on track. You need either 20% more in high-probability deals or need to compress your sales cycle to land deals faster.

Update frequency: Weekly (feeds forecast call)

Dashboard 2: Sales Productivity (answers Q2)

Shows:

• Revenue per AE (year-to-date): £[X] per rep, trending [up/down]
• Pipeline per AE: £[X] average, range £50K–£400K
• Deal velocity: average days from Proposal to Verbal. Trending [up/down]
• Win rate: £[X] expected wins from current pipeline. Trending [up/down]
• Ramp progress: new AE achievement vs. expected ramp curve (is new hire on track or behind?)

Key insight: You can see which AEs are behind quota and why (insufficient pipeline, low win rate, slow deal progression).

Update frequency: Weekly

Dashboard 3: Competitive Win-Loss (answers Q3)

Shows:

• Wins this quarter: 12, average deal size £[X]
• Losses this quarter: 8
• Top competitors we're losing to: Competitor X (4 losses), Competitor Y (2 losses)
• Reasons for loss: pricing (2), features (2), incumbent relationship (2), budget (1)
• Competitive win rate: 60% vs. Competitor X, 75% vs. Competitor Y

Key insight: You can see which competitors are taking deals and why, which informs product roadmap and positioning.

Update frequency: Monthly (or quarterly)

Dashboard 4: Customer Health (answers Q4)

Shows:

• Current ARR: £[X]
• MRR churn: [X]%, trending [up/down]
• Churn risk (customers with usage drop >40% last 30 days): [X] customers
• Expansion revenue (quarter-to-date): £[X], trending [up/down]
• NRR: [X]%, trailing 12 months

Key insight: You can see if retention is stable and if expansion is happening.

Update frequency: Monthly

Dashboard 5: Unit Economics (answers Q5)

Shows:

• CAC: £[X] per customer, by channel
• CAC payback period: [X] months
• LTV: £[X]
• LTV/CAC ratio: [X]x
• Gross margin: [X]%
• Magic number (revenue growth ÷ sales/marketing spend): [X]x

Key insight: You can see if your unit economics are improving or deteriorating, and which channels are most efficient.

Update frequency: Monthly

How These Dashboards Fit Together

Think of them as a waterfall:

Dashboard 1 (revenue forecast) tells you if you'll hit plan.

If you won't, Dashboard 2 (sales productivity) tells you why. Insufficient pipeline? Low win rate? Slow deals?

Dashboard 3 (competitive) tells you if you're losing deals to competitors (fixable) or if your pipeline just isn't there (sales/marketing problem).

Dashboard 4 (customer health) tells you if retention issues are impacting your ARR and whether expansion is filling the gap.

Dashboard 5 (unit economics) tells you if your go-to-market is sustainable at your current spending.

The Technical Setup

You don't need a fancy tool. You need:

1. A data source (your CRM—Salesforce, HubSpot, etc.)
2. Data consistency (stage definitions, probability, deal tracking)
3. A dashboard tool (Looker, Tableau, Google Data Studio, even a well-structured Google Sheet)
4. Weekly refresh discipline (someone owns updating the data)

That's it. This isn't heavy lift.

If your CRM data is clean (and if it's not, that's your first RevOps project), you can build these five dashboards in 2–3 days.

Making It Live

Once you build the dashboard:

1. Review it weekly in your forecast call. This becomes your forecast source of truth. Everyone uses the same data.

2. Share it with leadership pre-board. Your CEO shouldn't be surprised by forecast accuracy questions. The board shouldn't either.

3. Use it to guide decisions. "Our win rate is declining. Let's review recent losses to understand why."

4. Iterate monthly. As the business changes, the dashboard needs to evolve. New metric? Add it. Metric that's not useful? Remove it.

The goal is not to have a pretty dashboard. The goal is to have a source of truth that everyone trusts and uses to make decisions.

Next Steps

Pick one dashboard. Start with Dashboard 1 (revenue forecast).

Pull your last quarter of deals. Map them by stage and probability. Calculate your probability-weighted forecast. Compare to actual revenue closed.

You now have the baseline forecast dashboard. Build it in your preferred tool.

Run it for a month. Compare forecast to actuals. Refine.

Once that's solid, add Dashboard 2.

In 90 days, you'll have all five dashboards, and they'll be your source of truth for running the business.