Digital Marketing, Resources, Social Media

2018 Social Media KPI Tracking Spreadsheet – Downloadable Template

(Last Updated On: January 19, 2019)

Are you a social media manager who struggles to keep track of the monthly growth and performance of the channels you manage? Then you should definitely check out my 2018 Social Media KPI Spreadsheet!

What Is The Idea Behind The 2018 Social Media KPI Spreadsheet?

As a marketer who has been managing social media channels for a few years now, I used to find it pretty hard to actually sit down and evaluate my monthly and annual social channels performance.

My Social Media KPI template helped me solve this issue back in 2016.

Why am I using a spreadsheet to track KPIs?

Because it is simple, easy, free and customizable.

All it takes is to fill in my metrics at the end of each month and I can actually see and evaluate the performance of my overall social media strategy.

Why You Need To Track Your Monthly Social Media KPIs?

The majority of the social media networks you use for your marketing efforts provide an awesome amount of data.

However, I discovered that almost none of them can provide you with a big overview, monthly and annual KPI trends.

And yes…

I suppose there are many paid and free online tools that can give you that big overview.

But the power of manually entering your data in a social media KPI spreadsheet is that you really get to see and absorb all the information and important trends.

When I first started KPI tracking in 2016 with a spreadsheet similar to this one, I could definitely start to see all the impact from the social media algorithms updates.

Each month they would impact one or another of my KPIs and the best thing is that I knew what exactly provoked the decrease or increase in my social media KPI metrics.

Another great advantage of having your own KPI spreadsheet is that you get to monitor and track the exact metrics that matter to you.

Click here to access the Social Media KPI Spreadsheet for 2018! (Let me know you got it by sharing this blog post on Twitter or liking my Facebook page.)

What Is Inside My 2018 Monthly Social Media KPI Tracking Template?

My Social Media KPI spreadsheet might look quite basic, but once you start filling in your monthly data you will get very excited about the trends and data you will get to see.

So here are the sheets from the template:

The General Overview

In the first spreadsheet — called “2018 KPI tracking” — there are three tables.

Social Media KPI Spreadsheet Demo by Doraseeks.com
Track and compare your monthly social media KPIs

What I have decided to include is:

  • “Followers Growth Trends” table – where you get to see the monthly growth and growth trends for all the social media channels you manage.
  •  “Average Monthly Post Organic Reach Trends”  table – where you get to see the average post organic reach trends month over month for each of your social media.
  • “Average Monthly Engagement Rate Trends “ table – where you get to see the average monthly engagement rates for each of your channels;

Although this general overview might not be important for all of you, for many it could be a great thing to take one look and see how your channels are growing, how your organic reach is changing and how engaged your users are across each social media.

The Pre-Set Formulas

Here are the pre-set formulas that I have used for this sheet:

  • % change formula= ((new entry – previous entry)/(previous entry))*100
    • Example: ((value for Mar 2017 – value for Feb 2017)/(value for Feb 2017))*100
  • Absolute change formula = (new entry – previous entry)
    • Example: (value for Mar 2017 – value for Feb 2017)
    • This is the formula used for any metrics that are a % (like the avg. engagement rate metric);

The Facebook KPI Spreadsheet

Facebook KPI Spreadsheet, Twitter KPI Spreadsheet, Instagram KPI spreadsheet Templates by Doraseeks.com

Here are the metrics in the Facebook KPI template:

  • Number of New Posts – here you will enter how many new posts did you publish throughout the month on Facebook;
  • Likes – here you will enter the number of likes your page had at last day of the month;
  • Net Likes – this field calculates automatically and shows you the net increase/decrease of your Facebook likes;
  • Total Reach – fill in the total reach your new posts collected during the month;
  • Total Organic Reach – a column for the total organic reach your posts generated;
  • Total Paid Reach – a column for the total paid reach from your boosted Facebook posts;
  • Total Unique Engagements – here you will enter the total engagements that your posts collected during the month;
    • Alternatively: You can track the total unique engaged users to have an ever better idea of what is the exact % of people who saw your posts and engaged with them (the avg. engagement rate)
  • Avg. Engagement Rate – this field calculates automatically by dividing (total unique engagements)/(total reach)
  • Avg. Post Organic Reach – this field calculates automatically with the formula (total organic reach/number of new posts)

