The pipeline math nobody runs, and what it shows

The math most operators skip

Ask any home service operator if there’s recoverable revenue in their CRM and you’ll get a confident yes. Ask them how much, and you’ll get a guess. Maybe “a lot.” Maybe “six figures.” Almost never a real number.

That’s the problem. Operators run real math on every other line of the business: cost per acquisition, lifetime value, gross margin, win rates, marketing ROI. The one calculation almost nobody runs is the value of the pipeline they already paid for.

So decisions get made on intuition. Spend more on ads. Hire another rep. Buy another tool. The dormant pipeline keeps growing in the background, unmeasured, while the operator competes for new revenue and leaves older revenue uncounted.

This post fixes that. It walks through the framework we use to size recoverable pipeline, the recovery rates behind it, and a worked example you can apply to your own CRM in about 30 minutes.

Start by splitting your pipeline into three buckets

The mistake most reactivation math makes is treating all dormant leads the same. A homeowner who sat through an estimate last month is nothing like a lead that went cold two years ago. Lumping them together produces a number you can’t trust.

So we split dormant pipeline into three buckets, each with its own recovery profile:

Stalled deals. Estimates that went out and the homeowner went quiet. These are the warmest. The homeowner wanted the work, got a price, and stalled. The interest was real.

Canceled projects. Deals that got marked closed-lost or canceled. Colder than stalled deals, because something caused them to fall apart, but recoverable depending on the reason. Financing fallout recovers better than a competitor win.

Aged leads. Leads that haven’t been contacted in 3+ months. The largest bucket for most operators and the coldest, but there’s volume here, and volume at a modest recovery rate still produces revenue.

Sort your dormant pipeline into these three buckets and you’ve done the hard part. The math from here is simple.

The recovery rates

Each bucket recovers at a different rate. These rates come from recovery work at a national solar operator, applied conservatively across home service verticals. They’re estimates, presented as ranges, not guarantees:

• Stalled deals: 15-25%. Warmest bucket — the homeowner already saw the price.

• Canceled projects: 10-20%. Recoverable depending on why they canceled.

• Aged leads: 5-15%. Coldest, but volume makes up for the lower rate.

Your actual rates will vary with your vertical, your average deal size, and how your pipeline was worked before it went dormant. Use the conservative end if you want a number you can defend in any room.

The equation

For each bucket, the math is the same:

Bucket count × recovery rate × average deal size = recoverable revenue per bucket.

Run it for all three buckets, sum the results, and you have a defensible estimate of what’s recoverable from your dormant pipeline. Not a marketing number. A calculation you can stand behind in a board meeting.

A worked example

Take a home service operator with two years of CRM history, roughly 2,000 dormant records, and an $18,000 average ticket. Here’s the dormant pipeline split into buckets, using the realistic midpoint rates:

Roughly $4.3M in recoverable revenue, from a CRM the operator was probably ready to write off as a historical record. That number doesn’t require a new lead source, a new tool, or a new ad budget. It requires a recovery process applied to data that already exists.

“If you can’t put a number on dormant pipeline, you’re competing blind.”

What if your numbers are different

The example uses midpoint rates. Real businesses don’t sit at the midpoint. The honest version of this math is a range, not a single number.

Using the same 2,000-record pipeline and $18K ticket, here’s how the math moves at the conservative and optimistic ends:

Even at the conservative end, the recoverable revenue is substantial. Run your own numbers using your actual bucket counts and ticket size. The range narrows once you replace estimates with your real data.

How this compares to your next ad campaign

Put the recoverable revenue number next to your current cost of acquisition. The comparison usually surprises operators.

If your CAC on fresh leads is $400 per closed deal, generating $4.3M in revenue from new ad spend requires roughly:

Recovering the same revenue from dormant pipeline requires zero additional ad spend. The acquisition cost is already in your historical marketing budget, paid for months or years ago. The unit economics aren’t comparable. They’re substantially better.

This is what makes dormant pipeline recovery a margin play, not a growth play. You aren’t generating more demand. You’re capturing more of the demand you already paid for, at a fraction of the cost.

The cost of waiting

There’s one more variable the equation doesn’t capture: time.

Recovery rates aren’t constant. They decay as leads age. A stalled deal worked this month recovers far better than the same deal worked a year from now. Within the aged bucket, a lead that went cold three to six months ago sits near the top of the 5-15% range. A lead that went cold two years ago sits near the bottom.

Every quarter you wait, leads slide into colder territory. The fresh stalled deal slides toward the bottom of its range. The recently aged lead becomes an old aged lead. The recoverable revenue number doesn’t stay the same. It shrinks.

This is why operators who run the math and then don’t act on it often wish they had. The recoverable pipeline you have today is worth more than the same pipeline will be worth next quarter.

Why running this once changes how you think about growth

Most home service operators make growth decisions in the dark on this question. They know what new lead generation costs. They don’t know what dormant lead recovery would produce. So the default answer is always more ads, more reps, more tools.

Run the math once and the decision frame shifts. You can compare the ROI of another ad spend dollar against the ROI of working pipeline you’ve already paid to acquire. Most of the time, the recovery math wins by a wide margin.

That doesn’t mean stop running ads. It means stop ignoring the highest-margin growth lever in your business because it’s harder to see than a dashboard of fresh inbound.