Articles
RSS FeedJanuary 2, 2008
How to get your 2007 Twitter stats
Note: You need Mac OS X Leopard and Numbers to do this.
-
Download the Twitter stats zip at http://dcortesi.com/2007/12/27/twitter-stats/ .
-
Put the folder on your desktop and ensure it is named twitter_stats.
-
Open a new terminal window.
-
Enter
cd Desktop/twitter_stats, hit enter. You’ve navigated to the Twitter stats folder now. -
Enter the following command:
perl twitter_stats.pl twitter_username tweets.csv. Replace twitter_username with your own username. -
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.”
-
Open the numbers template in the twitter_stats folder. And paste paste the data in the topleft yellow table cell.
-
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.
-
Now click “Sheet 2″ in the Numbers template and you’ll see your stats.
The results will look like this:
Only mac? Yet another reason to buy one.
January 2nd, 2008 at 2:53 ∞Mac because you need Numbers for this one. However, somebody extended the script to work with Google Chars so PC users can generate their charts too (see http://matthau.yoz.com/twitter_stats.txt )
January 2nd, 2008 at 2:57 ∞Hey Wolf, thanks for posting the concise instructions. Much appreciated!
January 2nd, 2008 at 7:00 ∞[...] 2007 and creates pretty charts via a Numbers.app template on Mac OS X. If you need to, you can use this tutorial that tells you exactly what you need to do to make it [...]
January 7th, 2008 at 2:59 ∞[...] Stats for 2007 @williammanning January 7th, 2008 Eric has a really great link to a perl great tutorial on getting your twitter stats for the year. You need a Mac to do it because it requires Numbers but [...]
January 7th, 2008 at 5:48 ∞