Microsoft Analytics For Twitter

Martin Brinkmann
Jun 22, 2011
Updated • Jan 4, 2018
Companies, Microsoft, Twitter
|
7

Twitter has not only become a tool for Internet users to write and exchange messages, but also for marketers and researchers who want to analyze the dynamics or trends on the Internet platform. They can do that by searching on Twitter directly, by writing their own programs that utilize the Twitter API or use third party tools that do all the work for them.

Microsoft Analytics for Twitter is such a tool. Well, it basically is an Excel 2010 spreadsheet that everyone can use to pull data from Twitter. Before you jump in joy you need to know that it requires Microsoft's free PowerPivot for Microsoft Excel 2010, a 81 to 112 Megabyte download. I recommend to start downloading PowerPivot first, and during the download the Microsoft Analytics for Twitter installer.

The analytics Excel spreadsheet is placed on the computer desktop. All you need to do is to run it after installation of both required components.

The top offers a search form where you can enter up to five different search queries that you want analyzed.

microsoft analytics for twitter

Once you have entered the search terms, you click the search button to pull the data from Twitter. A small window is shown that displays the progress of that operation. Once that is finished, ou need to click on PowerPivot in the top menu and select Update All from the options there. This triggers a new window where some updating takes place. Close or minimize the window once that is completed.

Switch to the Data menu in Excel and select Update All. This updates the current spreadsheet with the new data set. You see an example of that display above on the screenshot.

The spreadsheet contains lots of information, from top hashtags over tweets by day or time of day to top mentions, top tweeters and the original and retweet ratio.

The information are great for comparing different topics, or for analyzing a single search term instead. This way you could see when people twitter about a certain topic, who writes about it the most and which hash tags are the most popular in the conversations.

It is worth installing the PowerPivot plugin for Excel? That depends. If you want to use the information presented for research or marketing, then probably yes, if you are curious, then probably yes as well. The information are presented in a way that makes it great for presentations for instance. I personally will use it to get a better picture of people who post messages about Ghacks on Twitter.

You can download Microsoft Analytics for Twitter from the official Microsoft Download page of the Excel spreadsheet. (via)

Advertisement

Tutorials & Tips


Previous Post: «
Next Post: «

