Microsoft Analytics For Twitter
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.
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
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.
EMRE ÇITAK posts are useless because they are fraught with inaccuracies and are irrelevant.
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
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.
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
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!!!!!!
@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
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.
“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.
No, they didn’t lmao.
https://twitter.com/vxunderground/status/1706523877478670542
What does this article about Musk/Tesla have to do with computing, devices, phones?
More irelevant filler.
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.