Skip to main content

Using Deal Funnel Reports to Track Pipeline Performance

Visualize your sales funnel, identify drop-offs, and measure conversion rates across stages using Deal Funnel reports.

Updated this week

The Deal Funnels data source lets you build a report from scratch that gives a visual and numeric breakdown of how deals progress through each stage of a selected sales pipeline. This helps you:

  • Identify bottlenecks
    โ€‹๐Ÿ“Œ Example: If a high number of deals reach the "Proposal" stage but few progress to "Negotiation", you might want to review your proposal quality or client expectations at that stage.
    โ€‹

  • Track performance
    โ€‹๐Ÿ“Œ Example: By comparing funnel conversion rates over different periods or across pipelines, you can track how well your sales team is moving deals forward.

How to Create a Deal Funnel Report

  1. Go to Reports > From Scratch.
    โ€‹

  2. Select Deal Funnels as the data source.
    โ€‹

  3. By default, two filters are automatically applied:

    • Pipeline: Always required for this report to work meaningfully.

    • Date Created: Defaults to โ€œThis yearโ€, but you can change or remove it. Related to the deal creation date.

๐Ÿ“Œ For accurate insights, keep the Pipeline filter active. If removed, the report may display incomplete or misleading data.

Understanding Funnel Stages

Each stage in the report shows how many deals have reached or passed through it. The values are cumulative, meaning they reflect every deal that entered that stage, regardless of where the deal is now.

๐Ÿ“Œ Example: If 5 deals entered the funnel and 3 reached the Prospect stage, the report will show: Lead: 5, Prospect: 3.
โ€‹

Key Metrics Explained

  • Reached stage: Total number of deals that entered or passed through a stage (only counted once per deal).

  • Next step conversion rate: Percentage of deals that moved to the next stage from this one.

  • Cumulative conversion rate: Percentage of deals that reached a stage compared to the total number of deals that entered the pipeline.
    โ€‹Formula: (Deals at stage รท Total deals at initial stage) ร— 100
    โ€‹Example: If 100 deals enter the pipeline and 30 reach the "Proposal" stage, the cumulative conversion rate is 30%.

  • Conversion to lost: Percentage of deals that were lost while in this stage.

  • Budget total: Total budget of all deals that reached the stage (based on current deal values).

  • Projected revenue: Budget ร— probability, for all deals that reached the stage.
    โ€‹

How Won and Lost Deals Are Counted

If a deal is marked as Won, itโ€™s automatically counted as having reached all prior stages, even if it skipped them.
๐Ÿ“Œ Example: A deal that goes directly from Lead โ†’ Won will still show as having reached all stages in between.

If a deal is marked as Lost, it is only counted in the stage where it was lost. This helps reflect where deals tend to drop off.

๐Ÿ“Œ Example: You had 5 deals, and 1 was lost at โ€œWorking on Proposalโ€: Reached: 4, Lost at this stage: 1, Conversion to lost: 25%.

Dealing with Non-Linear Stage Progression

In practice, not all deals move through stages in a neat, linear way.

  • If a deal skips stages (e.g. from Lead directly to Won), it will still be counted as having reached all in-between stages.

  • If a deal moves backward (e.g. from Negotiation back to Proposal), only the first entry into each stage is counted.

๐Ÿ“Œ This means the funnel report shows a simplified version of deal movement. It won't display loops, regressions, or skipped time-in-stage details. For a more detailed view, use the "Deals" data source reports and add the "Previous Stage", "Previous Probability", or "Lost Reason" and "Lost Reason Note" fields and filters.
โ€‹
๐Ÿ‘‰ Find out more in: Tracking Previous Deal Probability and Stage.
โ€‹

Did this answer your question?