FutureEdge CFO Academy

"Unlocking Success: Navigating the Future of Business, Strategy, and Finance"

FutureEdge CFO shares complimentary articles and e-books with anyone visiting our website and who is keen to find valuable, helpful, and interesting content. We stand for knowledge, which we believe redefines what it means to be human. It is a gift to belong to a brainy specie with a long history and each of us, including business and finance leaders, must seek knowledge. Enjoy our publications.
About FutureEdge CFO
“True success in consulting isn’t measured by the advice given, but by the transformation achieved through collaborative execution with client”
-Natalia Meissner
I am a future-focused and strategically minded finance professional with 20+ years of experience in industrial and technology verticals. With an MBA, CPA, and PMI background, I blend intellect with a strategic, financially savvy, and sustainability-focused mindset. Known for my energetic execution, analytical thinking, and transformative approach, I deliver results. I prioritize collaboration, invest in people, and leverage financial technology for data insights and automation. I excel in diverse, multicultural contexts, promoting collaboration. I grow business value, focusing on the top and bottom line, cash flow, and resource efficiency. My solutions help when internal resources are stretched thin or an outside perspective is essential. My network of C-Level executives is ready to step in and deliver lasting impact, ensuring your business’s continued success.

What Is Cohort Analysis And Why Does It Matter?

Cohort Analysis in a SaaS business is a method of tracking and analysing the behaviour and performance of specific groups of customers over time. It involves grouping customers who share similar characteristics or joined the service during a specific period into cohorts and then examining their engagement, retention, and revenue patterns.

Cohort Analysis is not a metric as such, but rather a framework for evaluating customer retention and their lifetime value to a SaaS business. Cohort Analysis provides a deeper understand of the why, how, and when of our customers’ actions. It is measured via bookings (logs) and dollar retention.

In SaaS business, the most commonly used characteristic to perform Cohort Analysis is the date or month of customer acquisition. The purpose of the analysis is to study how bookings retention, monthly recurring revenue (MRR) retention and customer actions evolve over time. This ultimately leads us to understanding customer lifetime value, retention patters and payback periods.

Here is an example of a Cohort based on time when customers were acquired:

In the above example we can see the following pattern:

At the most basic level, we are looking in the Cohort Analysis for answers to the following questions:

Question 1: Are they still a customer of ours? With each monthly cohort, we can visualize logo retention, dollar retention, and any “break points” in the data.

Question 2: Can we recognize a pattern and identify the root-cause of it?

The 7-Steps Scientific Approach To Cohort Analysis

Cohort Analysis is not unique to SaaS business, and in fact its application is most widely spread in science. And the scientific method of applying Cohort Analysis is a 7-step process:

Step 1: Ask question: What is the “thing” we want to know about customer retention and monthly recurring revenue (MRR)?

  • Why are our customers churning?
  • What makes customers successful?

Step 2: What information is already known? This is the existing internal knowledge and anecdotal evidence about customer retention.

Step 3: Set the hypothesis, or an educated guess or prediction of the outcome which you want to prove or disapprove. Put differently, if we take or implement action X will the result Y or not occur, and why? Making these educated guesses constantly happens in any SaaS business, but Cohort Analysis formalizes the process of making these guesses and gives structure to it.

Step 4: Carry out an experiment to test the hypothesis. Does the real world behave indeed as we predicted. Each month a SaaS business places the tactical components of the hypothesis into action, be it fine-tuning the customer acquisition channels, sales process, customer success, tech support, or even product features.

Step 5: Gather data generated during the experiment and summarize your observations about the experiment. Each month we record the new customers acquired and specific characteristics around each cohort that, we feel, are important in understanding customer behaviour and long-term success. This data can be summarized into:

  • Basic cohort analysis buckets these customers by acquisition month and follows their progression over time.
  • Segmented cohort analysis buckets these same customers by acquisition month but then buckets them again by an important characteristic such as acquisition channel (i.e. trade show or LinkedIn ad) and/or customer size.

Step 6: Reach conclusions about whether the hypothesis set in step 3 was true or not true. Validating or invalidating the hypothesis is done using data collected in step 5.

Step 7: In this final step the conclusions reached must be communicated by sharing the results along with recommended actions for improved customer retention and customer lifetime value.

The Cohort Analysis, as outlined above, is not a one-off exercise but continues being applied as a framework, over and over again.

The Output Of Cohort Analysis

It is helpful to compare the Cohort Analysis to a production line, as depicted on the image below.

When analysing the output of the Cohort Analysis we must ask the following questions about our customers and our business:

Question 1: Are they still a customer of ours? With each monthly cohort, we can visualize logo retention and any “break points” in the data.

Question 2: Can we recognize a pattern? For example,

  • We must ask ourselves, for example, how product usage differs between those who churned and those who remain?
  • What customer touchpoints did our customer success team, support team or services team have at that time
  • What role did we play in retention, and how can we improve?

