learn-metric-decomposition-with-phoebe / Builder session 1 of 10
Learn Metric Decomposition with Phoebe · Builder track · Session 1 of 10

Your first driver tree

"Sales are down 8%." That sentence is useless on its own - it names an outcome, not a cause. A driver tree breaks a top-line metric into the levers that actually move it, so a drop becomes a path you can trace instead of a mystery you argue about. Today you build one live: an online store's GMV, split into the three drivers underneath it, in a simulator you can poke.

🟢 Builder track Analysts · PMs · founders · ops Live tree simulator + SQL Start here
0-3 · Welcome 3-18 · What a driver tree is 18-42 · Build & break a GMV tree 42-45 · Q&A
Part 0

How this track works

Ten builder sessions, one skill: take any top-line business metric, break it into the drivers beneath it, and use that tree to diagnose a drop in minutes. You will learn the three decomposition patterns (b2), how to find leading indicators and run the diagnosis playbook (b3), then apply all of it to six real domains - ecommerce (b4), marketing (b5), branding (b6), internet/traffic (b7), B2B SaaS (b8), and B2G (b9) - before a capstone where a metric drops and you diagnose it end to end (b10). The leader track (a1-a6) teaches the same thinking for reading trees and running the weekly and monthly metric reviews.

Live - presented in session Self-study - read after class ▶ Live tree - editable & runnable Framework sources covered
★ What you walk out with today A working mental model of a driver tree, the ability to read GMV = Traffic x Conversion x AOV as a chain of levers, and a live simulator where you knock one driver down and watch the top line fall - the exact muscle a metric review needs.
Part 1 · covers Lean Analytics, the DuPont decomposition heritage

A metric is a chain of drivers 7 min live

Almost every top-line number is a product or a sum of smaller numbers. GMV is not a thing you control directly - it is what you get when traffic, conversion rate, and average order value multiply together. Each of those is itself controllable, measurable, and ownable. The tree just writes that relationship down so everyone argues about the same picture.

GMV $208K / mo Traffic 120,000 visits Conversion 2.8% Avg order value $62 x x 120,000 x 2.8% x $62 = $208,320. Change any one lever and the top line moves by the same ratio.
🔍 Click to zoom - GMV is not one number, it is three drivers multiplied
LiveWhy "sales are down" is a useless sentence3 min

A top-line metric is a lagging outcome - it tells you what happened, never why. Two companies can both report "GMV down 8%" for completely opposite reasons: one lost traffic while conversion held; the other kept traffic but conversion cratered. Same symptom, different disease, different fix. The tree is what lets you tell them apart in thirty seconds instead of a week of meetings.

  • The top line is the outcome you report to the board - GMV, revenue, ARR, bookings.
  • The drivers are the levers teams actually pull - traffic (marketing owns it), conversion (product owns it), AOV (merchandising owns it).
  • Decomposition assigns the drop to a lever, and a lever to an owner. That is the whole point.
Real world

