Marketing KPI Template in Google Sheets

by Sep 4, 2019

Alright marketers, this one’s for you.

Your team may be creating the coolest ad campaigns, the most creative content and the best design – but we all know that none of this matters unless you can prove they are actually working.

Managers look at the bottom line. And that means numbers. It may seem that the effectiveness of your marketing strategy is hard to evaluate, but one of the great things about the digital world is that it’s now easier than ever to measure results.

KPIs – or key performance indicators – measure whether a business or organization is achieving its objectives. Here we’re going to outline how you can track the right marketing KPIs in a really simple way. Using the tools you already know: spreadsheets. Oh, and it won’t cost you a thing. We’ve got a free marketing KPI template in Google Sheets to help you do it.

What are marketing KPIs?

You hear KPI, or key performance indicators, mentioned all the time. But it’s surprising how often people forget about the word key in this acronym. KPIs should be limited – they should be the most important metrics for measuring the success of your business. Rather than trying to measure 50 different things, we recommend that you focus on 10 or fewer.

First, let’s break it down by marketing channel.

When it comes to digital marketing, you will probably be working with these 6 channels:

  1. SEM (search engine marketing)
  2. Social and Display Ads
  3. SEO (search engine optimization)
  4. Content Marketing (blog posts)
  5. Email Marketing
  6. Community Building

Let’s take number 5 – Email Marketing – as an example. What key performance indicators might you look at? KPIs need to be SMART. This means they are:

  • Specific
  • Measurable
  • Attainable
  • Relevant
  • Time-bound

Following these criteria, 10 KPIs for Email Marketing might include:

  1. The number of emails opened (#)
  2. The email open rate (%)
  3. The number of clicks (#)
  4. The click rate (%)
  5. The number of conversions ( #)
  6. The conversion rate (#)
  7. The number of forwards/shares (#)
  8. The unsubscribe rate (%)

OK, so you get the idea. Your KPIs for other areas of your marketing strategy need to be similarly precise and measurable.

Once you’ve decided on what metrics you want to analyze, you can start tracking your KPIs. But what do you do with all this information and where do you store it?

Marketing analysis tools like Google Analytics are extremely powerful but you can risk drowning in data. A busy marketing team with a multi-channel strategy can generate a lot of data. It makes sense to bring all of your marketing KPIs together in one place to get a clear overview – and you might be surprised to learn that you can do that in a spreadsheet.

Using a spreadsheet to track marketing KPIs

When it comes to collating data, nothing beats a spreadsheet.

They’re relatively simple, everyone can use them, and – if you use Google Sheets – they are free and easy to share in the Cloud. In fact, a spreadsheet is all you need to monitor your marketing KPIs.

We’ve created a free marketing KPI template in Google Sheets to help you do this. No special software required. By using the template you can:

✅ Get an overview of all marketing channels’ KPIs

✅ Track KPIs to meet your business objectives

✅ View key metrics over time

✅ Compare different metrics

✅ Look at the status of projects (e.g. metric goal vs. metric result)

In one single spreadsheet

Using our ready-made, standalone template you just enter the data and our spreadsheet does the work. Easy. We’ve already written the formulas for you.

🙂 Free standalone marketing KPI template

🙂 No need for special software

🙂 Easy to use – in Google Sheets

How do I get the template?

  • Click the following link to get a copy of the free marketing KPI template
  • The template is saved to your Google Drive and it opens automatically

How do I use the template?

We’ve created the template for you in Google Sheets so all you need is a Google Account.

Step 1:

Get your copy from the link above. The template is saved to your Google Drive and it opens automatically.

Take a look at the instructions tab in the spreadsheet.

Step 2:

Register all of the KPIs for your individual marketing channels in the “Consolidated Tracking” tab.

Step 3:

In the “Experiments” tab, register all of your marketing experiments and their status. Only enter data into the white cells – the grey cells fill automatically.

Congrats!

Your Marketing KPI template is up and running. You’ve got a simple and clear overview of the progress your team is making towards their KPIs.

Check out your dashboard for an illustration of your most important marketing metrics.

Managing a large marketing team?

Try connecting spreadsheets in a Sheetgo workflow

Do you need a more collaborative solution than one single spreadsheet? Is it too difficult or time-consuming to pull together all of the KPI data from different teams or colleagues? We’ve got you covered.

Try creating a workflow with Sheetgo. With Sheetgo you can connect the KPI spreadsheets from each individual marketing channel to your own master sheet. Each team updates their own spreadsheet(s) and you can view all the results – in one place. And the best part? The data flows automatically.

Spreadsheets are a brilliant, universal solution for tracking KPIs – everyone has access to spreadsheets and they’re easy to use. But they rely on time-consuming manual work and copy/pasting can lead to errors. Imagine if your spreadsheets could “talk to each other”…

With Sheetgo, they can.

If you can use spreadsheets, you can use Sheetgo to automate your spreadsheet workflows. This means you can:

  • Create workflows by connecting different spreadsheets
  • Import data from multiple spreadsheets into one master sheet
  • Collaborate in teams
  • Get automated updates
  • Save time
  • Reduce manual errors
Channel Sheets and Marketing KPI Master Sheet Icons

How to connect spreadsheets with Sheetgo

Sheetgo is a connection tool for Google Sheets spreadsheets. Sheetgo powers connections between these spreadsheets. This allows data to flow from one to the other, in an automated system.

To get started:

Step 1:

Install the Sheetgo Add-On.

Step 2:

Click here to get a copy of the Content Marketing KPIs (input) spreadsheet. It’s a Google Sheets file so it will be automatically saved in your Google Drive. Make as many copies as you need. You can allocate a copy of this spreadsheet to individual colleagues who manage different marketing channels. Rename the files accordingly: e.g. SEO, SEM, Email Marketing and so on.

Your colleagues will use these spreadsheets to track their KPIs and send the data to your master spreadsheet (the template we gave you earlier!).

Put these files in a folder.

Step 3:

Open your Marketing KPIs dashboard master spreadsheet (the one we gave you earlier) in Google Sheets.

Go to the menu bar > Add-Ons > Sheetgo > Start. Sheetgo opens as a sidebar on your screen.

Step 4:

Use the Sheetgo Add-On to import data from the input (marketing channel) spreadsheets. Select the folder as your source.

Step 5:

Under “Settings” change the connection name to “Consolidated Tracking”.

That’s it!

You have connected spreadsheets with Sheetgo to create your own Marketing KPI workflow. Check out your dashboard. You now have a visual overview of the status of all your marketing channel KPIs.  Feel free to customize the dashboard to your needs.

Want to save time by automating other business processes? Check out our OKR template for managing your teams’ key objectives and results.

Content Marketing Sheet in Google Sheets

Pin It on Pinterest

Share This

Share this post with your friends!