How to Find Alive Leads Sitting in Your Contractor CRM

89.86% of multi-touch follow-up sequences get a response after the first contact misses, according to Hatch's 2025 Home Improvement Industry Report.

Most contractors quit after one call. The leads sit in the CRM, marked "no answer" or "left voicemail," and quietly age out.

Those are alive leads. Not dead. Not unqualified. Just unworked. This is how you find them in your database before the end of the week.

What Counts as an Alive Lead

A lead is alive if all three are true. The customer expressed real intent at some point. Their phone or email still works. Nobody has actually said no.

That last one is what most teams get wrong. "Didn't answer" is not a no. "Said they would think about it" is not a no. "Called twice and left voicemails" is not a no.

A 2024 LocaliQ home services search benchmarks report put HVAC cost-per-lead at $149 from Google Ads. Plumbing and roofing sit in the same band. Every alive lead in your CRM cost you that much already, and you have not booked them yet.

Text Clint: "list leads with no contact in last 60 days that we never marked dead"

Why CRMs Bury Alive Leads

Field service CRMs were built to track jobs, not nurture leads. Once a job closes, the lead status moves on. Once a quote sits unsigned for two weeks, it falls off the dashboard. Once a CSR marks a call "voicemail," nothing pulls that record back up.

Hatch's 2025 report notes that the average response rate to a single SMS is 32.39%, and that adding a second touch lifts it dramatically. The math on the second touch is the entire opportunity, and is exactly why 70% of leads die by week 2.

Invoca's 2025 home services call benchmark report puts call-to-appointment conversion at 30-40% across HVAC, plumbing, and electrical. That means the same lead, called a second time, has a 30-40% chance of booking. Most contractors leave that call unmade.

A roofer on r/sweatystartup put it bluntly: "I went back through 18 months of leads we marked closed-lost. Closed three deals in two weeks just from a polite text asking if the project was still on their list."

The Five Buckets of Alive Leads

A working lead-mining campaign starts with segments. A generic "checking in" blast lands in spam.

Bucket 1: One-touch leads. Customer called once, left a message, never got a callback or only got one. The CSR notes will say things like "vm" or "no ans." These are the highest-yield bucket because the customer was hot enough to reach out.

Bucket 2: Quote sent, no follow-up. Estimate created in the CRM, no record of a call or text after. Hatch's data shows quote follow-up drives 60% of close rate, and most contractors send the quote and stop.

Bucket 3: Booked, then cancelled, never rebooked. The job got on the calendar and came off. The reason might have been weather, a sick tech, or a stalled customer. Nobody pinged them again.

Bucket 4: Online form submissions with no response. Web form leads where nobody picked up the phone in under five minutes. Drift's 2024 lead response benchmarks put response after 30 minutes at a 21x lower conversion rate. The form is still in the inbox. The lead might still buy.

Bucket 5: Repeat past customers who got a quote and ghosted. They already trust you. They expressed intent. Then nothing. This bucket converts higher than any cold list, and dovetails with AI-driven customer reactivation campaigns that work the rest of your dormant database.

Text Clint: "find quote-sent leads with no follow-up activity in 14 days"

Find Them With These Queries

The exact field names depend on your CRM, but every modern field service platform exposes the same shape of data. The queries below run against Jobber, Housecall Pro, ServiceTitan, Workiz, and GoHighLevel without much translation. CRM-specific lead module setup lives in how to track leads in Workiz (Lead Manager, custom statuses, automations) and how to track leads in GoHighLevel (Contact vs Opportunity, lead vs job pipelines).

Query 1: Stale leads with phone numbers. Pull every lead with status "new" or "open" where last contact date is more than 30 days ago and phone is not null. In Jobber, this is the Requests report filtered by status and last activity. In ServiceTitan, the Lead List report with the same filters.

Text Clint: "show me open leads older than 30 days where phone number is valid"

Query 2: Quotes over $X with no signature. Pull every estimate above your average ticket where status is sent or pending and signed date is null. Sort by age descending. The biggest stalled quotes go to the top of the call list.

Text Clint: "find quotes over $5,000 that haven't been signed in 14 days"

Query 3: Cancelled jobs with no recovery activity. Pull every job marked cancelled in the last 90 days with no follow-up note, call, or text in the activity log.

Text Clint: "show me cancelled jobs from last quarter we never recovered"

Query 4: Inbound calls with no booked appointment. Cross-reference your call tracking (CallRail, Service Titan call recordings, or your phone system) with booked jobs. Every inbound call that did not turn into a job is an alive lead.

Text Clint: "list inbound calls last 30 days that didn't book an appointment"

