learn-ecommerce-metrics-with-phoebe / Analyst session 5 of 8
Learn Ecommerce Metrics with Phoebe · Analyst track · Session 5 of 8

Diagnose the drop

It is Monday morning. GMV is down 12% week over week, Slack is on fire, and three teams are already blaming each other's launch. Nobody actually knows why. This session gives you the five-step diagnosis workflow that turns that panic into a finding - and you practice it on the live tree until naming the guilty lever takes you minutes, not meetings.

🟡 Analyst track Analysts · marketers · ops · founders ▶ Live tree simulator 45 min
0-3 · Welcome 3-15 · The five-step workflow 15-42 · Live diagnosis drills 42-45 · Q&A
Part 0

Where you are

You can build the GMV tree (b3) and you know what each funnel gate measures (b4). Today those two skills earn their keep: a real-looking drop lands, and you walk it down the tree until it has a name, a size, an owner, and a fix date. This is the second live-simulator session - the same funnel-deep tree from b3 returns as your diagnosis scratch pad.

Live - presented in session Self-study - read after class ▶ Live tree - editable & runnable Sources covered
★ What you walk out with today A five-step drop-diagnosis workflow you can run before the 10am standup, hands-on practice recreating single and compound drops in the live tree, and a one-paragraph finding template that ends the Slack argument instead of feeding it.
Part 1 · the scenario and the workflow

Monday, 9:04am: GMV is down 12% 12 min live

The dashboard says Mango Lane's GMV fell 12% week over week. Marketing suspects the site redesign, product suspects the new ad audience, and the founder suspects everything. The worst response is to guess. The best response is a fixed walking order - the same five steps, every drop, every time - so the answer arrives before the opinions harden.

1 · Is it real? Tracking? Season? a5's YoY rule first 2 · Which lever? Top tree sessions / CR / AOV 3 · Which gate? Deep tree the four funnel gates 4 · Which slice? Segments channel · device (b6) 5 · Size + write The finding owner + re-check most drops die here pass-through math names the owner locates the break ends the argument Fixed order, every time. Skipping step 1 is how teams spend a week fixing a drop that never happened.
🔍 Click to zoom - the five-step diagnosis walk: real, lever, gate, slice, finding
StepThe questionThe toolWhat you get
1 · Real?Tracking change? Seasonal gravity?Deploy log + a5's YoY comparisonPermission to proceed - or to stand down
2 · LeverSessions, CR, or AOV?Top tree + pass-through mathThe guilty lever
3 · GateWhich funnel gate?Deep tree (the b3 simulator below)The owning team
4 · SliceWhich channel / device / cohort?Segment cuts (b6)The location of the break
5 · WriteSo what, who, by when?The finding template (Demo 2)One paragraph that ends the thread
LiveStep 1 - confirm the drop is real4 min▶

Before touching the tree, rule out the two impostors:

  • Tracking changes. Did anything ship last week that touches the analytics tags - a site release, a consent-banner change, an app update? A drop that starts the exact hour of a deploy is a tracking suspect until proven otherwise.
  • Seasonal gravity. a5's rule: compare year over year, not just week over week. If GMV falls 12% WoW every first week of the month (payday cycles, promo calendars), the drop is the calendar, not the business. Same week last year down a similar amount? Stand down.

Only when the drop survives both checks do you open the tree. Most Monday panics do not survive them.

LiveSteps 2-5 - walk the tree, then write4 min▶

Step 2 - top tree. GMV = sessions x session CR x AOV. Compute each driver's WoW percentage change. By b3's pass-through rule, the driver moves should roughly sum to the GMV move. One of the three will stick out.

Step 3 - deep tree. If CR is the guilty lever, open it into the four gates: PDP penetration, add-to-cart, checkout start, checkout completion. The gate that moved is the gate that names the owning team.

Step 4 - segments. Cut the guilty gate by channel, device, and new vs returning to find WHERE it broke. That is b6's whole session - today you just note the pointer.

Step 5 - size it and write the finding. One paragraph: what fell, by how much, traced to what, suspected cause, owner, action, re-check date. Demo 2 gives you the template.

Self-studySizing: turn the percent into dollars3 min read▶

"GMV fell 12%" gets attention. "This costs us about $79,000 a month if it holds" gets a fix scheduled. Sizing is one multiplication: the percentage fall x the baseline. At Mango Lane, 12% x $660,960 = $79,315 per month of run-rate GMV at risk.

  • Sizing sets priority. A $79K/month leak justifies pulling an engineer off the roadmap tonight; a $2K/month leak joins the backlog. Without the dollar figure, urgency is decided by whoever shouts loudest.
  • Size the fix window too. If the drop started Friday and gets fixed Thursday, the realized cost is roughly a week's slice, not the monthly figure. Say both numbers - "about $18K lost so far, $79K/month pace if unfixed".
  • Round honestly. $79,315.20 pretends to a precision the estimate does not have. "About $79K" is the analyst's number.
