Social media and I have a love/hate relationship. When I, and you too, actively participate in Facebook Groups, when we comment and find people we love on Instagram, when we open our hearts to new relationships, it is usually a great experience personally and professionally.
Obviously, we won’t be much of a lucrative business if we spend all our time making friends and doing favors for people.
So last year, I asked my assistant, Dannah, to record the stats for my social media accounts. For a couple months, we recorded the follower growth. That wasn’t quite cutting it.
It doesn’t take long to realize that just because people love your IG feed, doesn’t mean they will buy from you. So we decided to track how many of those people were landing on the website.
We used Google Analytics to track how many visitors landed on any page on WPBarista from each social platform we were using.
Admittedly, my Google Analytics ability is around the beginner level. I’d love to find a trained and professional GA person to teach me some stuff, if you know of someone – leave the name in the comments.
Social Media Followers per Platform
So here’s the spreadsheet we use with some sample data. Personally I’m a visual person, so I like the graph.
To use this sheet, you just enter the follower number once a week, every week at the same time, into each platform. the graph is automatically calculated.
But the number of followers isn’t the whole picture.
Site Visitors by % of Followers
So here’s another sheet in that same workbook. In this sheet, you enter the number of visits from each social media platform (find them under Aquisitions -> Social in Google Analytics).
But it isn’t a fair comparison because there can be vastly different numbers of followers on each platform… For this reason, I put more stock in the percentage of followers that visit, than the actual numbers.
If you’re following this, you realize that not everyone who lands on the site will be a follower… but for my purposes this worked fine.
If you enter the numbers in the top area, the bottom percentages are calculated automatically.
The next step for us is figuring out if those site visitors turn into customers. If your goal is to gain some more blog visitors, and maybe email sign-ups, swipe this file and I hope it helps you gain some clarity.
And in turn, decide to spend an appropriate amount of time focused where it should be!
Create a copy of the spreadsheet to use in your company.