Stage conversion report
The Stage conversion report answers one question: where in the pipeline do deals drop out? It takes the deals created in a period and shows how many reached each stage and how many were won, so the step that loses the most deals stands out. A second table turns the question around: of the deals that entered each stage in the period, where are they now?
Go to Reports and click Stage conversion under Leads & conversion.
The report covers the opportunities your role can view. It opens on This quarter.
One pipeline at a time
Section titled “One pipeline at a time”Stages belong to a pipeline, so the report reads one pipeline at a time. It opens on your default pipeline, the one the Stage conversion tile on the Manager board uses, and names it under the filters. If you have more than one pipeline, pick another with the pipeline filter; its first choice reads Default pipeline here, not All pipelines, because there is no cross-pipeline view. If you have no active pipeline, or the one you picked has no active open stages, the report says so; set one up under Settings > Pipeline & Sales Stages.
Filter the report
Section titled “Filter the report”Use the row of filters above the numbers:
- The period: a preset such as This quarter or Last month, All time, or Custom range with a from and a to date. The funnel counts deals by the day they were created; the outcomes table by the day they entered a stage.
- The deal owner: Everyone (or My team), or one person. This filter appears when your role reaches your team’s or everyone’s opportunities.
- The pipeline: the pipeline the report reads. This filter appears when you have more than one.
- The source: All sources or one source, matched to the deal’s Source.
The dates the period covers are shown at the right of the filters. Your filters are kept in the page address, so a bookmark opens the same view.
See the deals behind a number
Section titled “See the deals behind a number”Click a count to open the deals it counts, with Company, Owner, Stage, MRR, One-time fees, Total value and Close date. The list’s total matches the figure you clicked, and the chips at the top say what it is, such as Reached Proposal or Entered Proposal and Still there. A Lost count opens a list that also shows each deal’s loss reason and note. A figure with no deals behind it is plain text, and a percentage is never a link; click the count beside it. Click a deal to open it, or Stage conversion in the trail at the top to go back to the report.
What each number means
Section titled “What each number means”| Figure | What it is |
|---|---|
| Deals created | How many deals were created in the period that are in this pipeline now |
| Reached won | How many of them are in a won stage now, and what share of the deals created that is |
| Biggest drop-off | The step of the funnel with the lowest conversion, and its rate |
| No stage history | How many of the deals created have no recorded stage moves (see below) |
Percentages are shown to one decimal. A percentage with nothing to divide by, such as the step after a stage no deal reached, shows a dash.
Funnel
Section titled “Funnel”One row per open stage of the pipeline, in order, then Closed-won. Each row shows how many of the deals created reached that stage, the share of the step before it that got there (Step %), and a bar for the share of all the deals created. It uses the same definition as the Stage conversion tile on the Manager board, over the period you chose rather than the tile’s last 90 days, so for the same deals the two count the same way. The tile’s window ends at the moment you open it, while a period here is whole days, so a custom range matching the tile’s dates can differ from it by the deals created today.
A deal reached a stage when it is in that stage now, was moved through it at any point, or got further along the pipeline. A won deal reached every stage, whichever stages it was actually moved through. A lost deal reached only as far as its stage moves show. A deal that skipped a stage still counts as having reached it, since it got past it; a deal that was moved back counts for the furthest stage it ever reached.
Step % is the row’s count divided by the row above. Biggest drop-off is the step with the lowest Step %; it is the first place to look.
Stage outcomes
Section titled “Stage outcomes”One row per open stage, for the deals that entered the stage in the period, whenever they were created. A deal that entered a stage twice counts once. The columns say where those deals are now:
- Further along: in a later open stage of this pipeline.
- Won and Lost: in a won or lost stage.
- Back: in an earlier open stage of this pipeline.
- Still there: still in the stage.
- Elsewhere: in no stage, or in a stage that is not one of this pipeline’s active open stages (a deal moved to another pipeline, or parked in a stage since deactivated). The column appears only when a deal is there.
The columns add up to Entered. Advance % is the share that moved further along or were won. A stage with a high Still there count is where deals wait; a high Back count is a stage deals are moved into too early.
Deals with no stage history
Section titled “Deals with no stage history”Stage moves are recorded from when a deal is created in Gabriel and each time it is moved. Deals that existed before Gabriel began recording them, or that were brought in by an import or a sync with their stage already set, have no moves on record. In the funnel such a deal counts as having reached only the stage it is in now (or every stage, if it is won); in the outcomes table it is in no row, since it never entered a stage on record. The No stage history tile and the line under the funnel say how many of the deals created are affected; click the count to see them. As those deals age out of the period, the funnel fills in.
How it works
Section titled “How it works”- A deal counts as won or lost by its stage’s Outcome (Won, Lost or Open), set under Settings > Pipeline & Sales Stages. The stage name doesn’t matter. Only active Open stages are rows.
- The funnel counts deals by their Created date and by the pipeline of the stage they are in now. A deal created in this pipeline and moved to another is in the other pipeline’s funnel.
- The outcomes table counts deals by the day they were moved into the stage, whichever pipeline they were created in or are in now.
- A period is whole days in your own time zone, or your company’s if you haven’t set one. This month, This quarter and This year run to the end of the period.
Best practices
Section titled “Best practices”- Start at the biggest drop-off. It is the step where the most deals are lost relative to the ones that got there. Open the deals that reached the stage before it and read why they went no further.
- Read Still there beside Step %. A low step rate with many deals still in the earlier stage is a queue, not a loss: those deals may yet move. A low rate with many lost deals is a real drop-off.
- Compare periods, not days. The funnel for this quarter is unfinished until the quarter’s deals have had time to move. Bookmark the report on Last quarter for a settled view, and watch the direction.
- Keep stage moves in Gabriel. The funnel and the outcomes only know about moves made here. Moving deals through the board, rather than importing them with their stage set, is what fills the report in.
Troubleshooting
Section titled “Troubleshooting”The report says no pipeline to report on. You have no active pipeline, or the address names a pipeline that no longer exists. Pick one with the pipeline filter, or set one up under Settings > Pipeline & Sales Stages.
The numbers differ from the Stage conversion tile on the Manager board. The tile reads the last 90 days up to the moment you open it, in your default pipeline, and counts the same way this report does. A different period, a different pipeline, or an owner or source filter here all change which deals are counted; the deals created today are in the tile’s window but not in a custom range that ends yesterday.
Reached is higher for a later stage than the deals that passed through it. Won deals count as having reached every stage, and a deal that skipped a stage counts as having reached it. Reached means “got this far”, not “was in”.
The outcomes table lists a stage with deals the funnel doesn’t. The two count different deals: the funnel counts deals created in the period, the outcomes table deals that entered a stage in the period, whenever they were created.
A stage is missing. Only active open stages are rows. A deactivated stage, or one with the Won or Lost outcome, is not a row; deals in a deactivated stage show under Elsewhere.
