TweeterScore

A Report Card for any Tweeter

TweeterScore is an easy way to pull a summary of information about anyone on Twitter. It uses the Google Docs spreadsheet functions ImportFeed and ImportXML to grab data from Twitter using the Twitter API.

There's a lot going on in this TwitSheet. Pick any tweeter (by screen name) and enter how many prior tweets to grab (between 5 and 500 - you decide, since fewer is faster than a few hundred). You'll get:

=> Chart of duration between tweets
=> Tweeters basic info, including self-description, latest tweet, number of followers and friends (people they're following), URL, Image link, Location and total tweets.
=> Top @reply targets (known issue that @name's which end in colon or comma, etc are not yet counted as equal to @name with no suffix in the text)
=> FollowFactor: Ratio of followers to following (are they followed more than they follow others?)
=> Quietness and Chattiness: how much do they tweet?
=> Link-i-ness:  how often do they include a link in their tweets?
=> @Replyness:  how often do they include an @reply ?

Also, there are some customizations... you can change the charting buckets... so if you find a tweeter who is very chatty - feel free to re-distribute the categories to see more detail int the 5 min. to 1 hour periods. I tried to start you off with useful charting bands, but figured it was better to let others change this.

There are 4 sheets in this TwitSheet:
1 - TweeterInfo: This is the interactive reporting sheet. You just enter two bits of info and watch the report generate. No need to visit the other sheets at all.
2 - User Timeline:  This is where the detailed data is grabbed from twitter. Interesting to see, but don't muck with it ;)
3 - Settings:  This is where you can change set up some changes in the main TweeterInfo charts. If you like what you see, leave this one alone.
4 - Trend data: seemed useful to be able to copy/paste data for several tweeters in one place to compare and keep for later comparison... all manual for now.

If you want to play with this - you can CLICK HERE to GET YOUR OWN COPY...

Twitsheet: Tweeter info and scores


Comments