Microsoft Analytics for Twitter

Microsoft Analytics for Twitter is a handy tool that helps you dive into the world of Twitter right from your Excel spreadsheet. It lets you search through tweets, hashtags, mentions, and keywords while giving you a clear dashboard view of all those juicy Twitter stats.

What Can You Do with Microsoft Analytics?

This add-in is like having a superpower for analyzing tweets! Here’s what you can do:

• Run up to 5 searches at the same time (you can get up to 1500 results per query each day).


• Analyze tweets based on different criteria—like by day, hour, user, hashtags, and mentions.


• Make your data look just the way you want it using slicers, DAX formulas, or reference tables.

How to Perform a Twitter Search

Ready to start? Here’s how you can perform a search:

1. Open the Microsoft Analytics for Twitter.xlsx file on your computer.


2. Add up to 5 search queries in the search bar at the top of the “Topics,” “People,” “Tone,” or “Details” worksheets. You only need to type in your search terms once!


3. Hit that search icon to fetch your Twitter data.


4. You’ll see a message saying “Twitter Search Complete” when it’s done. Click OK!


5. If there’s a message about clipped queries, don’t sweat it—just tweak those search terms and try again!

Your Next Steps with Twitter Data

This tool makes understanding Twitter easier than ever. Once you've got your data pulled in Excel, you can analyze it however you'd like! If you're excited about diving deeper into social media analysis and want more details or even to download this awesome tool, check out this link: Download Microsoft Analytics for Twitter.