The Top London Ad Agencies by Foursquare Check-in (21.10.2010) [Infographic]

London Foursquare Ad Agency Rankings (21.10.2010)

Well the only thing scarier than the psudo Halloween motif we've gone with for the pre-Halloween version of the infographic might be the clustering in the bottom left of the graph. This might be forgiven though, as McCann's immense check-in growth is a problem to scale no matter how you cut it. It really seems to illustrate the power of consolidating locations and driving activity, to the level of doubling check-ins since the last time I tried a Foursquare ad infographic. 
Also interesting is the staying power of Foursquare Activity relative to the launch of Facebook Places. It seems that agencies are slower to adopt Facebook's location platform than pre-launch hype might have suggested. At the least, it seems that users who picked up Foursquare have carried on, regardless of other options.

The Top London Ad Agencies by Foursquare Check-in (06.08.2010)

I decided to do something a bit different than the normal top 30 infographic with the Foursquare check-in data. While the infographic may still come out at some point, I thought it might be easier and more useful to try out Tableau public and visualize the data as a dashboard. First attempt is below, though I may modify it for more functionality as time goes on.

Powered by Tableau

The Top 30 London Ad Agenices on Foursquare (for 16.07.2010)

Thanks to everyone who suggested new venues on Twitter, by email or in the comments last time. I've added quite a few new listings to the overall list. I'm hoping to upload the full list and simplified data in a few days, once I can plug it into some quick data visualization software for a post.

Also, I've fixed a bug in the aggregator that combined data from Proximity London & SapientNitro, so you should see these as distinct entries now.

As always, if you think that I've missed an agency or location to add to the search list, just email/DM or comment.

.jpg Version below (click to enlarge)

The Top London Ad Agenices on Foursquare (for 29.06.2010) [Infographic]

 As always, if you think that I've missed an agency or location to add to the search list, just email/DM or comment.

.jpg Version below (click to enlarge)

London Advertising Agencies on Foursquare (14.06.2010) [Infographic]

 As always, if you think that I've missed an agency or location to add to the search list, just email/DM or comment.

.jpg Version below (click to enlarge)

London Advertising Agencies on Foursquare (28.05.2010) [Infographic]

    So given that the last London Foursquare Agency graphic was a bit more graphic than info, I decided to add a little bit on the current version. I've posted the current infographic in both .pdf and .png formats. Also, thanks to Sinead Doyle for publicising the last Foursquare ranking post on her blog.  

Click for Larger Version....  As always, if you think that I've missed an agency or location to add to the search list, just email/DM or comment.

Foursquare & Central London Transport [Infographic]

Note:.jpg version at bottom of blog post....

     Lately, I and others have been looking at Foursquare/Gowalla & the like to analyze geolocation data and wrap our heads around what its all about (hence the explosion of Foursquare data in the blog lately). More robust data is being developed, but while this doesn't promise to do any of that, I thought it would be worthwhile to try my hand at another infographic. With this in mind, I thought that the network's potential in generating transport insight might be worthwhile and without providing anything groundbreaking, the takeaways from comparing how people register their travel were pretty interesting.

     As mentioned in the graphic, people seem to be registering locations while on the go, as tube stations aren't nearly as popular as train & tube/train stations. I know that some locations are naturally busier, Charing Cross vs. Brixton for example), but the under performance of some tube stations in popular locations (Leicester Square), means that not nearly as many people are checking in after the fact as would be expected.

     Aside from this, the variety of places people checked in is quite amazing. From buses (shown in the graphic) to planes & a few boats (not shown), people are dynamically logging information when possible.

     Perhaps the most striking fact from the data however, was the lack of dual or superfluous locations. Being that most seek to be mayor of somewhere, you would assume to see more distinctions of tube vs. train stations (for instance, Charing Cross is only listed as one entity). The multitude of people who check in from platforms within a train station however (not shown in final version of graphic), may counteract some of this.

    Overall, I think as the service grows, we should see more people fleshing out London's transport network in line with what we would expect. From this sampling of transportation options, the network is already beginning to be represented well.

[Development Notes: I selected a subset of tube stations to represent due to the fact that I was drawing the map underneath it. TFL is rather touchy about the rights to their map, so I wanted to make sure that mine was divergent enough to not be derivative (hence noticeable differences I've made sure are present).

If this goes over well, I'm considering expanding it to a longer version (including everything that I noted was missing), so if you have any thoughts or ideas, just let me know.

.jpg Version (Click to Enlarge):

Super Bowl XLIV and Twitter [Infographic]

       So this time a week ago, as I sat down to watch two teams I had little interest in (thanks Packers and subsequently Vikings for not livening up the day) fight for the NFL championship, I also decided to track what activity Twitter manifested for the game. The results, shown below in my first attempt at an infographic, are interesting, though after examination, I doubt they are complete. My sample was over 300,000 messages from the hours before till after the game, but I think due to the speed at which they were sent, I didn't get everyone. I still thought the data was interesting enough to be represented below, but keep in mind this is more of a thorough global sample than an exhaustive collection.

Comments and Suggestions about the methodology, the infographic design and the results are welcome.

 

Click for larger version..... 

Mirror for Download (RapidShare)