Turn monthly customer activity into cohort-level retention and churn views, so you can see how groups acquired at different times behave as they progress through the customer lifecycle.
This Excel workbook is designed for SaaS founders, operators, revenue teams, and analysts who track new customers and active customers by acquisition month. It organizes those entries into cohort schedules and percentage matrices that make differences in retention, churn, and customer longevity easier to review.
Compare acquisition cohorts
Review customer groups on a like-for-like lifecycle basis instead of relying only on blended company totals.
Locate retention changes
See where customer retention improves or weakens across successive months after acquisition.
Support growth-quality reviews
Connect new-customer volume with the active customer base and the rate at which customers leave each cohort.
What does the cohort view reveal?
A headline customer count can hide important differences between groups acquired in different periods. The workbook aligns each acquisition month to lifecycle periods M1 through M15, helping users compare how quickly customers remain active or churn after joining.
Organize new customers by monthly acquisition cohort and follow each cohort through later lifecycle periods.
Track active customer counts for each cohort rather than viewing only a single aggregate customer total.
Calculate customer retention percentages by cohort, with a weighted-average row for an overall lifecycle view.
Calculate customer churn percentages by cohort and identify periods with higher customer losses.
Compare the pace of customer acquisition with the size and persistence of the active customer base.
What is inside the workbook?
The visible workbook structure combines monthly customer inputs with cohort schedules and calculated percentage outputs. The tables keep acquisition timing on one axis and lifecycle month on the other, allowing the same customer groups to be examined from several operating perspectives.
Customer activity inputs
Enter monthly new-customer figures and the active customers associated with each acquisition cohort.
Cohort count schedules
Review active customers by acquisition month and by elapsed lifecycle period.
Retention and churn outputs
Use color-scaled percentage matrices and weighted averages to scan cohort performance over time.
The customer activity table places monthly new-customer entries above an acquisition-cohort schedule, creating the operating base for later retention and churn analysis.
Build the cohort activity base
Start with customer counts by month and cohort. The layout separates each acquisition group and carries its active customer count forward across calendar months, so the analysis preserves the timing of when customers originally joined.
The lifecycle schedule reorganizes active customer counts into M1 through M15, making cohorts acquired in different calendar months directly comparable.
Compare active customers at the same lifecycle stage
Calendar-month reporting can make older and newer cohorts difficult to compare. This schedule resets each group to its first month and follows it across subsequent periods, helping users assess whether recent cohorts are holding customers more effectively than earlier ones.
The retention matrix displays cohort percentages by lifecycle month and includes a weighted-average row for a consolidated view.
Read retention patterns across cohorts
The retention view converts customer counts into percentages. Its color scale helps users scan for stronger and weaker cells, while the weighted average summarizes retention at each lifecycle stage without removing the underlying cohort detail.
The churn matrix highlights the percentage of customers lost in each cohort and lifecycle period, alongside a weighted-average benchmark.
Identify when customer losses occur
The churn schedule provides the complementary view to retention. Reviewing both matrices can show whether losses are concentrated soon after acquisition or occur later in the customer lifecycle, informing where onboarding, engagement, or retention initiatives deserve closer review.
How do you use the template?
Prepare monthly customer data
Gather new-customer counts and active-customer counts that can be assigned to their original acquisition months.
Populate the cohort table
Enter the customer activity figures in the corresponding monthly and cohort positions, keeping the acquisition month consistent.
Review lifecycle schedules
Use the M1-to-M15 view to compare cohorts at equivalent stages rather than comparing groups of different ages.
Interpret retention and churn
Scan individual cohorts, then use the weighted-average rows to understand the broader pattern at each lifecycle month.
Who is this template for?
The workbook is suited to subscription and recurring-revenue teams that maintain monthly customer records and need a structured cohort perspective. Founders can use it to review growth quality, revenue and customer-success teams can investigate lifecycle weak points, and analysts or investors can assess whether newer cohorts retain customers differently from earlier groups. It is most useful when customer activity can be traced back to a clear acquisition month.
