Sales cycle & velocity report
The Sales cycle & velocity report answers two questions about the deals you have won: how long do they take, and where do they stall? It measures the days from each won deal’s creation to its close, the days it spent in each stage along the way, and turns your open pipeline, win rate and average deal into a velocity: the revenue your pipeline produces per day.
Go to Reports and click Sales cycle & velocity under Leads & conversion.
The report covers the opportunities your role can view. It opens on This quarter.
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. A won deal counts in the period its Close date falls in: the day it was marked won.
- 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: All pipelines or one pipeline. This filter appears when you have more than one.
- The source: All sources or one source, matched to the deal’s Source.
- The deal type, below the row: All, Recurring or Fixed, matched to the deal’s Deal type. Recurring contracts and fixed projects often have very different cycles, so compare them apart.
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 it keeps the deal type you chose. A figure with no deals behind it is plain text. The averages open the won deals they were computed from; the velocity itself is never a link, since its deals are the inputs shown below it. Click a deal to open it, or Sales cycle & velocity 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 |
|---|---|
| Won deals | How many deals in a won stage closed in the period |
| Average days to close | The mean of each won deal’s days from the day it was created to its close date |
| Median days to close | The middle value of those days: half the won deals closed faster, half slower |
| Velocity per month | The revenue the pipeline produces per day at the period’s rates, times 30; the per-day figure is beneath it |
Days are shown to one decimal. A deal whose close date is earlier than the day it was created, which can happen when deals are imported with their original dates, counts as 0 days rather than a negative number.
The median is the figure to trust when a few deals are unusual. One deal that took a year lifts the average for everyone; it moves the median by one place.
How velocity is calculated
Section titled “How velocity is calculated”Velocity is open deals × win rate × average won deal ÷ average days to close. The line under the tiles shows each input with its value, so you can see what moved:
- Open deals is every deal in an open stage right now, under the same owner, pipeline, source and deal type filters. It has no period: it is the pipeline as it stands today. Click it to see them.
- Win rate is won ÷ (won + lost) by count, over the deals closed in the period, as on the Win/loss report. The lost count beside it opens the lost deals. Under All time a won deal with no close date is left out, since it has no cycle, but a lost deal with none still counts, so the rate stays the one Win/loss shows.
- Average won deal is the won deals’ Value divided by their count.
- Average days to close is the figure in the tile above.
Velocity is blank when any input is missing or zero: no open deals, nothing closed, nothing won, or a cycle of 0 days leave the formula with nothing to say. To raise it, raise any input but the last: more open deals, a better win rate, larger deals, or a shorter cycle.
Days in each stage
Section titled “Days in each stage”One row per open stage the won deals passed through, in pipeline order, with how many of the won deals visited it and the average and median days they spent there. When the deals come from more than one pipeline, each row names its pipeline. Click a count to open the won deals that passed through that stage.
A stage’s time comes from the deal’s recorded stage moves: a visit to a stage starts when the deal is moved into it and ends when it is moved to the next, or at the deal’s close date if that comes first. A deal that went back to an earlier stage and then forward again has both visits added together, so each deal counts once per stage, with all its time there. Won and lost stages are not listed: moving a deal into one ends its last visit, but nobody waits in a closed stage. A deal that was marked lost, reopened and then won shows its time in the open stages only.
The line under the table says how many of the won deals the stage times come from, in three groups:
- Deals with full history: their stage moves were recorded from the day they were created, so every stage they passed through is in the table.
- Deals with history only from a later stage: they existed before Gabriel began recording stage moves, or were brought in by an import or a sync and moved afterwards. The moves they do have are in the table; the stages before their first recorded move are not.
- Deals that closed before stage history was recorded: no move was recorded at all. They are in every other figure, but not in this table. Click the count to see them.
As older deals age out of the period, the full-history count approaches the won total.
How it works
Section titled “How it works”- A deal is won by its stage’s Outcome (Won), set under Settings > Pipeline & Sales Stages. The stage name doesn’t matter. Open and lost deals are never in the cycle or stage figures.
- A deal is dated by its Close date, which Gabriel sets to the day the deal is marked won. The Win/loss report and the MSP revenue report date won deals the same way, so the three agree on what was won in a period. A won deal with no close date has no cycle to measure, so it is left out under every period, All time included.
- Cycle length runs from the deal’s Created date to its close date. A deal converted from a lead starts when the deal was created, not when the lead was.
- 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.
- Amounts are shown rounded, such as $18.9K; days to one decimal; the win rate to the nearest whole percent.
Best practices
Section titled “Best practices”- Read the median beside the average. When they are far apart, a few unusual deals are pulling the average; open the won deals and sort by close date to find them.
- Find the slow stage. The stage with the most days is where deals wait. Ask whether it is waiting on you (a proposal, a quote) or on the customer (a signature, a budget cycle), and set In stage for on the Stale and at-risk deals report a little above that stage’s median, so the deals that overstay it surface.
- Compare recurring and fixed apart. A managed-services contract and a one-off project rarely have the same cycle. Set the deal type to each in turn before comparing periods.
- Treat velocity as a trend, not a forecast. It multiplies four averages, so it swings when any one does. Bookmark the report on Last quarter and watch the direction month over month rather than the number on any one day.
- Keep stage moves in Gabriel. Stage times only exist for deals whose moves were recorded here. Moving deals through the board, rather than importing them already closed, is what fills in the table.
Troubleshooting
Section titled “Troubleshooting”The report says no deals were won in this period. Nothing closed in a won stage in the period with these filters. Set the period to All time, the deal type to All and clear the other filters. If it then says no deals have been won yet, no deal you can see is in a won stage with a close date.
Velocity is blank. One of its inputs is missing or zero; the line under the tiles shows which. No open deals, nothing closed, nothing won or an average cycle of 0 days each leave nothing to compute.
Average days to close is 0, or far lower than it should be. The won deals’ close dates are earlier than their created dates, which an import can do. Each such deal counts as 0 days. Open the won deals and check the dates.
The stage table is empty, or covers only a few deals. Stage times come from recorded stage moves, and deals closed before Gabriel recorded them, or moved by an import or a sync, have none. The line under the table says how many; click it to see them.
A stage is missing from the table. No won deal in the period passed through it. Only stages with a visit are listed.
