Metrics Spreadsheet for Every SaaS Company

Lately I’ve been talking to more entrepreneurs that have product/market fit and are working to find a repeatable customer acquisition process (see 5 Steps to Startup Success in 30 Words). Now, sales and marketing metrics become critical and it’s time to figure out what works. Christoph Janz has the best Google Sheets Dashboard for SaaS companies:

Visitors & Signups

  • Visitors
    m/m growth
  • Signups beginning of the month
  • New signups
    – Organic
    – Paid
  • Total new signups
    m/m growth
  • Visitor-to-signup conversion rate
  • Signups end of month

Paying Customers

  • Customers beginning of the month
    – New customers
    – Conversion rate
    – Lost customers
    – Churn rate
  • Net new customers
  • Customers end of month
    m/m growth

Monthly Recurring Revenue

  • MRR beginning of the month
  • New MRR
    – New MRR from new customers
    – New MRR from account expansions
  • Total new MRR
  • Lost MRR
  • MRR churn rate
  • New new MRR
  • MRR end of month
    m/m growth
  • Avg. revenue per customer
  • Avg. revenue per new customer

Customer Acquisition Costs (CAC)

  • Marketing spendings
    – Marketing spendings per signup (blended)
    – Marketing spendings per paid signup
  • Sales spendings
    – Sales spendings per new paying customer
  • Total CAC (blended)
  • Total CAC (paid signups)
  • Time-to-recover CAC for paid signups (months)
  • CLTV (e)
  • CLTV/CAC (paid signups)

Cash

  • Cash beginning of month
    – Cash coming in
    – Cash going out
  • Net cash burn
  • Cash end of month
  • Runway at current burn (months)

SaaS entrepreneurs would do well to use the Google Sheets Dashboard for SaaS companies. And, if inside sales is employed, take a look at the Google Sheets Dashboard with Inside Sales.

What else? What are your favorite metrics for SaaS startups?

Comments

7 responses to “Metrics Spreadsheet for Every SaaS Company”

  1. Joe Rizzo ͡(ಠ_ಠ) (@joemktg) Avatar

    Would you please check the link for the Sheet?

  2. Adam Rogers Avatar

    How about customer support metrics? Using customer support metrics to measure success is a great way to look at repeat business/customers or even where your customers are churning. There’s a full list here: https://blog.kayako.com/customer-support-metrics/

  3. Tracey Avatar
    Tracey

    What’s the difference between “signups” and “new customers”? Thanks!

    1. Leo Faria (@lhfaria) Avatar

      Hey Tracey, “signups” may refer to trials, while “new customers” refers to users that became actual paying customers.

  4. Leo Faria (@lhfaria) Avatar

    I kindly invite you guys to check out our solution at http://www.saasmetrics.co that contains pretty much all these metrics in a well designed, free software.

  5. Mo Abbas Avatar
    Mo Abbas

    Hi,

    Thanks for sharing, this is very useful!

    As the spreadsheet is geared towards a ‘low touch’ sales model (self-service/online signups etc) do you have a version for a direct/high touch sales?

    Regards,
    Mo

  6. Marilee smith Fitch Avatar

    The question I am seeking an answer to is within
    The operating company. Can I follow my company’s patterns ( even hourly and emotionally) to better the burn rate?

    Two ways to track this would be on a credit card that monitors everything ( time purchases made/ or money spent and WHY, who is buying stuff or issuing permission….. in my own company I suspect real costs to cut by about 1/3.

    Second example of this was by an app a client brought me to finance. It allowed doctor offices to follow ehat kind of people canceled appointments the most…this allowed the doctors offices to completely change how they scheduled their clients and re-tool their booking.

    If anyone is out their to talk with , please contact me
    Thank you

Leave a reply to Leo Faria (@lhfaria) Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.