learn-ship-platform-diagnosis-with-phoebe / Chairman session 2 of 3
Learn Ship Platform Diagnosis with Phoebe · Chairman track · Session 2 of 3

What went right, what went wrong

Session c1 handed you the map. This session walks it. Two servers sold the same volume at the same prices and lost thirteen margin points in one month; nobody looked because revenue kept climbing. Two quarters later their customers stopped coming back, then their merchants left, then their stores went quiet on paper without anyone closing them. And then, on the same data with the same rigour, four findings that point at growth rather than repair. Every finding lands as one sentence with a number in it, and you will write six of them yourself before the hour is out.

🟡 Chairman track Chairman · C-level · board · no code Findings focus 45 min
0-3 · Welcome 3-22 · What went wrong 22-40 · What went right 40-45 · Q&A
Part 0

Where this session sits

The chairman storyline has six acts. Session c1 played the first two: what a short window hides, and the platform in one picture. Today is acts three, four and five - the break, the lag, and the turn to what went right. Session c3 plays act six and converts every finding here into a decision with an owner, a number and a review date. The analyst track builds every chart on this page in Python from the same order lines; your job is to read them harder than anyone else in the room.

Live - presented in session Self-study - read after class Sources covered
★ What you walk out with today The break named by its mechanism - cost, not price, not volume, not mix - and priced: 251k of profit over thirty months, with the assumption doing the work stated out loud. The lag read as a chain of dated symptoms rather than three separate surprises. And four growth findings you can spend money on, because a room that only hears failures walks out defensive and changes nothing.
Part 1 · covers un-blending + the margin bridge + the price of the decision

The break: same volume, thirteen points less margin 10 min live

Un-blend the platform by server and the drift of two points becomes a cliff on two of ten. S07 and S08, the Vietnam servers that carried the 2021-2023 growth, ran at 42.3 percent margin in 2023 and 29.3 percent in 2025. Their revenue went from 686k to 884k to 765k over the same three years - up, then down, never alarming. A profit change has exactly four terms: volume, price, cost and mix. Name the term before you name a cause, because each term points at a different desk.

Where the thirteen points went: the bridge for S07 + S08 Profit before 12 months Volume -18k Price +6k Cost -54k Mix +5k Profit after 12 months fewer orders same list price unit cost up 22% product mix 2023 margin 42.3% 2025 margin 29.3% Cost is the whole story on S07 + S08. On the other eight servers the cost term is zero.
🔍 Click to zoom - four terms, one of them amber. The bridge tells you which desk to walk to.
Live Un-blend it 3 min▶

Ten small charts, one per server, same axes, sixty months each. Eight of them are boring - and boring is the finding, because it tells you the break is not seasonal, not macro, not a platform-wide price move. Two of them step down in the same month. When ten units share a market and two break together, the cause is something those two share and the others do not: in this case, one fulfilment set-up.

Margin percent per month for every server: the two key servers combined in amber drop from about 43 to 30 percent in March 2024, while the eight other servers in grey stay flat around 42 percent.
🔍 Click to zoom - eight flat panels and two with a step in the same month. The blend in c1 showed a two-point drift.
Why small multiples beat one big chart One line for the platform averages the broken units with the healthy ones. Ten lines on one chart tangle. Ten small panels on identical axes let the eye do what it is good at: spotting the two that look different. Ask for this shape whenever a business has more than three units.
Live Volume held, margin fell 3 min▶

Take the three months before the break, December 2023 to February 2024, and the three months after, April to June 2024. Orders: about the same. Average price per unit: about the same. Unit cost: up roughly 22 percent. Margin: down thirteen points. That is a fingerprint, and it rules things out. A demand problem moves volume. A pricing problem moves price. A cost problem moves neither - which is exactly why a growth dashboard cannot see it.

Orders and profit on S07 and S08 indexed to the six months before March 2024: orders stay near 100 while profit falls to about 68.
🔍 Click to zoom - three quiet bars and one loud one. The quiet bars are what the company was watching.

The seasonal trap here is real: compare March to December and you compare a quiet month to a peak. Comparing the three months either side of the decision holds the season roughly still and lets the decision show through.

Live The bridge names the term 3 min▶