The Pre-Set Formulas

Here are the pre-set formulas that I have used for this sheet:

  • % change formula= ((new entry – previous entry)/(previous entry))*100
  • Absolute change formula = (new entry – previous entry) 
  • Avg. Engagement rate formula = (total engagements/total reach)*100
  • Avg. Post Organic reach formula = (total organic reach/number of new posts) 

The Twitter KPI Spreadsheet

Visually the KPI spreadsheet for Twitter is similar to the one for Facebook. Here is the columns I included:

  • Number of New Tweets – here you will enter how many new Tweets did you post throughout the month on Twitter;
  • Followers – here you will enter the number of followers your Twitter profile had at the end of the month;
  • Net Followers – this field calculates automatically and shows you the net increase/decrease of your Twitter followers;
  • Total Impressions – fill in the total impressions your new Tweets collected during the month;
  • Total Organic Impressions – a column for the total organic impressions your Tweets generated;
  • Total Paid Impressions – a column for the total paid impressions from your promoted Tweet posts;
  • Total Engagements – here you will enter the total engagements that your Tweets collected during the month;
  • Avg. Engagement Rate – this field calculates automatically by dividing (total engagements)/(total impressions)
  • Avg. Tweet Organic Impressions – this field calculates automatically with the formula (total organic impressions/number of new tweets)

The Pre-Set Formulas

Here are the pre-set formulas that I have used for the Twitter sheet:

  • % change formula= ((new entry – previous entry)/(previous entry))*100
  • Absolute change formula = (new entry – previous entry) 
  • Avg. Engagement rate formula = (total engagements/total impressions)*100
  • Avg. Tweet Organic Impressions formula = (total organic impressions/number of new Tweets) 

The Instagram KPI Spreadsheet

I have as well included an Instagram KPI Spreadsheet with similar metrics like the once for Twitter and Facebook. Here are the columns I included:

  • Number of New Posts – here you will enter how many new posts did you publish throughout the month in Instagram;
  • Followers – here you will enter the number of followers your Instagram page had at last day of the month;
  • Net Followers – this field calculates automatically and shows you the net increase/decrease of your Instagram audience;
  • Total Impressions – fill in the total impressions your new posts collected throughout the month;
  • Total Reach – a column for the total reach your posts generated;
  • Total Post Engagements – here you will enter the total engagements that your posts collected during the month;
  • Avg. Engagement Rate – this field calculates automatically by dividing (total post engagements)/(total impressions)
  • Avg. Post Impressions – this field calculates automatically with the formula (total impressions/number of new posts)
  • Avg. Post Reach – this field calculates automatically with the formula (total reach/number of new posts)

The Pre-Set Formulas

Here are the pre-set formulas that I have used for this sheet:

  • % change formula= ((new entry – previous entry)/(previous entry))*100
  • Absolute change formula = (new entry – previous entry) 
  • Avg. Engagement rate formula = (total post engagements/total impressions)*100
  • Avg. Post Impressions formula = (total impressions/number of new posts) 
  • Avg. Post Reach formula = (total reach/number of new posts) 

The YouTube KPI Spreadsheet

Last but not least, in my Social Media KPI spreadsheet is a sheet for tracking your key performance indicators in YouTube.

I must admit right away that the YouTube KPI template is too basic. But I included it to give you an idea of what are the very basic metrics you might want to keep an eye on month-over-month.

YouTube KPI Tracking template for 2018 by DoraSeeks

Here are the columns I decided to include:

  • Number of new videos – here you will enter how many new videos you uploaded throughout the month on your YouTube page;
  • Subscribers – here you will enter the number of subscribers your YouTube page had at last day of the month;
  • Net Subscribers – this field calculates automatically and shows you the net increase/decrease of your YouTube audience;
  • Total Channel Video Views –  here you can enter the total channel video views that were generated throughout the month.

The Pre-Set Formulas