Demo 1 of 2

Recreate the drop in the live tree ★ 15 min · everyone builds

The funnel-deep tree from b3 returns, at Mango Lane's healthy baseline. Your job today is the reverse of b3: there you broke the tree to see what happens; here you are handed what happened and must find the break that produces it. That reversal is diagnosis.

{
  "unit": "$",
  "root": {
    "label": "GMV", "op": "x",
    "children": [
      { "label": "Orders", "op": "x", "unit": "orders", "children": [
        { "label": "Sessions",          "value": 360000, "unit": "sessions" },
        { "label": "PDP penetration",   "value": 0.40, "pct": true },
        { "label": "Add-to-cart rate",  "value": 0.25, "pct": true },
        { "label": "Checkout start",    "value": 0.45, "pct": true },
        { "label": "Checkout completion","value": 0.60, "pct": true }
      ] },
      { "label": "AOV", "value": 68, "unit": "$" }
    ]
  }
}

Drill 1 - the single-lever drop. Recreate Monday's report: cut Checkout completion from 60 to 52.8 (that is exactly -12%). Confirm GMV shows -12%. One lever, full pass-through - if the whole 12% traces to one gate, your diagnosis is already 80% written.

Drill 2 - the compound drop. Reset. Now cut Sessions by 5% (360,000 to 342,000) AND Add-to-cart from 25 to 23.25 (that is -7%). Confirm GMV shows about -11.7%: 0.95 x 0.93 = 0.8835. Real drops are often two medium moves, not one big one - the pass-through math is how you check your explanation actually adds up.

Two ordinary-looking dips compound into the real drop Sessions -5% Add-to-cart -7% Combined GMV fall -11.7% Neither -5% nor -7% alone triggers an alert - together they multiply to -11.7%, the whole story.
🔍 Click to zoom - two unremarkable dips can multiply into the whole drop

Drill 3 - the reflex builder. Reset, then press Simulate a drop repeatedly. Each time, race to name the guilty gate out loud before reading the note. Ten rounds of this and the walk from "GMV fell" to "checkout completion fell" stops being a procedure and becomes a reflex.

Real world

