1. Lighthouse

Level 6 · Metric trap: the LTV of the survivors

The request

From Andrew Ramos, Marketing Manager

“Good news for the budget: our active customers have each brought in $4,714.50 so far. If a new customer turns out like them, we can easily afford to pay $1,500 to acquire one. Can you sanity-check the logic before I send it?”

Your goal

Pick the answer that explains what is wrong, if anything, with using the active customers' revenue as the value of a new customer.

Andrew defines active customers as the 878 people with a booked order since 2025-10-01. Their net revenue to date averages $4,714.50. Across all 1,740 customers who ever placed a booked order, the average is $3,268.55. What should you tell him?

Pick one answer, then check it.

The lesson

Survivorship bias

Survivorship bias is what happens when you study only the things that made it through a filter and treat them as typical. The classic example is planes returning from missions: the bullet holes on the survivors show where a plane can be hit and still fly home.

In customer analytics the filter is “still buying”. Any group defined as active, current or loyal has survived every month of churn so far, and it differs from a fresh customer in exactly the way that matters for value.

The numbers at Harbor & Pine

Define active as a booked order since 2025-10-01. Then:

group                  customers   revenue to date   orders
active (since Oct 1)         878         $4,714.50     8.83
not active                   862         $1,795.76     3.95
everyone who bought        1,740         $3,268.55

The active customers are worth more than everyone else because staying is what makes a customer valuable. A customer acquired tomorrow has not stayed yet. Some will become loyal regulars; many will buy a few times and leave. Valuing them as if they were already loyal overstates what they are worth, and an acquisition budget based on that number overpays for every customer.

The fix: cohorts, not survivors

Value a new customer with a group defined before the outcome: an acquisition cohort, everyone whose first order fell in a period, whether they stayed or not. Then compare cohorts over equal windows (for example, revenue in the first 365 days), as in the historic LTV level. The predictive formula from level 4 also avoids the trap, because churn is built into the lifespan.

Where else it shows up

  • Satisfaction surveys of current customers: the unhappy ones already left.
  • “Our average customer has been with us four years”: computed on customers who are still here.
  • Product reviews written mostly by people who kept the product.
  • Best-selling products this year: discontinued products are missing from the list.

Interview note

“What is survivorship bias? Give an example from business data” is a frequent question. A strong answer names the filter (“customers still active”), explains why the filtered group differs from a new one, and gives the fix: define the group before the outcome, as a cohort.

Pick what may run on this site. You can change this any time from "Cookie settings" at the bottom of every page.