Profit change between two periods decomposes exactly into four terms: how much came from selling more or fewer units, from charging more or less per unit, from paying more or less per unit, and from selling a different mix of products. On S07 and S08 the terms read volume -18k, price +6k, cost -54k, mix +5k. Cost is the whole story. Run the same bridge on the other eight servers and the cost term is zero - a second confirmation that the break was a decision, not a market.

Profit bridge for S07 and S08 from 193k to 132k: volume minus 18k, price plus 6k, cost minus 54k in amber, mix plus 5k. Cost explains the whole change.
🔍 Click to zoom - the waterfall your analysts build in a2. Read the amber bar and go find the March 2024 decision.
TermS07 + S08Other eight serversWhose desk
Volume-18kordinary movementGrowth, merchant success
Price+6kordinary movementPricing, catalogue
Cost-54kzeroOperations, fulfilment
Mix+5kordinary movementCatalogue, merchants
Real world A regional marketplace ran a rolling 90-day review for years while a payment-provider fee change quietly took several margin points from one country. Volume kept growing, so the country looked like a success on every growth chart. The fee was found in an annual audit from a full-history chart nobody had asked for. The bridge would have named the cost term in the first quarter.
Self-study The price of the decision 4 min▶

Describing a break is not the same as pricing it. Take the margin the two servers earned before the shift, 42.4 percent, apply it to every month of revenue since, and the gap between that and the profit actually booked is the cost of the decision: 251k over thirty months, an average of 8.4k a month. The revenue itself kept growing in 2024, which is why nobody with a revenue chart felt any pain.

Cumulative profit gap on S07 and S08 at the pre-shift margin since March 2024, reaching 100k by January 2025, 200k by January 2026 and 251k by August 2026.
🔍 Click to zoom - the shaded gap is the price. The assumption that makes it a price is written on the chart, not hidden under it.

The number rests on one assumption and it must be said out loud: that the March cost change caused the margin drop rather than coinciding with it. Two things make the assumption defensible here. The other eight servers, same months, same market, show no cost term. And the two-event test in Part 2 shows the customer effect in both surviving-merchant and churned-merchant customers, so the change reached the customer experience itself. Neither is a counterfactual, and the analyst notes say so. A number with its assumption attached survives a hostile board; a number without one does not.

  • State the counterfactual. "At the old margin" is a choice; write it on the chart.
  • Say where it is tested. The eight quiet servers and the two-event split are the tests here.
  • Do not add the retention loss yet. That is a second estimate with a second assumption. Stack them and the board discounts both.
Part 2 · covers cohort lag + merchant survival + the two-event confound + dormancy

The lag: one decision, three delayed symptoms 9 min live

A cost decision shows up in the margin line the same month. It shows up in customers two quarters later, in merchants two quarters after that, and in the store dimension never, because nobody closes records. Read separately these look like three different problems owned by three different teams. Read on one timeline they are one decision arriving on three different delays.

Two decisions, three symptoms, one timeline 2024 2025 Cost decision unit cost up 22% Mar 2024 Success team cut VN merchant success Jun 2024 Repeat rate falls 28.8% to 17.2% Sep 2024 Churn doubles hazard 1.26 to 2.39% 2024 H2 Stores go dormant records never closed 2025 amber: decisions the company took navy: symptoms that arrived on a delay of two quarters, then two more
🔍 Click to zoom - the symptoms are dated. Put them on one line and the two decisions become the only candidates.
Live Customers left two quarters later 3 min▶

A customer belongs to the quarter of their first order. Ask what share of each quarterly cohort came back within the next two quarters. On S07 and S08 that share ran at 28.8 percent for the 2023 cohorts and 17.2 percent by 2025. On the other eight servers: 27.4 percent, then 26.8. Same company, same products, same years - the only thing that differs is which servers the customer bought on. The first cohort to fall is the one acquired around September 2024, two quarters after the cost decision.

Repeat rate within two quarters by acquisition quarter: the key servers fall from about 29 percent to 17 percent starting with the 2024Q3 cohort while the other servers hold near 27.
🔍 Click to zoom - one line falls off a shelf, the other does not move. The gap opens two quarters after March 2024.
Two cohort triangle heatmaps, key servers and other servers, rows are acquisition quarters and columns are quarters since acquisition. Key-server rows from late 2024 are visibly paler from the first column on; incomplete cells are blank.
🔍 Click to zoom - frozen history: a completed cell never changes, and the current partial quarter is blank on purpose.
Why the cells are frozen A retention number that restates history every time someone reruns it cannot be governed - last month's 28 becomes this month's 26 and nobody knows which was true. Cohort cells that never change once complete give the board a number it can hold the team to. The blank cell is honesty, not a bug.
Live Merchants followed 3 min▶

