learn-data-literacy-with-phoebe / Session 5 of 8
Learn Data Literacy with Phoebe · Session 5 of 8

Funnels, cohorts and RFM: where the customers leak out

Session 4 gave you the tree; this session gives you the three x-ray machines behind its branches. Funnels show where customers leak, cohorts show whether they come back, and RFM sorts them into segments that each deserve a different move. All three run on data you already have.

🟡 Core Execs & business leaders Builds on Session 4 45 min live + self-study
0-3 · Welcome 3-18 · Concepts 18-40 · Apply-along 40-45 · Q&A
Part 0

Three x-rays for one customer journey

Every customer walks a path: they discover you, try you, pay you, and either return or quietly vanish. Funnels x-ray the path forward (where do they leak?), cohorts x-ray the path back (do they return?), and RFM x-rays the crowd (who deserves which message?). Master these three and you can interrogate almost any growth claim anyone puts in front of you - which is precisely the job of a data-literate leader.

Live - presented in session Self-study - read after class ★ Apply-along - interactive, everyone plays Real cases: Baymard, Facebook, Sephora & more
★ What you walk out with today Three habits: the leak-first principle (fix the weakest funnel stage, not the loudest one), the cohort lens that catches the churn a growing average hides, and an RFM segmentation you could genuinely run in a spreadsheet by Friday - plus the metric pack for your industry so you know which numbers your peers are watching.
Part 1 · the path forward

Funnel analytics 5 min live

Every business is a funnel: many enter, few pay. The magic number is not the count at any stage - it is the conversion rate between stages, because that is where the money silently leaks out.

Visit · 100,000 45% continue Product view · 45,000 ⚠ 30% - the weakest stage Add to cart · 13,500 40% continue Checkout · 5,400 65% complete Purchase · 3,510 · the money AARRR (McClure) Acquisition - they arrive Activation - first value Retention - they return Referral - they invite Revenue - they pay the startup funnel: five stages, five questions to ask Leak-first principle: fix the weakest stage, not the loudest one. 96.5% of visitors never buy - and that is a normal e-commerce funnel.
🔍 Click to zoom - five stages, four leaks, one red flag worth all your attention
LiveThe leak-first principle3 min▶

Three rules of funnel reading:

  • Conversion between stages beats counts at stages. "13,500 added to cart" is information; "only 30% of viewers add to cart, versus 45% and 65% elsewhere" is the insight.
  • Fix the weakest stage, not the loudest one. The loudest stage is usually the top (marketing wants more traffic) or the bottom (finance stares at purchases). The weakest stage is wherever conversion sags - and fixes there multiply through everything downstream.
  • Leaks compound. The funnel is a chain of multiplications, which you already know how to read: it is a KPI tree lying on its side.
Real world

Baymard Institute's running meta-study: average documented cart abandonment is roughly 70% - seven of ten loaded carts never check out. A top killer is disclosing shipping costs late: the price grows at the last step and trust snaps. The fix (show total cost early) is a product tweak, not an ad budget - a classic weakest-stage win that no amount of top-of-funnel spend could buy.

Self-studyAARRR: pirate metrics, seriously2 min read▶

Dave McClure's AARRR framework (yes, named for the pirate noise) is the funnel generalized for any product: Acquisition (they find you) → Activation (they experience first value) → Retention (they come back) → Referral (they bring friends) → Revenue (they pay). Its power is diagnostic: a struggling business is usually failing at exactly one letter, and each letter has a different fix. Dropbox's famous referral program (free space for both inviter and invitee) was an R-for-Referral play chosen only after activation and retention already worked - referral pours fuel, and fuel on a leaky funnel just burns faster.

Part 2 · the path back

Cohorts and retention 5 min live

A cohort is simply a group that started together - the January signups, the Black Friday buyers. Track each cohort separately over time and you get the single most honest chart in analytics: the retention curve.

100% 50% 0 months since signup → 12 flattens = habit formed product-market fit lives here dives to zero = leaky bucket The cohort table each row = one start month read fading along the row One curve per cohort. If newer cohorts flatten higher than older ones, the product is genuinely improving.
🔍 Click to zoom - the two fates of every cohort: habit, or goodbye
LiveWhy cohorts beat averages3 min▶

