Get the most out of your Twitter Analytics

October 12, 2016


Get the most out of your tweet data with excel pivot tables. Receive my FREE customizable Excel Pivot Table Template 

Twitter analytics allows you to see impression numbers—i.e., how many times your tweet was seen on Twitter. You can take it further by also knowing when and where each of these impressions happened. The same goes for click stats and engagement metrics (likes, retweets, replies etc.). Twitter analytics tells you where on the tweet and where on Twitter people clicked or engaged with your tweet. You can visit your analytics here

How to use Twitter Analytics



Your Home dashboard gives you a basic 28 day overview of your most relevant stats with change over previous period. You can see if you’ve gone up or down. See Total tweet count, Total Tweet impression count, Profile visit count, mentions and new followers count.



Your Tweets dashboard breaks down all the tweet activity around your tweets over a 28 day period by default. But you can select up to 90 days by clicking on the date box in the top right corner. See all the activity around your tweets. Likes, Retweets, url clicks, hashtag clicks etc.


The beauty about tweet data is that you can export it into a csv file and upload into excel for further analysis. I will show you how you can get the most out of your tweet data with excel pivot tables shortly.



Your audiences tab gives you a statistical overview of your followers. Demographics, Interests and Mobile Footprint 

Demographics: age, gender, language, country, region

Interests: like technology, entertainment, comedy, sports etc.

Mobile Footprint: like wireless carrier and device type



The events tab allows you to see Tweet data based on events like “Holidays”, “Entertainment”, “Sports”, “Movies” and “Recurring Trends” (like trending hashtags) Allowing you to best plan your tweet campaigns around important events for your industry.

Analyze your tweet data with Excel pivot tables

Twitter analytics gives you a simple overview of your stats. But what if you need to take your analytics to the next level. What if you need to analyze the trends within your tweets by grouping them by type and sorting them by rank. Spotting trends like seeing that your tweets with images got the most engagement. Seeing that tweets with hashtags got the most likes. This is all possible with excel pivot tables. A pivot table allows you to extract the significance from a large, detailed data set. There is no need to keep sorting and filtering to get different views. All the different views are already pre-programmed. All you do is paste your new data and refresh all tables. Its that simple.

Step 1:

Download my Free Twitter Analytics Pivot Table Template: tweet_activity_metrics-pivot-table Then Delete sample data from rows 2-11

Step 2:

Copy your csv export data and go to cell 2A and hit the paste button


Step 3:

Go to the second Tab, The Tweet Activity Summary tab. Click anywhere on the pivot table and then refresh all.



Leave a Reply

Your email address will not be published.