What a Real CRM and Funnel Audit Should Show You

Most "CRM audits" are glorified data exports. Someone runs a quick filter, counts contacts, and hands you a spreadsheet titled something like Leads_2024_FINAL_v3.xlsx. You skim it, nod, and nothing changes.

A real audit does the opposite. It tells you where money is leaking, why it's leaking, and what to fix first. It doesn't inventory your database. It diagnoses your growth system.

If you've paid for an audit before and walked away with a PDF that just restated the obvious, here's what a serious one should actually surface.

The 5 Things a Real CRM and Funnel Audit Should Show You

A useful audit is blunt. It points at the specific stages where leads, intent, and revenue are falling through the cracks. The five sections below are what we look for first, in roughly this order.

1. How much of your database is actually alive

The first number most operators get wrong is database size. They'll say "we have 40,000 contacts" like it's an asset. The relevant question is: how many of those contacts have shown any sign of life in the last 6, 12, or 24 months?

A real audit breaks the database into cohorts by recency and engagement:

• –Active (0–90 days): opened, clicked, replied, or submitted a form recently
• –Cooling (90–365 days): once engaged, now quiet
• –Dormant (1–2 years): no signal, but not dead — usually a reactivation candidate
• –Dead (2+ years): no engagement, bad fit, or hard bounced emails. These are liabilities, not assets

Most B2B databases we look at are 60–80% dormant or dead. That's not a crisis. It's normal. The problem is treating the whole 40,000 contacts as pipeline. A proper CRM revenue breakdown starts with this honest segmentation, because every downstream decision depends on it.

If your audit doesn't show you a recency breakdown, it didn't look hard enough.

2. Where leads actually fall out of the funnel

Funnels don't break in the middle. They break at the handoffs. A real audit walks the path a lead takes from first touch to closed deal and marks exactly where drop-off is worst.

For most B2B teams the worst leaks are:

• –Form to CRM: lead submitted, never made it into the system, or got dumped in a generic inbox
• –CRM to sales: lead assigned, but never worked. SDRs logged out before touching it
• –MQL to SQL: marketing calls something a marketing-qualified lead, sales never agreed, and the lead just sat there
• –Quote to close: proposal sent, no follow-up cadence, deal went cold in 14 days

If you're running paid traffic into this, you're paying twice: once for the click, once for the leak. This is the exact dynamic we cover in Why Meta Lead Ads Bring Bad Leads and How to Fix the Funnel. The ad isn't usually the problem. The receiving system is.

A real audit quantifies each handoff. Not "our follow-up is inconsistent." More like: "12% of form submissions are touched by sales within 24 hours. Of those, 31% reply to the first email. Reply rate drops to 6% if first touch is delayed past 72 hours." Those are the numbers that move decisions.

3. Lead quality by source, not just by volume

"We got 500 leads last month" is a vanity number. The audit question is: which 500, and from where, and what did they become?

Break it down by source (paid social, organic, events, referrals, outbound) and score each source on:

• –Cost per lead
• –Cost per qualified lead (your sales team has to define "qualified," not marketing alone)
• –Contact rate (how many answered or replied at all)
• –Cost per opportunity and cost per closed deal, if your CRM is wired that far

A paid social lead at $8 each that never answers the phone is worse than an outbound lead at $120 each that books a demo on the second call. Most audits never get to cost-per-deal because the CRM data is too messy to support that math, which is itself a finding worth writing down.

We wrote more on this trade-off in How to Improve Facebook Lead Quality Without Killing Lead Volume. The core point: volume is the easiest metric to game, and the worst metric to optimize against.

4. Whether your lead scoring means anything

If your CRM has a lead score and nobody acts on it, you don't have a lead score. You have a number.

A real audit checks three things:

• –Is the score actually predictive? Pull a list of closed-won deals from the last 12 months and check what their score was at the moment of conversion. If high scores don't correlate with closed deals, the model is broken.
• –Is anyone using it? If reps route around the score, sort manually, or work leads in chronological order, the score is decorative.
• –Is it being gamed? If marketing can manually bump a score to push a lead to sales, the signal is corrupted.

This is one of the highest-leverage fixes most teams can make. We break down a small-team version in Lead Scoring for Small B2B Teams: How to Focus on the Leads That Actually Convert. The short version: a simple, ugly, accurate score beats a beautiful, theoretical one every time.

5. What your follow-up system actually does (and doesn't)

Most teams think they have a follow-up system. They have a sequence.

An audit should walk a real lead through what happens after they submit a form:

• –What email goes out, and when
• –What SMS or retargeting triggers, and when
• –What task the sales rep gets, and how long until it's touched
• –What happens if the lead replies (does it route correctly)
• –What happens if the lead doesn't reply (is there a 2nd, 3rd, 4th touch)
• –What happens at day 30, 60, 90 (does the lead get recycled, re-scored, archived, or just left alone)

The answer is usually "we send three emails and then hope." That is a sequence, not a system. A real follow-up system has branching logic, ownership rules, and a recycle path back into nurture or reactivation. For dormant leads especially, the playbook is different. See Database Reactivation Campaigns: Wake Up Dormant Leads Without Spamming for the non-spammy version.

If your audit can't draw this picture for any one lead, the system isn't documented well enough to fix.

What a Real Audit Should NOT Be

A few red flags that mean the audit is theater:

• –It starts with your tech stack. If the first question is "which CRM should you be on," the auditor is selling software, not diagnosing growth.
• –It recommends more tools. Most teams we audit need to use what they have better, not add another subscription. The exception is when the CRM is genuinely broken, but that's usually a 10% case.
• –It doesn't produce a ranked action list. If the deliverable is a 40-page report, the auditor got paid to write. If it's a 1-page ranked list of the top 5 fixes with effort and impact estimates, they're trying to help.
• –It avoids your sales team. If the audit doesn't interview reps, watch a discovery call, or look at how leads are actually worked, it's missing the most important layer.

The Output That Actually Matters

A real audit ends with three things, in this order:

1. A short list of leaks, ranked by revenue impact. Not by what's easy to fix. By what is leaking the most dollars.
2. A 30/60/90 plan of which leaks to patch first, with an owner attached to each.
3. A baseline so you can measure whether the fixes worked. If you don't have a "before" number, you'll never know if the "after" was worth it.

Anything else is a data dump.

If your CRM feels busy but revenue feels flat, the problem is almost always one of the five things above, and usually all of them at once. We run focused CRM and funnel audits for B2B teams that want a clear, ranked diagnosis instead of another spreadsheet. Get your free audit here and we'll send back a short list of where your pipeline is actually leaking.