Last version published: 20/12/2016 10:04
Publication number: ELQ-94256-3
View all versions & Certificate
SaaS Metrics 2.0 Dashboard
A dashboard to help founders manage their SaaS business
This file contains an excel sheet for a hypothetical SaaS company with a traditional numeric report and a dashboard of graphs is included. Although there are multiple approaches to doing this, this template is intended to provide inspiration for your own metrics dashboard.
o One version of the dashboard for companies using primarily monthly contracts (focused on MRR)
o A second version designed for companies using annual contracts, focusing on ACV (Annual Contract Value)
What are the metrics?
o MRR (Monthly Recurring Revenue)
o Churn metrics
o Unit economics (new customers)
o Summary financial metrics
o Cash and deferred revenue
o Funnel metrics
o Sales metrics
+ Associated graphs
N.B. It is recommended that you replace the formulae and instead use the Copy & Paste function to paste in values instead of formulae. This is because the value of this spreadsheet is not in the formulae, but more in the understanding of knowing what to track.
- David Skok, www.forentrepreneurs.com
More on this page: http://www.forentrepreneurs.com/saas-metrics-2/
This business tool includes
1 Excel Model
David Skok offers you this business tool for free!
download for free
Add to bookmarks
- José Ignacio Bravo(last updated: 18/04/2018 02:28)
- Estelle Padeloup(last updated: 01/03/2018 20:52)
- Paya Danesh(last updated: 25/02/2018 09:47)
- Alfonso Cioffi(last updated: 31/12/2017 14:14)
- Jane Uzunovski(last updated: 25/12/2017 13:07)Great SaaS Metrics Model!
- Mamadou Dr. Bass(last updated: 29/09/2017 09:43)
- Guilherme Lima(last updated: 21/09/2017 17:54)
- Alexandr Marchenko(last updated: 26/05/2017 05:14)
- Baptiste Lacroix(last updated: 17/01/2017 15:00)
People using this tool also downloaded
SaaS Metrics DashboardA simple KPI sheet for early-stage SaaS startups with a low-touch sales model.startupsventure capitalsaaskpismetricsdashboardsoftware as a service3,499 remove_red_eye
SaaS Venture DashboardAn operational dashboard to help drive your SaaS business and the associated methodologykey performance indicatorsstartupsventure capitalsaasdashboardoperationsacquiring customersretaining customersconverting customers385 remove_red_eye
The Economics of SaaS - Gearing up a SaaS salesforceUsing a salesforce for CEOs, VP’s of Sales to understand the economics of a SaaS business.key performance indicatorscash flowstartupssaasmetricsscalingsalesforcesubscriptionrecurring revenueentrepreneur tools500 remove_red_eye
Transform SaaS Bookings into a KPI Dashboard - AutomatedTransform SaaS Bookings Data into an Executive KPI Dashboard: includes charts & graphs. (Updated)customerssaasmetricsdashboardchurnmrrkpibookingsbillingskey metric reporting587 remove_red_eye$50.00by Adam Jernigan
Guide: Analyze a company's SaaS metricsFundraise like an expert with this Internal SaaS Metrics Playbook.fundraisingstartupsguidedecision makingearly-stageventure capitalsaaskpismetricsanalytics294 remove_red_eyefreeby Ali Rahimtula
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.modelinvestorsstartupsventure capitalsaastemplateexcelenterprisefundraise132 remove_red_eye$299.00by Alexander Jarvis
The Complete Guide to SaaS MetricsFind out what are the must-have metrics each SaaS company should track + how to calculate themstrategystartupsguideearly-stagesaaschartsmetricsdashboardskpianalytics tool409 remove_red_eyefreeby Alex Flom
Simple SaaS cash flow analysisIllustrates the SaaS P&L/Cash Flow trough highlighting the importance of growth management for better profits.analysiskey performance indicatorscash flowstartupssaaschurneconomicsacquisition costscustomer value478 remove_red_eye
SaaS Cohort Analysis ModelA simple cohort analysis spreadsheet to understand how you are doing on your KPIs (Churn, Customer Lifetime etc.)startupssaasconversionsoftware as a servicechurncohort analysismrrcustomer retention748 remove_red_eye
SaaS Revenue Forecasting ModelFull-packed revenue forecasting model to help SaaS founders take better decisions with key indicators.key performance indicatorssalesrevenuesforecastingstartupssaasassumptionssoftware as a servicerecurring revenue850 remove_red_eyefreeby Noah Barr
Any questions on SaaS Metrics 2.0 Dashboard?
The user community and author are here to help. Go ahead!