An ecommerce conversion funnel shows how shopping sessions progress from visiting an online store to making a purchase. Instead of judging performance by one conversion rate, it helps you identify which transition needs closer investigation.
This guide covers six stages, step-by-step formulas, a complete example, and a practical optimization process. You can also download a free Excel conversion funnel template to calculate stage completion and drop-off rates and organize an action plan.
Quick answer: Stage completion rate = Sessions completing the next step ÷ Sessions completing the previous step × 100. Drop-off rate = 100% − Stage completion rate. Use the same measurement scope and session-based counting method throughout the funnel.
Table of Contents
- What Is an Ecommerce Conversion Funnel?
- Conversion Funnel vs. Sales Funnel
- How to Measure the Funnel With GA4
- The 6 Stages of an Ecommerce Conversion Funnel
- How to Calculate Completion and Drop-Off Rates
- Complete Ecommerce Funnel Example
- How to Interpret Drop-Offs
- How to Use Conversion Benchmarks
- Common Measurement Mistakes
- How to Improve the Funnel: A Practical Process
- Mini Exercise and Checklist
- Free Ecommerce Conversion Funnel Excel Template
- Frequently Asked Questions
- Conclusion
- References and Further Reading
What Is an Ecommerce Conversion Funnel?
An ecommerce conversion funnel is a measurement framework for the actions shoppers take between arriving at your online store and purchasing. In this guide, the example follows a defined six-step sequence:
Sessions → Product View → Add to Cart → Begin Checkout → Payment Info → Purchase
The counts normally decrease as the process advances. That pattern helps locate friction or differences in visitor intent, but a drop-off is an observation, not proof of its cause. Two stores with the same final conversion rate may have very different problems: one before product discovery, the other during payment.
The sequence here is a custom, session-based model. It is not a universal checkout design and should not be confused with every platform’s standard funnel report.
Ecommerce Conversion Funnel vs. Sales Funnel
A broader sales funnel can cover awareness, consideration, purchase, retention, and advocacy. An ecommerce conversion funnel usually answers a narrower operational question: Which measurable shopping step is losing progression after visitors reach the store?
To complement behavioral analysis with broader commercial measures, see our Sales KPIs guide. Conversion measures are useful, but do not tell you whether the resulting orders are profitable.
How to Measure the Funnel With Google Analytics 4
Google Analytics 4 recommends ecommerce events including view_item, add_to_cart, begin_checkout, add_payment_info, and purchase. These events require correct implementation; they are not automatically captured simply because GA4 is installed. See Google’s ecommerce measurement documentation.
For the Excel template, the input is the number of sessions that complete each successive stage in the selected order, within one consistent reporting period. Count each qualifying session once per stage. Do not mix the number of users, raw event fires, sessions, and orders in the same funnel.
A standard GA4 Funnel Exploration counts users following its configured sequence and may use open or closed funnel rules. It therefore cannot be copied into this session-based spreadsheet without checking the measurement method. An ecommerce event report containing raw event counts is not the same thing either.
- Use the same date range, store, geography, and device scope for all six inputs.
- Use sessions following the defined sequence, not six unrelated event totals.
- Verify that later-stage counts never exceed the immediately preceding stage.
- Confirm event tagging, duplicate events, consent effects, and checkout pathways before interpreting missing stages.
- If data for a required step is unreliable, fix the measurement definition instead of entering an invented number.
The 6 Stages of an Ecommerce Conversion Funnel
The following six steps match the model and stage labels used in the downloadable workbook. Use them as a structured analysis of a store whose events support this sequence.
1. Sessions
Sessions represent store visits in the selected period and provide the starting denominator. Example: 50,000 sessions. Examine traffic source, device, campaign, location, and landing-page relevance when visitors rarely progress toward products.
2. Product View
The view_item event indicates that a product’s details were viewed. Count qualifying sessions reaching this step after entry into the funnel.
Product View Rate = Product View Sessions ÷ Sessions. Example: 20,000 ÷ 50,000 = 40%. A low rate may point to traffic quality, product discovery, confusing navigation, weak category pages, search, or mismatched landing pages—not necessarily to defective products.
3. Add to Cart
The add_to_cart event records when an item is added to the cart. This transition is often useful for examining whether the product and offer meet shopper expectations.
Product View → Add to Cart = Add-to-Cart Sessions ÷ Product-View Sessions. Example: 2,400 ÷ 20,000 = 12%. Investigate images, specifications, price, size or variant selection, stock availability, delivery information, returns, reviews, and the clarity of the Add to Cart control.
The context matters: consumer buying behavior can help explain why shoppers view products while still comparing options or deciding whether to purchase.
4. Begin Checkout
The begin_checkout event represents a shopper starting the checkout process. Add to Cart → Begin Checkout = Begin-Checkout Sessions ÷ Add-to-Cart Sessions. Example: 1,200 ÷ 2,400 = 50%.
Explore shipping costs, delivery promises, taxes, promo-code distraction, cart usability, account creation, and purchase timing. Cart abandonment is not always a usability failure: some visitors are browsing or comparing options. Baymard’s 2026 research distinguishes user-experience problems from other reasons for abandonment.
5. Payment Info
The optional-in-practice add_payment_info event is recommended when a customer submits payment details. Within this fixed six-stage template, the payment-information stage must be measured reliably to calculate the next two transitions.
Begin Checkout → Payment Info = Payment-Info Sessions ÷ Begin-Checkout Sessions. Example: 1,000 ÷ 1,200 = 83.33%. If the rate appears weak, assess form fields, mobile usability, address entry, payment availability, error handling, and trust signals.
Important: some express-checkout or digital-wallet paths may bypass a separately observable add_payment_info event. Missing event data does not automatically mean a shopper abandoned checkout. Verify the actual journey and event implementation before using this six-stage model; otherwise, the funnel may exclude valid purchases.
6. Purchase
Google recommends the purchase event when a transaction is completed. For this model, enter sessions completing the defined path and ending in purchase, not a raw count of all purchase events or orders.
Payment Info → Purchase = Purchase Sessions ÷ Payment-Info Sessions. Example: 780 ÷ 1,000 = 78%. Investigate payment declines, gateway issues, authentication, error recovery, and confirmation reliability if this step weakens. The Baymard Payment UX guide provides research-backed areas to review.
How to Calculate Completion and Drop-Off Rates
| Metric | Formula | Example |
|---|---|---|
| Stage completion | Next-stage sessions ÷ Previous-stage sessions × 100 | 2,400 ÷ 20,000 = 12% |
| Stage drop-off | 100% − Stage completion rate | 100% − 12% = 88% |
| Sessions not progressing | Previous-stage sessions − Next-stage sessions | 20,000 − 2,400 = 17,600 |
| Modeled purchase-session rate | Purchase-stage sessions ÷ Starting sessions × 100 | 780 ÷ 50,000 = 1.56% |
In the example, the 1.56% is the share of starting sessions completing the modeled six-step sequence. It equals the storewide purchase-session conversion rate only if all valid purchasing paths are included. Where customers can skip a tracked stage or place multiple orders in one session, this figure can differ from the platform’s orders-per-session rate.
Always distinguish purchase sessions from orders. A session may contain more than one order, while a raw purchase event total may contain duplicate instrumentation events. Do not substitute these measures without reconciliation.
Complete Ecommerce Conversion Funnel Example
Consider a fictional U.S. fashion ecommerce store that has collected consistent session-based data for one month. The six-stage counts are illustrative and match the workbook’s sample values.
| Stage | Sessions | Completion from prior stage | Drop-off from prior stage | Sessions not progressing |
|---|---|---|---|---|
| Sessions | 50,000 | — | — | — |
| Product View | 20,000 | 40% | 60% | 30,000 |
| Add to Cart | 2,400 | 12% | 88% | 17,600 |
| Begin Checkout | 1,200 | 50% | 50% | 1,200 |
| Payment Info | 1,000 | 83.33% | 16.67% | 200 |
| Purchase | 780 | 78% | 22% | 220 |
Overall modeled purchase-session rate: 780 ÷ 50,000 × 100 = 1.56%.
Largest percentage drop-off: Product View → Add to Cart, at 88%. This is the transition highlighted by the workbook’s diagnostic.
Largest absolute loss: Sessions → Product View, with 30,000 sessions not progressing. Product View → Add to Cart loses 17,600 sessions in absolute terms.
Those observations answer different questions. A large percentage loss does not automatically represent the greatest revenue opportunity; a large absolute loss may include visitors who never intended to shop. First assess data quality, traffic intent, potential improvement, implementation cost, and commercial impact.
How to Interpret Ecommerce Funnel Drop-Offs
Use the transitions to decide where to investigate, not to declare a root cause. A concise diagnostic map helps avoid repeating the same speculation in every section.
| Transition | What to investigate first |
|---|---|
| Sessions → Product View | Traffic intent, landing pages, navigation, collections, search and product discovery |
| Product View → Add to Cart | Offer clarity, product content, price, variants, stock, shipping transparency and trust |
| Add to Cart → Begin Checkout | Total costs, delivery promises, cart layout, checkout CTA and guest checkout |
| Begin Checkout → Payment Info | Measurement coverage, form friction, payment choice, mobile UX and technical errors |
| Payment Info → Purchase | Payment declines, authentication, gateway performance, errors and order confirmation |
For a reliable diagnosis, segment the funnel by device, traffic source, landing page, product category, or country when you have sufficient data. Pair quantitative patterns with customer feedback, usability tests, recordings where appropriate, and technical checks.
A drop-off should become a testable hypothesis. For instance: “Shipping cost and delivery timing are not sufficiently visible before Add to Cart.” Then verify the hypothesis before redesigning the entire checkout.
How to Compare Ecommerce Conversion Benchmarks
Benchmarks can supply context, but percentages with different definitions should not be compared directly. For example, Add-to-Cart Sessions ÷ All Sessions is not the same as Add-to-Cart Sessions ÷ Product-View Sessions.
Before using an external reference, compare its numerator, denominator, counting method, time period, industry, market, product price, traffic source, and device mix. Shopify’s 2026 ecommerce conversion-rate guide illustrates how estimates change by sector and methodology.
The workbook’s Benchmark Reference sheet offers external points of reference, not universal targets. Some historical entries are labeled broadly as directly comparable; independently verify the metric definitions and source dates before making that claim. For a structured approach to comparisons, read our Benchmarking in Business guide.
Practical rule: compare your own store’s results across equivalent periods first. Use external benchmarks only when the methodology is sufficiently similar.
Common Mistakes When Analyzing an Ecommerce Funnel
- Mixing units: combining sessions, users, event counts, and orders as if they were interchangeable.
- Ignoring sequence: using separate stage totals that were not filtered to the same ordered purchase path.
- Forcing a payment step: treating an untracked or bypassed
add_payment_infoevent as definite abandonment. - Assuming the biggest drop-off proves a cause: an 88% loss tells you the size of the transition, not why it occurred.
- Using incompatible benchmarks: comparing different denominators, periods, traffic mixes, or markets.
- Changing several elements at once: making it impossible to know which action affected the result.
- Ignoring order economics: improving purchase progression without considering discounts, fulfillment, payment fees, returns, or contribution margin.
A Practical Process to Improve Your Ecommerce Funnel
- Validate tracking. Confirm the reporting period, stage definitions, ordered sessions, and event implementation.
- Locate the weakest transition. Review both percentage drop-off and the absolute number of affected sessions.
- Segment the evidence. Check whether the problem is concentrated in mobile traffic, a channel, or a product category.
- Write a specific hypothesis. Describe a plausible cause that can be checked.
- Prioritize the test. Consider likely impact, uncertainty, cost, implementation effort, and technical risk.
- Make a controlled change. Test one clearly defined improvement when feasible.
- Re-measure. Use comparable data and look for effects on downstream purchases, not merely on one transition.
Example: if shoppers frequently reach product pages but rarely add items to cart, test clearer shipping cost and delivery information near the purchase controls on selected products. Monitor Product View → Add to Cart and eventual purchases; do not assume the intervention will work until it has been measured.
For research-based ways to document and prioritize usability problems, see Baymard’s UX Audit Checklist and Template Framework (2026).
Mini Exercise and Ecommerce Funnel Checklist
For your most recent complete reporting period, perform this short exercise:
- Collect the six stage counts as comparable ordered sessions.
- Validate that each count is a whole number and does not exceed the previous stage.
- Calculate the completion and drop-off rates for each transition.
- Calculate the overall modeled purchase-session rate.
- Identify both the largest percentage loss and the largest absolute loss.
- Check that the Payment Info stage covers the store’s real checkout paths.
- Write one evidence-based hypothesis and choose a metric to measure before and after a test.
The objective is not to eliminate every drop-off. Some visitors are browsing or comparing options. The objective is to improve the parts of the buying process where valid evidence suggests a meaningful, fixable problem.
Free Ecommerce Conversion Funnel Excel Template
Download the free Excel workbook to enter session counts for all six stages, calculate completion and drop-off rates, review data-quality checks, and organize a practical optimization test. The four worksheets have the following functions:
| Worksheet | What it includes |
|---|---|
| Instructions | Definitions, measurement guidance, and a step-by-step workflow |
| Funnel Analysis | Editable stage counts, completion and drop-off formulas, data checks, optional targets, and summary diagnostics |
| Benchmark Reference | External comparison figures and important limitations of comparability |
| Action Plan | Priority transition, hypothesis, test, owner, timing, and before/after learning |
The workbook identifies the transition with the largest measurable percentage drop-off when the data pass its checks. That output is a starting point for investigation, not a demonstrated root cause or automatically the most profitable action.
Before using it: export or prepare one consistent set of sequential session counts. If your reporting tool uses users or raw events, reconcile the definitions first. The Excel workbook does not create or repair GA4 tracking automatically.
Free .xlsx file. Save an untouched copy before replacing the sample data. The existing Benchmark Reference figures should be treated as contextual, not universal performance targets.
Frequently Asked Questions About Ecommerce Conversion Funnels
What Is an Ecommerce Conversion Funnel?
It is a model of the steps shopping sessions take toward a purchase. By measuring how many sessions progress between stages, a store can identify where to investigate potential friction or mismatched visitor intent.
What Are the Six Stages of This Ecommerce Funnel?
Sessions, Product View, Add to Cart, Begin Checkout, Payment Info, and Purchase. This is the six-step model used in the downloadable workbook; real checkout paths may differ.
How Do You Calculate Ecommerce Funnel Drop-Off?
Divide the number of sessions reaching the next stage by those reaching the previous stage, then subtract that percentage from 100%. For example, 2,400 divided by 20,000 equals 12% completion and 88% drop-off.
Why Does the Excel Rate Differ From GA4 Funnel Exploration?
This Excel model uses counts of qualifying sessions in a specified sequence. Native GA4 Funnel Exploration counts users under its configured open or closed funnel rules. They should not be expected to match without aligning the definitions.
What if My Store Skips Payment Info?
Verify how accelerated checkout and digital wallets are tracked. Do not enter a zero or interpret missing add_payment_info data as confirmed abandonment. Revisit the measurement design before applying the fixed six-stage analysis.
Which Funnel Stage Should I Optimize First?
Investigate the transition that combines reliable evidence with meaningful improvement potential. The largest drop-off percentage is a useful starting signal, but it does not determine the best commercial investment on its own.
What Is a Good Ecommerce Conversion Rate?
There is no single rate suitable for every store. Product category, device, traffic quality, price point, repeat purchasing, and measurement definitions all affect the result. Compare consistent internal periods and use relevant external benchmarks cautiously.
Conclusion: Turn Funnel Metrics Into Better Decisions
A useful ecommerce conversion funnel does more than report an overall conversion rate. It shows how purchase progression changes between well-defined stages, separates percentage losses from absolute volume, and supports focused investigation.
Use the free Excel template to organize your six-stage analysis. Start with accurate measurement, develop a testable hypothesis, and evaluate downstream purchasing outcomes before expanding your changes. For a broader view of customer acquisition and revenue, explore the Marketing & Sales resource hub.
References and Further Reading
Baymard Institute — UX Audit Checklist (October 2026): how to investigate and prioritize issues.
Google Analytics — Measure Ecommerce: official documentation for recommended ecommerce events and their implementation.
Google Analytics — Funnel Exploration: official definitions of ordered-user funnels and open versus closed entry rules.
Baymard Institute — How to Reduce Cart Abandonment (May 2026): distinguish user-experience issues from other abandonment reasons.
Baymard Institute — Payment UX (June 2026): research-based recommendations for the payment stage.
Shopify — Ecommerce Conversion Rate: Benchmarks & Tips (August 2026): conversion definitions and limits of comparing stores.
Discover more from
Subscribe to get the latest posts sent to your email.
