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.
- Social and Display Ads
- Content Marketing (blog posts)
- Email Marketing
- Community Building
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
After logging in, click on ‘Use template‘ to configure the Marketing KPIs template in your Google Drive.
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.
Step 3. Fill out all input spreadsheets
Each of the spreadsheets has an instructions tab that will explain step by step the process to fill out and configure the template. Let’s learn more about these KPIs Spreadsheets.
All Individual KPIs Spreadsheets contain the following tabs
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
Step 4. Configure the Marketing KPI dashboard
This spreadsheet consolidates all your individual Marketing KPI spreadsheets into a single master sheet and contains the following tabs:
You’ve configured your Marketing KPI template and dashboard for Google Sheets. Feel free to adapt it as you see fit to meet the needs of your business. If you have had difficulties making this template work, please chat with us using the bubble on the right below and we will be happy to assist you with setting it up.