Query 5: Form leads with no outbound contact. Pull every web form submission with timestamp, then check whether anyone called or texted within 24 hours. The gaps are alive leads.

This is the kind of cross-source query that no CRM dashboard answers natively, which is the whole class of questions dashboards miss.

The Outreach Script That Actually Books Them

Bad copy: "Just checking in." Gets ignored.

Working copy is specific, low-pressure, and ends with a clear option. Here is a tested template for a stale HVAC quote:

"Hi [Name], it's [Shop]. We sent you a quote on [Month] for the [system type] at [address]. With the season changing, I wanted to check if the project is still on your list. Reply YES if you'd like a 15-minute call this week, or NO and we'll close the file."

The four pieces. Specific reference (month, system, address). Clear timing reason. One easy ask. An out for the customer.

Hatch's 2025 report shows that giving the customer a clear opt-out lifts response rates and protects compliance. TCPA compliance for contractor SMS matters here. Quiet hours, opt-out language, and consent records all need to be tight before you blast 800 stale leads.

How Tommy Mello Thinks About This

Tommy Mello built A1 Garage Door to $220M+ on database discipline. In every Owned and Operated podcast appearance with John Wilson and Jack Carr, the same theme repeats: the leads you already have are worth more than the leads you are buying.

Mello's framing in The Home Service Millionaire is that the average garage door shop has 18-24 months of pipeline already in the CRM, and the difference between $1M and $5M is whether the owner has a system to work it.

Peterman Brothers, the Indiana plumbing and HVAC operator, grew past $100M on similar discipline: every lead, every quote, every dropped appointment gets followed up on a defined cadence.

These are the people the rest of the industry copies. They are not finding new sources of leads. They are working the leads everyone else throws away.

Why This Beats Buying More Leads

LocaliQ's 2025 benchmark puts HVAC Google Ads CPL at $149 and conversion-to-customer rate at roughly 8-12%. So a booked HVAC customer from Google Ads costs $1,200-$1,800 in ad spend.

A booked customer from your stale CRM list costs the price of an SMS plus the time to read a reply. The reactivation math we covered in the dead leads post shows the same gap. A roofer who reran his real LTV math found customer lifetime value was $12K, not the $8K per job he'd assumed, which made every recovered quote worth twice what he thought.

If your CRM has 1,000 stale leads and you book 5% of them, that is 50 customers. At an average $4K ticket on a roof or HVAC install, that is $200K in revenue you already paid the lead cost for.

A landscaper on r/sweatystartup said it cleanly: "We stopped buying leads for two months and just worked our database. Booked more revenue than the previous two months combined."

A Two-Week Plan

Day one. Pull the five queries above as CSVs. Stash them in one spreadsheet. Sort by quote value or job size descending.

Day two. Pick the top 100 records. Validate the phone numbers and email addresses. A free phone validator and a quick check on bounced emails saves hours later.

Day three. Write four SMS templates, one per bucket. Match the segment to the message. The unconverted quote message is different from the cancelled job message.

Day four. Send the SMS in batches of 20-50 per hour, respecting quiet hours and TCPA. Most contractors do this through their existing texting tool or a Hatch vs Podium for contractors class of platform.

Days five through ten. Reply to every response same day. Book what is bookable. Mark dead what is actually dead. Pass anything over $10K to a salesperson for a phone call.

Days eleven through fourteen. Run a second touch on non-responders with a different message. Hatch's data says the second touch is where the 89.86% multi-touch response rate compounds. The full sequence is in the 5-touch follow-up cadence for cold leads.

A solo CSR can run this on top of their normal workflow. Most $1M-$10M shops will book 30-60 jobs out of the first 500 records and pay for a year of better tooling in two weeks.

Where AI Changes the Job

A human can do all of this. The reason most contractors do not is that it never makes the priority list against the call queue and the dispatch board.

AI does not get distracted. An agent connected to your CRM can pull the five queries every morning, draft the SMS, send it through a TCPA-compliant pipeline, handle replies, book on the calendar, and only escalate the complex conversations.

That is the design pattern in AI lead qualification agents for home services and the missing piece in most contractors' missed-call follow-up stack. Clint runs the same plays from your texting line, against your real CRM data, on a daily cadence.

The question is not whether your alive leads exist. They do. The question is whether anyone is actually calling them this week.

Sources

• Hatch 2025 Home Improvement Industry Report
• Invoca Home Services Marketing Benchmarks
• LocaliQ 2025 Home Services Search Advertising Benchmarks
• Drift Lead Response Time Benchmarks
• Owned and Operated Podcast with Wilson and Carr
• Peterman Brothers ServiceTitan Case Study