Skip to content

SaaS KPI Dashboard Excel Template

4.64 (11 reviews)

Excel KPI tracker for software business. Track your key metrics with monthly and cumulative analysis. Printable, dynamic and nice-looking dashboard.

Download Free Version
One-Time Purchase
Business Subscription

Additional Services



Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

One-Time Purchase
Business Subscription
SOMEKA BUSINESS 99 $ /m

Redeem 3 Templates

Download 3 premium templates of your choice for free each month.

Continuous Technical Support

We’ll be your one-stop assistant for all your Excel & Google Sheets questions and needs.

Multi-User Environment

You’ll be entitled to multi-user licensing for your templates.

Cancel Anytime | Growing Catalogue | Continuous Updates

Get Startup Bundle
someka-bundle-icon

This template is also included in bundle with special discount! See details >>

TEMPLATE DESCRIPTION

Software as a Service also known as web-based software is a natural evolution of old traditional solutions. And, this SaaS KPI Dashboard Excel Template will take your results and turn them into presentable data which can be analyzed to give you a better picture of how successful you have been.

Furthermore, you will demonstrate what your SaaS business needs to perform better in the industry through measurable and precise KPI and OKR (Objectives and Key Results) metrics.

In general, we’ve focused on the most used 23 KPIs in 5 main groups for software companies:

SAAS-KPI-Dashboard-Excel-Template-Someka-01-Flow

Now, let’s see the details of the SaaS KPI Dashboard Excel Template.

SaaS KPI Dashboard Excel Template Features:

On the Dashboard, you will input the values Current Year Actual, Current Year Target, and Past Year Actual you would like to demonstrate. In this regards the navigation buttons are designed to make it easier to switch between other sections.

Navigation Menu

 

If you would like to add your own data or add a new row with a new Saas KPI code, simply delete all dummy information we used for the sample.

SAAS-KPI-Dashboard-Excel-Template-Someka-03-New-Row

Warning!: Do not forget to change other sections when you add/remove a KPI code. For example, if you add a new KPI to CY Actual section, you should also change it in CY Target, PY Actual, and Cumulative.

Trends forming with the charts will allow you to understand how your key SaaS metrics perform by giving visuals. You can select one of the SaaS KPIs you need to see.

SAAS-KPI-Dashboard-Excel-Template-Someka-04-Chart

After you input all the figures to the SaaS KPI Dashboard Template, Dashboard will present monthly and cumulatively results separately to provide a clear point of view for you. It will make it easier to interpret the past year and the company targets comparison

Detailed Description of SaaS KPI Dashboard Excel Template Metrics:

customer-iconCustomer

The Total Number Of Subscribers: Commonly referred to as “members”. The total number of receivers by paying advance regularly.

The Total Number Of Visitors: A single visitor can have multiple visits. You should track unique users that have had at least one session within the selected month.

The Total Amount of Sign-Ups: Without sign-up your product has no purpose. To increase this important metric, you should offer an incentive.

New Subscriber/Organic: Also known as natural traffic. This metric shows your accessibility to exclude advertisement.

New Subscriber/Paid: The total amount of subscribers who are coming from search engine results that are the result of paid advertising via Google AdWords or another paid search platform.

Conversion Rate: The conversion rate is the percentage of visitors who visited your page and take action on the page. They might visit the page a thousand times. But if it doesn’t convert, there’s no use in directing paid traffic to this site. This metric is especially useful if you’re using pay-per-click campaigns to drive traffic to specific pages.

You can add more KPIs for your dashboard in this Excel template.

churn-iconChurn

Number Of Churned Customers: The total number of customers/subscribers who cut ties with you during last month.

Churn Rate: Also called the attrition rate, an Increased churn rate may be a sign of poor user experience or slow service performance. Also maybe a sign of insufficient marketing activities or customer relations.

Churn Expense: This is the total amount of your churn expenses. To calculate this metric: multiply your ARPA by the number of canceled subscriptions.

Retention Rate: This Saas KPI indicates the number of customers who keep using your products and are engaged to make repeat purchases. (CE-CN)/CS: CE is the number of customers, CN is the number of new customers acquired and CS is the number of clients at the start.

revenue-iconRevenue

Average Revenue per User-ARPU: Also known as Average Revenue per Unit. To calculate ARPU: Divide the total revenue by the number of subscribers.

Monthly Recurring Revenue-MRR: This is the most important metric in the subscription business. To calculate MRR: Multiply your ARPU (average revenue per user) by the total number of paying users.

