# Funnel Analysis Calculator: Step Conversion and Drop-off

Page: https://alidemirbas.com.tr/en/calculators/funnel-analysis-multistep

Use this funnel analysis calculator: enter the count at each stage to see step conversion, drop-off and where the funnel leaks most.

**How to calculate funnel drop-off**

`Step conversion = (Stage ÷ Previous stage) × 100, drop-off rate = 100% − step conversion`

1. List the stages in the order people move through them, from the widest (visits) to the goal (purchase), and count each one for the same period and the same group of people.
2. Divide each stage's count by the stage before it to get the step conversion. Subtract that from 100% to get the drop-off rate for the step.
3. Divide the last stage by the first for the overall conversion, then find the step with the largest drop-off, in percent and in people.

`10,000 visits → 1,800 add to cart (18%) → 900 checkouts (50%) → 620 purchases (68.89%), overall 620 ÷ 10,000 = 6.2%`

## What is funnel analysis

Funnel analysis breaks a journey such as visit, add to cart, checkout and purchase into ordered stages and measures how many people move from each stage to the next. The share who move on is the step conversion, and the share who leave is the drop-off rate. The ratio of the last stage to the first is the overall conversion of the whole funnel.

The overall figure tells you how much the funnel lost. Only the step-by-step breakdown tells you where. In the example above, 6.2% of visitors bought something, which on its own gives no hint of what to fix. The steps show that the biggest loss happens between the visit and the add-to-cart stage, where 82% of people leave. Checkout, by contrast, keeps more than two thirds of those who reach it. That makes product pages and the offer the first place to look, but the biggest loss is not automatically the best fix. Before you choose, weigh how much of the loss you could realistically recover, how the later stages convert, what the people at that step are worth and what the change would cost to build.

