Graphing Total Daily Tweets

Last year I started tracking the total number of tweets posted to Twitter every day. I wrote a Ruby script that uses the Twitter API to post a new tweet to a private Twitter account and log the ID number of that tweet. That script runs once a day at the same time every day. Tweet IDs appear to be auto-incrementing integers, so we can track the total number of tweets posted in the past 24 hours by subtracting today’s tweet ID from the previous one. Another Ruby script processes the log file so I can feed it to Excel to produce pretty graphs.

I started the script in April 2008 and promptly forgot about it before checking out the results today.

Daily Tweets

This graph shows the number of tweets posted each day for most of the last year. I had to smooth the data in a couple of places when Twitter was down… in those cases I just extrapolated between the closest two points.

A few quick takeaways:

  • As noted by others, Twitter is busier on weekdays than on weekends
  • Notice the traffic surge during the November 2008 elections
  • Notice the decrease over the 2008 Christmas holidays

6 thoughts on “Graphing Total Daily Tweets

  1. Pingback: The Social Media MacGuffin: A Volume-based Business Model for Twitter

  2. Could you give me the script? I really dislike tweetstats that use bar graphs and give me too little information. Your idea sounds wonderful. and respond by email if you wish.. i recommend that. 😀


  3. Joseph – The script doesn’t produce the graph, just the log file, which gets imported into Excel to produce the graph. And it only saves the current tweet_id number so we can calculate how many total tweets were posted that day. It won’t give you any personalized stats like TweetStats will. I’d be happy to share the script — it just doesn’t do much.


  4. Pingback: Gewitter auf Twitter – es „buzzt“ in den Connunities und regent „Tweets“ | GlobalCom PR-Blog

  5. Pingback: Be Here Now…by writing about it later

  6. Pingback: Check-Ins: Not Just for Places Anymore | Location Meme

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s