For every 100 people who visit an e-commerce site, roughly 2-4 will buy something. The other 96-98 leave at various stages: some bounce immediately, some browse but never add to cart, some add to cart but abandon before checkout, and some start checkout but drop off before payment. Funnel analysis tells you exactly where you are losing customers and helps you prioritize which leaks to fix first.
The Standard E-Commerce Funnel
Most e-commerce funnels have five distinct stages. The specific names may vary by platform, but the structure is consistent:
- Site Visit — User lands on the site from any source
- Product View — User views at least one product detail page
- Add to Cart — User adds at least one item to their cart
- Checkout Initiated — User begins the checkout process (enters shipping info, creates account)
- Purchase Complete — User completes payment
Each stage has a conversion rate (percentage of users who advance from one stage to the next) and a drop-off rate (percentage who leave). The product of all stage conversion rates equals your overall conversion rate.
Example: 10,000 visits × 60% view product × 15% add to cart × 60% initiate checkout × 70% complete purchase = 378 purchases. Overall conversion rate: 3.78%.
Step 1: Build the Funnel With Your Data
Data Requirements
You need event-level data that tracks each user action with a user identifier and timestamp. Most e-commerce platforms and analytics tools capture this:
- Page views: With URL or page type (homepage, category, product, cart, checkout, confirmation)
- E-commerce events: product_view, add_to_cart, begin_checkout, purchase
- User identifier: Session ID at minimum, user ID when available for logged-in users
- Timestamps: When each event occurred, for time-based analysis
- Source/medium: How the user arrived (organic, paid, email, social, direct)
Constructing the Funnel
A funnel query counts unique users (or sessions) at each stage. The critical detail is how you define the funnel: strict or flexible.
Strict funnel: User must complete stages in exact order. Visit → Product View → Add to Cart → Checkout → Purchase. A user who adds to cart without viewing a product detail page (possible if they use search and quick-add) would not be counted.
Flexible funnel: User must reach each stage at some point during the session, regardless of order. This is more forgiving and usually produces a more accurate picture of the customer journey.
For most e-commerce analyses, a flexible funnel is more useful because real shopping behavior is not strictly linear. Users browse, compare, go back, add, remove, and eventually buy through a winding path.
Connecting the Data to clariBI
If your e-commerce data lives in a database (common for custom platforms) or if you can export it from your analytics tool, connect it as a data source in clariBI. The AI assistant can then answer questions like "What is the conversion rate from add-to-cart to purchase this month?" or "Show me the funnel drop-off by traffic source." See the data source connection guide for setup.
Step 2: Identify the Biggest Drop-Off
Once you have the funnel built, look at where the largest absolute and relative drops occur.
Visit to Product View
Typical range: 40-70% conversion. High drop-off here means:
- Landing pages do not match user intent (ad promised one thing, page shows another)
- Navigation is confusing — users cannot find what they are looking for
- Site speed is slow — users leave before content loads
- Homepage or category pages are not compelling enough to click into products
Product View to Add to Cart
Typical range: 8-20% conversion. This is usually the largest drop-off by percentage because it is the first point of commitment. Drop-off reasons include:
- Price is higher than expected
- Insufficient product information (no size guide, unclear specifications, few images)
- Out-of-stock in the desired variant
- No reviews or social proof
- Shipping cost surprises (displayed after clicking "add to cart")
Add to Cart to Checkout Initiated
Typical range: 40-70% conversion. Users who add to cart have shown intent but have not committed. Common barriers:
- Cart is used as a "wishlist" or "save for later" with no real purchase intent
- Shipping costs revealed at cart stage create sticker shock
- No guest checkout option — requiring account creation adds friction
- Expected delivery time is too long
- Discount code field is visible but the user does not have a code (sends them to Google for coupons, where they may find a competitor)
Checkout Initiated to Purchase Complete
Typical range: 50-80% conversion. Users who start checkout are very close to buying. Drop-off at this stage is particularly costly because you have invested the most in getting them here. Common causes:
- Payment declined or preferred payment method not available
- Form is too long or requires information the user does not have handy
- Unexpected taxes, fees, or surcharges
- Security concerns (no SSL indicator, unfamiliar payment processor)
- Site error or crash during checkout
Step 3: Segment the Funnel
Overall funnel conversion rates hide significant variation across segments. Break the funnel by:
Traffic Source
Compare funnels for organic search, paid search, email, social, and direct traffic. You will often find that email traffic converts at 2-3x the rate of social traffic because email subscribers have higher intent. This affects how you value each channel and how you allocate spending.
Device Type
Mobile, desktop, and tablet funnels often look radically different. Mobile typically has lower conversion rates, especially at the checkout stage where form entry is harder on a small screen. If your mobile checkout conversion is significantly below desktop, mobile UX optimization is a high-impact area.
New vs. Returning Visitors
First-time visitors convert at a fraction of the rate of returning visitors. This is normal — first visits are often research, and the purchase happens on a subsequent visit. Track the funnel for each to set appropriate expectations and target your optimization efforts.
Product Category
High-consideration products (electronics, furniture) have different funnel shapes than impulse purchases (accessories, consumables). Segment by category to understand where category-specific interventions are needed.
Step 4: Quantify the Revenue Impact
Funnel analysis becomes actionable when you attach revenue to each stage. Calculate the revenue impact of improving each step:
Revenue uplift = Current visitors × Improvement in conversion rate × Average order value
Example: You have 100,000 monthly visits. Your product-view-to-add-to-cart rate is 10%. If you improve it to 12% (a 2 percentage point improvement), you get 2,000 additional add-to-cart events per month. If 40% of those eventually purchase at a $75 average order value, that is 800 × $75 = $60,000 in additional monthly revenue.
This quantification helps you prioritize. A small improvement at a high-volume stage often generates more revenue than a large improvement at a low-volume stage.
Step 5: Optimize Each Stage
Improving Visit to Product View
- Match landing page content to ad messaging — if the ad mentions "summer dresses," the landing page should show summer dresses, not the homepage
- Improve site search — users who search convert at 2-5x the rate of browsers, so make search prominent and accurate
- Reduce page load time — every additional second of load time drops conversion by 7-10%
- Show best-sellers and personalized recommendations on category pages
Improving Product View to Add to Cart
- Display shipping cost and delivery estimate on the product page, not as a surprise later
- Add customer reviews and ratings prominently
- Include multiple high-quality images and, where applicable, video
- Show clear size guides, compatibility information, and product specifications
- Add urgency signals when genuine (limited stock, sale ending)
Improving Add to Cart to Checkout
- Offer guest checkout — do not require account creation
- Remove or minimize the discount code field (test hiding it behind an expandable link)
- Show a progress indicator so users know how many steps remain
- Implement cart abandonment emails for logged-in users
Improving Checkout to Purchase
- Minimize form fields — only ask for what you truly need
- Support multiple payment methods (credit card, PayPal, Apple Pay, Google Pay)
- Display security badges and trust indicators near the payment form
- Ensure the checkout page works perfectly on mobile
- Implement real-time form validation so errors are caught immediately, not after submission
Monitoring Over Time
Set up a recurring funnel dashboard in clariBI that updates daily or weekly. Track:
- Overall conversion rate trend
- Stage-by-stage conversion rates with week-over-week comparison
- Segmented funnels by source, device, and customer type
- Revenue impact of conversion rate changes
Configure alerts for significant drops at any stage. A sudden 10% decrease in checkout completion might indicate a payment processing issue, a broken form field, or a site error that needs immediate attention.
Funnel analysis is not a one-time exercise. Customer behavior, traffic composition, and site changes all affect conversion rates continuously. Build the dashboard, review it weekly, prioritize the highest-impact fixes, test improvements, and measure the results. The compounding effect of consistent small improvements across all funnel stages produces significant revenue growth over a year.