Getting Hardcore with Twitter Analytics


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:

  1. Make sure you have Excel 2010.
  2. Download PowerPivot. (Free Download)
  3. Download the Excel add-in for Twitter. (Free Download)
  4. Get hardcore with your Twitter analytics.
  5. 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?

12 Responses to “Getting Hardcore with Twitter Analytics”

  1. 1 Mark Raburn

    I am receiving the following error when searching . . . “An exception occurred while searching”. Any thoughts? Thanks, Mark

  2. 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. 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!


  4. 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. 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. 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. 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. 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. ăƒ€ăƒłăƒ’ăƒ«ăƒšăƒł

  10. Hi Dear, are yoou in fact visiting thiis web site on a regular basis, if so then you wll
    absolutely obtain nice know-how.

  11. 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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: