Design a pipeline surfacing dashboard: source mix, velocity, conversion, and leak points.
- User
Design a pipeline surfacing dashboard: source mix, velocity, conversion, and leak points.
Assistant
The user wants a design for a "Pipeline Surfacing Dashboard". The dashboard needs to cover four specific metrics/areas:
- Source Mix: Where are the leads/opportunities coming from?
- Velocity: How fast are they moving through the stages?
- Conversion: What are the conversion rates between stages?
- Leak Points: Where are opportunities being lost or stalling?
I need to structure this as a comprehensive dashboard design specification. I should outline the layout, the specific visualizations for each metric, and the underlying data logic.
Target Audience: Sales Managers, RevOps, or Sales Leadership. They need actionable insights, not just pretty charts.
Core Concept: A funnel or "river" metaphor usually works best for pipelines, but for a dashboard with these specific dimensions, a modular layout is better. Let's break down the sections.
1. Layout Strategy:
- Header: Filters (Time period, Team/Rep, Region, Product). Key Aggregate Metrics (Total Pipeline Value, Open Opportunities).
- Top Row (The "Health Check"): High-level trends (Velocity & Conversion).
- Middle Row (The Composition): Source Mix.
- Bottom Row (The Diagnosis): Leak Points (Deep dive).
2. Section-by-Section Design:
-
Section 1: Source Mix (The "Ingredients")
- Goal: Understand quality vs. quantity of inbound sources.
- Visuals: Donut chart is okay, but a horizontal bar chart is better for readability. Better yet, a Scatter Plot (Volume vs. Win Rate) or a Treemap.
- Selection: Let's go with a Horizontal Bar Chart showing Volume, but color-coded by Win Rate. This immediately shows which sources are "junk" (high volume, low win) vs. "gold" (low volume, high win).
- Metrics: # Opps, $ Value, Win %, Avg. Deal Size.
-
Section 2: Velocity (The Speed)
- Goal: Are we speeding up or slowing down?
- Visuals: A line chart showing "Days in Stage" over time.
- Specifics: "Sales Cycle Length" trend (Month over Month).
- Alternative: A Stage Duration Bar (Gantt chart style average) showing how long deals sit in Discovery vs. Negotiation.
- Metric: Average Days to Close.
-
Section 3: Conversion (The Flow)
- Goal: Efficiency of the funnel.
- Visuals: A classic Funnel Chart is the most intuitive here.
- Details: Lead -> MQL -> SQL -> Opportunity -> Closed Won.
- Enhancement: Show the conversion percentage between stages. Highlight the drop-off.
-
Section 4: Leak Points (The Blockages)
- Goal: Where do deals die?
- Visuals: A Sankey Diagram is the "gold standard" for showing flow and leakage, but it's complex to build. A simpler, highly effective alternative is a "Drop-off Waterfall" or a "Stage Exit Analysis".
- Idea: A heatmap or matrix showing "Stage Entered" vs. "Outcome". E.g., Of the deals that entered "Demo", how many moved to "Proposal" vs. "Lost"? Or a "Reason for Loss" breakdown specifically for deals that stalled in specific stages.
- Selection: Let's use a "Loss by Stage" Bar Chart (Where did they exit?) and a "Reason Code" Table.
3. Interactivity/UX:
- Drill-down capability. If I click "Paid Search" in Source Mix, the rest of the dashboard should filter to show Velocity/Conversion specifically for Paid Search leads.
- Comparison toggles (This Quarter vs. Last Quarter).
4. Refining the Design (Self-Correction during thought process):
- Critique: A standard funnel is boring.
- Improvement: Combine Velocity and Conversion. A "Funnel with Velocity" visualization. Each layer of the funnel shows the conversion rate and the average time spent in that layer.
- Critique: "Source Mix" usually just shows volume. We need value.
- Improvement: Use a "Square Pie" (Waffle chart) or a Treemap to show $ Volume contribution.
5. Final Structure Proposal:
- Title: Pipeline Health & Flow Dashboard.
- Filters: Time, Segment, Owner.
- Module 1: Inflow (Source Mix) - Treemap by $ Value, colored by Conversion Rate.
- Module 2: Flow (Velocity & Conversion) - A modified Funnel or Stage Gantt.
- Module 3: Blockage (Leak Points) - Sankey or Drop-off analysis.
- Module 4: Action Items - Top deals stalling, top leads to chase.
Drafting the response: I will organize this into a UX/UI specification format:
- Executive Summary (The "Why")
- Layout Wireframe (The "Where")
- Detailed Component Specs (The "What"):
- Source Mix (Quality vs. Quantity)
- Velocity (Time analysis)
- Conversion (Stage progression)
- Leak Points (Loss analysis)
- Interactivity & Experience
Let's refine the "Leak Points" visual. A Sankey diagram is visually impressive. I will suggest it as the premium option, with a standard "Loss by Stage" bar chart as the practical alternative.
Let's refine "Velocity". A "Cycle Time Bridge" (Waterfall) is cool. It shows Start Time + Discovery Time + Negotiation Time = Total Time. Or just a simple trend line. Let's stick to the "Stage Duration Average" bar chart.
Let's refine "Source Mix". A scatter plot is the most analytically rigorous. X-axis: Volume, Y-axis: Velocity (Speed to close), Bubble Size: Revenue, Color: Win Rate. That might be too complex for a standard "Surfacing" dashboard. Let's stick to a Dual-Axis Bar Chart: Bars = Volume, Line = Win Rate.
Final Polish of the Plan:
- Dashboard Type: Strategic/Analytical.
- Visual Style: Dark mode for data density or clean white for reporting. Let's imply a clean, modern data-viz style (like Looker/Tableau).
Let's write it out. This is a design specification for a Pipeline Surfacing Dashboard. The goal of this dashboard is not just to report historical data, but to "surface" immediate insights that require action.
1. Executive Summary: The "Flow" Concept
To visualize a pipeline effectively, we will use a Fluid Dynamics Metaphor.
- Inflow (Faucet): Source Mix.
- Current (Speed): Velocity.
- Turbine (Efficiency): Conversion.
- Cracks (Loss): Leak Points.
2. Dashboard Layout Wireframe
The dashboard is divided into three horizontal bands. It is designed to be read from Left-to-Right (Input Output) and Top-to-Bottom (Summary Deep Dive).
Header: Global Filters
- Date Range: (e.g., Q3 2023 vs. Q2 2023)
- Segment/Team: (e.g., Enterprise, SMB, Mid-Market)
- Pipeline Type: (e.g., New Business, Renewal, Upsell)
3. Component Breakdown
Module A: Source Mix (The Composition)
Located Top-Left. Replaces the standard "Bar Chart" with a view on Quality vs. Quantity.
- Visualization: Quadrant Scatter Plot (Bubble Chart).
- X-Axis: Volume (Number of Opportunities Created).
- Y-Axis: Win Rate (Quality of Lead).
- Bubble Size: Average Deal Size (ACV).
- Color: Sales Cycle Length (Green = Fast, Red = Slow).
- Why this design: A simple bar chart hides inefficient sources. This visualization immediately highlights "The Sweet Spot" (High Volume, High Win Rate) vs. "The Money Pit" (High Volume, Low Win Rate).
- Surfaced Insight: Bubbles in the top-right are your engine; large bubbles in the bottom-left require immediate strategy revision.
Module B: Velocity (The Speed)
Located Top-Center. Focuses on time efficiency.
- Visualization: Cycle Time Histogram & Box Plot.
- Design:
- Display the distribution of deal durations.
- Benchmark Line: A vertical dashed line indicating the "Target Close Date" vs. "Actual Close Date."
- Stage Velocity Heatmap: A grid showing average days spent in each stage (e.g., Discovery Proposal).
- Surfaced Insight: If the "Proposal" stage is turning red (taking 2x longer than average), the dashboard flags a bottleneck in pricing approval or negotiation.
Module C: Conversion (The Efficiency)
Located Top-Right. Visualizes the tightening of the funnel.
- Visualization: Interactive Funnel Chart (Sankey Diagram style).
- Design:
- Standard funnel steps (Lead MQL SQL Opportunity Closed Won).
- The "Squeeze": Visualize the drop-off percentage between every single stage.
- Surfaced Insight: Hovering over the gap between "SQL" and "Opportunity" reveals the exact number of leads rejected by sales, flagging a potential misalignment between Marketing and Sales definitions.
Module D: Leak Points (The Diagnosis)
Located Bottom (Full Width). This is the most actionable part of the dashboard.
- Visualization: "Leakage Waterfall" or Stage-Exit Analysis.
- Design:
- Instead of just showing "Closed Lost," this chart breaks down where deals go to die.
- Categories: Lost to Competitor, No Response, Budget Cuts, Disqualified, Churned.
- Grouping: Group these losses by the Stage they were in when lost (e.g., losing a deal in "Negotiation" is more painful than losing in "Discovery" due to sunk cost).
- Surfaced Insight:
- Scenario: You see a large red bar for "Lost to Competitor" in the "Demo" stage.
- Action: Review demo script or competitor battle cards immediately.
4. The "Prescriptive" Element (Alerts)
To make this a true "Surfacing" dashboard, static charts are not enough. We need Smart Alerts pinned to the top:
- The "Zombie" Alert: "35 opportunities have been in 'Discovery' for > 30 days. Action Required."
- The "High Risk" Alert: "Deals worth $250k have not had activity in 14 days."
- The "Source Shift" Alert: "Referral volume is down 20% WoW."
5. Design Aesthetics (UI/UX)
- Color Palette:
- Flow: Cool Blues/Teals (representing active, healthy pipeline).
- Warning: Amber/Orange (Stagnation/Slow velocity).
- Leakage: Muted Red (Lost deals/Blockages).
- Density: High. This is a tool for RevOps and Sales Leaders who need to scan 50 data points in 5 seconds.
- Interactivity: Clicking a bar in the "Source Mix" should filter the "Velocity" and "Leak Points" modules to show the performance of that specific source.
Summary View
Metric Visual Type Key Insight Surfaced Source Mix Scatter Plot (Vol vs. Win Rate) Where should we allocate budget? (High Quality vs High Quantity) Velocity Stage Heatmap Where is the deal getting stuck? (Process bottlenecks) Conversion Funnel w/ Gap Analysis Where is the funnel broken? (Qualification issues) Leak Points Stage-Exit Bar Chart Why are we losing? (Pricing vs. Fit vs. Competition)
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.