That worked out pretty well, and tonight I decided to reformat and post those tweets in a more permanent location and a more readable format. I discovered that no single application exists to do what I want, which is to export a specific subset of my status messages and conversations. (C'mon, Interwebs, this is the one time you don't anticipate my needs? We need to talk.)
Twitter's search interface only exports to a noisy XML feed, and what I really wanted was a simple, denormalized CSV data file which I could slice and dice manually. I found three web apps that claim to do this:
- TweetDumpr only exports status messages (without timestamps) to a flat text file.
- Twickie offers several formatting options, but the "Get CSV" link doesn't work.
- Tweetake is the one that actually worked, but it didn't provide many filtering options.
- were posted by me and
- were posted within a specific time window and
- include the hashtag #Leverage and
- include one of the hashtags #extra or #extras; or
- are part of a conversation (replies, retweets, etc.) linked to any tweets matching the above criteria.
For now, you can see the crappy Excel HTML dump of my tweets from two days of being a #Leverage 204 #extra. Note that all times are GMT; subtract seven hours to get local time in PDX.
And yes, I still refuse to use the unreadable abomination that is LoudTwitter.
* You can be an extra too! Here's how.