Accounts
6
At risk
2
Revenue at risk
$134,000
Customer Health Scorecard
Score each account on usage, support, relationship and payments to spot churn risk early.
SpreadsheetAccounts & CustomersFree
Calculate LTV, LTV:CAC and payback by plan, and track how many customers each monthly cohort keeps over time.
Shown with sample data
Calculate LTV, LTV:CAC and payback by plan, and track how many customers each monthly cohort keeps over time.
Latest: 92.3%
Know what a customer is worth before you decide what to spend acquiring one. The LTV sheet takes average revenue per user, gross margin, monthly churn and acquisition cost for each plan and returns expected lifetime, lifetime value (ARPU × gross margin ÷ churn), LTV:CAC and months to pay back CAC, with a health flag. The Cohorts sheet tracks each month’s new customers and how many remain after 1, 2, 3, 6 and 9 months, turning them into retention percentages and a weighted average curve.
A common formula for subscriptions is LTV = ARPU × gross margin ÷ monthly churn rate. For example, $60 a month × 75% margin ÷ 3% churn = $1,500. Average lifetime is 1 ÷ churn, so 3% monthly churn means about 33 months.
Around 3:1 is the widely used benchmark: each customer is worth three times what it cost to acquire. Much lower means you are overspending on acquisition or losing customers too fast; much higher may mean you are underinvesting in growth.
Grouping customers by the month they joined and tracking what share remain active over time. It shows whether retention is improving for newer customers and when most customers leave, which averages across the whole base can hide.
Customers lost during the month ÷ customers at the start of the month. Use an average over several months for the LTV calculation because single months are noisy.
Download a copy
Downloads need a free account.