How to Improve Your Tweets Using Twitter Analytics

Are you using Twitter effectively? Have you looked at ways of analysing how your tweets are being recognised on Twitter?

If you are looking at what tweet(s) gets more engagement as you use Twitter, there is a tool by Twitter to help analyse your tweets. Knowing which tweets have generated strong engagement in the past helps you plan ahead for better tweets.

In this blog post, you will learn how to analyse your tweets data to improve your Twitter marketing and branding.

Gathering Twitter activity

You do not need to create Twitter ad campaigns to access the data in Twitter analytics tool. If you have a Twitter account, then you have a Twitter ads account. Simply go to, and sign in with your regular Twitter username and password. The first time you log in, you will have to set your country and time zone (these settings cannot be changed).

Once logged in, go over to Analytics and then scroll down and click on Tweet Activity. Your tweets for the last 28 days as well as the number of impressions, engagements, links clicks, retweets, favourites and replies, will automatically appear.

Now, change the date range. You can go back 13 months but you can only see 92 days at a time. There are other third party apps that can go further than 13 months of data.

There is a lot to see natively through Twitter ads but the real power comes after you export and analyse the data, track trends and discover where your biggest opportunities lie.

Exporting Twitter data

Click the Export button in the top right corner of your window just below your Twitter icon. Select the first batch of 92 days and click Export Data. Adjust the date range to the next batch of 92 days. Repeat until you have at least a year’s worth of data downloaded.

Then open up each Excel file. Choose one as a master file and copy the rest of the data into it. Be sure to remove the title rows from your other copied tweets, so there is just tweets and data with only one title row. To make the file easier to worth with, freeze the top row. First, click on the View tab and find Freeze Panes. Click on it and then select Freeze Top Row. Now you can scroll up and down and keep the titles at the top.

Once you have a master file of all your Twitter data for a year, look at what the data has to say. It will tell you the best time to tweet to reach the most people, the types of tweets that consistently get the most engagement from your audience and exactly how many engagements your account has gotten in the past year.

Find your best times to tweet

To find the best time to tweet, go into your master file and sort your data from most to fewest impressions. Highlight the Impressions column and go to the Home tab. There, usually on the far right side, is the Sort & Filter icon that looks like a funnel. Click Sort the entire sheet from Largest to Smallest.

Once you have recorded your data, you will find the dates and times of the tweets that got the most impressions (the ones seen by the most people in your audience). If you see a trend based on the day of the week or time of day, you have found the peak times for your tweets to go out to be seen by the most people.

Review the top 50 or 100 tweets and you will most likely find at least a few time trends. You need to tweet consistently to get an accurate assessment.

Most engaging tweets

Now that you know when to tweet, do a similar sort on the Engagements column to see what types of tweets your audience likes the most. Twitter defines engagements as retweets, replies, favourites and any kind of click. The more actions a person takes after seeing your tweet, the more successful you were at reaching your audience. Trends in engagement levels will tell you what types of messaging and content your audience prefers.

Highlight the Engagements column and sort the sheet so that the largest amount of engagement is on top. If you want, hide the Time and Impressions columns, so the corresponding tweets are right beside the numbers. This part is a bit more manual and qualitative but it is worth it to know which type of messages resonate with your audience.

Review the top 50 or 100 tweets or whatever number makes the most sense for you. If you can see a trend with fewer tweets, good for you. If you have the time and really want to be thorough, by all means dive deep into that data have a swim around.

Now that you have seen what your audience wants and when they want it, craft effective Twitter updates and schedule them for the best times. Find time to go through these reports to see what works for you. The improvement in results from your Twitter marketing will be worth it. Once you get comfortable with this kind of data review, check back every week, month or quarter to make sure that you are still hitting the optimal mark. The social media world moves fast and analytics will help you keep pace with the changes.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s