KPI Trees for E-Commerce

The E-Commerce Revenue Equation

Every e-commerce business follows the same fundamental equation:

Revenue = Traffic × Conversion Rate × Average Order Value

This three-branch decomposition is the starting point for every e-commerce KPI tree. Each branch maps to a different function: marketing drives traffic, product and UX drive conversion, and merchandising drives AOV.

Traffic Decomposition

Traffic breaks down by source:

• Organic = SEO impressions × click-through rate
• Paid = ad spend ÷ cost per click
• Direct = brand awareness and repeat visits
• Referral = partner traffic and affiliates
• Email = list size × open rate × click rate

This decomposition shows where customers come from and what each channel costs. When traffic drops, the tree immediately shows which channel is responsible.

Conversion Rate Decomposition

Conversion rate is not a single metric. It is a funnel:

Conversion Rate = Product View Rate × Add-to-Cart Rate × Checkout Start Rate × Checkout Completion Rate

Each step in the funnel has different drivers. Product view rate depends on site navigation and search. Add-to-cart depends on product pages and pricing. Checkout completion depends on payment options and shipping costs.

AOV Decomposition

Average order value breaks into:

AOV = Items per Order × Average Item Price

Items per order depends on cross-sell and bundle effectiveness. Average item price depends on product mix and discounting strategy.

Putting It Together

A complete e-commerce KPI tree has 15 to 25 nodes across 3 to 4 levels. The power is in the structure: when revenue drops, you do not guess. You check traffic (stable?), conversion (down?), and AOV (flat?). Then you drill into the branch that moved.

E-Commerce-Specific Tips

1. Segment by device. Mobile and desktop have different conversion patterns.
2. Include return rate. Net revenue = gross revenue × (1 - return rate).
3. Track new vs returning customer revenue separately. The acquisition cost structures are fundamentally different.