Some quick Twitter analytics analysis

2015-01-06 2 min read

I finally got around to exploring the Twitter analytics data and wanted to see whether I could find anything useful. My dataset contained 831 tweets, every single one since October 2013, as well as the text, the number of impressions, and the number of engagements. Just by loading the data into Excel, calculating a few values, and generating a pivot table it’s easy to investigate a few ideas. I’ve included some of the pivot tables below along with the various items that stood out.

Has hashtag No hashtag
Has mention 171 251
No mention 237 181
  • Avg impressions vs hashtag and mention (excluding @replies): Idea was to investigate whether tweets with hastags or mentions end up being due to the fact that they are more likely to appear in search results. The results are a bit weird since it seems as if having a hashtag only helps if there wasn’t also an @ mention. Otherwise it hurts.
@mention # tweets Total engagments Total impressions Avg engagement rate Engagements / Impressions Avg impressions
No 446 2192 89714 2.7% 2.4% 201
Yes 385 914 58112 2.9% 1.6% 151
  • I suspected that sending someone an @reply would reduce total impressions but increase the engagement rate since it’s directed at someone. It does reduce the average impressions and only leads to a slight increase in engagement rate - and only when looking at the average of rates, not the total engagements over total impressions. I suspect most people don’t differentiate between an @reply and an @mention which doesn’t lead to a significant difference in actual engagement rates.
Has mention # tweets Total engagments Total impressions Avg engagement rate Engagements / Impressions Avg impressions
No 331 1524 62850 2.6% 2.4% 190
Yes 115 668 26864 2.8% 2.5% 234
  • If we exclude @replies and compare tweets with and without mentions, the tweets with mentions have both a higher average number of impressions and a higher engagement. Nothing surprising here - @mentions are good since they draw attention to a tweet while @replies hurt since they limit total reach. Still nice to have some data to confirm.
Has Link # Tweets Total engagements Total impressions Engagement rate Avg impressions
No 426 990 59385 1.7% 139.4
Yes 405 2116 88441 2.4% 218.4
  • Tweets with links have higher engagement - most likely since there’s a stronger call to action. Again this isn’t surprising but nice to see it backed up by a bit of data.