SaaS Metrics Dashboard

Description
Note: The cells with light blue background are data-entry cells and contain arbitrary sample numbers which you can change. Everything else is calculated.
Footnotes
1) Make sure that only visitors to your marketing website are included here. Exclude visits from existing users who use the application.
2) Signups = Free trials
3) In order to keep this template simple and general, different pricing plans or multiple seats per account are not modeled here. You may want to add this based on your specific requirements.
4) New customers divided by the signups of the previous month, assuming a 30-day trial. Since the actual time-to-conversion may vary (e.g. due to trial extensions), this is a simplification.
5) This means new MRR from existing customers, e.g. due to existing customers buying more seats or upgrading to premium plans or features.
6) It's important to distinguish MRR churn from customer churn – MRR churn is more important since it takes into if you're losing smaller or bigger accounts.
7) Lost MRR divided by MRR at the beginning of the month. Another way to look at this would be to view the difference between new MRR from account expansions and lost MRR. Based on that metric you can achieve negative churn if new MRR due to account expansions is bigger than lost MRR.
8) Marketing spendings per paid signups are more important than the blended view since it is a better indication of lead generation costs at scale.
9) This shows the average sales spendings per new customer. If you have different customer segments (e.g. small customers who get less attention from the sales team, big customers who get more attention) you should model this here.
10) For simplification purposes this assumes that organic and paid signups convert equally well to paying customers. This may not be true, make sure you track conversion rates per marketing channel.
11) This is a crude estimation based on the churn rate. Since churn doesn't occur linearly over the customers' lifetime you need to do a cohort analysis in order to get a better approximation.
Explanation of acronyms
MRR = monthly recurring revenue
ARPA = average revenue per account
CAC = customer acquisition costs
CLTV = customer lifetime value
Disclaimer: Please be aware that his model may be inaccurate, incorrect or misleading, use it at your own risk.