What Is a Sales Funnel Analysis (And How to Do One)

The short version: a sales funnel analysis is the process of tracking how many people move from awareness to purchase at each stage, then finding the exact stage where you're losing the most people and money. It's not a report you commission once a year, it's a habit, and most businesses I've worked with have never done one, which is exactly why they can't answer a simple question: where do your leads die.

What a sales funnel analysis is

Strip away the jargon and it's this: you count how many people enter your funnel, count how many come out the other end as paying customers, and then work out where the biggest gap sits in between. That's it. Awareness, interest, consideration, decision, purchase, whatever labels you use, the point is the same. You're looking for the leak.

I worked with a client, a B2B software company doing around £40,000 a month in recurring revenue, who was convinced their problem was lead volume. They were spending close to £6,000 a month on ads to get more people into the top of the funnel. When we ran the numbers, the top of the funnel was fine. Nearly 1,200 people a month were hitting the pricing page. The problem was between demo booked and demo attended, where they were losing 43 percent of people who'd booked. Nobody had looked at that number before because everyone was staring at traffic and ad spend, which felt more urgent and more controllable. It wasn't the real problem. The real problem was a clunky booking confirmation email and no reminder sequence. We fixed that one thing and booked-to-attended went from 57 percent to 79 percent within six weeks, with zero extra ad spend. That's what a proper funnel analysis finds, and it's usually not what people expect.

Why most businesses skip this (and pay for it)

Here's the uncomfortable bit nobody likes to say out loud: most business owners would rather spend money fixing the top of the funnel than admit their middle or bottom stages are broken. Adding more leads feels like progress. Fixing your follow-up process feels like admitting you've been sloppy for a year. So people keep pouring more traffic into a funnel with a hole in it, and wonder why revenue doesn't move even as spend goes up. If you run lead generation campaigns, my lead generation guest post guidelines explain what to send.

I've seen this pattern more times than I can count. A founder will tell me their conversion rate is "roughly fine" without knowing the actual number, then spend £2,000 on a new lead magnet before they've checked what happens to the leads they already have. It's easier to buy more attention than to sit with a spreadsheet and find out that your sales team takes four days on average to follow up with a hot lead, and that four-day gap is costing more than any ad campaign ever will.

The five stages you need to track (with real numbers)

Every funnel has stages specific to your business, but for most companies selling anything above impulse-buy price, these five hold up:

• Awareness: website visitors, social reach, ad impressions. This is volume, not quality.
• Interest: people who take a small action, opt in for a lead magnet, follow you, download something, sign up for a newsletter.
• Consideration: people who engage with sales-specific content, book a call, ask for pricing, add to cart.
• Decision: people who get a proposal, quote, or demo and are actively weighing it up.
• Purchase: people who pay.

For a typical mid-size B2B service business, healthy benchmarks look roughly like this: 2 to 5 percent of website visitors move to interest (opt in for something), 20 to 30 percent of those move to consideration (book a call), 40 to 60 percent of calls move to decision (get a proposal), and 20 to 30 percent of proposals close. If your numbers are wildly off any one of those, that's your stage. Don't chase all five at once, fix the worst one first.

Step by step: how to run your own funnel analysis

You don't need expensive software to start this. You need a spreadsheet, access to your analytics, and about three hours.

• Step 1: define your stages. Write down the exact actions that count as each stage for your business. "Interest" for an ecommerce store might mean adding to basket. For a consultancy it might mean booking a discovery call. Be specific, not generic.
• Step 2: pull three months of numbers. Not one month, that's too noisy, and not a year, that's too slow to react to. Three months gives you a pattern without being ancient history. Pull raw counts for each stage from your CRM, your email platform, and your analytics tool.
• Step 3: calculate the conversion rate between each stage. Not the overall conversion rate, the stage-to-stage rate. If 1,000 people saw your offer and 40 bought, your overall rate is 4 percent, but that tells you nothing useful. You need to know that 1,000 became 300 became 90 became 40, so you can see which jump was smallest.
• Step 4: benchmark each jump against the previous three months. Is the consideration-to-decision rate dropping? That tells you something changed in your sales process, your pricing, or your competition, and it's worth investigating before you touch anything else.
• Step 5: find the single worst stage and go deep on it. Don't try to fix five things. Pick the stage losing you the most people relative to the effort it took to get them there, and put all your attention on that one leak for a month.
• Step 6: talk to actual humans who dropped off. Email or call ten people who got a proposal and didn't buy. Ask them directly why not. This single step gives you more insight than any dashboard, because dashboards show you the "what" and humans give you the "why."
• Step 7: fix one thing, measure again in 30 days. Resist the urge to change everything at once. If you change your email sequence, your pricing page, and your follow-up timing all in the same week, you'll have no idea which change moved the number.

The tools that make this less painful