Here is the formula for calculating customer retention, on a logo basis rather than a dollar basis:

Here is an example of how Cohort Analysis helps evaluation customer retention:

In addition to tracking customer retention, we track the total MRR associated with each cohort. By tracking MRR, we want to know if retained customers are expanding or downgrading. Is the customer adding users, modules, and
thus more MRR? Or are they downgrading by dropping seats, modules, etc.? And, of course, we track churned customers which removes MRR from the
cohort. As a result, we can track gross dollar retention (GDR) and net revenue retention (NRR).

We discussed GDR and NDR in Chapter 2 but let’s recall the meaning of these metrics.

  • Gross Dollar Retention(GDR): The subscription dollar retention after accounting for churn and downgrades, it is always < 100%.
  • Net Dollar Retention (NDR): Gross dollar retention + expansion from existing customer base, can be < or > 100%.

Here is the Gross Dollar Retention formulae:

And here is an example:

And here is the Net Dollar Retention (NDR) formulae:

And here is the Net Dollar Retention (NDR) formulae:

Introducing Segmentation To Cohort Analysis

We have mentioned earlier that there are basis and segment Cohort Analysis. What has been outlined above is the basis type. The segment Cohort Analysis follows the exact same logic and flow, except that we go deeper into the data on the basis that certain characteristics of the cohort (e.g. acquisition channel) are fundamentally different and require a separate analysis. This could look as follows:

Tips And Tricks For Performing Cohort Analysis

Cohort Analysis is not simple, but it is powerful. It takes data discipline to track and analyse cohort data. It doesn’t magically appear in your monthly reports. The observations and analysis provides actionable insights into operational strategy and resource allocation. Again, the purpose of cohort analysis is to improve customer retention and increase lifetime value.

Here are some tricks and tips on performing Cohort Analysis:

  1. Track your monthly additional bookings (new, renewals, expansion).
  1. Track your monthly books contraction (churn and downgrades)
  1. Make sure you have a good CRM system that produces good data about additional bookings and contraction bookings and that it does so for each monthly cohort. This booking data is what seeds your Cohort Analysis.
  1. Find the associated Monthly Recurring Revenue (MRR) for each month’s cohort as it is a critical input to the Cohort Analysis.
  1. If you want a CAC Payback Period in your Cohort Analysis, and it is advisable to have it, calculate recurring gross margin and CAC for each monthly cohort. And we must re-emphasis that for the recurring gross margin and CAC calculation you must have your P&L set up as a SaaS P&L. Otherwise, you will not be able to calculate correct and reliable metrics needed for the Cohort Analysis. And remember that for CAC calculation you must isolate your sales and marketing expenses dedicated to new business acquisition, as explained in the previous chapter. This can be as simple as making a % allocation of total sales and marketing expenses based on number of new business and existing business representatives.
  1. Look for “break-points” in the data, or outliers that point to something happening that either increased additional bookings or caused an unusual contraction of bookings. It is these “break points” that you must investigate and act upon. And look at the trend from month to month, if all goes well, your aggregate retention should be improving and also the performance of each new cohort should be improving relative to previous cohorts.
  1. Iterate on strategy for acquisition and retention, by fine-tuning your engine of growth.

Cohort Analysis And Its Relation To SaaS Financial Metrics​

Cohort analysis and SaaS financial metrics are closely related and provide valuable insights into the performance and growth of a SaaS business. Cohort analysis helps to understand customer behaviour and measure their value over time, while SaaS financial metrics provide a quantitative view of the company’s financial performance. Let’s explore the link between the two:

  • Customer Lifetime Value (CLTV): Cohort analysis can help calculate CLTV, which is the projected revenue a business expects to earn from a customer over their entire relationship with the company. By tracking cohorts of customers and analysing their purchasing patterns, usage behaviour, and churn rates, businesses can estimate the CLTV, a crucial metric for assessing the financial health of a SaaS company.
  • Customer Acquisition Cost (CAC): Cohort analysis can also assist in determining the CAC, which is the cost incurred by a company to acquire a new customer. By examining cohorts and measuring the expenses associated with acquiring customers within each cohort, businesses can calculate the average CAC and monitor its trends over time. This information is vital for evaluating the effectiveness of marketing and sales strategies and optimizing customer acquisition efforts.
  • Churn Rate: Cohort analysis enables businesses to track customer churn rates, which represent the percentage of customers who discontinue using the service over a specific period. Analysing cohorts helps identify patterns and trends in customer churn, such as variations in churn rates among different cohorts. By understanding the factors influencing churn, SaaS companies can develop targeted retention strategies and mitigate customer attrition, thereby improving their financial performance.
  • Monthly Recurring Revenue (MRR): Cohort analysis can be used to track MRR, which is the predictable revenue generated from customers on a monthly basis. By examining cohorts based on the time of acquisition, businesses can analyse MRR growth rates, identify variations across cohorts, and understand how different groups of customers contribute to overall revenue. This information is valuable for forecasting future revenue, identifying revenue drivers, and optimizing pricing and packaging strategies.
  • Customer Expansion Revenue: Cohort analysis can help measure the expansion revenue generated from existing customers. By examining cohorts and tracking the additional revenue derived from upsells, cross-sells, or upgrades within each cohort, SaaS businesses can gauge the effectiveness of their expansion strategies. This metric provides insights into the company’s ability to grow revenue from its existing customer base and is crucial for assessing the scalability and long-term financial sustainability of the business.

