Microsoft Land

Archive for the ‘Social Media’ Category

Analytics for Twitter is an useful freeware add-in based on PowerPivot and allows users to search Twitter and create dashboard views on Tweet statistics inside Excel 2010.  Users can use any combination of search terms, including #hashtags, @mentions, @users, and keywords to search Twitter using their documented APIs, perform comparative analysis on tweets, as well as depict the tone of the tweets using a customizable tone dictionary of terms.  The workbook comes with several sheets that provide insights into the query terms.

With this FREE add-in, you can:

  • Perform up to 5 parallel Twitter Searches (limited to 1500 results per query per day).
  • Drive ad-hoc analysis of tweets by day, by hour, by tweeters, by #hashtags and @mentions.
  • Customize your views (using slicers, DAX formulas or reference tables).
  • Setup Tone Dictionary

Analytics for Twitter works only with the latest versions of Microsoft Excel 2010 and of Microsoft® PowerPivot for Excel 2010.

Edelman ( the world’s leading PR company has launched two simple but powerful Measurement tools for Tweeters and Bloggers on 14th of July.

Proud to be part of the team and working with Jonny Bentwood (@jonnybentwood) as I have learned how critical it is to measure the social media and how big the target audience group is. Technically it was very helpful especially the integration with various Social Media metric API’s / Analysis on them which helped me in gaining a decent idea on how to use them in the best way to produce metrics.

Two good things that i like about the tools are, they are simple to use / very user friendly in the way it captures and presents the information for a blog / tweet. I have looked at various similar tools like Klout / Twitalyzer but I think these tools are straight to the point in the way they present the information about a Blog / Twitter account and are primarily targeted to calculate the Influence of a Blog / Tweeter.

Try out the tools at &

Last but not the least, I like the badge, Can’t wait to have it into my Blog. Just waiting for the right score.

My Tweets


Get every new post delivered to your Inbox.

Join 121 other followers