It’s been a few months since I wrote about missing Twitter.

Since then, I became a semi-regular user on Mastodon but after Threads launched, I went all in there. It was good to see “big accounts” show up there but what I have missed are two big things I relied on Twitter for – real-time stuff where we watch sports and awards shows and react together as a community, and DMs coupled with easy access to customer support.

Having said that, it is still a good place to get news and I have made some new online buddies there.

After being one of the early users of Bluesky and not liking it much, I have started enjoying that service too. The biggest draw is that a lot of my old Twitter friends are actively posting there. It’s been good to interact with them again. Plus, it has a good emphasis on real time stuff and I have seen some popular sports reporters also start posting there.

So for now, my Twitter experience is a messy combination of Threads and Bluesky.

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]