The platform's own customers are merchants. Count them the way you count customers: new, retained, churned, net, every quarter. The Vietnam servers were the growth engine from 2021 to 2023 - then the merchant churn bar grows through the second half of 2024. The survival view says the same thing more precisely: before June 2024 a key-server merchant had a 1.26 percent chance of leaving in any given month; after it, 2.39 percent. The hazard doubled in the quarter the merchant-success team was cut.

Quarterly merchant growth accounting on the key servers: new merchants stacked above, churned merchants below, net line on top. New merchants dominate 2021 to 2023; the churned bar grows from the second half of 2024 and net turns negative.
🔍 Click to zoom - the merchant version of the growth-accounting identity. Read the bottom bar, not the top one.
Monthly merchant churn hazard on S07 and S08: 1.26 percent before June 2024, one in 80, against 2.39 percent after, one in 42.
🔍 Click to zoom - survival curves keep the merchants who are still here in the picture instead of dropping them.

The method matters for one reason a chairman should know: a plain average of merchant lifetimes throws away every merchant who has not left yet, so it flatters the past and hides the present. Survival analysis counts the still-here merchants as "at least this long" and gives you a rate you can compare before and after a date.

Live Two decisions, one drop - which lever? 3 min▶

Here is the honest problem with the story so far. Two decisions landed three months apart on the same servers: the fulfilment change in March and the merchant-success cut in June. The repeat rate fell. Which lever pulled it? Split the key-server customers by whether their merchant survived to 2026. If the drop lives only among customers of merchants who later left, the June cut did it - customers left because their shop did. If it shows in customers of surviving merchants too, the buying experience itself changed.

Grouped bars of repeat rate for key-server customers split by whether their merchant survived to 2026. Surviving-merchant customers fall from 29.2 to 17.7 percent; churned-merchant customers fall from 27.4 to 15.5 percent. Both groups drop by about the same amount.
🔍 Click to zoom - both groups fall. If only the right-hand pair had fallen, this would be a merchant story. It is not.
Customers of ...2023 cohortsLate 2024 onwardReading
merchants still trading in 202629.2%17.7%the experience changed for customers whose shop never left
merchants that churned27.4%15.5%slightly lower again - the June cut compounded it

So the March decision reached the customer, and the June decision made it worse. That ordering is what c3 needs, because it means reversing or re-pricing the fulfilment change is the first lever and restoring merchant success is the second - not the other way round, and not either alone.

Self-study Stores that exist and stores that sell 3 min▶

The store dimension says 342 stores exist. A store exists in that table until someone closes the record, and nobody closes records - roughly 65 percent of stores that have not sold in a year are still marked open. Define active as at least one order in the trailing 90 days and the share of dormant stores climbs through 2025, concentrated on the key servers. Dormancy is the earliest merchant-churn signal there is: a merchant stops selling long before anyone files paperwork.

Stacked monthly count of stores by status: active with an order in the last 90 days, dormant, and dead but still open in the dimension. Dormant and dead shares climb through 2025, most steeply on the key servers.
🔍 Click to zoom - the top of the stack is what the dimension table believes. The bottom band is what is actually selling.
  • Count active, not existing. Existence in a table is a fact about the table.
  • Status as events, not fields. A field that gets overwritten has no history; an event that gets appended does. c3 puts this in the tech table.
  • Dormancy is a list, not a chart. Each dormant store on a key server is a merchant somebody should call this week.
Build-along

Write the six findings as sentences ★ 8 min · everyone builds

A finding that cannot be said in one sentence with a number in it is not yet a finding. Take the six you heard today and write each one so that a director who missed the session could act on it. Then order them, then cut.

One sentence, one number. "S07 and S08 lost thirteen margin points in March 2024 while selling the same volume." Not "margin by server". The number is the sentence's spine.

