Getting Hardcore with Twitter Analytics

22Jun11

Disclosure: PowerPivot is a client of mine, and the awesome chick in the blue shirt in the video is someone I work with often. In no way has the PowerPivot team asked me to write this post or talk about the tool. I thought it was awesome and useful to my readers, hence why I’m sharing.

So it’s not often that I run across a Twitter analytics tool that I feel like warrants talking about. Most of the time, tools are flashy, visually appealing, but leave me questioning “but what do the pretty charts mean?” Tools tend to be surface level. They don’t let me splice and dice the data in the way I want, so I end up coming up with some way to extract the insights that I need.

No more when it comes to Twitter. The Microsoft PowerPivot team has developed an add-in for Excel 2010 which leverages PowerPivot to give you power over your Twitter data. And best of all… it’s FREE.

They also created the below awesome video to introduce individuals to this tool. Now it may be too powerful for some of those newer to Twitter, but definitely will give those hardcore users the control that they are craving.

So to get started:

Make sure you have Excel 2010.
Download PowerPivot. (Free Download)
Download the Excel add-in for Twitter. (Free Download)
Get hardcore with your Twitter analytics.
Enjoy the awesomeness. 🙂

If you end up trying it out and have any feedback I’d love to hear your experiences.

Any other Twitter analytics tools you use that you find useful?

Filed under: Analytics, Twitter | 12 Comments
Tags: Analytics, Business Intelligence, Excel 2010, PowerPivot, Social Media, Twitter

12 Responses to “Getting Hardcore with Twitter Analytics”

Feed for this Entry Trackback Address

1 Mark Raburn on August 13, 2011 said:

I am receiving the following error when searching . . . “An exception occurred while searching”. Any thoughts? Thanks, Mark
2 Joshua Squires on September 29, 2011 said:

This is awesome. I love any and all analytics tools. Closest I’ve come to a good analytics tool for Twitter was Klout, which obviously isn’t as thorough or as specific.
3 Lynn Morton on October 3, 2011 said:

Joshua,

You may also want to look into Twitalyzer. I’ve always preferred it to Klout. In fact I find Klout really inaccurate most of the time.

Plus any analytics and metrics need to map back to your goals with the platform. That will allow you to look deeper into the numbers beyond just a follower count.

Let me know if you have any questions!

~Lynn
4 jarida theme free download on May 5, 2013 said:

Ensure that you have the guest list ready with you, so that you do not miss out on any important guest.
Lubith provides you with an extended typography: over 400 fonts are available to select from,
some of them support additional scripts (Latin Extended, Cyrillic, Greek, and Vietnamese).
Some designs need additional extensions to become utilized.
5 Terrence on June 9, 2013 said:

I really like your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for you?

Plz answer back as I’m looking to design my own blog and would like to know where u got this from. thanks a lot
6 financial information on June 9, 2013 said:

I’m gone to say to my little brother, that he should also pay a visit this blog on regular basis to take updated from most recent information.
7 wedding shower invite wording on June 27, 2013 said:

Hi there I am so glad I found your web site, I really found you by
accident, while I was researching on Google for something
else, Regardless I am here now and would just like
to say cheers for a tremendous post and a all round
exciting blog (I also love the theme/design), I
don’t have time to read through it all at the moment
but I have bookmarked it and also included your
RSS feeds, so when I have time I will be back
to read more, Please do keep up the fantastic b.
8 financial advice for young adults on June 27, 2013 said:

Hi there to all, how is all, I think every one is getting more from this website, and your
views are pleasant in favor of new visitors.
9 exactiveness exactly exactment exactness exactor exactors exactress exacts exactus exacuate exacum exadverso exadversum exaestuate exaggerate exaggerated exaggeratedly exaggeratedness exaggerates exaggerating exaggeratingly exaggeration exaggerations exag on August 1, 2013 said:

I love to share information that I have accumulated through
the 12 months to help enhance group efficiency.
10 mcm ブラックシルバー on August 6, 2013 said:

ダンヒルペン
11 buy get more twitter followers instantly on March 19, 2014 said:

Hi Dear, are yoou in fact visiting thiis web site on a regular basis, if so then you wll
absolutely obtain nice know-how.
12 search engine optimization godaddy on September 21, 2014 said:

Normally I do not learn post on blogs, but I would like to say that this write-up very pressured me to try and
do it! Your writing taste has been amazed me. Thanks, quite nice article.