Here are the pre-set formulas that I have used for this sheet:

  • % change formula= ((new entry – previous entry)/(previous entry))*100
  • Absolute change formula = (new entry – previous entry) 

Click here to access the Social Media KPI Tracking Template for 2018! (Let me know you got it by sharing this blog post on Twitter or liking my Facebook page.)

How To Use The 2018 Social Media KPI Template?

Filling in the monthly data

In general, I try to fill in last month’s data in the first week of the current month.

Click on the links below to discover more about each of the official social media KPI data sources:

Customize it for your own needs

Customize it!

My social media KPI spreadsheet works as a great beginner spreadsheet. However I strongly advise you to customize it to your specific needs and goals.

If your biggest channel is LinkedIn, create a special spreadsheet for your LinkedIn KPIs. If you mostly work with Snapchat, make sure you have a detailed KPI spreadsheet for it as well.

The point is…

You are the one who will use this data at the end of the day. So I strongly encourage you to rework the template as much as possible.

How to create charts

If you would like your spreadsheet to be more visual, I advice you to check out the resources below:

Why are charts awesome?

Sometimes it could be hard to catch trends just by a simple glance at a data-filled table.

With charts, noticing trends is a lot easier. 

Take the chart below as an example:

Social Media KPI Example Chart by DoraSeeks

I used Google Drive Spreadsheets to create a chart where I compare the number of new posts published per month to the average organic reach they generated.

Although the data is fake and the numbers were chosen intentionally, you get an idea of how easy it will be to see trends.

Click here to access the Social Media KPI Spreadsheet for 2018! (Let me know you got it by sharing this blog post on Twitter or liking my Facebook page.)

Let me know what you think about my 2018 Social Media KPI spreadsheet?

So what do you think about the KPI template? Do you think it will help you better track your social media channels performance in 2018? Is there something else you would like to see in it?

Let me know in the comments section below!

If you share the social media KPI template with other people or in your blog, please don’t forget to mention this article.

Even More Useful Templates And Spreadsheets For Marketers

It would mean the world to me if you follow me on social media or share this template with your followers by using the social sharing buttons below.

If you would like to stay tuned for the upcoming marketing templates and spreadsheets, make sure you subscribe to my monthly newsletter.

Thank you for reading!

-Dora

Spread the word!

70 Comments

  1. Hello ☺

    Great work, congratulations !

    Same for me, can’t download your 2018 Social Media KPI Spreadsheet…

    Is it possible to sent it on my mail ?

    Thank you ☺

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

  2. I have liked your facebook page and I am interested in all your FREE Spreadsheets but I am not able to download any? I also subscribed to your blog for updates! It’s not a great tactic to offer freebes for FB likes and not deliver what you promise!

    1. Sorry to hear that the plugin doesn’t work for you either. This was definitely not my intention. I have now removed the plugin from all articles with resources and you will be able to access them directly.

      Thank you for understanding!
      Dora

    1. Hi Ksenia, it looks like I have a problem with the CSS of the site, which is why you can’t see the links. But I just sent it over to you via email (just make sure you also check your spam folders as well)

    1. Hi Diane, I sent it over to you via email. The email subject is “The Marketing Templates You Requested” – please check all your folders including spam 🙂

      Happy planning,
      Dora

  3. Hi Dora,

    Could you send mie the template (Social Media KPI Tracking Spreadsheet) too? I cannot find a link where I can download it.

    Thanks a lot!
    Patricia

  4. Hi Dora,
    Agreat artical.
    I cannot find the download link for the Social Media KPI Tracking Spreadsheet .

    Many thanks in advanced

  5. Hello Dora,

    Thanks for having such a great blog and useful spreedsheets for your fellow marketeers 🙂

    Do you mind emailing me the social media KPI spreadsheet ? Thanks a lot

  6. Hey Dora,

    Great article that makes my life a lot easier 🙂

    Like the commente before this one, is it possible to send me the KPI spreadsheet please.
    I also subscribed to your blog.

    Greeting Jacko

Leave a Reply

Your email address will not be published. Required fields are marked *