Analytics for Twitter enables you to create tweet dashboards inside Microsoft® Office Excel 2013 by searching on any combination of terms including #hashtags, @user mentions, and keywords. The workbook comes with several sheets that provide valuable insight
into the search terms and are an easy way create your own customized Twitter analytics.
• Topics – identify key topics and mentions, frequency of tweets by time of day, and top tweeters.
• People – insight into the key tweeters for your search queries including mentions and retweets.
• Tweet Map – a map of where are your tweeters are located and a distribution of when they tweeted.
• Mentions – the most talked about tweeters for your search terms.
• Tweeter Profiles – explore details about tweeters and the most talked about tweeters for your search terms.
• Details – dive into every tweet, filtering on key items.
Note: During the searching process if your search queries return too many results in a short amount of time you may have to wait a few minutes before
Twitter will provide you more tweets. Analytics for Twitter will automatically continue gathering tweets after this waiting period, but if you don’t want to wait click the “Stop & Process Now” button to generate the reports with the tweets you already have.
To fully harness the power of Analytics for Twitter we recommend using advanced search. By specifying a small amount of search information such as location, type of tweets, and language you can generate a much
more targeted analysis of Twitter. In advanced search each of your five queries use their own configuration enabling you to compare the same query in different areas or languages.
Note: A very easy way to get a geocode for a given location is to search for it on
bing maps. If you right click on the map it will give you the latitude and longitude for the clicked location.
Analytics for Twitter has been designed to support up to five concurrent search queries on #hashtags, @mentions, keywords and Tweeters. The search operators' syntax follows Twitter Search syntax.
For more information see Twitter’s documentation on advanced searches.
The following examples outline several sample search scenarios.
• #microsoft, #msbi, #sql, #sqlserver, #powerpivot
• #microsoft AND #bi, #sql OR #sqlserver
• @microsoft, @microsoftbi, @powerpivot
• @microsoft AND @bi, @sql OR @sqlserver
Searching Keywords (i.e. freeform text search)
• microsoft, powerpivot, excel
• excel AND bi, powerpivot or sql
• from:MicrosoftBITV, from:MicrosoftBI
• from:MicrosoftBITV OR from:MicrosoftBI
#msbi, @microsoftbi, MicrosoftBI, from:MicrosoftBI
#msbi AND @microsoftbi, MicrosoftBI OR from:MicrosoftBI
When you open the Analytics for Twitter workbook it will prompt you to install the Silverlight Plugin if it is not present on your system. If the Silverlight Plugin fails to load or install properly while you are in Excel it will keep prompting you to install
the plugin. To troubleshoot this problem follow the following steps.
Verifying Silverlight Plugin Installation
Disabling and Enabling the PowerView Add-In
Version 1.2 (July/2013)
Improved exception handling for when Twitter servers are over loaded and returns an Over Capacity error during the query and data refresh processes.
Updated to Twitter API v1.1 call for downloading user profile images.
Added additional devices and apps to meta data table.
Version 1.1 (April/2013)
Updated exception handling for errors during the query and data refresh processes. Includes updated rate limit processing and mitigation of incomplete or corrupted tweet data. Added a check to ensure tweet data does not exceed excel table row limitations.