Customer Lifetime Value – LTV: This metric is one of the most important Saas KPI metrics which is a prediction value of the net profit coming from the entire future relationship with a client. It represents the total amount of profit that each client is likely to spend over his/her lifetime.

Net New MRR: This metric shows your new lifeblood. To calculate using this formula: Net New MRR = New MRR + Expansion MRR – Churned MRR

Adsense Income: This metric should show your total payment revenue from your advertisers.

Again, this SaaS KPI Dashboard template allows you to add or change metrics according to your needs.

cost-iconCost

Customer Acquisition Cost-CAC: To calculate CAC, divide your total sales and marketing spend (including personnel) by the total number of new customers.

Cost of Adsense: Ads are one of the most important metrics in any SaaS business. You may have an excellent product, but even if you don’t invest in the advertisement, you will not improve your business.

Employee Payroll: Ads are one of the most important metrics in any SaaS business. You may have an excellent product, but even if you don’t invest in the advertisement, you will not improve your business.

Cost Of Goods Sold-COGS: The COGS is a very clear metric that shows your direct costs of the goods sold per month. In general, COGS should include hosting costs, keeping the product running, third-party apps included in product delivery, etc.

management-iconManagement

Support Tickets Created: This metric should show how many issues appear per month. All the problems or requests should be converted into a ticket.

Net Promoter Score: Net Promoter Score measures the satisfaction of your business partner. Usually measured on a scale from 1 to 5 representing the amount of the satisfaction of your SaaS business.

Customer Engagement Score: Also known as Customer Effort Score which measures the effort that your customer puts in personally to have the request handled. You can measure it on a scale from 1 to 5 representing the amount of your customer’s effort.

Gross Margin: Generally, It’s calculated with this formula: Net Sales Revenue – COGS (Cost Of Goods Sold)

SaaS KPI Dashboard Excel Template Features Summary:

  • Monthly and Cumulative analysis with Saas Metrics Dashboard
  • Comparison with Past Year and Target values
  • Summary dashboard supported with interactive charts
  • Easy to use and nice design to be used in presentations
  • Clear on-sheet instructions
  • Compatible with Excel 2010 and later versions
  • Works both on Windows and Mac
  • No installation needed. Ready to use
  • Full Print ready
  • White Label
  • Does not include any VBA macros

SaaS KPI Dashboard is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

11 reviews for SaaS KPI Dashboard Excel Template

  1. Fábio Lima

    It has truly simplified the way we track and measure our metrics.

  2. Sarah D. Lay

    Great job! template’s design is classy and professional. fit my presentation perfectly!

  3. Vern J.

    Hello, I’m hoping you can assist me in unlocking my template. I bought it, it doen’s let me change colors and fonts

    • Someka

      Hi Vern, no worries at all, we are always here to help. Please use the password file that we sent you for you in the zip file. And use it to unlock the sheet. Now you can modify your template as you wish!

  4. Carol N. Myers

    Confusing input layout.

  5. John Garrison

    Good complete and reliable, I like it very much will definitely come back again, thanks

  6. Angus

    This product fulfilled my needs it was easyto use

  7. Sadio

    Hello i like the template very much but i have some question how to change image link on your template, i changed the picture to our logo but i want to it to link to our website like you did with someka logo

    • Someka

      Hi Sadio,

      Thank you for your nice comment. In order to add/change a link in a picture, you just have to right-click on it and select “add/edit link”.
      Input the link in the dialog box and that’s all. Bear in mind you have to do this AFTER you have changed the default image.

      Please see the image below:

      SaaS_review1

  8. Dan

    The template is awesome very complete and robust, i will come back for more

  9. paul dave

    really nice work. a good dashboard is about telling your performance. It provide accurately calculating what has happened, and you can find a reason for why. but correct me if I am wrong here. how do I interchange the formula for a criteria where an increase is not good?

    • Someka

      Hello Paul! Thank you for your kind words! In the formula only you have to do is changing the formula in Act/PY columns.
      For instance you can change G23/I23 formula here to I23/G23:
      =IF(LEN($D23)<2;"""";IFERROR(G23/I23*100;"""")) ---> IF(LEN($D23)<2;"""";IFERROR(I23/G23*100;""""))

      If you can't get it feel free to contact us!

  10. derek newlands

    Great value for money in this template. Comes with good dashboard to work for us and has all the major metrics you need.

  11. amanda corrado

    One thing keep this theme from being a 5-star: There is no weekly results.

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES

Search