How many leads never got a follow-up call?
You paid for those leads. They filled out a form, requested a quote, or asked for a call. Then nothing happened. Here is how to find every lead that fell through the cracks in your CRM, and what they are costing you.
The short answer
More than you think.In most small businesses, 15-30% of new leads never receive a single follow-up call or meaningful outreach. They enter the CRM, sit there for a few days, and quietly go cold. To find them, filter your CRM contacts by “Last Activity Date” and look for leads with no logged calls, meetings, or outbound emails.
Why unfollowed leads are the most expensive waste in your business
Every lead has a cost. If you are running Google Ads, that lead might have cost $40-$200 in ad spend. If it came from a referral, someone spent social capital sending them your way. If it came from a conference, you spent $2,000 on a booth to collect that card.
When a lead never gets a follow-up, you get zero return on that investment. Worse, the prospect forms an impression of your company: they reached out and nobody responded. They are not coming back.
The most common cause is not laziness. It is process failure. The lead comes in on a Friday afternoon. Nobody has a task assigned. The CRM notification gets buried in email. By Monday, three more leads came in and this one gets forgotten. It happens quietly, repeatedly, and at scale.
What it means to have “no follow-up” in your CRM
In HubSpot, every contact has activity properties that track interactions:
- Last Activity Date. The last time a note, call, email, meeting, or task was logged for the contact. Set automatically by HubSpot.
- Last Contacted. The last time a call, sales email, or meeting was logged. This is more specific than Last Activity Date because it excludes internal notes and tasks.
- Next Activity Date. The date of the next scheduled task, call, or meeting. If this is empty, nobody has planned a follow-up.
- Number of Times Contacted. A running count of logged outreach activities. If this is zero, the lead has never been contacted.
How to find unfollowed leads in HubSpot (step by step)
- 1Go to CRM → Contacts
Click the “All Contacts” view or create a new saved view for this analysis.
- 2Filter by Create Date in the last 90 days
You want to look at recently created leads, not your entire database. Set Create Date to “is after” 90 days ago.
- 3Add filter: Number of Times Contacted is equal to 0
This shows contacts that have never had a logged call, tracked email, or meeting. These are your unfollowed leads.
- 4Alternative: use the “No Activity Scheduled” deal view
In CRM → Deals, HubSpot provides a built-in view called “No Activity Scheduled” that shows open deals with no next step planned. This is a quick way to find deals going cold.
- 5Calculate the cost of dropped leads
Count the unfollowed leads. Multiply by your average cost-per-lead (ad spend divided by total leads). Then multiply by your typical close rate and average deal size to estimate lost revenue. Example: 40 unfollowed leads x 20% close rate x $8,000 average deal = $64,000 in potential lost revenue.
Total time: 20-30 minutes for the CRM filter. Calculating the revenue impact requires cross-referencing with ad spend data from Google Ads, which adds another 15-20 minutes.
What it takes to catch dropped leads every month
Running this filter once is eye-opening. But leads fall through the cracks every week, not just once a quarter. To stay on top of it:
- Run the CRM filter weekly or set up a workflow to alert when a lead has not been contacted within 48 hours of creation.
- Track the unfollowed rate as a percentage of total leads each month.
- Cross-reference with ad spend to calculate the monthly cost of dropped leads.
The CRM can catch the problem. But quantifying the cost requires pulling ad spend data from a separate system, which is where the manual effort compounds.
Or catch dropped leads automatically, every month
Bottomline connects to your CRM and ad platforms. Every month, it counts leads that never received a follow-up, calculates how much you spent to acquire them, and estimates the revenue you left on the table.
You do not need to run CRM filters or pull ad spend data. Bottomline flags the gap, shows you the cost, and gives you the information you need to fix the process.