How much revenue did I lose to deals that fell through?
Lost deals are not just missed opportunities. They represent real cost: sales time, ad spend, and pipeline resources spent on prospects who never paid. Here's how to quantify the damage.
The short answer
How much revenue slipped away?Look at your CRM for deals marked “Closed Lost” or that stalled in pipeline without closing. Sum their expected values. Then go deeper: which stage did they drop out at? Which channels produced the most losses? What was the acquisition cost you spent on those lost deals? The total impact is bigger than just the lost revenue.
Lost deals cost you twice: the revenue you missed and the money you spent chasing them
Last quarter, you lost 8 deals worth $94,000 in your CRM pipeline. That is $94,000 in potential revenue that did not materialize. But it is worse than that. You spent ad dollars acquiring those leads. Your sales team spent hours on proposals, demos, and follow-ups. You might have even started preliminary work or reserved capacity for deals that never closed.
If you spent an average of $300 to acquire each of those 8 leads through paid channels, that is $2,400 in acquisition costs with zero return. If your sales rep spent 10 hours per deal on proposals and demos, that is 80 hours of time that could have been spent on deals that were more likely to close.
Understanding where and why deals fall through is the first step to reducing the loss. But most businesses only track the top-line lost number. They do not break it down by stage, channel, or reason. And they rarely connect the lost deals back to the acquisition cost that was wasted.
Lost deal analysis: the metrics beyond the headline number
A thorough lost deal analysis covers more than just the total value:
- Total lost deal value. Sum of all deals marked Closed Lost or stuck in pipeline beyond their expected close date. This is the headline number.
- Loss by pipeline stage. Where did deals die? Early-stage losses (first meeting, qualification) are normal. Late-stage losses (proposal sent, negotiation) are expensive because you invested more time and resources.
- Loss by acquisition channel. Which channels produced leads that did not close? If Meta Ads produces lots of leads but most of them fall through, the true cost of that channel is much higher than the CAC alone suggests.
- Wasted acquisition cost. The ad spend and sales time invested in deals that did not close. This is the hidden cost of a low close rate.
- Win rate by channel. Closed-won deals / total deals by source. Channels with low win rates are producing low-quality leads, even if the lead volume looks good.
How to analyze lost deal revenue across CRM and accounting (7 steps)
This requires CRM pipeline data and, ideally, accounting data to verify that “won” deals actually paid. Plan for about 60-75 minutes.
- 1Export lost and stalled deals from your CRM
In HubSpot, go to CRM → Deals. Filter by “Deal Stage = Closed Lost” for the quarter. Also filter for deals where the close date has passed but the deal is still in an open stage (stalled deals). Export both sets. In Salesforce, run an Opportunity report for “Stage = Closed Lost” and a separate one for opportunities past their expected close date.
- 2Sum the total lost value
Total the “Amount” column for all lost and stalled deals. This is your headline lost revenue number.
- 3Break down by pipeline stage
Group lost deals by the last stage they reached before being marked lost. In HubSpot, this is the “Deal Stage” before it moved to Closed Lost (you may need to check deal activity history). In Salesforce, check the Stage History related list.
- 4Break down by acquisition channel
Match each lost deal to the original lead source. In HubSpot, check the associated contact's “Original Source.” In Salesforce, check the “Lead Source” on the Opportunity or the converted Lead.
- 5Calculate wasted acquisition cost
For each lost deal from a paid channel, estimate the acquisition cost: the average cost per lead on that channel (from Google Ads or Meta Ads Manager). Sum it up. This is money spent on leads that produced nothing.
- 6Calculate win rate by channel
For each channel: won deals / (won + lost deals) = win rate. A channel with a 15% win rate is producing lower quality leads than one with a 40% win rate, even if the volume is higher.
- 7Verify “won” deals actually paid (optional but valuable)
Cross-reference your Closed Won deals against QuickBooks or Xero. Some “won” deals never actually resulted in payment. These are hidden losses that your CRM does not track.
Total time: 60-75 minutes. The stage breakdown (step 3) requires checking individual deal histories, which is tedious when you have more than 10-15 lost deals.
Why lost deal analysis gets skipped
Nobody likes reviewing losses. Psychologically, it is much more pleasant to focus on the deals you won than the ones that slipped away. And practically, lost deal analysis requires digging through individual deal records, checking stage histories, and cross-referencing multiple systems.
The result is that most businesses have a vague sense that they “lose some deals” but no concrete understanding of how much revenue is at stake, where in the process deals fail, or which channels produce the most losses. Without this analysis, the same patterns repeat quarter after quarter.
Or see your lost deal impact calculated automatically
Bottomline connects to your CRM and accounting software. It tracks every deal through the pipeline, flags losses and stalls, calculates the wasted acquisition cost, and shows you where to focus your efforts to recover revenue.
The analysis reveals two things the headline number hides: most losses happen at the proposal stage (a sales process problem, not a lead quality problem), and Meta Ads has a 22% win rate compared to 71% for referral. Meta is not just expensive per customer. It is producing leads that mostly do not close, wasting both ad spend and sales team time. That is the kind of insight that changes budget decisions.