Frequently Asked Questions

This blog covers retention metrics for subscription-based small businesses. The core topics are churn rate calculation and interpretation, the compounding effect of churn over time, customer lifetime value using a simple formula, cohort analysis as a tool for understanding subscriber behavior, building a self-updating retention dashboard in Google Sheets, and the decision framework for when to invest in acquisition versus retention.

The goal is to make these frameworks accessible to operators who don't have a data team. Every topic includes a downloadable template.

No. This blog is purely informational. There is no consulting service, no paid course, and no upsell. The templates are free. The frameworks are documented in full. The contact form exists for questions about the content, not for booking any service.

No account is required. The templates are available without signing up for anything. You may need to request access via the contact form for some templates while the download system is being set up, but no email subscription or account creation is required.

The basic formula is: (Subscribers Lost During the Month) divided by (Subscribers at the Start of the Month). The result is your monthly churn rate as a decimal, which you multiply by 100 to express as a percentage.

The denominator choice matters. Some operators use the subscriber count at the end of the month or an average of start and end counts. Each approach gives a slightly different number. The important thing is to pick one method and apply it consistently so your numbers are comparable month over month.

Gross churn measures only the revenue or subscribers lost. Net churn subtracts any expansion revenue from existing subscribers (upgrades, add-ons) from the lost revenue. Net churn can be negative, meaning existing subscribers are generating more new revenue than the revenue lost from cancellations.

For most small subscription businesses, gross churn is the more useful number because expansion revenue is limited. Net churn becomes meaningful when you have meaningful upsell or cross-sell activity.

Failed payments (involuntary churn) should ideally be tracked separately from voluntary cancellations. If a subscriber's card fails and they don't update their payment method, that's a different problem than a subscriber who actively decides to cancel.

For the churn rate calculation, you have two options: include failed payments in your churn count (gives a complete picture of subscriber loss) or exclude them and track involuntary churn separately. Either approach is defensible as long as you apply it consistently and understand what your number represents.

The napkin formula (Monthly Revenue per Subscriber divided by Monthly Churn Rate) is a useful approximation, not a precise measurement. It assumes a constant churn rate and identical subscriber revenue, neither of which is exactly true for most businesses.

Its value is in being directionally correct and immediately calculable. If your napkin CLV is $200 and your customer acquisition cost is $180, that ratio tells you something important about your business even if the precise CLV is somewhere between $180 and $230. Use it as a decision-making input, not as an accounting figure.

Cohort analysis starts becoming useful with six months of data and at least 30-50 subscribers per cohort. With fewer than 30 subscribers in a cohort, the percentage changes from month to month are noisy and hard to interpret meaningfully.

If your cohorts are smaller than that, you can group multiple months together into a single cohort (Q1 subscribers, Q2 subscribers) to get larger groups. The insight is less granular but the numbers are more reliable.

The churn cliff is the point in a subscriber's lifecycle where cancellation risk is highest. For many subscription products it occurs in the first 30 to 90 days when subscribers are deciding whether the product delivers on its promise. A cohort grid makes this visible as a steep drop in the retention percentage in the early months.

Identifying when your churn cliff occurs tells you where retention intervention has the highest potential impact. If most cancellations happen in month two, that's where onboarding improvements, engagement prompts, or value reinforcement communications should be focused.

No. The template is pre-built with all formulas in place. You only interact with the data input tab, which is structured like a simple table. You add your subscriber counts and revenue figures for each month and the metrics and charts update automatically.

The topic documentation explains how the formulas work in case you want to understand or modify them, but understanding the formulas is not required to use the template.

The template is designed for manual data entry, not live data connections. Most small subscription businesses can export a monthly CSV from their payment processor (Stripe, Paddle, etc.) and paste the relevant numbers into the input tab in a few minutes.

If you want a live connection, Google Sheets supports API connections through Apps Script, but that requires development work that goes beyond what this blog covers. The manual approach is intentional: it keeps the template accessible and doesn't require any third-party integrations.