A trip to New York in February
January 26th, 2009
I’m taking a trip to New York between February 3rd and February 5th.
Posted in Uncategorized | Comments Off
Porter Novelli Twitter folk ranked by number of followers
January 25th, 2009
Yesterday I did a little work with the TwitterCounter API. Today I’ve gone a little further and (purely as an experiment) ranked a list of Twitter people in Porter Novelli by the number of their followers.
What happens if we chart this? Here’s a kind of Pareto chart showing users ranked in order of followers and the total reach that we get at each stage.
If you’ve seen this kind of thing before, it looks wrong, doesn’t it? That red curve should be steeper at the beginning and have longer flatter asymptote. If you’ve ever heard of the 80/20 rule this is one of the graphs that describes it. Normally the head of the graph (the first 20% of the x-axis) controls around 80% of the value while the tail (the remaining 80% of the x-axis) controls around 20% of the value. If you’ve ever heard about the long tail, it’s this tail that Chris Anderson et al. are talking about.
What’s wrong with the data?
It’s not so much the data as what I’ve not done with it. There must be many, many duplicated connections here. So now I need to write something that will go through the followers of all the Porter Novelli Twitter usernames in ranked order, and only count unique (or unduplicated) followers.
I’m hoping that when I re-do the chart, it will look something more like this:
Posted in porter novelli, twitter | 1 Comment »
Counting Twitter followers
January 24th, 2009
TwitterCounter, the service that tells you how many people followed a given Twitter user on a given date (among other things) has an API – so I thought I’d take a look at it to see whether I could create a quick automated table of rankings.
Here’s the simplest way to query the API:
[code]
http://twittercounter.com/api/?username=mediaczar&output=xml
[/code]
Just cut and paste that into the address bar of your browser for example. Fairly simple. Change the username and you’ll get the data for a different user. Here’s what you get back from the API — an XML file with lots of rich meaty data:
Read the rest of this entry »
Tags: google spreadsheets, twitter, twittercounter, xml
Posted in hack, pipes, twitter | 3 Comments »
Dan Zarella’s ReTweet Mapper
January 22nd, 2009
Dan Zarella’s ReTweet mapper “indexes ReTweet streams into hierarchical structures that can be displayed visually”. I wouldn’t have known about this if it hadn’t been for the Retweetist — a project that tweets out the most retweeted URLs, and the Tweetbacks plugin from Joost de Valk that traps Tweets that mention your blog post. That’s a lot of pinging around the web. As if by magic, the views on the US congress Twitter map post have shot up again, even though it’s almost ten days old.
Really quite flattered to have one of my posts tweeted by Jack Schofield. I rather feel like I’ve arrived.
Tags: dan zarella, jack schofield, joost de valk
Posted in twitter | Comments Off
Introducing the Porter Novelli magic Twitter friend maker (beta)
January 22nd, 2009
A couple of days ago, I posted a map of all the Porter Novelli people we knew of who are tweeting. The list keeps getting bigger: at today’s count, there are 212 known Twitter people.
At the moment, I manage three Twitter accounts (thanks mostly to the excellent Twhirl Twitter client that lets me log in simultaneously to as many accounts as I like. Two of those accounts are Porter Novelli-related, so it was essential that I follow everyone. Of course, I could simply set up an auto-follow using something like Tweetlater , but that wasn’t going to work if people didn’t know about and follow those accounts in the first place.
Read the rest of this entry »
Posted in porter novelli, twitter | 1 Comment »








