datarekha

Funnel Analysis

10,000 people visited; 360 paid. Where did the other 9,640 go — and which leak should you fix first? Funnel analysis answers both.

7 min read Intermediate Business Analytics Lesson 10 of 21

What you'll learn

  • What a conversion funnel is and why it narrows at every step
  • Overall conversion = the product of step rates, not the average
  • How to find the biggest leak and why fixing it beats buying more traffic
  • Quick math: lifting one step rate and watching the compounding effect

Before you start

You ran ads, wrote content, and earned 10,000 visitors this week. By Friday, the payment system logged 360 customers. Your manager asks: “Should we spend more on ads to get more visitors, or is something else broken?”

Funnel analysis is the tool that answers this precisely — without guessing.


What is a Conversion Funnel?

A conversion funnel is the ordered sequence of stages a prospect passes through on the way to becoming a customer — visit the site, sign up, activate (use the product enough to see value), then pay. The shape is a funnel because people drop off at every step: the pool narrows from one stage to the next.

At each step you can measure the conversion rate — the percentage of people who move from that stage to the next. Three step rates define our example:

  • Visitors → Sign-ups: 32% of 10,000 visitors sign up = 3,200 sign-ups
  • Sign-ups → Activated: 45% of 3,200 activate = 1,440 activated users
  • Activated → Paid: 25% of 1,440 upgrade to paid = 360 paid customers

The rest — 6,800 people who never signed up, 1,760 who signed up but never activated, 1,080 who activated but never paid — are the drop-off at each step (the people lost before reaching the next stage).


Overall Conversion: Multiply, Never Average

Here is the number that surprises almost everyone.

The overall conversion rate is not the average of the three step rates. You multiply them:

32% × 45% × 25% = 3.6%

So 360 paid customers out of 10,000 visitors — an overall rate of 3.6%. If you had averaged (32 + 45 + 25) / 3 = 34%, you would wildly overestimate how many people reach the end.

Why multiply? Because the rates are sequential gates. To reach Paid you must pass all three. The probabilities compound: if only 32% make it past gate one, the 45% at gate two applies to those 3,200 people, not to the original 10,000. Each step shrinks the pool that the next step acts on.


Finding the Biggest Leak

Drop-off in absolute numbers:

StepInOutLost
Visitors → Sign-ups10,0003,2006,800
Sign-ups → Activated3,2001,4401,760
Activated → Paid1,4403601,080

The biggest absolute loss is at the very first step (6,800 people never signed up). But the worst conversion rate is Activated → Paid at 25%. That 25% is the biggest leak — the step where you are losing the largest fraction of the people who reached it.

Why focus on the worst rate? Because fixing it compounds. Lift Activated → Paid from 25% to 35%:

Paid = 1,440 × 35% = 504

That is 504 paying customers instead of 360 — a 40% increase in revenue with zero extra traffic. The lift on one step flows through to the final number because every activated user who converts adds to the bottom line.


Try It: The Funnel Explorer

Drag the sliders to see how each step rate changes the paid count. Start by nudging Activated → Paid upward — watch how fast the final number moves compared with adding more visitors.

The widget flags the lowest-conversion step in red. That red step is where your next experiment should live.


Why More Traffic Is Usually the Wrong First Move

The compounding nature of funnel rates means improving the worst step is usually the cheapest and fastest path to more revenue. Traffic is expensive; product and onboarding improvements are often one-time costs.


The Quick “What Should We Fix?” Checklist

  1. Write down all step rates.
  2. Circle the lowest rate — that is the biggest leak by percentage.
  3. Estimate the gain from lifting that rate by 10 percentage points.
  4. Compare the cost of that fix to the cost of buying equivalent traffic.
  5. Invest where the math is most favorable — almost always the leaky step.

Quick check

0/3
Q1In the worked example (10,000 visitors, 32% → 45% → 25%), what is the overall conversion rate from visitor to paid customer?
Q2A SaaS product has three funnel steps: Ad Click → Free Trial (20%), Free Trial → Onboarded (60%), Onboarded → Paid (50%). Which step is the biggest leak and what is the overall conversion rate?
Q3A marketplace app reports: 50,000 app opens → 15,000 product views (30%) → 3,000 add-to-cart (20%) → 900 purchases (30%). A growth team has budget for ONE experiment. According to funnel analysis, which step should they prioritize?

Next

Cohorts, retention, and churn — what happens to your 360 paid customers after they convert, and how you measure whether they stay.

Practice this in an interview

All questions
DAU dropped 15 % week-over-week with no planned changes. How do you diagnose it?

A metric drop investigation starts by confirming the drop is real — ruling out logging bugs and metric-definition changes — before hypothesising causes. Then segment by platform, geography, user cohort, and funnel step to isolate where the drop is concentrated, which points to the most likely root cause.

30-day retention dropped from 42 % to 31 % over the last two months. How do you diagnose the root cause?

A retention drop investigation requires distinguishing between an acquisition-mix shift (newer cohorts are lower quality) and a genuine product regression (existing cohorts are performing worse). The two look identical in aggregate retention but have completely different fixes. Cohort analysis — plotting the D30 survival curve for each weekly acquisition cohort — is the first move.

How would you measure user engagement for a mobile app — what metrics would you use and how would you structure them?

Engagement is multi-dimensional: breadth (how many users engage), depth (how much they do per session), and frequency (how often they return). A robust engagement framework stacks these three layers into a metric hierarchy and links them to retention curves, because engagement that does not predict long-term retention is usually noise.

How would you define and measure the success of a new feature — say, a 'Stories' feed added to a social app?

Success definition requires aligning a north-star metric to the feature's goal, pairing it with guardrail metrics that catch side-effects, and deciding on a measurement window before launch. For a Stories feed, adoption rate and daily story views per active user are reasonable primary signals, while core feed engagement and notification opt-out rate serve as guardrails.

Sign in to track your progress

Completed lessons, your XP, level, and streak save to your account — it's free and takes a few seconds.

Explore further

Glossary terms

Related lessons

Skip to content