Fast growth is a magician's cape: it hides churn. When signups grow 20% a month, the average user is always young, engaged and shiny - even while every cohort quietly bleeds out behind the curtain. Total active users climbs; the business is dying. Only a cohort view separates the two stories, because it refuses to let new users answer for old ones.

  • Read the shape, not the level: a curve that flattens (even at 25%) means a durable habit; a curve that slides to zero means a leaky bucket, whatever this month's topline says.
  • Compare cohorts to each other: newer cohorts flattening higher = the product is improving. Flattening lower = growth is buying worse customers.
Real world

Facebook's early growth team mined cohort data for the difference between users who stayed and users who vanished, and landed on a famous rule: get a new user to 7 friends in 10 days and they stick. That single activation insight reorganized the entire onboarding flow around friend-finding - not profile completion, not feature tours. One cohort analysis became the company's growth strategy.

The exec move Whenever growth is fast and someone shows you an average or a topline, say: "show me this by cohort." Five words. It is the highest ratio of insight to syllables in this entire course.
Part 3 · the crowd, sorted

RFM: segmentation you can run in a spreadsheet 5 min live

Recency, Frequency, Monetary - Arthur Hughes built it in the direct-mail era, and it is still the workhorse of e-commerce CRM because it needs exactly three columns you already have: last purchase date, purchase count, total spend.

LiveScore, segment, act - the whole method3 min▶

Score every customer 1-5 on each letter: Recency (how recently they bought - 5 is most recent), Frequency (how often), Monetary (how much). Segments fall out of the combinations:

SegmentProfile (R / F / M)The move
Champions5 / 5 / 5 - recent, frequent, bigreward, early access, ask for reviews - never discount
Loyal4 / 4 / 3 - steady regularsupsell gently, build the habit loop
New5 / 1 / low - just arrivedonboard toward the second purchase fast
At-risk champions2 / 5 / 5 - valuable but slipping awaywin-back NOW, personal touch, highest priority
Hibernating1 / 1 / low - long gone, barely knew youcheap reactivation at most, or let go gracefully

The whole point: stop sending the same email to everyone. A discount that delights a hibernating customer insults a champion (who would have paid full price) - one blast, two opposite effects, both invisible in the average open rate.

Real world

Sephora's Beauty Insider and Starbucks Rewards are RFM-style machines at loyalty-program scale: tiers keyed to spend and visit frequency, with different perks, nudges and win-back offers per tier. And when win-back budgets are tight, the play is always the same: target the at-risk champions first - they were recently valuable, so recency says they are the most likely to answer and the most expensive to lose.

Self-studyYour industry's metric pack3 min read▶

Every industry has a standard dashboard. Knowing yours - and your investors' - is table stakes:

IndustryThe packThe one to watch
Internet / consumer appsDAU, MAU, DAU/MAU stickiness, session lengthDAU/MAU - above ~20% means a habit, not an app
SaaSMRR/ARR, NRR, churn rate, CAC, LTV, CAC payback months, magic numberNRR - above 100% means existing customers grow even with zero sales
E-commerceGMV, AOV, conversion rate, repeat purchase rate, cart abandonmentrepeat purchase rate - the difference between a brand and a transaction

Notice the family resemblance: every pack is a funnel metric + a retention metric + a money metric. Same three x-rays, industry costume.

Apply-along 1 of 3

Find the leak worth fixing ★ 9 min · everyone simulates

The Part 1 funnel, live. Two executives propose two fixes; you have the simulator they did not.

Read the baseline: 100,000 visitors trickle down to purchases at $80 average order value. Say the end-to-end conversion out loud - it is smaller than most people guess.

Find the flagged weakest stage. (It is the add-to-cart step at 30% - the Baymard story from Part 1 predicts exactly this kind of sag.)

The boardroom duel: the CMO proposes doubling ad spend - set visitors to 200,000 and note the revenue. Reset. The product lead proposes fixing add-to-cart from 30 to 40 - try that and note the revenue. Now compare the two outcomes per dollar of effort: media budgets rent traffic monthly; a checkout fix is built once.

Free play: find the smallest single change that adds $1M of annual revenue. Compare answers across the room - there are several paths, and they disagree in interesting ways.

The debrief Leaks compound, so upstream fixes multiply downstream: every visitor saved at add-to-cart still has to survive checkout, and they do at the same rates - which is why a 10-point fix mid-funnel can rival doubling the traffic bill. Fix the funnel, then buy the traffic. In that order.
Apply-along 2 of 3

