How to Spot Shaky Product-Market Fit in Your Retention Data
There's one pattern in your customer data that says more about Product-Market Fit than almost anything else, and you can usually find it with an export from your billing system and an afternoon in a spreadsheet. The pattern is retention that swings from one group of customers to the next.
When that happens, it means the product delivers value to some customers and not others. Because you can't tell in advance which kind a new customer will be, you can't tell what a customer is worth, and every decision built on that number gets riskier. This post walks through what the pattern looks like, how to check for it yourself, and what to do with what you find.
What it looks like
The usual way to look at retention is by cohort. A cohort is just a group of customers who signed up in the same period, say the same quarter. For each group, you check what share are still customers after 3, 6 and 12 months. Here's an illustrative example of what shaky retention can look like:
| Customers who signed up in | Still with you at 3 months | At 6 months | At 12 months |
|---|---|---|---|
| Q1 | 95% | 90% | 86% |
| Q2 | 88% | 70% | 58% |
| Q3 | 93% | 84% | 74% |
| Q4 | 90% | 79% | (too early) |
Averaged together, twelve-month retention is about 73%, which nobody would call a disaster. Read row by row, it tells a different story. The Q1 group mostly stayed. Nearly half of the Q2 group left within a year. The company was selling the same product, with the same team, to what it believed was the same market, yet results swung widely depending on when customers happened to sign up. That swing is what's sometimes called retention volatility, and it's one of the clearest signs that value isn't being delivered consistently.
How to build this view yourself
You don't need a data team or a special tool. Most companies can do this with data they already have:
If your revenue is usage-based rather than a flat subscription, track revenue instead of headcount: what share of each group's starting monthly revenue is still there after 3, 6 and 12 months. Usage-based customers often shrink before they leave, and this catches it.
How to read it
If the rows look roughly alike, that's a good sign. Customers are getting a similar experience no matter when they joined. If the rows swing widely, look at what made the good groups different. Did one quarter bring in more customers of a particular size or industry? Did the founder close more of those deals personally? Did a certain marketing channel send better-fit customers? The second cut, by customer type and by how they were won, usually answers this. Often you'll find that one type of customer does well consistently and others pull the average down.
Why shaky retention makes every growth bet fragile
A customer's lifetime value is roughly what they pay you each month multiplied by how many months they stay. A customer who stays three years is worth a lot. One who leaves after six months may not even pay back what it cost to win them. So when retention swings, lifetime value swings with it, your revenue projections swing, and you lose the ability to say what a new customer is worth.
That number sits underneath almost every growth decision: how much to spend on marketing, whether to hire more salespeople, which channels to expand into, even how to price. If it's unstable, the cost of winning a customer becomes a gamble, sales hiring becomes risky and paid marketing can burn through cash. The classic trap is scaling up spending after a strong quarter, only to find the next group of customers leaves early. That's what fragile growth looks like, and it's why this pattern matters far more than a single retention number.
What strong Product-Market Fit looks like in the same table
When Product-Market Fit is strong, the rows in that table start to look alike, at least for customers in your ideal profile. The retention curves flatten out at similar levels from one quarter to the next. New customers reach their first real result in a predictable amount of time. And when customers do leave, the reasons narrow down to a few you understand, such as a company that was too small or a champion who moved on.
That consistency is the real signal. Strong Product-Market Fit means the same type of customer reliably gets the same result. When that's true, retention steadies, and you finally know what a customer is worth. When it isn't, retention depends on segment, timing, whether the founder was involved, or plain luck. If your table looks more like the example above than you'd like, that's useful to know now, because it tells you where to focus before you spend more on growth.
Not sure your data can show you this yet? The free Aukiva Data Check tells you whether your data can answer questions like this one, or book a conversation and we'll look at it with you.
