Pipeline Visibility

Pipeline Visibility for B2B Revenue Operations

Pipeline visibility is the ability to see what's in your pipeline, trust that it's accurate, and act on it before it's too late. Most revenue teams have dashboards. Few have visibility.

The difference: dashboards show numbers; visibility drives decisions.

---

The Visibility Stack

Pipeline visibility has four layers. Most teams only build the first two and wonder why their forecast is wrong.

Layer 1: Pipeline Structure (Foundation)

What stages exist, what they mean, and what data is required at each.

Stage design principles:

1. Each stage has a verifiable exit criterion (not "rep feels good about it")
2. Stages represent buyer actions, not seller activities
3. 5-8 stages maximum (more creates friction and reduces compliance)
4. Probability increases monotonically (if it doesn't, stages are wrong)

Recommended B2B SaaS stages:

| Stage | Probability | What It Means | |-------|------------|---------------| > Common SaaS defaults. Replace with your historical stage-to-close conversion rates within 90 days of implementation.

| Discovery | 10% | Initial meeting done; pain confirmed | | Qualification | 20% | Budget, timeline, decision process, champion identified | | Solution Design | 40% | Requirements documented; demo/POC delivered | | Proposal | 60% | Proposal delivered; pricing discussed | | Negotiation | 75% | Verbal yes; contract in legal | | Closed Won | 100% | Signed | | Closed Lost | 0% | Documented loss reason |

Layer 2: Pipeline Reporting (What most teams stop at)

Reports and dashboards that show pipeline state.

Layer 3: Pipeline Hygiene (Where accuracy comes from)

Automated systems that keep pipeline data clean, current, and trustworthy.

Layer 4: Pipeline Intelligence (Where decisions come from)

Alerts, signals, and analysis that surface what needs attention NOW — before humans notice it.

---

Dashboard Architecture

Design Principles

1. One dashboard per audience — executives, managers, and reps need different views
2. Leading indicators first — pipeline created and activities before closed revenue
3. Exceptions over summaries — surface what's wrong, not what's fine
4. Minimal click depth — the answer should be visible without drilling down
5. Consistent time frames — pick a standard (rolling 90 days, current quarter, etc.)

Executive Dashboard

Audience: CRO, VP Sales, CEO Cadence: Weekly review Purpose: "Are we going to hit the number?"

| Widget | Metric | Format | |--------|--------|--------| | 1 | Pipeline by Forecast Category (current period) | Stacked bar | | 2 | Pipeline Coverage Ratio (open pipeline ÷ remaining target) | Single number with RAG status | | 3 | Win Rate Trend (rolling 3 months) | Line chart | | 4 | Average Deal Size Trend | Line chart | | 5 | Forecast vs Actual (current + prior 2 periods) | Bar chart comparison | | 6 | Top 10 Deals (value, stage, next step, days in stage) | Table |

RAG thresholds for Pipeline Coverage:

• Green: ≥3.5x
• Amber: 2.5-3.4x
• Red: Based on Clari's vetted pipeline benchmark of 3.2× (2024-2025) and the 3-5× industry range. Note: Ebsta's 2025 GTM Benchmarks (655K opportunities) suggest effective coverage may need to be as high as 5.3× given declining win rates. Calibrate to your historical win rate: required coverage = quota ÷ win rate.

Sales Manager Dashboard

Audience: Front-line sales managers Cadence: Daily Purpose: "Which deals need my attention today?"

| Widget | Metric | Format | |--------|--------|--------| | 1 | Team Pipeline by Rep and Stage | Matrix/heatmap | | 2 | Deals Advancing vs Stalling This Week | Comparison bar | | 3 | Activities per Rep (calls, meetings, emails) | Bar chart | | 4 | Stale Deals (no activity > threshold) | Table with days-stale column | | 5 | Speed-to-Lead SLA Compliance | Gauge/percentage | | 6 | Forecast Accuracy by Rep (historical) | Table with trend arrows | | 7 | Pipeline Created This Week/Month vs Target | Progress bar |

Individual Rep Dashboard

Audience: AEs, SDRs Cadence: Daily Purpose: "What should I work on right now?"

| Widget | Metric | Format | |--------|--------|--------| | 1 | My Pipeline by Stage | Funnel or bar | | 2 | Deals Closing This Month/Quarter | Table sorted by close date | | 3 | My Activities This Week vs Target | Progress bar | | 4 | My Overdue Tasks | Task list | | 5 | My Quota Attainment (actual + forecasted) | Gauge |

RevOps Operational Dashboard

Audience: RevOps team Cadence: Weekly Purpose: "Is the system healthy?"

| Widget | Metric | Format | |--------|--------|--------| | 1 | Data Quality Score (avg pipeline quality across open deals) | Number + trend | | 2 | Stage Conversion Rates (funnel) | Funnel chart | | 3 | Pipeline Velocity (days per stage, avg) | Table | | 4 | Loss Reason Distribution | Pie/bar chart | | 5 | Pipeline Created vs Target | Progress bar | | 6 | Enrichment Coverage (% records with key fields) | Bar chart |

---

Pipeline Hygiene Automation

The Hygiene Problem

Pipeline rots silently. Deals go stale, close dates pass without update, amounts stay at placeholder values. Without automated hygiene, your "€5M pipeline" might be worth €2M in reality.

Stale Deal Detection

Definition: An opportunity with no logged activity for a configurable threshold.

Recommended thresholds by stage:

| Stage | Stale After | Action | |-------|------------|--------| | Discovery | 7 days | Alert rep | | Qualification | 10 days | Alert rep + manager | | Solution Design | 14 days | Alert rep + manager | | Proposal | 7 days | Alert manager (high urgency) | | Negotiation | 5 days | Alert manager + VP |

Automation:

• Daily scheduled job queries open deals past threshold
• Marks deal with stale flag for dashboard visibility
• Sends notification to owner + manager
• Creates task: "Review stale deal — no activity in X days"
• If still stale after 2x threshold: escalate to VP + RevOps

Overdue Close Date Handling

Deals with close dates in the past are the single biggest source of forecast error.

Automation:

• Daily job: Query open deals where Close Date Operational template — adapt scoring weights and thresholds to your GTM process. Gong and Ebsta use proprietary weighting that changes dynamically per deal; these dimensions represent their published signal categories, not their exact algorithms.

Usage:

• Dashboard: Average Pipeline Quality Score by team/rep
• Track trend over time, not just absolute score
• Deals declining on 2+ dimensions simultaneously: flag for immediate deal review

Big Deal Alerts

Automatically surface high-value deals that need executive attention:

Trigger conditions:

• Deal value exceeds configurable threshold (e.g., >€50K for mid-market; >€200K for enterprise)
• Deal advances to Qualification or beyond
• Deal value increases by >25%
• Deal close date moves into current quarter

n> Template thresholds — configure based on your ACV distribution and deal-size tiers.

Alert content: Deal name, value, stage, owner, next step, days in stage, close date Recipients: VP Sales, CRO, RevOps lead Channel: Slack + email (redundancy for critical signals)

---

Pipeline Intelligence

Signals That Predict Outcomes

Move beyond descriptive reporting to predictive signals:

| Signal | What It Indicates | Action | |--------|-------------------|--------| | No activity in >7 days at Proposal+ stage | Deal at risk | Manager intervention; check with champion | | Close date pushed 3+ times | Timeline not real | Honest conversation about buyer readiness | | Single-threaded (1 contact) | Fragile deal | Multi-threading campaign | | Amount decreased | Scope shrink or competitive pressure | Win strategy review | | New competitor mentioned in notes | Competitive threat | Competitive positioning resources | | Stage regression | Qualification lost | Re-qualify or close | | Champion went dark | Organisational change or lost interest | Executive sponsor outreach | | Activity spike from buyer | Evaluation intensifying | Accelerate; ensure access to resources |

Pipeline Movement Analysis

Track weekly changes to pipeline to understand momentum:

| Movement Type | Definition | What to Watch | |--------------|-----------|---------------| | Created | New pipeline added this week | Pace vs target | | Advanced | Deals that moved to a later stage | Velocity signal | | Stalled | Deals that didn't advance and had no activity | Hygiene issue | | Pushed | Close date moved to a later period | Forecast risk | | Pulled In | Close date moved to an earlier period | Potential upside (verify it's real) | | Lost | Moved to Closed Lost | Loss reason analysis | | Won | Moved to Closed Won | Celebrate; capture learnings |