Add the grain. Per server, per quarterly cohort, per merchant, per basket. A repeat rate without "per cohort" will be argued about for twenty minutes.

Add the unit. Percent, thousands, months, per month. "Churn doubled" and "hazard 1.26 to 2.39 percent a month" are different sentences; only one can be checked.

Add the confidence and the caveat. "At the pre-shift margin; no counterfactual server." "Sixty-nine days of logins; a snapshot, not a trend." A caveat stated by you is a strength. Found by the board, it is a wound.

Order them for the turn. Break, lag, then the growth findings. The room needs to hear what went wrong before it will fund what went right, and it needs to hear what went right before it will leave the room willing.

Strike any sentence without a decision. If nothing changes whichever way the number falls, it leaves the deck. Keep the chart in the appendix if you must; it does not get a slide.

The test Read the six sentences aloud in order, without the charts. If they tell the story on their own, the charts are evidence. If they do not, the charts are decoration and the story is still missing.
Homework

Try it yourself - this week ◐ 30 min

Sources covered

What this session draws on

The findings here are read with a small set of working methods borrowed from data storytelling, decision science, valuation and survival statistics. This page teaches the working core of:

✓Cole Nussbaumer Knaflic - Storytelling with Data: one finding, one chart, the title is the findingBuild-along · the six sentences and the turn
✓Cassie Kozyrkov - Decision Intelligence: the decision column on every findingPart 3 · strike any sentence without a decision
✓Aswath Damodaran - narrative and numbers: price the story, state the assumption doing the workPart 1 · the price of the decision
✓Kaplan-Meier survival analysis (the lifelines library) - hazard before and after a date, censoring respectedPart 2 · merchants followed
◐Growth accounting - new, retained, resurrected, churned, applied to merchantsPart 2 · read here; built in analyst session a4
◐Basket analysis - support, confidence, lift on product-line pairsPart 3 · read here; built in analyst session a3
Check yourself

Three questions before you go 🎯 ◐ 90 seconds

1 · A bridge on two servers reads volume -18k, price +6k, cost -54k, mix +5k. A colleague proposes a price rise to recover margin. What does the bridge say?

The bridge exists to name the term before anyone names a cause. Price moved up slightly and volume held; the whole loss sits in cost, and the other eight servers show a cost term of zero. A price rise might recover margin, but it would answer a question the data did not ask and risk the volume that held.

2 · Repeat rates fell for customers of surviving merchants (29.2 to 17.7 percent) and for customers of churned merchants (27.4 to 15.5). What is the right reading?

If the drop lived only among churned-merchant customers, it would be a merchant story. It shows in both groups at nearly the same size, so the March decision reached the customer directly, and the slightly lower churned-merchant figure is the June cut on top. That ordering decides which lever c3 pulls first.

3 · Why does the storyline turn from the breaks to what went right, rather than ending on the price of the decision?

The turn is not a softening and the growth findings carry the same rigour and the same caveats. It is where the decisions live: a board funds growth it has just seen evidence for. End on the price and you get defence; end on the bundles and the customisation lever and you get a budget line.

Chairman session 2 cheat sheet · pin this

Un-blend firstSmall multiples per unit on identical axes. Eight boring panels are the finding: the break is local, so the cause is local.
Four terms, then a causeProfit change = volume + price + cost + mix. On S07 + S08: -18k, +6k, -54k, +5k. Cost is the whole story; elsewhere the cost term is zero.
Price it, with the assumptionPre-shift margin 42.4 percent on post-shift revenue: 251k over 30 months, 8.4k a month. Say "at the old margin" on the chart.
The lag is a chainCost decision Mar 2024; repeat rate falls two quarters later (28.8 to 17.2); merchant hazard doubles (1.26 to 2.39); stores go dormant on paper.
Split before you blameTwo decisions, one drop: split customers by merchant survival. Both groups fell, so the experience changed and the June cut compounded it.
Frozen cohortsCompleted cells never restate; the partial cell is blank. A retention number that changes daily cannot be governed.
The turnCustomisation: 8-10 margin points and 33.9 vs 28.1 repeat. Bundles at lift 1.3-1.6, never sold. Bags up, stationery down. Churn visible in month three.
Six sentencesOne number, the grain, the unit, the confidence, the caveat. Ordered for the turn. Any sentence without a decision leaves the deck.