The DuPont move, a century old and still undefeated. In the 1910s DuPont broke "return on equity" into margin x turnover x leverage - the first famous driver tree. Every metric framework since (Lean Analytics, Amplitude's North Star, an Amazon weekly business review) is the same idea: never stare at a top-line number, always break it into the levers underneath.

Self-studyLeading vs lagging, previewed2 min read

Inside the tree hides the distinction that session a2 and b3 make central. GMV is a lagging indicator - it moves after the fact. But traffic is more leading than GMV, and further down the tree, "ad impressions" or "email sign-ups" lead traffic. The deeper you go, the earlier the warning. You steer by the leading drivers near the leaves and report the lagging number at the root.

  • Root of the tree: lagging, board-facing, slow to move.
  • Leaves of the tree: leading, team-facing, quick to move and quick to warn.
  • The skill: push your tree deep enough that the leaves give you early signal, not just after-the-fact accounting.
Part 2 · covers the multiplicative pattern (rate x volume)

The multiplicative tree, and why ratios matter 5 min live

GMV = Traffic x Conversion x AOV is a multiplicative tree: the top line is the product of its drivers. Its defining property - the one that makes diagnosis fast - is that a percentage change in any single driver flows straight to the top line as the same percentage. Traffic down 10% with everything else held? GMV down 10%. That clean pass-through is exactly what you exploit when a metric falls.

LiveThe pass-through rule2 min

In a pure product, the percentage moves add up. If traffic falls 10% and conversion falls 5%, the top line falls roughly 15% (10 + 5), not 50%. That approximation holds for the small moves you see week to week, and it is why a multiplicative tree lets you literally read the drop off the branches: sum the percentage changes down the guilty path and you have explained the fall.

The pass-through rule: percentage moves simply add up Traffic -10% Conversion -5% GMV (combined) -15% Traffic -10% and conversion -5% combine to roughly -15% off GMV - percentages simply add.
🔍 Click to zoom - two small drops down the tree add up, they do not multiply
The one trap Percentages, not absolute values, are what pass through cleanly. A "10-point" swing means nothing until you know 10 points of what. Always diagnose a multiplicative tree in percentage change per driver - the simulator below reports exactly that.
Demo 1 of 2

Build it, then break it ★ 12 min · everyone builds

Here is the GMV tree as a live simulator. Every leaf is editable and every parent recomputes instantly. First read it, then edit a driver and watch the top line move, then press Simulate a drop - one driver gets knocked down at random and the whole path from that leaf up to GMV lights coral. Your job: name the guilty driver from the trail, every time.

{
  "unit": "$",
  "root": {
    "label": "GMV", "op": "x",
    "children": [
      { "label": "Traffic",     "value": 120000, "unit": "visits" },
      { "label": "Conversion",  "value": 0.028,  "pct": true },
      { "label": "Avg order value", "value": 62, "unit": "$" }
    ]
  }
}

Read the baseline: 120,000 visits x 2.8% x $62 = about $208K. That is GMV at rest.

Edit one leaf - drop Conversion from 2.8 to 2.5 - and watch GMV fall and the delta chip appear. That is a controlled experiment.

Edit one leaf: drop Conversion from 2.8% to 2.5% and watch GMV fall ✓ Baseline conversion 2.8% 120,000 visits x 2.8% x $62/order = 3,360 orders at $62 average GMV = $208,320 ✗ Conversion drops to 2.5% 120,000 visits x 2.5% x $62/order = 3,000 orders at $62 average GMV = $186,000 (down 10.7%) A 0.3-point conversion drop cuts GMV 10.7% - traffic and AOV never moved.
🔍 Click to zoom - a 0.3-point conversion drop cuts GMV 10.7%, nothing else moved

Press Simulate a drop. A random driver falls. Read the coral trail: which leaf moved, and by what percent?

Say the diagnosis out loud: "GMV fell X% because [driver] fell Y%." Press Reset and do it again until it is automatic.

Real world

This is a metric review in miniature. When an ecommerce team opens Monday's dashboard and GMV is down, the good analysts are not smarter - they just have this tree memorised. They glance at three drivers, spot the one that moved, and route the question to its owner before anyone finishes their coffee. You are building that reflex now.

Demo 2 of 2

One level deeper: segment to find the culprit ★ 10 min · everyone builds

The tree tells you which driver fell. Segmentation tells you where. If conversion dropped, was it every channel or just one? Real diagnosis ends in a GROUP BY. These editors run live SQL against a small store's orders - the same move you make when the tree points at a guilty driver.

LiveRevenue by channel - is the fall everywhere or somewhere?4 min

The tree flagged a driver. Now split it. Run this to see revenue split by channel - the first cut any analyst makes when a top-line metric drops.

SELECT o.channel,
       COUNT(DISTINCT o.order_id)             AS orders,
       ROUND(SUM(oi.quantity * oi.unit_price), 0) AS revenue
FROM orders o
JOIN order_items oi ON o.order_id = oi.order_id
WHERE o.status = 'completed'
GROUP BY o.channel
ORDER BY revenue DESC;
The diagnosis chain Tree points at the driver -> segment splits the driver by dimension -> the outlier segment is your lead. Tree first (which lever), SQL second (which slice). Never skip to SQL before the tree tells you where to look.
LiveYour turn: split AOV instead3 min
SELECT o.channel,
       ROUND(SUM(oi.quantity * oi.unit_price) * 1.0
             / COUNT(DISTINCT o.order_id), 2) AS avg_order_value
FROM orders o
JOIN order_items oi ON o.order_id = oi.order_id
WHERE o.status = 'completed'
GROUP BY o.channel;
Homework

Try it yourself - this week ◐ 20-30 min total

Framework sources

Frameworks this session draws on

Metric decomposition has no single certificate - it is a craft distilled from a handful of durable frameworks. This track teaches the working core of these, applied live instead of described. This page draws on:

Lean Analytics (Croll & Yoskovitz) - the one metric that matters, per business modelPart 1 · why a top-line splits into ownable drivers
DuPont analysis - the original driver-tree decompositionPart 1 · the century-old multiply-the-levers move
Amplitude North Star Playbook - inputs that move the outputSelf-study card · leading inputs vs lagging output; full treatment in b3
Amazon Weekly Business Review - reading trees on a cadenceDemo 1 · the review reflex; the full ritual is leader session a5
Check yourself

Three questions before you go 🎯 ◐ 90 seconds

1 · Why is "GMV is down 8%" not enough to act on?

A top-line metric is a lagging outcome. The driver tree turns the drop into a specific lever (traffic, conversion, AOV) owned by a specific team - which is what you can actually act on.

2 · In GMV = Traffic x Conversion x AOV, traffic falls 10% and nothing else changes. GMV falls...

In a multiplicative tree a percentage change in a single driver flows to the top line as the same percentage. That clean pass-through is what makes diagnosis fast.

3 · The tree says conversion is the guilty driver. What is the next move?

Tree points at the driver; segmentation finds where. A GROUP BY on the guilty driver isolates the slice - one channel, one device, one cohort - before you spend a cent fixing anything.

Builder session 1 cheat sheet · pin this

Driver treeA top-line metric broken into the levers that multiply or sum to make it. Outcome at the root, levers at the leaves.
GMV treeGMV = Traffic x Conversion x AOV. Marketing, product, and merchandising own one lever each.
Lagging vs leadingRoot = lagging outcome (reports late). Leaves = leading drivers (warn early). Steer by leaves, report the root.
Multiplicative pass-throughIn a product tree, a % change in one driver ≈ the same % change in the top line. Sum the % moves down the guilty path.
Diagnose in percentagesAbsolute swings mislead. Always read a drop as % change per driver - that is what passes through cleanly.
Tree then segmentTree says which driver. GROUP BY says which slice. Never SQL-first - let the tree aim you.
Every driver has an ownerDecomposition assigns a drop to a lever and a lever to a team. Ownerless drivers go unwatched.
Running skillBuild the tree, break it, name the culprit. Next: b2, the three decomposition patterns.