Social Media Spreadsheet
You can never know how far you've come unless you keep track of your progress!
You're on all the social platforms and feel like you're doing all you can to just stay on top of posting everywhere.
You know that analytics and stats are important but you don't know where to start!
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.
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!