
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
Description
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.
What’s included?
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 Bookings
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
Reviews
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!Thanks David!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 Dashboard
A simple KPI sheet for early-stage SaaS startups with a low-touch sales model.startupsventure capitalsaaskpismetricsdashboardsoftware as a service3,499 remove_red_eye2 chat_bubbleSaaS Venture Dashboard
An operational dashboard to help drive your SaaS business and the associated methodologykey performance indicatorsstartupsventure capitalsaasdashboardoperationsacquiring customersretaining customersconverting customers385 remove_red_eyeDiscussThe Economics of SaaS - Gearing up a SaaS salesforce
Using a salesforce for CEOs, VP’s of Sales to understand the economics of a SaaS business.key performance indicatorscash flowstartupssaasmetricsscalingsalesforcesubscriptionrecurring revenueentrepreneur tools500 remove_red_eyeDiscussfreeby David Skok
Transform SaaS Bookings into a KPI Dashboard - Automated
Transform SaaS Bookings Data into an Executive KPI Dashboard: includes charts & graphs. (Updated)customerssaasmetricsdashboardchurnmrrkpibookingsbillingskey metric reporting587 remove_red_eyeDiscuss$50.00by Adam Jernigan
Guide: Analyze a company's SaaS metrics
Fundraise like an expert with this Internal SaaS Metrics Playbook.fundraisingstartupsguidedecision makingearly-stageventure capitalsaaskpismetricsanalytics294 remove_red_eyeDiscussfreeby Ali Rahimtula
Enterprise SaaS and SME/Consumer Fundraising Excel Model
For large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.modelinvestorsstartupsventure capitalsaastemplateexcelenterprisefundraise132 remove_red_eyeDiscuss$299.00by Alexander Jarvis
The Complete Guide to SaaS Metrics
Find out what are the must-have metrics each SaaS company should track + how to calculate themstrategystartupsguideearly-stagesaaschartsmetricsdashboardskpianalytics tool409 remove_red_eyeDiscussfreeby Alex Flom
Simple SaaS cash flow analysis
Illustrates the SaaS P&L/Cash Flow trough highlighting the importance of growth management for better profits.analysiskey performance indicatorscash flowstartupssaaschurneconomicsacquisition costscustomer value478 remove_red_eyeDiscussfreeby David Skok
SaaS Cohort Analysis Model
A 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_eyeDiscussSaaS Revenue Forecasting Model
Full-packed revenue forecasting model to help SaaS founders take better decisions with key indicators.key performance indicatorssalesrevenuesforecastingstartupssaasassumptionssoftware as a servicerecurring revenue850 remove_red_eye1 chat_bubblefreeby Noah Barr
Any questions on SaaS Metrics 2.0 Dashboard?
The user community and author are here to help. Go ahead!