Funnel Chart for E-Commerce Checkout — Cart Abandonment & Purchase Flow
An e-commerce checkout funnel chart tracks shopper progression from product impression to completed order ($CR = Orders / Sessions$) to pinpoint cart and checkout abandonment stages.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 |
Add-to-Cart Rate = AddToCart / PDP_Views. Cart Abandonment Rate = (1 - (Orders / AddToCart)) * 100%. Store Conversion Rate = (Orders / PDP_Views) * 100%.
Chart Design & Use-Case Tips
- 01Add-to-Cart Rate = AddToCart / PDP_Views. Cart Abandonment Rate = (1 - (Orders / AddToCart)) * 100%. Store Conversion Rate = (Orders / PDP_Views) * 100%.
- 02Cart Abandonment Rate equals `1 - (Order Confirmed / Added to Cart)`—in the sample dataset, 2,480 / 10,200 = 24.3% checkout completion (75.7% cart abandonment).
- 03A steep drop between Cart Review and Shipping Entered usually signals unexpected shipping fees or forced account creation.
- 04Compare Apple Pay / Shop Pay express checkout funnels against guest checkout.
Frequently Asked Questions
What is the average e-commerce cart abandonment rate?+
Across global e-commerce benchmarks (Baymard Institute), roughly 68% to 75% of shoppers who add an item to their cart leave before completing payment.
Why separate 'Payment Submitted' from 'Order Confirmed'?+
A drop between Payment Submitted and Order Confirmed exposes payment gateway declines, 3D Secure friction, or card processor errors that are invisible to UX designers.
Can I paste Shopify Analytics funnel numbers directly?+
Yes, copy your Shopify conversion funnel metrics and paste them into the CSV/TSV Workbench.