London's Agencies Squared: How London Advertising/Media Agencies Rank Up on Foursquare....

        As I mentioned in my last post about the Psychology of Foursquare, I've been looking into data aggregation and analysis of geo-located networks lately. While I wouldn't want the blog to become a 'one concept pony', I thought it would be interesting to see how agencies around London use Foursquare, since adoption around the industry is key to driving new networks and ideas.

 One aggregation engine & a list of IPA agencies later, I've managed to pull together a rough 'league table' of the top 25 advertising and media agencies in London by check-ins (as of 4/5/2010).

Agency	Id	Check-ins
1. McCann Erickson Advertising Ltd	172633	660
2. Wieden & Kennedy London	219558	529
3. Agency Republic	154743	460
4. Delaney Lund Knox Warren & Partners Ltd	154868	446
5. MindShare	161142	385
6. Dare	154565	297
7. Saatchi & Saatchi	244912	288
8. Profero Ltd	161146	259
9. Digitas	154598	227
10. PHD Media Ltd	173059	217
11. Proximity London	154900	187
12. Wunderman Ltd	605057	178
13. Bartle Bogle Hegarty Ltd	154630	178
14. Zed Media (Branch of ZenithOptimedia UK Limited)	154651	178
15. MediaCom	203677	178
16. Mediaedge:cia	537324	153
17. Abbott Mead Vickers BBDO Ltd	171053	148
18. LBi Limited	154854	138
19. Publicis Ltd	236312	138
20. MPG Media Contacts	1200388	133
21. Media Contacts (Branch of MPG Media Contacts)	1200388	133
22. Glue London Ltd	523581	130
23. Ogilvy Advertising Ltd	156590	128
24. Fallon London	183035	122
25. MediaVest	208064	116

       By taking the agency list and searching rather quickly through Foursquare, I've managed to compile the main Foursquare IDs for a variety of agencies (Currently 105 in total). I know many agencies have a variety of check-in locations within their offices (3rd floor desk with some interesting tips at a certain advertising agency...I'm looking at you), but I chose the most popular/obvious choice presented to me, much in the way a new visitor to an office might. I'm also aware, as many of you have probably thought, that there are many agencies left out by using only the IPA website list. If you have an agency you feel I've left off (there are many), and you have enough check-ins to place you in the top 25, message me on Twitter (@dubosecole), email me or leave a comment and I'll add your Foursquare ID on the list for next time.