Wednesday, January 9, 2008

How to get your 2007 Twitter stats

Note: You need Mac OS X Leopard and Numbers to do this.

  1. Download the Twitter stats zip at

  2. Put the folder on your desktop and ensure it is named twitter_stats.

  3. Open a new terminal window.

  4. Enter cd Desktop/twitter_stats, hit enter. You've navigated to the Twitter stats folder now.

  5. Enter the following command: perl twitter_username tweets.csv. Replace twitter_username with your own username.

  6. Follow the instructions onscreen. First, hit enter to start generating the CSV file which contains your stats. When this is done, you will get the following message: "Tweets per hour, data has been copied to the clipboard."

  7. Open the numbers template in the twitter_stats folder. And paste paste the data in the topleft yellow table cell.

  8. Repeat the process for the 5 tables in the numbers template (pasting the data in the correct tables), hitting enter inside terminal to get the new data on your clipboard.

  9. Now click "Sheet 2″ in the Numbers template and you'll see your stats.

The results will look like this:


No comments:


Blog Widget by LinkWithin