You can absolutely do a first-pass funnel analysis in a spreadsheet, and I'd argue you should, because building it manually once forces you to understand your own numbers rather than trusting a dashboard blindly. But once you know what you're tracking, tools save serious time. Your CRM (Pipedrive, HubSpot, or similar) should already be logging stage-to-stage movement if your sales team is disciplined about updating it, which, honestly, is its own problem in most businesses. If your team is inconsistent about logging activity, no analysis tool will save you, because the data going in is the data you'll be lied to by. I've written before about the tools that help sales teams stay productive without adding admin burden, and getting that discipline right matters more than which software you pick.

If a chunk of your funnel lives in outbound prospecting, it's worth checking your source data too, because a funnel analysis is only as good as the leads feeding it. I put together a huge list of sales prospecting tools for outbound sales that's worth a look if your top-of-funnel volume itself is the actual problem, not just a symptom of a broken middle.

Where social and content fit into the funnel

People often forget that awareness stage numbers come from somewhere specific, and if you're not tracking which channel is feeding your top of funnel, you'll misdiagnose the whole thing. I covered this in a webinar transcript on how to measure your social media success for Simplilearn, and the same logic applies here: vanity metrics like followers and likes tell you nothing about funnel health unless you can trace them to an actual stage movement. Same goes if Instagram is a real driver for you, there's a breakdown on measuring sales success through Instagram analytics that connects social metrics directly to pipeline, which is the only version of social reporting that matters to a business owner trying to hit revenue targets.

Where AI helps, and where it doesn't

AI tools can now flag drop-off points automatically, summarise why leads went cold based on CRM notes, and even draft follow-up sequences for the exact stage where you're bleeding people. That's useful and worth exploring, there's a good starting point in my piece on where to learn how to use AI tools for your business in 2026. But I'll say the uncomfortable part again because it needs repeating: no AI tool fixes a funnel problem caused by a slow, disorganised, or under-trained sales team. It will just tell you the same thing faster. The fix is still human: better follow-up timing, clearer pricing, a shorter gap between interest and contact. AI speeds up diagnosis, it doesn't replace treatment. If you want a wider view of what's shifting in the AI and small business space generally, I round up developments weekly in posts like AI news for small business.

If you've run the numbers yourself and you're still stuck on where the leak is, that's usually a sign the problem sits deeper in your sales process than a spreadsheet can show you, and it's worth getting a second pair of eyes on it through an AI consultant for small business who can look at your data and your process together rather than one without the other.

Common mistakes I see over and over

• Measuring the whole funnel, not the stages. A 4 percent overall conversion rate tells you nothing about where to focus.
• Comparing to industry benchmarks instead of your own history. Your funnel from last quarter is the only benchmark that matters, because it's the same audience, same offer, same team.
• Fixing the wrong stage because it's the easiest to fix. Redesigning a landing page is satisfying. Chasing down why your sales rep waits three days to call a hot lead is not. Guess which one usually moves the needle more.
• Never talking to lost leads. The data tells you where people drop off. Only conversations tell you why.
• Doing this once a year. A funnel analysis done once and filed away is a historical document, not a management tool. Run a lightweight version monthly.

What good looks like once you're doing this

You'll know your stage-to-stage numbers off the top of your head. You'll be able to say "our proposal-to-close rate dropped from 28 percent to 19 percent this quarter, and it happened right after we changed our pricing page" without pulling up a report. You'll stop guessing which marketing activity to cut when budgets tighten, because you'll know exactly which stage of the funnel is starving for attention and which one is already healthy. That clarity is worth far more than any single tactic, and it's the difference between running a business on instinct and running one on evidence.

For freelancers, selling funnel design is a strong offer.

Frequently asked questions

How often should I run a sales funnel analysis?

Do a full deep analysis quarterly and a lightweight check monthly, just pulling the stage-to-stage numbers and comparing them to the previous month. Waiting a full year means you find problems long after they've cost you real money.

What's the difference between a sales funnel and a marketing funnel?

A marketing funnel usually stops at the lead stage, tracking awareness through to interest. A sales funnel analysis extends all the way to purchase, including everything your sales team does after marketing hands a lead over, which is exactly where most businesses lose the most people.

What tools do I need to do a sales funnel analysis?

You can start with a spreadsheet, your CRM export, and your website analytics. That's enough for a first pass. Dedicated funnel software helps once you know what you're tracking, but it won't fix bad or missing data in your CRM, so get your team logging activity consistently before you buy anything.

What's a good conversion rate for a sales funnel?

It depends heavily on your price point and sales cycle, but as a rough guide, expect 2 to 5 percent of website visitors to become leads, 20 to 30 percent of leads to become qualified opportunities, and 20 to 30 percent of proposals to close. Compare against your own past performance rather than these numbers alone, since your specific business and audience matter more than any general benchmark.