Competitive Analysis: Free Twitter Analytics Spreadsheet
Sometimes I like to reminisce about the days where I just didn’t understand the basics of Twitter. I was dumbfounded over the 140 character limit, thought the hashtag was a pound sign, and the only other time I used “@” was before the domain of someone’s email.
Actually, now I’m laughing at my Twitter immaturity because looking back at those thoughts and comparing to what I’m ramping up now my mind is blown. Twitter usage represents 22% of internet users with over 500 million users tweeting over 340 million tweets per day and spending a daily average of 36 minutes on Twitter.
Now, change into a competitive perspective…that’s a lot of opportunities to spy on your competitors. Am I right?
Even though it is a rather fast-paced social media channel, it’s still extremely valuable to keep track of especially in a conversational standpoint. This fast-paced conversation can be rather frustrating to keep tabs on as well.
About a month ago we made a free competitive analysis spreadsheet for Facebook, but we thought we should include one with Twitter as well.
First, the spreadsheet is laid out in a weekly format. So everyday during the business week you can keep track of the number of followers, number of people following, the number of tweets per day, and how many favorites they have.
After inserting in those numbers, we set aside a space on the side that calculates all of the averages of each of those categories to help show you what your industry benchmark is.
After the weekly view of the actual Twitter accounts, we’ve also outlined a daily view of notable tweets that day. So, let’s say your competitor tweets something phenomenal out and it gets 20 Retweets and 50 Favorites. You’ll be able to note that tweet down in the spreadsheet and keep track of their weekly progress with individual dissected tweets.
On the side, the averages are calculated as well with the individual tweets so you can see how you stack up as well too.
So how do you gain competitive insight with these numbers? Like with the Facebook, there are certain numbers you can compare to see where your efforts may be lacking and how you an gain the advantage. For example, you could graph the comparisons between the number of Twitter Followers to the number of times they tweet in a day. Or you could also see if there is a correlation between the number of characters a tweet has and the number of retweets they get.
Ready. Set. Go. —> Download it HERE.
It’s essential to keep tabs on your competitors and gaining knowledge on their habits on Twitter can help you decide how you should act with those 140 characters.
Have questions for me? Feel free to email me (sabel@trackmaven.com), holler at me on Twitter (@sabelharris), or if you just want to ruff at Maven he’ll bark back (@TrackMavenApp). ;D
