Social Media Spreadsheet

You can never know how far you've come unless you keep track of your progress!

Social Media Counts Spreadsheet
  1. You're on all the social platforms and feel like you're doing all you can to just stay on top of posting everywhere.
  2. You know that analytics and stats are important but you don't know where to start!
  3. You manage social media for several different clients and need an organized way to keep track of all the numbers.

Does any of that Sound familiar? Yes? Then This spreadsheet is for you!

I challenge you to check in with your stats once a week. This will give you a better overview of what's working... what isn't working... what platforms you should or shouldn't pay more attention to... and so much more!

So, to make it easy for you I've created a spreadsheet template in Google Drive that you can copy and paste and use on your own. I use this exact spreadsheet on a weekly basis for myself as well as for my clients.

Get access to the Social Media Spreadsheet Template

How to use the spreadsheet template

  • Copy the spreadsheet content (Command+A will select all)
  • Paste into a new spreadsheet on your Drive
  • Add columns for any platforms you're using that aren't already included
  • If you're managing multiple clients, add a tab (at the bottom of the spreadsheet) for each client and copy and customize the template columns again
  • The spreadsheet is dated with each Monday for the rest of 2017... so make a reminder in your calendar or on your phone to check in every Monday with your social follower numbers
  • Each Monday, add your follower counts for each social platform. Note: It's very easy to get distracted by your News Feed while checking in on these numbers. So, when you do this give yourself a 5-10 minute timeline and stay on track!
  • At the end of the month, calculate the change from beginning to end of the month
  • After you calculate change, focus on what platforms are growing at a faster rate than others... why is that? how can you do more of that? should you put more focus on that platform? should you stop trying so hard on Twitter? should you give more attention to Spotify? Ask yourself these questions! Remember, nothing will change unless you do.
  • At the end of each quarter, calculate the change from the past 3 months
  • Most importantly... know that it's ok for social media growth to fluctuate. Just make sure you're constantly providing value for your followers!

Get access to the Social Media Spreadsheet Template

 
Katherine Forbes

Katherine Forbes, Founder of Designing the Row

A Music City girl obsessed with creating confidence in my clients through designing, branding and marketing. In today’s world, your visual branding and online presence will either make or break you. I’ve got my Diet Coke in hand and am ready to get started on your next project.

 

Subscribe to the blog

 

Follow @designingtherow on Instagram

 

More Free Downloads