Customer Cohort Revenue & LTV Analytics Dashboard — Excel spreadsheet template to download
Track subscription cohort revenue, churn, and lifetime value over time
Analytics · dashboard · CC0 public domain · Built by Sheetly AI
About this template
This analytics dashboard brings together indicators like "Total Active Customers", "Monthly Recurring Revenue (MRR)" and "Average Monthly Churn Rate" in a single view. Edit the entries in the Data tab and the dashboard numbers update instantly — no need to build the spreadsheet from scratch.
Released under the CC0 license (public domain): download, edit and use it freely — including commercially — with no attribution required.
Use cases
- Visualize indicators like "Total Active Customers" and "Monthly Recurring Revenue (MRR)"
- Make faster decisions based on "Average Monthly Churn Rate"
- Compare your data without building the spreadsheet from scratch
- Edit the entries in the Data tab and watch the dashboard recalculate automatically
Key features
- Total Active Customers
- Monthly Recurring Revenue (MRR)
- Average Monthly Churn Rate
- Visual dashboard with 3 automatic indicators
- Editable formulas in the Data tab
- In-cell mini charts (sparklines)