Win/loss report
The Win/loss report answers two questions about the deals you have closed: how often do we win, and why do we lose? It counts the deals won and lost in the period, shows the win rate between them by month, by owner and by source, and lists the lost deals by loss reason, with the note a rep wrote when they marked each deal lost one click away.
Go to Reports and click Win/loss 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 deal counts in the period its Close date falls in: the day it was marked won or lost.
- The deal owner: Everyone (or My team), or one person. This filter appears when your role reaches your team’s or everyone’s opportunities. People who have left are listed last, marked (inactive).
- 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 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 any count or amount to open the deals it counts, with Company, Owner, Stage, MRR, One-time fees, Total value and Close date. A list of lost deals also shows each deal’s Loss reason and Loss note, so you can read why each one was lost without opening it. The list’s total matches the figure you clicked. A figure with no deals behind it is plain text, and a win rate is never a link: its deals are the row’s won and lost counts. Click a deal to open it, or Win/loss 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 | How many deals in a won stage closed in the period, and their Value added up |
| Lost | How many deals in a lost stage closed in the period, and their Value added up |
| Win rate | Won deals divided by all closed deals (won plus lost), by count. Blank when nothing closed |
| Avg won deal | Won value divided by won deals. Blank when nothing was won |
The win rate is by count, not by value: three small wins and one large loss is a 75% win rate. Read it beside the values to see whether you win the deals that matter.
By month
Section titled “By month”One row per month, by the month each deal closed, with the months that have no closed deals kept so a quiet month is visible.
- Under a period, the rows are the period’s calendar months. A period longer than 13 months shows its latest 13, with one row Before the first of them holding the earlier part of the period, so the column still adds up to the totals. Choose a shorter period to see those months apart.
- Under All time, the rows are this month and the twelve before it, with a row Before them for deals closed earlier and a row After them for deals whose close date is later than this month. A close date can be edited, and an import can bring one in the future, so After is where to look when the months add up to less than the totals.
By owner
Section titled “By owner”One row per owner who closed a deal in the period, most closed deals first. Deals with no owner are last, as Unassigned. Compare win rates across the team here, and open a rep’s lost deals to read their notes.
By source
Section titled “By source”One row per source that a closed deal names, most closed deals first. Deals with no source are last, as No source. A source that wins often is worth more leads; one that loses often may be bringing in the wrong prospects.
Lost by reason
Section titled “Lost by reason”One row per loss reason, in the order they appear under Settings > Picklists, with the lost deals that name each and their value. Every active reason is listed, so a reason nobody picked shows a zero. A reason that has been retired still appears, marked (retired), while lost deals in the period name it. Deals lost with no reason are last, as No reason.
Loss reasons come from Settings > Picklists > Opportunities, and a person marking a deal lost must choose one; see Opportunities. A deal moved to a lost stage by an automation or an import has no reason, and shows under No reason.
Closed deals with no close date
Section titled “Closed deals with no close date”A closed deal with no close date falls in no period and no month. Under every period a line below the tables says how many won and lost deals have none; click the count to open them and set their dates. Under All time they are in the totals and in the owner, source and reason tables, but still in no month row.
How it works
Section titled “How it works”- A deal is won or lost by its stage’s Outcome (Won or Lost), set under Settings > Pipeline & Sales Stages. The stage name doesn’t matter. Open deals are never counted.
- A deal is dated by its Close date, which Gabriel sets to the day the deal is marked won or lost. The MSP revenue report dates won deals the same way, so the two agree on what was won in a period.
- 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 $12.5K; win rates to the nearest whole percent.
Best practices
Section titled “Best practices”- Read the loss notes, not just the reasons. The reason table tells you what kind of loss you have; the notes behind it tell you what to change. Open Lost on the report each month and read the notes in one sitting.
- Keep the loss reasons list short and distinct. A list of twenty reasons gives you twenty rows of one deal each. Five or six reasons that reps can tell apart give you a table you can act on. Retire a reason rather than deleting it; its deals keep their history and the report still shows it.
- Compare win rate by source before you spend. A source with a high win rate deserves more leads even if it brings fewer; one with many deals and a low win rate is costing the team time.
- Watch for No reason. Deals lost by an automation or an import have no reason, which is expected. A person’s deal under No reason was lost before loss reasons existed. If the row keeps growing, ask which automation is closing deals and whether it should.
- Put a close date on every closed deal. A deal closed with no date is in no month and in no period but All time, so the quarter’s win rate is computed without it. Check the line below the tables and clear it.
Troubleshooting
Section titled “Troubleshooting”The report says no deals were won or lost in this period. Nothing closed in the period with these filters. Set the period to All time and clear the other filters. If it then says no deals have been won or lost yet, no deal you can see is in a won or lost stage.
The win rate is blank. No deal closed in the period, so there is no rate to show. A blank is not 0%: a 0% win rate means deals closed and every one was lost.
A lost deal is missing. Its close date is blank or outside the period, or its stage’s Outcome is not Lost. Set the date, choose a longer period or All time, or check the stage under Settings > Pipeline & Sales Stages.
A lost deal shows “No reason recorded”. It was moved to its lost stage by an automation or an import, or before loss reasons existed. Only a person marking a deal lost is asked for a reason. Open the deal to add one.
A reason I retired is still on the report. It stays while lost deals in the period name it, marked (retired), so those deals are not hidden. Choose a period after you retired it and the row goes.