Why checkout gets checked early: checkout is where the most machinery lives - payment providers, address validation, promo codes, 3-D Secure - and industry-wide about 70% of carts are already abandoned there in the best of times (Baymard Institute's running average is 70.22%). A gate that fragile plus a Friday-evening payment deploy is the single most common true answer to a Monday GMV drop.

Self-studyWhy compound drops fool smart people3 min read▶

Drill 2's drop is sneakier than drill 1's, and it is worth naming why. A single -12% lever screams from the dashboard. Two levers at -5% and -7% each look like ordinary weekly wobble on their own charts - neither triggers an alert, neither gets a Slack thread - yet together they produce almost the same top-line damage.

  • Do not stop at the first suspect. Finding one lever down 5% does not explain a 12% drop. Run the pass-through check: do the falls you found multiply out to the fall you are explaining? 0.95 alone = -5%. Not enough. Keep walking.
  • Compound drops often mean compound causes. Sessions -5% (a paused campaign) and add-to-cart -7% (a PDP image bug) can land the same week by pure coincidence. One finding per cause, two owners, two re-check dates.
  • The tree keeps you honest both ways: it stops you blaming one lever for everything, and stops you declaring victory at half an explanation.
Demo 2 of 2

Write the finding ★ 10 min · everyone writes

A diagnosis that lives in your head ends nothing. The deliverable is one paragraph, posted where the argument is happening. Same skeleton every time - fill the brackets and hit send.

LiveThe one-paragraph finding template4 min▶

"GMV fell [X]% WoW. The drop traces to [lever/gate], which fell [Y]% ([baseline] -> [now]). [Slice detail if known]. Suspected cause: [hypothesis]. Owner: [team]. Action: [fix]. Re-check: [date]."

Every bracket is a claim you can defend from the tree. No adjectives, no blame, no "it seems" - numbers, a name, and a date.

LiveThe template filled in - Monday's drop4 min▶

"GMV fell 12% WoW. The drop traces to checkout completion, which fell 12% (60% -> 52.8%). Concentrated in mobile sessions paying by card. Suspected cause: payment provider latency spike after Friday's gateway update. Owner: payments team. Action: roll back the gateway config and re-test the card flow. Re-check: Thursday's numbers, posted here."

Notice what this paragraph did to the Slack thread: marketing's redesign and the new ad audience are both off the hook without anyone arguing, and there is exactly one next step with exactly one name on it.

The bar for a finding A finding names a lever, a size, an owner, and a re-check date - or it is just vibes. If any of the four is missing, you are not done diagnosing; you are contributing to the thread.
Self-studyKeep a finding log3 min read▶

Post the finding where the argument is happening, then copy it into one running document - a simple dated list of every finding you have written. Three payoffs arrive within a quarter:

  • Repeat offenders surface. If checkout completion stars in four findings in three months, the payment stack needs a project, not another rollback. The log turns incidents into a pattern.
  • Re-check dates actually get checked. A finding with a date in a log is a finding someone follows up on. A finding in a scrolled-away Slack thread is a wish.
  • Your hit rate becomes visible. When the Thursday re-check confirms the fix, say so in the log. A track record of confirmed findings is what makes the next one believed on sight - and it feeds directly into b7's weekly review pack.
Part 4 · the drops that are not drops

False positives self-study

Self-studyWhen the tracking breaks, not the business4 min read▶

The nastiest false positive: a tracking outage masquerading as a conversion drop. The purchase events stop arriving - a tag broken by a release, a consent change, an SDK update - but the orders keep landing in the payment and order systems just fine. Your dashboard shows checkout completion cratering; your warehouse is shipping at full speed.

Order-system orders normal? Measurement problem Tag broke, not demand Sharp cliff at a deploy? Deploy broke it - check release logs Real sloping demand - run the b3-b5 tree yes no yes no Analytics down, orders steady means the tag broke, not demand - check that before writing a finding.
🔍 Click to zoom - before writing a finding, rule out a tracking outage first
  • The cross-check: before declaring a business problem, compare event-counted orders (from analytics) against order-system orders (from the platform's order admin or finance) for the same period. If the order system shows normal volume while analytics shows a cliff, you have a measurement problem, not a demand problem.
  • The tell: tracking breaks tend to be sharp cliffs starting at a deploy timestamp, often on one platform (app vs web) only. Real demand problems usually slope.
  • The payoff: this one check has saved more analyst credibility than any model ever built. Declaring a fake drop real burns trust in every future finding you write.
Homework

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

Sources

Sources this session draws on

Diagnosis is a craft workflow built on the course's own earlier machinery plus one industry benchmark. This page draws on:

✓The pass-through rule (b3) - percentage moves in a multiplicative tree flow to the top lineSteps 2-3 and both compound-drop drills
✓Baymard Institute - 70.22% average cart abandonment (50-study average, updated Sep 2025)Demo 1 · why checkout is the usual first suspect
✓The YoY seasonality rule (a5) - compare against last year before calling a WoW move realStep 1 · the seasonal-gravity check
◐The tracking-outage false-positive pattern - craft knowledge from practice, not a published standardPart 4 · the events-vs-orders cross-check
Check yourself

Three questions before you go 🎯 ◐ 90 seconds

1 · GMV is down 12% WoW. What is the very first thing you do?

Step 1 always comes first: rule out tracking changes and seasonal gravity (a5's YoY rule) before opening any tree. Most Monday panics die at step 1 - and diagnosing a drop that never happened costs a week.

2 · Sessions fall 5% and add-to-cart falls 7% in the same week. GMV falls about...

Multiply the survival rates: 0.95 x 0.93 = 0.8835, so GMV lands at 88.35% of baseline - a fall of about 11.7%. Small percentage moves roughly add (5 + 7 = 12 is close), but the multiplication is the exact check.

3 · Which of these is a complete finding?

A finding names a lever, a size, an owner, and a re-check date. Option B has all four. The others are vibes - no owner, no size, no date, no end to the Slack thread.

Analyst session 5 cheat sheet · pin this

The five steps1 real? 2 which lever (top tree) 3 which gate (deep tree) 4 which slice (segments) 5 size it + write the finding.
Step 1 gateTracking change at a deploy timestamp? Seasonal gravity (a5's YoY rule)? Most reported drops die here.
Pass-through checkDriver percentage falls should multiply to the GMV fall: 0.95 x 0.93 = 0.8835 means about -11.7%. If they don't, keep looking.
Single vs compoundOne lever at -12% and two levers at -5% and -7% look identical at the top line. Only the tree walk tells them apart.
Gate = ownerPDP penetration - navigation. Add-to-cart - PDP/merch. Checkout start - cart UX. Completion - payments. Name the gate, name the team.
The finding templateFell X% -> traces to [lever] -Y% (baseline -> now) -> suspected cause -> owner -> action -> re-check date.
The finding barLever + size + owner + re-check date, or it is just vibes. All four or keep working.
False-positive checkCompare event-counted orders vs order-system orders before declaring a business problem. Cliffs at deploy time = tracking.