How Funnel Analysis Can Unlock E‑commerce Conversion: A Taobao Case Study

1. What Is Funnel Analysis

Funnel analysis is a systematic data‑analysis process that visualizes user behavior steps and conversion rates from start to end, helping to assess user flow and identify drop‑off points. It is widely used in the internet industry for traffic monitoring and conversion optimization.

2. Core Steps of Funnel Analysis

The four key elements are:

Research object (analysis dimension, e.g., users, products, orders)

Time period (start and end of the event)

Nodes (critical steps in the process, including start, end, and intermediate nodes)

Metrics (quantitative indicators that describe the funnel)

Based on these, the core steps are:

Define the research object and select analysis dimensions.

Set the event’s start and end times.

Break down the user path and identify key nodes.

Specify key metrics to fully characterize the business and guide optimization.

3. Detailed Funnel‑Analysis Example: Taobao Reverse Logistics

3.1 Business Background

Taobao’s reverse logistics includes three services: door‑step return, door‑step exchange, and interception. The door‑step exchange is newly launched and requires systematic analysis to improve exchange success rate and on‑site pickup penetration.

3.2 Indicator System

The indicator system tracks the entire exchange process, focusing on exchange success rate (completed orders ÷ buyer‑initiated exchanges) and door‑step pickup penetration (on‑site pickups ÷ buyer‑initiated exchanges).

3.3 Current Situation and Problem Exploration

Two main problems were identified:

Exchange success rate is high (94.5%) but still has a 5.5% loss that could be recovered.

Door‑step pickup penetration (45.78%) lags behind the return service (55.86%), a gap of 10.08%.

3.4 Locating Issues with Funnel Analysis

By mapping the exchange path, the analysis pinpointed factors affecting the two key metrics, such as merchant refusal, buyer refusal, cancellations, and overdue shipments.

3.5 Hypothesis Verification

Factors affecting exchange success rate: merchant refusal due to damaged goods, incomplete branding, non‑new items, or wrong tracking numbers; buyer refusal linked to a 54.31% repurchase rate, suggesting buyers prefer returns.

Factors affecting door‑step pickup penetration: buyer cancellations (68.92% repurchase rate) and overdue shipments (only 26.79% freight‑insurance coverage).

3.6 Recommendations

To improve exchange success rate, introduce end‑point inspection services and tracking‑number verification. For higher pickup penetration, increase freight‑insurance coverage, offer on‑site pickup coupons, and send reminder SMSes.

4. Conclusion

Funnel analysis is essential for visualizing user flows, defining monitoring metrics, locating bottlenecks, and validating hypotheses with data. Applying it to Taobao’s door‑step exchange reveals actionable insights that can boost both exchange success rate and pickup penetration.