Showing posts with label Foursquare Agency Rankings. Show all posts
Showing posts with label Foursquare Agency Rankings. Show all posts

Monday, 25 October 2010

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.

Sunday, 8 August 2010

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.

Saturday, 17 July 2010

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)

Friday, 2 July 2010

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)

Tuesday, 15 June 2010

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)

Sunday, 30 May 2010

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.

Saturday, 15 May 2010

Top London Agencies by Foursquare Check-ins (14.05.2010)

Agency: Id: Check-ins:
1.) McCann London 172633 684
2.) Wieden+Kennedy 219558 579
3.) DLKW 154868 493
4.) Agency Republic 154743 488
5.) Mindshare 161142 439
6.) MediaEdge CIA 537324 353
7.) Dare Digital 154565 339
8.) Saatchi & Saatchi 244912 303
9.) PHD 173059 288
10.) Profero 161146 265
11.) We are social 1168488 251
12.) Digitas London 154598 240
13.) SapientNitro 154900 235
14.) MPG/Media Contacts 1200388 232
15.) Mediacom 203677 203
16.) Wunderman 605057 202
17.) BBH London 154630 190
18.) Zed Media 154651 190
19.) glue London 523581 174
20.) AMV BBDO 171053 168
21.) Publicis 236312 152
22.) Ogilvy 156590 144
23.) LBi London 154854 140
24.) Fallon London 183035 137
25.) Rocket 538270 133

(Click for large version)

      As with last week's attempt at pulling Foursquare check-ins for advertising/media around London, 105 existing advertising agencies and 4 new locations were analyzed through Foursquare activity.With only two weeks of complete data, I'm still reconciling merged venues and entries with incomplete or closed duplicates.

      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. 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.

Wednesday, 5 May 2010

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.