What's up — it's Tuesday.
Last week's Sunday deep-dive teased this one: How to build a dashboard that doesn't just look good in board meetings, but actually steers your pipeline.
Here's the thing about most RevOps dashboards:
They're garbage.
The Problem With Standard Dashboards
The problem isn't that people don't track data. The problem is they track the wrong data.
Most dashboards look like this:
Pipeline by stage (pretty bar chart)
Forecast vs. quota (trending line)
Rep activity (emails sent, calls made)
Win rate by region (pie chart, nobody cares)
And then... what? You look at it, nod, and move on. No insight. No action.
Here's what's actually happening under those charts:
You have $2M in pipeline, but $1.5M is stalled in Negotiation for 40+ days
Your top 3 reps are hitting quota on 12 deals, but your newer reps need 25 deals to hit the same number (different conversion rates, different deal sizes — and you don't know why)
You lost 3 deals last month for the same reason, but nobody captured the data
Real dashboards don't just show you what happened. They show you where to intervene.
The 4-Layer Dashboard Framework
Build your dashboard in four layers. Each layer answers a different question.
Layer 1: Leading Indicators (Top of the Dashboard)
The question: "Is pipeline healthy 60-90 days from now?"
These are the activities that predict revenue.
Track:
Qualified pipeline added (week-over-week)
Target: 3-4x monthly quotaAverage time in each stage
Target: Discovery <5 days, Proposal <7 days, Negotiation <10 daysWin rate by stage
Target: 30-40% from Qualified → Close (higher = might be underqualifying)
Why this matters:
If qualified pipeline added drops 25% this week, you won't hit quota in 90 days. Time to intervene now, not in July when deals don't close.
Red flag: If qualified pipeline is trending down month-over-month and you're hitting quota, you're burning through old deals. You're living on fumes.
Layer 2: Early Warning Signs (Middle of Dashboard)
The question: "What deals are at risk right now?"
Not "could be at risk" — are at risk.
Track:
Deals stalled >30 days without activity
(This is a killer — stalled deals = dead deals)Deals without a champion identified
(Multi-threading failure. If your contact leaves, so does the deal.)Deals with no mutual action plan update in 7+ days
(No momentum = negotiation's stalling out.)Reps below activity benchmarks
(Not enough prospecting = pipeline cliff in 6 weeks)
Why this matters:
These are your intervention points. A deal stalled 30+ days? Pick up the phone TODAY, not next week.
Real example:
One client had 8 deals stalled 30+ days. When they manually checked in (not via email), 4 moved forward in the same week. $400K reopened. Cost: 8 phone calls.
Layer 3: Deal Health Scoring (Bottom Left of Dashboard)
The question: "Which deals are actually closeable this month?"
Don't trust reps' forecasts. Score deals objectively.
Simple scoring system (0-10 points):
Champion identified & engaged: 2 points
Business problem articulated (in their words): 2 points
Budget confirmed: 2 points
No competitors in the picture (or we're winning): 2 points
Active next step with date committed: 2 points
Deals scoring 8-10: Likely to close this month (Commit)
Deals scoring 5-7: Could close, but uncertain (Best Case)
Deals scoring <5: Long shots (Pipeline)
Why this matters:
Your forecast becomes accurate overnight. No more "I feel good about this one" — you have objective data.
Bonus: You can see which reps are overestimating vs. underestimating. That's a coaching moment.
Layer 4: Forecast Health (Bottom Right of Dashboard)
The question: "Will we hit quota?"
This is the "so what" layer — where everything else converges.
Track:
Commit vs. quota (80%+ = on track)
Best case vs. quota (120%+ = upside room)
Trend line (last 7 days — accelerating or stalling?)
Days to close gap (if you're at 75% of quota with 15 days left, you need X more meetings)
Why this matters:
It forces the hard conversation early. If you're at 60% of quota on day 20 of the month, you already know you're missing. Deal with it now, not in the last week.
How to Build It (Without Dying)
Step 1: Pick your tool
Salesforce dashboards (if you're already there)
Tableau / Looker (more powerful, steeper learning curve)
HubSpot dashboards (simpler, good for small teams)
Google Sheets + Zapier (scrappy but works)
Don't overthink this. Start simple.
Step 2: Get clean data first
Before you build anything, do one audit. Pull a sample of 20 deals.
Are stages accurate? (Is this deal really in Proposal?)
Are stages used consistently? (Do all reps define "Qualified" the same way?)
Are dates being updated? (Or is the deal sitting in "Proposal" for 60 days with no update?)
If data quality is bad, your dashboard is useless.
Step 3: Start with Layer 1 only
Build qualified pipeline added, average time in stage, and win rate by stage. Run it for one month. Get the team comfortable with it.
Step 4: Add layers monthly
Month 2: Add Layer 2 (early warning signs)
Month 3: Add Layer 3 (deal health scoring)
Month 4: Add Layer 4 (forecast health)
Don't boil the ocean on day one.
The Action Items
This week:
Audit one rep's pipeline. Are the stages accurate? Is data being updated?
Pick your tool (Salesforce / HubSpot / Google Sheets — doesn't matter for week 1)
Build Layer 1: Qualified pipeline added, time in stage, win rate by stage
Next week:
Review it with your sales leader
Identify one metric that surprised you ("Oh, we're spending 20 days in Proposal? Why?")
Plan your intervention
The Bottom Line
A dashboard isn't useful if you don't use it to change behavior.
Most dashboards are pretty wallpaper. Build yours to intervene.
Leading indicators → Early warnings → Deal scores → Forecast → Action
That's the playbook.
See you Friday for Pipeline Pulse.
— Pipeline Playbook