Weekly pipeline waterfall:

Starting Pipeline: €4.2M
  + Created:  +€800K
  + Advanced: €1.1M moved forward
  - Pushed:   -€300K pushed to next quarter
  - Lost:     -€450K closed lost
  - Won:      -€600K closed won
= Ending Pipeline: €4.45M

This waterfall, reviewed weekly, is the single most powerful pipeline visibility tool.

---

Forecast Accuracy Reporting

Tracking Setup

Capture forecast snapshots at regular intervals:

| Field | Purpose | |-------|---------| | Period | Quarter/Month being forecast | | Snapshot Date | When this forecast was captured | | Rep | Individual forecaster | | Commit Value | Amount in Commit category | | Best Case Value | Amount in Best Case | | Pipeline Value | Amount in Pipeline | | Actual Closed | Populated after period ends | | Accuracy | Formula: 1 - ABS(Actual - Commit) / Target |

Cadence: Snapshot weekly (or at each forecast call). Enables trend analysis: "How does our forecast accuracy change as we get closer to period end?"

Accuracy Patterns to Spot

| Pattern | What It Means | Fix | |---------|--------------|-----| | Consistently over-forecasts | Reps/managers optimistic; Commit criteria too loose | Tighten Commit definition; require independent verification | | Consistently under-forecasts | Sandbagging; conservative culture | Review incentive structure; celebrate accurate forecasting | | Accurate early, wrong late | Late-quarter deals spike or collapse | Better pipeline coverage earlier; less reliance on last-week heroics | | Individual rep outlier | One rep consistently off | Coaching opportunity; investigate deal progression habits |

