LogoAI Finance Tools

Cohort Analysis

Tracking a group of customers acquired in the same period to measure retention and revenue trends over time.

Cohort analysis is an analytical technique that groups customers or users by a shared characteristic—most commonly their acquisition date (e.g., all customers who signed up in January 2024)—and then tracks that group's behavior over successive time periods. By isolating cohorts, businesses can distinguish genuine improvement in retention or engagement from the noise of a growing customer base.

In SaaS and subscription businesses, cohort analysis is most commonly used to measure revenue retention: how much of the revenue generated by a cohort in month one is still present in months two, three, six, and twelve? A well-retained cohort maintains or grows its revenue over time, whereas a poorly retained cohort shows a steep decline curve.

Cohort tables are typically visualized as a triangular heat map where rows represent acquisition periods (cohorts) and columns represent time elapsed since acquisition. Green cells indicate high retention; red cells indicate churn. Comparing rows helps identify whether recent cohorts are healthier than older ones—a sign of product improvement or better customer targeting.

Beyond revenue, cohort analysis applies to behavioral metrics: feature adoption curves by cohort, support ticket volume per cohort, or upgrade rates by cohort. Product teams use behavioral cohort analysis to understand which onboarding changes improved activation.

Cohort analysis is foundational for forecasting future revenue because it allows finance teams to project forward from current cohort retention curves. Investors frequently request cohort data during due diligence as evidence of long-term unit economics.

FAQs

What is a cohort in the context of SaaS analysis?

In SaaS, a cohort is a group of customers who started their subscription in the same time period, such as all customers who signed up in Q1 2024. By grouping customers this way, you can track how their behavior—revenue retained, feature usage, churn rate—evolves over time and compare different cohorts to measure whether the business is improving at retaining and growing customers.

How do you read a cohort retention table?

A cohort retention table has rows for each acquisition period (e.g., each month) and columns for time elapsed (Month 0, Month 1, Month 2, etc.). Each cell shows the percentage of the original cohort still active or the revenue retained. Reading down a column shows whether newer cohorts perform better or worse than older ones at the same age, while reading across a row shows how a single cohort decays over time.

What retention curve shape indicates a healthy SaaS business?

A healthy SaaS retention curve flattens out after an initial drop, eventually plateauing. This flattening means the remaining customers are highly engaged and unlikely to churn further. A curve that keeps declining toward zero suggests the product has no sticky core audience. Best-in-class companies show curves that not only flatten but slope upward over time—indicating expansion revenue from existing customers exceeds churn.

Related Terms

Tools for this concept

Workday Adaptive Planning (formerly Adaptive Insights, acquired 2018) is a cloud-based financial planning and analytics platform that provides flexible, collaborative budgeting, forecasting, and reporting capabilities for organizations of all sizes. For Workday Financials customers, Adaptive Planning provides native integration with actual financial data—enabling real-time plan vs. actual analysis without manual data exports. The platform's modeling environment supports driver-based financial models where operational changes automatically update financial projections. Scenario planning enables finance teams to model multiple futures simultaneously and compare outcomes. Workforce planning connects headcount assumptions to financial models with employee-level detail. Sales planning and pipeline analysis extend planning beyond finance to revenue operations. The Office Connect tool embeds live Adaptive Planning data in PowerPoint and Excel for executive presentations. The platform's accessibility for business partners—not just finance professionals—enables distributed budgeting with central governance. Approvals and workflow manage the budget submission and review process across business units. Real-time dashboards provide financial performance visibility for executives and managers. Workday Adaptive Planning's advantage is its Workday ecosystem integration—combined with Workday HCM and Workday Financials, it creates a comprehensive people, finance, and planning platform with native data consistency across all modules. Gartner rates it among the top cloud FP&A solutions globally.

Prophix is a Corporate Performance Management (CPM) software company providing budgeting, planning, reporting, and consolidation for mid-market organizations that have outgrown Excel but don't require full enterprise EPM complexity or pricing. Founded in 1987 in Mississauga, Canada, Prophix serves over 3,000 companies in 100+ countries with a focus on making financial planning accessible to organizations with 200–2,000 employees. The platform provides a complete FP&A workflow: budget and forecast modeling, variance analysis, management reporting, and financial consolidation. Driver-based planning models connect operational assumptions to financial outputs. The cloud-based platform provides browser access and mobile reporting for executive stakeholders. Prophix IQ uses AI to surface financial insights and assist with narrative generation for reports. Pre-built content and implementation methodology enable faster deployment than bespoke enterprise implementations. Integration with popular ERP systems including NetSuite, SAP, Oracle, and QuickBooks enables automated actuals import. Consolidation capabilities handle multi-entity organizations with currency translation. Prophix's mid-market positioning delivers enterprise FP&A capabilities at accessible pricing, making it competitive for organizations underserved by both enterprise platforms (too complex and expensive) and basic tools (too limited). Gartner recognizes Prophix in the FP&A market as a mid-market leader.

Jedox is an AI-powered planning, analytics, and reporting platform that combines the familiarity of Excel with enterprise-grade planning capabilities, making it particularly accessible for finance teams transitioning from spreadsheet-based planning. Founded in Freiburg, Germany in 2002, Jedox serves over 2,500 organizations globally. The Excel Add-In enables finance teams to work in Excel while accessing a shared, consistent planning database—eliminating version control and data integrity issues of standalone spreadsheets. Cloud and on-premise deployment options accommodate data governance requirements. AI-driven planning assistance provides forecast recommendations, anomaly alerts, and data enrichment automatically. Driver-based financial models connect operational metrics to financial projections. Consolidated planning covers P&L, balance sheet, cash flow, and operational plans in connected models. Workforce planning handles headcount and compensation modeling. Pre-built content for retail, manufacturing, and financial services accelerates deployment. Integration with SAP, Oracle, Microsoft Dynamics, Salesforce, and other systems automates actuals import. Jedox's Excel familiarity reduces training requirements and adoption resistance—a persistent challenge with enterprise planning tools. The platform is particularly popular in Europe and with organizations that want modern planning capabilities while leveraging existing Excel expertise. Gartner recognizes Jedox in the FP&A Solutions market.