Overall, cohort analysis complements SaaS financial metrics by providing a more in-depth understanding of customer behaviour, which in turn influences these financial metrics. By analysing cohorts, SaaS businesses can make data-driven decisions to optimize customer acquisition, retention, and expansion strategies, thereby enhancing their financial performance and overall success.

In Conclusion

In conclusion, cohort analysis enables data-driven decision-making by providing granular insights into customer behaviour, retention, and revenue. It helps SaaS businesses identify opportunities for growth, optimize customer experiences, and drive long-term success of the SaaS business.

Future Focus: A Newsletter for Forward-Thinking Business Professionals

Subscribe now for thought-provoking content delivered straight to your inbox

Explore FutureEdge CFO Academy 

The FutureEdge CFO Academy (“aka” Blog) is our central repository for all meaningful information and content that FutureEdge CFO cares for and supports, which we package and make accessible to anyone who visits our site to facilitate creative thinking and inner reflection. We aspire to cultivate a growing body of knowledge that is uniquely our own, but is acquired externally, and we share it to promote the values we stand for, but also to help make sound decisions and take the most effective action.

Futuristic digital illustration representing the SaaS (Software-as-a-Service) industry. The image features a glowing cloud as the central element, interconnected with various abstract data visualizations, graphs, and network nodes. Dynamic lines and gradients suggest speed, connectivity, and innovation, while additional smaller cloud icons emphasize the cloud-based nature of SaaS. The overall aesthetic is sleek and modern, evoking themes of technology, scalability, and efficiency

The 5 Pillar SaaS Model: A Comprehensive Framework for Success

The 5 Pillar SaaS Model provides a comprehensive framework for SaaS success by focusing on Growth, Retention, Gross Margins, Profitability, and Efficiency. This holistic approach helps businesses optimize key metrics, adapt to their lifecycle stage, and build a scalable, sustainable company.

Read More
Abstract illustration depicting a dynamic contrast between a red ocean with turbulent waves and figures symbolizing competition on one side, and a calm blue ocean with serene waves and figures symbolizing opportunity and innovation on the other side. The imagery conveys the concept of Red Ocean and Blue Ocean strategies in business.

Is Your Business Strategy Red or Blue? Mastering Market Analysis

Is your business stuck in competitive Red Oceans, or are you exploring opportunity-rich Blue Oceans? Transitioning requires smart market analysis: uncover gaps, address unmet needs, and innovate. Learn how companies like Tesla and Netflix redefined industries and created fresh demand. Chart your path to growth by embracing innovation and creating your Blue Ocean.

Read More
An engaging office environment with a diverse team of professionals collaborating at a central table. A leader in a suit is presenting with dynamic gestures, pointing to a wall covered in futuristic, data-driven graphics, charts, and icons. Team members are using laptops and taking notes, displaying focus and collaboration. The background features a modern glass-walled office space with additional colleagues in discussion, fostering an atmosphere of innovation and teamwork.

Leaders Build High-Performing Teams – Not HR

High-performing teams aren’t built by HR—they’re shaped by leaders who inspire purpose, foster trust, and create clarity. While HR provides tools and frameworks, the real work happens in daily interactions, decisions, and leadership accountability. Discover the five pillars of exceptional teams and how leaders can drive extraordinary results.

Read More
n illustrative representation of a business ecosystem using interconnected gears to symbolize various operational and strategic components. Each gear depicts specific activities like supply chain management, logistics, customer engagement, and technology integration. Visual elements include modern cityscapes, delivery vehicles, data analytics icons, and communication tools, emphasizing collaboration, efficiency, and innovation. The background features a dark gradient, creating contrast and highlighting the vibrant colors and dynamic flow of the interconnected processes.

Understanding Your Business and Strategy: The Value Chain Framework

In today’s competitive business environment, strategic clarity is essential. A well-defined mission, vision, and values framework serves as a guiding star for decision-making and ensures alignment across operations. Central to achieving this clarity is understanding your business’s value chain—a powerful tool that dissects your operations into distinct activities to identify where value is created, costs are incurred, and competitive advantages can be leveraged. This article explores the value chain concept and provides a practical three-step framework to analyse and align it with your mission, vision, and values, helping businesses optimize operations, reduce costs, and enhance their competitive edge.

Read More
* Future Edge CFO * Bringing Value Of Your Business To Life
en_USEN