|
Are you conducting competitive analysis? Or are you just keeping tabs on celebrities, athletes, teams, companies, or colleagues? You can put everyone you know into this worksheet and keep up to date with their social media status -- at the push of a single button.
It's easy to setup. You just enter a list of people or companies that you want to track and then press one button. This Excel Facebook / Twitter spreadsheet fetches the metrics offered by Facebook and Twitter. It's easy to track popularity and engagement, as well as participation within and from social media.
You can see their Facebook Fan Count, which is an indication of how popular they are. Remember, there is quite a few Facebook users out there -- this is a statistically significant group!
Their URL (the one they use in Facebook). This may not be the same one as their corporate URL, which means they might have different content for the social media crowd.
The number of times people have Shared something about them. This tells you that people think their content is interesting. It gives a sense of viral their content could be, because Shares tend to encourage broad audiences.
The number of times people have pressed the Like button for them. This is a simple gesture and people do it for different reasons so it’s usefulness to an analyst is only a general indicator.
The number of times people have commented on something they wrote on Facebook. Comments always give good indication of how enthusiastic people are. Beware that comments aren’t always positive, so you should use our Facebook Dashboards to read and quantify what people are saying.
The total count of shares, likes, and comments – this is a general measure of their popularity.
Their Twitter name so you know who is being reported on. Notice that we offer a technique to collate a number of Twitter users for a company. Twitter, by its nature, are individuals contributing to a common idea, so it’s important to look at a group of Twitterers, not just one.
The number of followers they have – this is a measure of how many people pay attention to what they say. Beware that a percentage of those Followers might not be interested parties, just list builders.
The number of tweets they have made – this is a measure of how active they are in Twitter. Our other Twitter dashboards can show you those Tweets and you can normalize them to look for common patterns or outliers.
How does it work?
If you’re technically inclined, look carefully at the picture below. You’ll see the Next Analytics for Excel script there. Basically the rows 1 thru 8 are Sets of information. Each row represents someone or something you want to track. These rows are where you enter what you know about them.
The command uiRunEachSet in row 9 causes the subsequent scripts to run multiple times, in this case 8 times. For each row, it substitutes the items in yellow when it queries the Facebook or Twitter data server.
You can download this Excel 2007 spreadsheet here. If you want this in Excel 2003 format, please send me email to our support desk and we'll send it to you. |
