I have been playing with Excel’s Power View, Power Query (my favorite) and Power Pivot (older but still fantastic) and a few weeks ago someone tweeted something about their twitter archive. That gave me an idea to see if there is any pattern in my tweeting.

So I went to twitter web settings and requested a fresh archive. As a side, how awesome is it that twitter lets you request an archive and that it is ready in minutes. This is a company that could not go back more than a few days in history not so long ago!

Anyway, I brought in all the data from the csv file and put a couple of simple charts together. I’d have loved to share this as an embedded Excel file but because it has all the data, the file is ~19MB and Excel Online can only handle file size of 5MB and below :-(

Anyway, it is interesting to see that my peak twitter was 2012, and for some reason, April of 2012. And as for the clients, MetroTwit, which is still one of the best twitter experiences I have had, very surprisingly dropped to negligible levels after 2012.

Anyway … as usual, there is more insight to gain from the data. I just found these to be the quick and easy ones to look at.

[caption id=“attachment_3601” align=“aligncenter” width=“646”] Tweets by month[/caption]

[caption id=“attachment_3602” align=“aligncenter” width=“646”] Tweets by client[/caption]