To export your Twitter analytics, the first thing you’ll need to do is log into your Twitter profile, click on your profile image, then click Analytics. This will bring up Analytics page, but you still need to click View All Tweet Activity. From here, you can go ahead and export the data to a CSV file.
I recommend going back at least 90 days versus the default 28 days. What that will do, is give you a CSV file. What’s nice about this is now that it’s in Excel, we can actually manipulate the information. As an example, I have asked Excel to give me my most, highest engaged rate tweets, and then I’m actually going to copy and paste them into my browser to see what they are. In this case, the top five are all video. That tells me my most engaging tweets are video.
Take a couple minutes now and export your Twitter analytics to get a better understanding of what’s working for you in your Twitter feed.