Comments

  1. The Dark Lady said on July 9, 2023 at 11:19 am
    Reply

    Martin, I would appreciate that you do not censor this post, as it’s informative writing.

    Onur, there is a misleading statement “[…] GIFs are animated images …”. No, obviously you don’t seem to have take much notice of what you were told back in March regarding; Graphics Interchange Format (GIF).

    For example, https://www.ghacks.net/2023/03/31/whats-gif-explanation-and-how-to-use-it/#comment-4562919 (if you had read my replies within that thread, you might have learnt something useful). I even mentioned, “GIF intrinsically supports animated images (GIF89a)”.

    You linked to said article, [Related: …] within this article, but have somehow failed to take onboard what support you were given by several more knowledgeable people.

    If you used AI to help write this article, it has failed miserably.

    1. E. Fromme said on September 29, 2023 at 1:32 pm
      Reply

      EMRE ÇITAK posts are useless because they are fraught with inaccuracies and are irrelevant.

  2. KeZa said on August 17, 2023 at 5:58 pm
    Reply

    AI is stupid, and it will not get any better if we really know how this all works. Prove me wrong.. https://www.youtube.com/watch?v=4IYl1sTIOHI

  3. Database failure said on August 18, 2023 at 5:21 pm
    Reply

    Martin, [#comment-4569908] is only meant to be in: [https://www.ghacks.net/2023/07/09/how-to-send-gifs-on-iphone-two-different-ways/]. Whereas it appears duplicated in several recent random low-quality non relevant articles.

    Obviously it [#comment-4569908] was posted: 9 July 2023. Long before this thread even existed… your database is falling over. Those comments are supposed to have unique ID values. It shouldn’t be possible to duplicate the post ID, if the database had referential integrity.

  4. Howard Pearce said on August 25, 2023 at 12:24 pm
    Reply

    Don’t tell me!

    Ghacks wants the state to step in for STATE-MANDATED associations to save jobs!!!

    Bring in the dictatorship!!!

    And screw Rreedom of Association – too radical for Ghacks maybe

  5. Howard Allan Pearce said on September 7, 2023 at 9:13 am
    Reply

    GateKeeper ?

    That’s called “appointing” businesses to do the state’s dirty work!!!!!

    But the article says itself that those appointed were not happy – implying they had not choice!!!!!!

  6. owl said on September 7, 2023 at 9:50 am
    Reply

    @The Dark Lady,
    @KeZa,
    @Database failure,
    @Howard Pearce,
    @Howard Allan Pearce,

    Note: I replaced the quoted URI scheme: https:// with “>>” and posted.

    The current ghacks.net is owned by “Softonic International S.A.” (sold by Martin in October 2019), and due to the fate of M&A, ghacks.net has changed in quality.
    >> ghacks.net/2023/09/02/microsoft-is-removing-wordpad-from-windows/#comment-4573130
    Many Authors of bloggers and advertisers certified by Softonic have joined the site, and the site is full of articles aimed at advertising and clickbait.
    >> ghacks.net/2023/08/31/in-windows-11-the-line-between-legitimate-and-adware-becomes-increasingly-blurred/#comment-4573117
    As it stands, except for articles by Martin Brinkmann, Mike Turcotte, and Ashwin, they are low quality, unhelpful, and even vicious. It is better not to read those articles.
    How to display only articles by a specific author:
    Added line to My filters in uBlock Origin: ghacks.net##.hentry,.home-posts,.home-category-post:not(:has-text(/Martin Brinkmann|Mike Turcotte|Ashwin/))
    >> ghacks.net/2023/09/01/windows-11-development-overview-of-the-august-2023-changes/#comment-4573033

    By the way, if you use an RSS reader, you can track exactly where your comments are (I’m an iPad user, so I use “Feedly Classic”, but for Windows I prefer the desktop app “RSS Guard”).
    RSS Guard: Feed reader which supports RSS/ATOM/JSON and many web-based feed services.
    >> github.com/martinrotter/rssguard#readme

  7. Anonymous said on September 14, 2023 at 6:41 pm
    Reply

    We all live in digital surveillance glass houses under scrutiny of evil people because of people like Musk. It’s only fair that he takes his turn.

  8. Anonymous said on September 18, 2023 at 1:31 pm
    Reply

    “Operating systems will be required to let the user choose the browser, virtual assistant and search engine of their choice. Microsoft cannot force users to use Bing or Edge. Apple will have to open up its iOS operating system to allow third-party app stores, aka allow sideloading of apps. Google, on the other hand, will need to provide users with the ability to uninstall preloaded apps (bloatware) from Android devices. Online services will need to allow users to unsubscribe from their platform easily. Gatekeepers need to provide interoperability with third-parties that offer similar services.”

    Wonderful ! Let’s hope they’ll comply with that law more than they are doing with the GDPR.

  9. sean conner said on September 27, 2023 at 6:21 am
    Reply
  10. Sherry Grant said on September 29, 2023 at 7:47 pm
    Reply

    What does this article about Musk/Tesla have to do with computing, devices, phones?
    More irelevant filler.

  11. Anonymous said on September 29, 2023 at 8:47 pm
    Reply

    yeah sure… they are always the victims and it is only against them ????

    Believe them 100% and never question anything. This lawsuit sounds like the type you heard when people were eating batteries.

Leave a Reply

Check the box to consent to your data being stored in line with the guidelines set out in our privacy policy

We love comments and welcome thoughtful and civilized discussion. Rudeness and personal attacks will not be tolerated. Please stay on-topic.
Please note that your comment may not appear immediately after you post it.