---

Essential Reports Checklist

The minimum reporting set every B2B revenue team needs:

| Report | Grouping | Filters | Purpose | |--------|----------|---------|---------| | Pipeline by Stage | Summary by Stage | Open, current FY | Pipeline health | | Pipeline by Close Date | Summary by Month | Open, next 2 quarters | Timing distribution | | Win Rate | Won ÷ (Won + Lost) | Closed this quarter | Conversion performance | | Sales Cycle | Avg days from creation to close | Closed Won, current quarter | Velocity | | Conversion Funnel | Count by stage | Created in cohort period | Drop-off analysis | | Stale Deals | Tabular | Open, no activity > threshold | Hygiene | | Loss Analysis | Summary by Reason | Closed Lost, last 90 days | Pattern detection | | Pipeline Coverage | Formula | Open ÷ remaining target | Forecast risk | | Rep Scorecard | Matrix (Rep × metrics) | Current quarter | Individual performance | | Pipeline Created | Summary by week | Created date | Leading indicator |

---

Cross-References

• For CRM-specific dashboard implementation → see revops-hubspot or revops-salesforce
• For forecast methodology and categories → see revops-forecasting
• For pipeline metrics and benchmarks → see revops-metrics
• For meeting architecture to review pipeline → see revenue-operating-cadence
• For enrichment that feeds pipeline data quality → see data-enrichment

---

References

• Pipeline coverage: Clari, "Sales Pipeline Coverage Ratio" (2024-2025). 3.2× for vetted opportunities. Industry range: 3-5×.
• Deal slippage: Ebsta 2025 GTM Benchmarks. 36% slippage rate (down from 44% in 2024). 655K opportunities, $43B pipeline analysed.
• Forecast accuracy tiers: Fullcast, "Forecast Accuracy Benchmarks" (2024-2025). 80-85% acceptable; 85-95% good; 95%+ world-class.
• Forecast variance: InsightSquared, "2021 State of Sales Forecasting." Only 9% of organisations achieve ≤5% forecast variance.
• Close date push impact: Gong (2024-2025). Win rate drops ~50% when deal pushed from 1 week to 1 month.
• Deal health scoring approach: Gong Deal Likelihood Score (300+ signals, dynamic weighting); Ebsta Deal Score (1-99, 7 published attributes across 655K+ opportunities).
• Ebsta 2025 GTM Benchmarks: Early decision-maker involvement: +55% win rates. Delayed deals: -113% win rates. Top performers close 11× faster. A-players manage 164% more pipeline.
• Pipeline health management: Salesforce research: teams actively managing pipeline health metrics achieve 18% higher win rates and 28% more accurate forecasts.

> Built by Neon Triforce

---

What good looks like

Great output builds the full four-layer visibility stack, not just dashboards: stages with verifiable buyer-action exit criteria, one dashboard per audience (exec, manager, rep, RevOps) with exceptions surfaced over summaries, automated hygiene (stale-deal detection by stage, overdue close-date handling, a quality score tracked as a trend), and a weekly pipeline waterfall that shows created/advanced/pushed/lost/won movement. Every threshold (coverage RAG, staleness days, big-deal alerts) is calibrated to the team's own historical conversion data rather than copied defaults.

Mediocre output stops at Layer 2: a pile of summary reports and a single all-purpose dashboard, probabilities left at vendor defaults, no automated hygiene so the pipeline rots silently, and forecast accuracy never snapshotted so nobody can say whether the number improves as the quarter closes. It shows what the pipeline is but never surfaces which deals need attention now.

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: swan-gtm
• Source: swan-gtm/gtm-skills
• License: MIT

Install and usage instructions live in the source repository linked above.