Most SaaS businesses hide their churning reality behind monthly recurring revenue (MRR) reports. Learn the specific cohort metrics that reveal true product health.
Deal Alert AI is reader-supported. We earn commissions from affiliate links at no cost to you.
This post is based on a video from our Deal Alert AI YouTube channel. Watch the original or read the full breakdown below.
Buying a Software as a Service (SaaS) business feels like buying a perpetual monthly paycheck. The seller shows you a chart with a steady line going up, a high retention rate, and a hefty monthly recurring revenue figure. It looks safe. It looks predictive. But in my seven years of advising buyers on over $150 million in digital transactions, I have seen that clean top-line graph lie to you. The single most dangerous blind spot in SaaS due diligence is ignoring the cohort analysis of the customer base. Without understanding how specific groups of customers perform over time, you are essentially guessing how long the revenue will actually last.
Cohort analysis is not just for data scientists. It is the backbone of smart SaaS valuation. When you break down your user base into groups based on when they started, you can see the decay rate of customer lifetime value (CLV) and the trend of churn. This helps distinguish between a healthy business that is growing through organic advocacy and a troubled business that is constantly buying new traffic to plug a leaky bucket. If you are planning to acquire a subscription-based business, this section of due diligence is non-negotiable.
In this guide, we will walk through the exact steps to perform this analysis. We will look at the specific metrics to request during the data room phase. We will discuss how to interpret the curves so you do not get fooled by vanity metrics. And we will show you how to use these insights to negotiate a better price or walk away from a deal that looks good on the surface but is falling apart underneath. Whether you are a first-time buyer or a seasoned operator, mastering this skill saves you from the most expensive mistakes in online business acquisition.
Monthly Recurring Revenue is the headline number that every SaaS founder loves to share. It is the total amount of money that comes in every month from active customers. However, MRR is a stock metric, not a flow metric. It tells you how much water is in the bathtub, but it does not tell you the size of the hole in the bottom. A business with $50,000 in MRR and 40% monthly churn is a very different investment than one with $50,000 in MRR and 4% monthly churn. The first one is a dying business; the second is a growing asset.
Consider a scenario where a seller presents $20,000 in monthly revenue. If the churn rate is 10%, that means $2,000 in revenue is lost every month. To maintain the status quo, the business must acquire $2,000 in new business every month. If they cannot, the revenue drops into the basket. Now, imagine the churn jumps to 20%. Suddenly, $4,000 is lost monthly. The growth line might still look up if the seller is aggressively spending on ads, but the net profit is eroding. Cohort analysis exposes this constant need for new blood to keep the lights on.
Furthermore, MRR masks the quality of the customer mix. A business might have hundreds of low-value users who churn quickly and a handful of high-value enterprise clients. If the small users churn, the MRR drops, but the impact is less severe. If the high-value clients churn, the business loses a disproportionate amount of its value. By building revenue solely on the acquisition of new users without analyzing the retention of existing cohorts, businesses often mask structural product weaknesses. You need to see the age of the revenue to assess its stability.
We scan Empire Flippers, Flippa, Acquire.com and Quiet Light daily — scoring every listing. Start free.
A cohort is a group of customers who share a common characteristic or experience within a defined period. In SaaS, the most useful cohorting variable is the month they first subscribed. By grouping customers by their start month, you create a longitudinal view of their behavior. Instead of looking at all customers at once, you look at a specific batch of customers over time. This allows you to see if the product is getting better or worse for new users as time passes.
For example, you create a cohort for customers who signed up in January. You measure their activity, revenue generation, and churn in January, February, March, and so on. Then you create a separate cohort for February sign-ups. By comparing the January cohort’s retention in its third month to the February cohort’s retention in its third month, you can see a trend. If the January cohort retained 40% of customers in month three, but the February cohort only retained 30%, that is a red flag. It suggests the product is degrading or the marketing is bringing in lower-quality leads.
This concept is critical because SaaS businesses are often optimized for immediate growth rather than long-term retention. Founders may feel pressure to show high user growth numbers for venture capital or to justify their own salaries. They may relax qualification criteria for sales or lower price points to boost the customer count. Cohort analysis cuts through this noise. It forces you to look at the engagement and willingness to pay of users who have already been with the product for a while, giving you a clearer picture of product-market fit.
When you are in the due diligence phase, you must request a cohort retention matrix. Many business owners are familiar with this if they have ever used tools like Amplitude, Mixpanel, or even advanced spreadsheets. If they cannot provide this immediately, ask for raw data. You need a list of all customers, their start date, their cancellation date (if applicable), and their monthly payment history. From there, you can build the matrix yourself. Do not rely on the seller’s interpretation. Build it independently to verify the numbers.
The first metric to extract is the Churn Rate per Cohort. For each month after sign-up, calculate the percentage of customers from that original cohort who remain active. Plot this out. A healthy SaaS business typically shows a steep drop in the first month (onboarding friction) followed by a plateau. If the curve continues to drop linearly or exponentially without stabilizing, the product lacks long-term utility. A plateau indicates that you have a core user base that finds continuing value in the product.
Next, calculate the Net Revenue Retention (NRR) for each cohort. Unlike simple churn, NRR accounts for expansion revenue (upsells) and contraction (downsells). If a customer starts at $50/month and leaves at month six, that is 100% churn for that individual. But if they started at $50, upgraded to $100 at month three, and stayed, their contribution to NRR increases. In acquisition, NRR is the king metric. If a cohort’s NRR is above 100%, the business is growing even without acquiring a single new customer. This is the holy grail of SaaS economics and a major indicator of a strong asset.
Once you have your cohort matrix, look for anomalies. One common pattern is the "Cliff Churn." This is when a specific cohort experiences a sudden, massive drop in retention at a specific day or month. Often, this aligns with a product change. Did the company remove a popular feature in Month 2? Did they change their pricing model? If the January cohort churns at month three because of a price increase, but the February cohort (who signed up after the change) doesn't, you have a clear signal that the price increase was a mistake. This historical data tells you about the stability of the business’s operational decisions.
Another pattern is the "Onboarding Leak." If the first month churn is consistently above 20-30% across all recent cohorts, the product is hard to use or the value proposition is not clear to new users. This is a fixable problem, but it costs money and time. When valuing the business, you need to estimate the cost of fixing onboarding. If the fix requires hiring a dedicated Customer Success team, the effective earnings of the business are lower than the reported net income. You must adjust your offer price to account for these necessary operational improvements.
Finally, look at the "Sticky Core." In successful SaaS businesses, you will eventually see a cohort curve that flattens out at a certain percentage. For example, 60% of customers might churn in the first two months, but the remaining 40% stay for an average of 18 months. This creates a recurring revenue base that is incredibly stable. When evaluating a target, ask: Is the business growing its core, or is it just growing its inflow? If the core is shrinking, the business is burning cash to maintain appearances. If the core expands, you are buying a durable asset. This distinction dictates whether you are buying a service business or a software asset.
Valuation in SaaS is typically based on a multiple of Annual Recurring Revenue (ARR) or EBITDA. However, the multiple you can command depends heavily on the quality of that revenue. A business with high retention and high NRR deserves a premium multiple, often 4x to 6x ARR. A business with high churn and low retention might only command 2x to 3x ARR, regardless of the headline revenue number. Using cohort analysis allows you to categorize the target and apply the correct multiple rather than paying a premium for a flawed asset.
For example, suppose you are looking at two businesses, both with $1 million in ARR. Business A has an average customer lifespan of 3 years and a churn rate of 3% per month. Business B has an average customer lifespan of 6 months and a churn rate of 15% per month. Business A’s revenue is much more predictable. The cost of acquiring a customer is amortized over a longer period, leading to higher margins. Business B is essentially a customer acquisition service; it must constantly spend to replace lost customers. In a market where ad costs are rising, Business B’s margins will compress. Therefore, Business A should be valued at a significantly higher multiple, and your cohort analysis proves this disparity.
Additionally, cohort analysis helps in projecting future cash flows, which is essential for internal rate of return (IRR) calculations. If you assume that the historical churn rates will continue, you can model out the future revenue. But if you notice that the most recent cohorts are underperforming the previous ones, you must model a deceleration in growth or an acceleration in churn. This conservative modeling protects your exit strategy. If you buy based on optimistic, flat trendlines that ignore recent cohort degradation, you may find yourself holding a declining asset that is difficult to resell at the price you paid.
You do not need to be a data scientist to do this. Most SaaS businesses of this size (small to mid-market) have their data in a CSV export from their billing provider like Stripe, Chargebee, or Recurly. Request a CSV file containing `customer_id`, `start_date`, `end_date`, and `monthly_revenue`. Once you have this file, you can use Excel or Google Sheets to build your matrix. This hands-on approach ensures you understand exactly how the numbers are derived and prevents the "black box" effect where you trust a dashboard that could be configured to hide bad data.
Start by creating a list of months in your columns from the earliest sign-up month to the current month. In your rows, list each cohort month. For each cell in the matrix, calculate the percentage of customers from that row who were still active in that column month. You can use a simple formula: (Active Customers in Column Month / Total Customers in Row Cohort). It helps to color-code the cells. Dark green for high retention, red for high churn. Visualizing the decay curve helps you spot the "cliff" or "plateau" mentioned earlier. This visual representation is also wonderful to bring to your advisors or co-pilots for discussion.
Next, calculate the Lifetime Value (LTV) for each cohort. LTV is the average monthly revenue per user in that cohort, multiplied by the average lifespan of that cohort. If the January cohort lasted an average of 12 months and paid an average of $50/month, their LTV is $600. If the February cohort lasted only 6 months and paid $50/month, their LTV is $300. A declining LTV trend is a massive red flag. It means the business is attracting lower-quality customers or the product is losing value over time. You need to explain this trend before agreeing to a valuation. If the seller cannot explain why the LTV is dipping, the risk is too high for a standard purchase.
To ensure you are not missing any critical data points during your due diligence, use this checklist. I have refined this list over dozens of transactions. It covers the data requests, the calculations, and the qualitative questions you need to ask the seller. Do not skip any of these steps. Missing even one can lead to a mispriced acquisition that erodes your returns over the first year of ownership.
Once you have completed the analysis, you must translate the data into a business decision. If the cohorts show strong, stable retention with an upward trend in NRR, you have found a high-quality asset. In this case, you can be more aggressive in your offer. You are confident that the revenue is sticky. You can allocate more of your capital to the purchase price and less to a reserve for operational fixes. The risk profile is low, which should command a lower discount rate in your valuation model.
Conversely, if the cohorts show a downward trend in retention or a high initial churn rate, you have two choices. First, you can lower your offer significantly to account for the time and money needed to fix the product. This means negotiating the price based on the *fixed* earnings potential, not the current messy earnings. Second, you can walk away. Not every deal is right. If the product fundamentally lacks the "hook" to retain users, no amount of marketing spend or sales effort will save it. It is better to spend your capital on a business that already has product-market fit than to try to create it from scratch in an acquired codebase.
Remember, the goal of due diligence is not to find a perfect business. It is to find a business where you understand the risks. Cohort analysis gives you a transparent view of those risks. It moves the conversation from "What is your MRR?" to "How well do you retain your customers, and is that retention improving?" This shift in perspective protects your capital and sets the foundation for a successful post-acquisition integration. Use the tools available to you, insist on the data, and make your decision based on evidence, not emotion.
Utilizing professional marketplaces can streamline your search for verified assets. Platforms like Empire Flippers often provide preliminary financial data that can give you a baseline before you dive into deep-dive cohort analysis. Similarly, Flippa offers a wide range of small business acquisitions where manual cohort analysis is even more critical, as data hygiene can vary. By combining these marketplaces with strict analytical rigor, you position yourself as a sophisticated buyer.
As you continue to build your portfolio of digital assets, keep refining your ability to read these numbers. The market is full of mediocre businesses pretending to be great. The buyers who win are the ones who see the truth in the data. If you are ready to streamline your due diligence process and access verified opportunities, explore the resources at Deal Alert AI. We help you find the right deals and connect you with the expertise needed to close them safely. Your next profitable acquisition starts with the right question: "Show me your cohorts." You will be surprised by what they reveal and how this single piece of diligence will set you apart in the acquisition market. Stop guessing, start knowing. The data is already there; you just have to ask for it.
Take the time to master this skill. Practice it on live data. Compare your findings with the seller’s projections. The more comfortable you are with the numbers, the more confident you will be during negotiations. And when confidence meets preparation, you find success that is not only profitable but durable. This is how you build a sustainable empire of online businesses, one well-analyzed cohort at a time.
We scan Empire Flippers, Acquire, Flippa, and Quiet Light daily. The best sub-$500K businesses are gone within 48 hours.