Score three customers yourself ★ 8 min · everyone scores

RFM only sticks once you have scored someone. Three imaginary customers, three verdicts, three different emails.

Customer 1 - the friend of the brand: bought last week, buys monthly, spends big. Score them. (Expect a Champion - note the recommended move is a reward, not a discount.)

Customer 2 - the big spender who vanished: two large purchases, but the last one was a year ago. Score them and read the segment carefully - this is the at-risk profile the win-back budget exists for.

Customer 3 - the newcomer: one small purchase last week. Score them. The move is onboarding toward purchase two, not loyalty perks they have not earned.

Discuss: which segment does your current marketing actually talk to? In most companies the honest answer is "everyone gets the same blast" - which means champions are subsidizing the discounts and hibernators are ignoring them.

Apply-along 3 of 3

Draw YOUR funnel ★ 5 min · everyone draws

Sketch your own business as a funnel: 4-6 stages from first touch to money. B2B works too - lead → qualified → demo → proposal → closed.

Guess the conversion rate at each stage. Write the guesses down - next week, ask your analyst for the real numbers and enjoy the humility.

Mark the stage nobody owns. Almost every room finds one - typically the handoff between two departments (marketing to sales, or purchase to second purchase).

Circle your best guess at the weakest stage. That circle plus Session 4's tree tells you where next quarter's effort belongs.

After the session

This week ◐ 30 min total

Check yourself

Three questions before you go 🎯 ◐ 90 seconds

1 · Your funnel converts: visit → view 50%, view → cart 30%, cart → checkout 45%, checkout → purchase 90%. Where do you put the team first?

The leak-first principle: 90% is already excellent, and traffic poured into a leaky mid-funnel mostly leaks. Lifting view-to-cart from 30% to 36% raises purchases 20% with zero extra media spend - the compounding works for you.

2 · Active users grew 20% this quarter. The CMO says retention is clearly fine. What does the data-literate leader say?

Growth is a magician's cape. Total actives can climb for quarters while every cohort dives to zero - the leaky bucket refilled faster. Only cohort curves separate a habit from a treadmill.

3 · RFM stands for - and why does R lead the win-back list?

Hughes' direct-mail finding still holds: how recently someone bought predicts response better than how much or how often. That is why the at-risk champion (high F, high M, fading R) is the most urgent - and most winnable - save in the file.

Source material

Concepts covered & their origins

This session teaches the working 80% of each idea and credits the canon - the books and decks stay the deep end for anyone who wants more.

✓Funnel analytics + leak-first principlestage conversion, weakest-stage fixes, compounding - Part 1 + Apply-along 1
✓AARRR pirate metrics (Dave McClure)acquisition → activation → retention → referral → revenue - Part 1 card + SVG rail
✓Cohort analysis + retention curvesflatten vs dive, why cohorts beat averages, Facebook's 7-in-10 - Part 2
✓RFM segmentation (Arthur Hughes)1-5 scoring, segments, action per segment - Part 3 + Apply-along 2
✓Industry metric packsInternet / SaaS / e-commerce dashboards - self-study table in Part 3
◐NRR mechanics in depthnamed and defined here; the expansion/contraction math stays a finance-course topic
◐Statistical testing of funnel changesbefore trusting a funnel "win", apply Session 3's A/B intuition - pointer only

Session 5 cheat sheet · pin this

Leak-first principleFix the weakest funnel stage, not the loudest one. Upstream fixes multiply downstream; traffic on a leaky funnel just leaks faster.
AARRRAcquisition → Activation → Retention → Referral → Revenue. A struggling product usually fails at exactly one letter.
Cohorts beat averagesFast growth hides churn - new users mask old ones leaving. Five magic words: "show me this by cohort."
Retention curve shapesFlattens = habit, product-market fit. Dives to zero = leaky bucket, whatever the topline says. Newer cohorts flattening higher = real improvement.
RFMRecency · Frequency · Monetary, each scored 1-5. Champions get rewards, at-risk champions get the win-back budget, hibernators get let go. Never one blast for all.
Your industry packInternet: DAU/MAU stickiness. SaaS: NRR above 100%. E-com: repeat purchase rate. Every pack = funnel + retention + money.