I was writing a post the other day and like any good blogger (this is being said with sarcasm, by the way) I was scheduling out tweets using Buffer. However, I was curious what times my tweets were actually being seen by my followers. So I did a little digging and found my answer.
This combines two of my favorite things: Twitter and Microsoft Excel (yes, I am a nerd!!). I wanted other bloggers and entrepreneurs to know how to find their optimal times to tweet so they’re getting as many views as possible. (*lazy girl hack: scroll to the bottom of this post for a video tutorial!*)
1. Head over to Twitter and click your picture in the top right-hand corner. Scroll down and select “Analytics.”
2. Once you’re on the Analytics page, select “Tweets” at the top of the page.
3. In the left corner, you need to select how many days of tweets you want to look at. I did 28 days (the default) but if you tweet a lot, you could do fewer days, and if you tweet infrequently, you might want to do more days. Click “Export data.”
4. Once your data has been exported, a spreadsheet will open in Excel. The very first thing you want to do is add two blank columns to the right of the “time” column. (To do this, click the “F” column and then click “Insert” on the ribbon above.)
5. Once you have your blank column, you’re going to need to delimit your “D” column (“time”). In non-nerdy terms, this means you need to separate parts of that column out. To do this, click the D so the whole column is highlighted. Then, at the top of the screen, click “Data,” then select “Text to columns.” A popup will open. On the first screen, select “delimited,” then click next. Under the “delimiters” category, unselect the default option and select the “Space” option. Leave everything else the same and click finish.
6. You’ll notice that your “time” column has now been divided into three columns. The date, the time, and one full of zeroes. Feel free to delete the column full of zeroes, it’s unnecessary. However, you will need the other two. Now, you’ll want to change the format of the times, unless you’re used to a 24-hour clock (which I’m definitely not). To do this, select the “E” column, then under the “Home” tab at the top, select the drop-down list in the number section and select “More Number Formats.” In here, select “Time,” then choose how to want to see your time. I chose the one that looks like “1:30 PM” but hey to each her own.
7. You’re almost there, I promise! Now is the easy part. At the top of the screen, under the Home tab, on the right ride, select “Sort & Filter” then “Filter.” This will add the option to filter each column. Now you get to choose which metric you want to look at. If you want to see when to post a tweet that will get lots of impressions, filter the impressions column from largest to smallest. If you want to see when to post tweets that get a lot of retweets, filter the retweet column from largest to smallest…. you get my point. From here, simply compare the metric to the time in the E column. You’ll see in my spreadsheet that I filtered my impressions largest to smallest, and my most “seen” tweet was posted at 10:30PM. (**Disclaimer: make sure your timezone is correct in your Twitter settings. Mine was incorrect, so it thought that this tweet was at 10:30, when it was actually 8:30PM my time. Oops!)
It’s as simple as that! (Haha okay it actually isn’t super simple, but it’s not that hard!) Now you know when your tweets are being seen, and you’ll be able to better schedule out your tweets. The only issue I see with this is that you need to take into account why your tweet had so many impressions (or any other metric). For example, the tweet you see in these screenshots was retweeted by some of my favorite podcasters (shoutout to The Lady Gang and The Skinny Confidential). Because they have so many followers, my tweet had a ton more impressions because all of their followers saw it in addition to mine. This is obviously good, but it might not have to do with when a tweet is posted, and more about who retweeted it. Just something to keep in mind!
Was that tutorial too much for you? Watch me follow these steps in this simple video!
Still have questions? Feel free to shoot me a comment below, or send me an email!
As always, follow me on Twitter,Facebook, Bloglovin’ and Pinterest, cheers bitches 🙂