Alright marketers, this one if for you. So you’ve been using some Marketing KPI to get the most out of your product, service, website or blog -great! Now, you may wonder: “how to effectively track marketing KPIs?” Well, let’s face it, marketing is all about continuously experimenting and collecting data making it inevitable to use good old spreadsheets.

For that reason, we’ve created a marketing system that doesn’t require you to use complicated formulas or other technical skills. The best part of this is that you can manage all your Marketing KPIs under the same hood. All you have to do is to set it up and use the dashboard to track and share your KPIs with colleagues. This is a free Marketing KPI template for Google Sheets. 🙂

What are the most important Marketing KPI for SaaS companies?

If you are investing in SEM tools such as Google Ads, Bing Ads or Facebook Ads then you should know your Return on Investment (ROI) as there are many SEM techniques available such as PPC (pay-per-click), CPC (cost-per-click), PPC (pay-per-call), Paid search advertising, PFI-Pay For Inclusion, Paid search ads, and SEO-Search Engine Optimization.

We’ve put together our Top 6 Marketing KPI for Saas companies.

  1. SEM
  2. Social and Display Ads
  3. SEO
  4. Content Marketing (blog posts)
  5. Email Marketing
  6. Community Building
Channel Sheets and Marketing KPI Master Sheet Icons

Let’s Get Started

Step 1. Install the Marketing KPI template for Google Sheets

Click on the button below to install your Marketing KPI template. You will be asked to log in with your Google account as the spreadsheets will be created and saved into your Google Drive. Your Sheetgo account will automatically be created after the Google login.

After logging in, click on ‘Use template‘ to configure the Marketing KPIs template in your Google Drive.

Example

Sheetgo Marketing KPI Template Overview

Step 2. Open all spreadsheets

The template consists of 4 input spreadsheets (“SEO”, “SEM”, “Content Marketing”, and “Email marketing”) that are connected to 1 master spreadsheet “Marketing Dashboard KPIs”. Open each of these spreadsheets by clicking on their spreadsheet icons, as seen on the image below.

Marketing KPI Template: Network Illustrating Workflows and Connections

Step 3. Fill out all input spreadsheets

Content Marketing Spreadsheet

This part of the Template has the following KPIs:

  • # of blog posts created
  • # accumulated blog posts created
  • # of total visitors
  • Average visitors per post
  • # of converted visitors
  • % conversion rate

Example

Content Marketing Sheet in Google Sheets

Step 4. Configure the Marketing KPI dashboard

Marketing KPI Dashboard in Google Sheets

Congrats! 🙂

Share This