Funnel Chart
Funnel Chart
What Is This Report Type?
A Funnel Chart is a specialized chart that displays sequential stages of a process as progressively narrowing horizontal bands stacked vertically. Each band represents a stage, and its width is proportional to the volume or percentage of items that reached that stage. The tapering shape visually communicates where drop-offs occur as data moves through a process from top to bottom.
Why Is It Used?
Funnel Charts are the definitive tool for conversion and pipeline analysis—any process where items flow through ordered stages and some are lost at each step. They make drop-off rates immediately visible by shape alone: a sudden narrow band signals a critical bottleneck, while a gradual taper indicates consistent attrition.
Key Features and Characteristics
| Feature | Description |
|---|---|
| Sequential Stages | Stages are ordered top-to-bottom, each narrower than the last to reflect volume loss. |
| Proportional Width | Each band’s width encodes the count or percentage at that stage. |
| Drop-off Labels | The percentage lost between stages is displayed as a conversion rate between each band. |
| Color Gradient | Stages can use a color gradient or distinct colors to differentiate funnel levels. |
| Neck / Inverted Option | Can be displayed as a standard funnel or as a pyramid (inverted) depending on context. |
When to Use It (Use Cases)
- Sales Pipeline: Tracking leads → qualified → proposal → negotiation → closed-won.
- E-commerce Conversion: Website visits → product views → add to cart → checkout → purchase.
- Recruitment Pipeline: Applications → screening → interviews → offers → hires.
- Onboarding Flow: Sign-ups → profile complete → first action → retained → churned.
Real-Time Business Example
Scenario: A sales operations manager needs to identify where the most leads are being lost in the sales pipeline across a quarter.
Visualization: A Funnel Chart shows five stages: Leads (10,000), Qualified (4,200, 42%), Proposal Sent (1,800, 43%), Negotiation (900, 50%), and Closed Won (320, 36%). The widest drop-off is at the top—58% of leads fail qualification—indicating the lead source quality is the primary bottleneck. The manager prioritizes improving lead scoring over closing skills.
Common Metrics Displayed
- Lead Counts: Number of prospects at each pipeline stage.
- Conversion Rates: Percentage progressing from each stage to the next.
- Order Volume: Cart additions, checkouts, and completions in e-commerce flows.
- Applicant Counts: Candidates at each recruitment stage.
User Interactions
| Interaction | Behavior |
|---|---|
| Filters | Filter by date range, team, region, or campaign to segment funnel analysis. |
| Hover / Tooltip | Hovering over a stage shows the exact count, percentage of total, and stage-to-stage conversion rate. |
| Click / Drill-Down | Clicking a stage navigates to the detailed record list for that pipeline stage. |
| Export | Export to Excel. |
Creation Steps
- Select Funnel Chart as the report type.
- Stages: Drag an ordered category field representing process stages (e.g., Pipeline Stage).
- Metrics: Drag the count or value field for stage volume (e.g., Lead Count or Deal Value).
- Sort: Ensure stages are sorted in correct sequential order.