A conversion funnel can describe any ordered journey: a signup flow, an onboarding sequence, a lead form or a B2B sales pipeline. What makes it a multi-step funnel analysis is the chain of stages in between. Two stages give a single ratio, which the [conversion rate calculator](https://alidemirbas.com.tr/en/calculators/cr) already covers. Three or more stages show which transition deserves attention.

> The overall number tells you how much the funnel lost, and only the steps tell you where.

## Ecommerce funnel example: reading each step

The table below runs the calculator's example through each step and shows the funnel step conversion and drop-off for every transition. Reading it row by row shows why the same overall result can come from very different funnels, and where you should start work in this one.

| Step | People in | People who moved on | Step conversion | Drop-off rate |
| --- | --- | --- | --- | --- |
| Visit → Add to cart | 10,000 | 1,800 | 18% | 82% (8,200 people) |
| Add to cart → Checkout | 1,800 | 900 | 50% | 50% (900 people) |
| Checkout → Purchase | 900 | 620 | 68.89% | 31.11% (280 people) |
| Overall: Visit → Purchase | 10,000 | 620 | 6.2% | 93.8% |

The first step loses the most people in both percentage and absolute terms, so in this ecommerce funnel example the product and listing pages come before the checkout form. Absolute numbers matter as much as rates. A step with a modest drop-off rate near the top of the funnel can lose more people than a step with a dramatic rate near the bottom. Far more people pass through the top. The overall conversion is also the product of the step rates: 18% × 50% × 68.89% gives the same 6.2%. If the other steps hold, improving one step by a given factor lifts the overall figure by that same factor.

## Open vs closed funnel and other data checks

Funnel numbers come from event data, and small differences in how each stage is counted change the result. Google Analytics 4, for example, offers two kinds of funnel. In a closed funnel users must enter at the first step, while in an open funnel they can enter at any step. In both, a user who misses a step is not counted in the steps after it ([GA4 funnel exploration](https://support.google.com/analytics/answer/9327974)). Before you trust a step rate, check these points:

- Open or closed funnel: in an open funnel people can join at a later stage, so a later step can show more people than the one before it. In a closed funnel that should not happen.
- Same period and audience: counting one stage over 7 days and the next over 30 days produces rates that describe no real group of people.
- One clearly defined event per stage: a stage that fires twice per visit, or a step renamed halfway through the period, breaks the comparison.
- Empty stages: if a stage counts zero, the steps after it cannot be calculated. That often means the event was not tracked. Rule that out before you conclude that nobody reached the stage.

When a later stage counts more people than the stage before it, the calculator flags that step with a warning. In a single-cohort funnel the likely causes are double counting, a wider date range or two different event definitions. To check whether a change in one step between two periods or two variants is more than chance, use the [A/B test significance calculator](https://alidemirbas.com.tr/en/calculators/ab-test). It answers only the statistical question for the two groups you enter. Two periods are not a randomised, simultaneous experiment, so a season, a campaign or a change in traffic between them stays in the difference.

## When to use funnel analysis

Use it when you need to find where a funnel leaks, or when you compare the same funnel across periods, devices or channels. It also helps when the overall conversion has moved and you need to know which stage moved it. Keep the stage definitions fixed across those comparisons. Before testing a fix on the weakest step, estimate how much traffic you need with the [sample size calculator](https://alidemirbas.com.tr/en/calculators/sample-size-calculator).

## Where funnel analysis misleads

Step rates from funnels with different stage counts or definitions cannot be compared, even when the first and last stages look alike. A stage that counts more people than the one before it is a data problem to investigate. Percentages alone can also send you to the wrong step, so read them next to the number of people each step loses.

## Frequently Asked Questions

### What is funnel analysis?

Funnel analysis measures how people move through an ordered series of steps toward a goal, for example visit, add to cart, checkout and purchase. For each pair of consecutive stages it shows the step conversion, the share who moved on, and the drop-off rate, the share who left. It also shows the overall conversion from the first stage to the last. Its value lies in locating the loss: a single rate tells you how many people finished, and the funnel shows at which step the others stopped. This funnel calculator accepts 2 to 10 stages.

### How do you calculate funnel drop-off rate?

Divide each stage's count by the count of the stage before it to get the step conversion, then subtract it from 100%. Drop-off rate = (1 − Stage ÷ Previous stage) × 100. If 10,000 people visited and 1,800 added something to the cart, the step conversion is 18% and the drop-off rate is 82%. That means 8,200 people left at that step. The overall conversion is the last stage divided by the first, 620 ÷ 10,000 = 6.2% in the example. Each step rate depends only on the two stages next to it, so it measures one transition on its own.

### Why does a later funnel stage show more people than the one before it?

In a funnel where everyone starts at the first stage, this usually signals a data problem. Look for double counting, a wider date range on the later stage, or two stages that measure different events. It can also happen legitimately in an open funnel, where people can enter at a later step without passing through the earlier ones. The calculator flags such a step so that a step conversion above 100% does not pass as a normal result. It computes whatever counts you enter and cannot check that each stage is a subset of the one before it, so confirm that in your analytics tool first.

### What is the difference between an open and a closed funnel?

In a closed funnel, people are counted only if they enter at the first step and then move through the steps in order. In an open funnel, they can enter at any step. Google Analytics 4 offers both options in its funnel exploration, and in both a user who misses a step drops out of the steps after it ([GA4 funnel exploration](https://support.google.com/analytics/answer/9327974)). Open funnels suit journeys with several entry points, such as visitors landing straight on a product page. Closed funnels give cleaner step rates for a single path. Before comparing two reports, find out which type each one uses.

### How many stages should a funnel analysis have?

At least two, and this calculator accepts up to ten. Two stages give one ratio, which is the same as a simple conversion rate. The diagnostic value comes from the stages in between, because they show which transition loses the most people. You do not need every small event from your analytics. Three to five stages that match real decisions usually draw a clearer funnel than a long chain of events where little changes. Viewing a product, adding it to the cart, starting checkout and paying are decisions of that kind.