World Cup, through quarter finals: Foursquare and gowalla checkin totals

This entry was posted by Laura on Friday, 9 July, 2010 at

The World Cup is done.  Based on averages, there do appear to be trends for usage around different teams.  I don’t have any other large international competition which to compare this two but it might be of interest to others who are organizing such events like the women’s World Cup for soccer and the Rugby World Cup.  Some national contingents will be the same and if we assume that these patterns hold across nationalities… it might give national sides, companies and organizers using geolocation services an idea which one is better for their audience and which games to target.  This is especially true if we assume that Foursquare and Gowalla users are representative of active social media users period who will use other services to discuss the event.

Related to the results: For the Germany vs. Spain game,between getting data before the event and after the event, Foursquare merged two locations.  If I had just used the one, it would have possibly included an additional 43 checks for the game that were from previous games.  Thus, I subtracted the previous venue’s totals from the venue that they were merged into.

Onwards with the results…

Foursquare

Country Total Checkins Total Unique Visitors Average Checkins Average Unique Visitors Games played Grounds
Uruguay 1037 426 172.83 71.00 6 Green Point Stadium ; Loftus Versfeld Stadium ; Royal Bafokeng Stadium ; Nelson Mandela Bay Stadium ; Soccer City ; Cape Town Stadium
Ghana 819 362 163.80 68.40 5 Loftus Versfeld Stadium; Royal Bafokeng Stadium ; Soccer City ; Soccer City
South Africa 399 179 133.00 59.67 3 Soccer City Soccer Stadium; Loftus Versfeld Stadium; Free State Stadium
Germany 735 394 122.50 65.67 6 Moses Mabhida Stadium; Nelson Mandela Bay Stadium ; Soccer City ; Free State Stadium ; Cape Town Stadium ; Moses Mabhida Stadium
Spain 681 400 113.50 66.67 6 Moses Mabhida Stadium; Ellis Park Stadium ; Loftus Versfeld Stadium ; Cape Town Stadium ; Ellis Park Stadium ; Moses Mabhida Stadium
Mexico 453 199 113.25 49.75 4 Soccer City Soccer Stadium; Peter Mokaba Stadium ; Royal Bafokeng Stadium ; Soccer City
Argentina 512 228 102.40 45.60 5 Ellis Park Stadium; Soccer City ; Peter Mokaba Stadium ; Soccer City ; Cape Town Stadium
Portugal 317 166 79.25 41.50 4 Nelson Mandela Bay Stadium; Cape Town Stadium ; Moses Mabhida Stadium ; Cape Town Stadium
Netherlands 461 219 76.83 36.50 6 Soccer City Soccer Stadium; Moses Mabhida Stadium ; Cape Town Stadium ; Moses Mabhida Stadium ; Nelson Mandela Bay Stadium ; Cape Town Stadium
Nigeria 228 89 76.00 29.67 3 Ellis Park Stadium; Free State Stadium; Moses Mabhida Stadium
England 302 150 75.50 37.50 4 Royal Bafokeng Stadium; Cape Town Stadium ; Nelson Mandela Bay Stadium ; Free State Stadium
Italy 186 99 62.00 33.00 3 Cape Town Stadium; Mbombela Stadium ; Ellis Park Stadium
North Korea 176 83 58.67 27.67 3 Ellis Park Stadium; Cape Town Stadium ; Mbombela Stadium
France 166 82 55.33 27.33 3 Green Point Stadium ; Peter Mokaba Stadium; Free State Stadium
Brazil 265 156 53.00 31.20 5 Ellis Park Stadium; Soccer City ; Moses Mabhida Stadium ; Ellis Park Stadium ; Nelson Mandela Bay Stadium
Chile 211 108 52.75 27.00 4 Mbombela Stadium; Nelson Mandela Bay Stadium ; Loftus Versfeld Stadium ; Ellis Park Stadium
USA 205 102 51.25 25.50 4 Royal Bafokeng Stadium; Ellis Park Stadium ; Loftus Versfeld Stadium ; Royal Bafokeng Stadium
Honduras 142 75 47.33 25.00 3 Mbombela Stadium; Ellis Park Stadium ; Free State Stadium
Denmark 134 59 44.67 19.67 3 Soccer City Soccer Stadium; Cape Town Stadium ; Royal Bafokeng Stadium
Paraguay 209 115 41.80 23.00 5 Cape Town Stadium; Free State Stadium; Peter Mokaba Stadium ; Loftus Versfeld Stadium ; Ellis Park Stadium
Slovakia 152 95 38.00 23.75 4 Royal Bafokeng Stadium ; Free State Stadium ; Ellis Park Stadium ; Moses Mabhida Stadium
Serbia 76 41 38.00 13.67 3 Loftus Versfeld Stadium; Nelson Mandela Bay Stadium ; Mbombela Stadium
South Korea 149 77 37.25 19.25 4 Nelson Mandela Bay Stadium; Soccer City ; Moses Mabhida Stadium ; Nelson Mandela Bay Stadium
Cameroon 110 64 36.67 21.33 3 Free State Stadium; Cape Town Stadium ; Cape Town Stadium
Algeria 102 60 34.00 20.00 3 Peter Mokaba Stadium; Cape Town Stadium ; Loftus Versfeld Stadium
Switzerland 94 55 31.33 18.33 3 Moses Mabhida Stadium; Nelson Mandela Bay Stadium ; Free State Stadium
Slovenia 93 43 31.00 14.33 3 Peter Mokaba Stadium; Ellis Park Stadium ; Nelson Mandela Bay Stadium
Côte d’Ivoire 88 59 29.33 11.19 3 Nelson Mandela Bay Stadium; Soccer City ; Mbombela Stadium
Australia 85 44 28.33 14.67 3 Moses Mabhida Stadium; Royal Bafokeng Stadium ; Mbombela Stadium
New Zealand 75 49 25.00 16.33 3 Royal Bafokeng Stadium ; Mbombela Stadium ; Peter Mokaba Stadium
Japan 85 57 21.25 14.25 4 Free State Stadium; Moses Mabhida Stadium ; Royal Bafokeng Stadium ; Loftus Versfeld Stadium
Greece 55 29 17.33 9.67 3 Nelson Mandela Bay Stadium; Free State Stadium ; Peter Mokaba Stadium

Gowalla

Team Total Checkins Average Checkins Games Grounds
Germany 26 4.33 6 Moses Mabhida Stadium ; Nelson Mandela Bay Stadium ; Soccer City ; Free State Stadium ; Cape Town Stadium ; Moses Mabhida Stadium
Netherlands 26 4.33 6 Soccer City ; Moses Mabhida Stadium ; Cape Town Stadium ; Moses Mabhida Stadium ; Soccer City ; Cape Town Stadium
Argentina 18 3.60 5 Coca-Cola Park (Ellis Park Stadium) ; Soccer City ; Peter Mokaba Stadium ; Soccer City ; Cape Town Stadium
Ghana 17 3.40 5 Loftus Versveld Stadium ; Royal Bafokeng Stadium ; Soccer City ; Royal Bafokeng Stadium ; Soccer City
Uruguay 19 3.17 6 Loftus Versveld Stadium ; Cape Town Stadium ; Royal Bafokeng Stadium ; Nelson Mandela Bay Stadium ; Soccer City; Cape Town Stadium
Denmark 9 3.00 3 Soccer City ; Loftus Versveld Stadium ; Royal Bafokeng Stadium
Cameroon 8 2.67 3 Free State Stadium ; Loftus Versveld Stadium ; Cape Town Stadium
Spain 17 2.83 6 Moses Mabhida Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Loftus Versveld Stadium ; Cape Town Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Moses Mabhida Stadium
England 10 2.50 4 Royal Bafokeng Stadium ; Cape Town Stadium ; Nelson Mandela Bay Stadium ; Free State Stadium
Algeria 7 2.33 3 Peter Mokaba Stadium ; Cape Town Stadium ; Loftus Versveld Stadium
Italy 7 2.33 3 Cape Town Stadium ; Mbombela Stadium ; Coca-Cola Park (Ellis Park Stadium)
Portugal 9 2.25 4 Nelson Mandela Bay Stadium ; Cape Town Stadium ; Moses Mabhida Stadium ; Cape Town Stadium
Slovakia 8 2.00 4 Royal Bafokeng Stadium ; Free State Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Moses Mabhida Stadium
Brazil 9 1.80 5 Coca-Cola Park (Ellis Park Stadium) ; Soccer City ; Moses Mabhida Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Soccer City
Japan 7 1.75 4 Free State Stadium ; Moses Mabhida Stadium ; Royal Bafokeng Stadium ; Loftus Versveld Stadium
Mexico 7 1.75 4 Peter Mokaba Stadium ; Soccer City ; Royal Bafokeng Stadium ; Soccer City
United States 7 1.75 4 Royal Bafokeng Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Loftus Versveld Stadium ; Royal Bafokeng Stadium
Paraguay 8 1.60 5 Cape Town Stadium ; Free State Stadium ; Peter Mokaba Stadium ; Loftus Versveld Stadium ; Coca-Cola Park (Ellis Park Stadium)
Chile 6 1.50 4 Mbombela Stadium ; Nelson Mandela Bay Stadium ; Loftus Versveld Stadium; Coca-Cola Park (Ellis Park Stadium)
Australia 4 1.33 3 Moses Mabhida Stadium ; Royal Bafokeng Stadium ; Mbombela Stadium
France 4 1.33 3 Cape Town Stadium ; Peter Mokaba Stadium ; Free State Stadium
Honduras 4 1.33 3 Mbombela Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Free State Stadium
South Korea 4 1.00 4 Nelson Mandela Bay Stadium ; Soccer City ; Moses Mabhida Stadium ; Nelson Mandela Bay Stadium
New Zealand 3 1.00 3 Royal Bafokeng Stadium ; Mbombela Stadium ; Peter Mokaba Stadium
Nigeria 3 1.00 3 Coca-Cola Park (Ellis Park Stadium) ; Free State Stadium ; Moses Mabhida Stadium
Serbia 3 1.00 3 Loftus Versveld Stadium ; Nelson Mandela Bay Stadium ; Mbombela Stadium
Switzerland 3 1.00 3 Moses Mabhida Stadium ; Nelson Mandela Bay Stadium ; Free State Stadium
North Korea 2 0.67 3 Coca-Cola Park (Ellis Park Stadium) ; Cape Town Stadium ; Mbombela Stadium
Slovenia 2 0.67 3 Peter Mokaba Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Nelson Mandela Bay Stadium
South Africa 2 0.67 3 Loftus Versveld Stadium ; Soccer City; Free State Stadium
Côte d’Ivoire 1 0.33 3 Nelson Mandela Bay Stadium ; Soccer City ; Mbombela Stadium
Greece 0 0.00 3 Nelson Mandela Bay Stadium ; Free State Stadium ; Peter Mokaba Stadium

Related Posts:

Tags: , , , , , ,
Category: World Cup, foursquare, gowalla
You can follow any responses to this entry via RSS.
You can skip to the end to leave a comment. Trackbacks are currently not allowed.
  • http://www.typeboard.com Valeri

    So it's safe to say Uruguay was the most popular team of the world cup when you add up the stats for Foursquare and Gowalla.. correct?

  • http://www.fanhistory.com LauraH

    That would be what I'd say for Foursquare. Germany and Netherlands for Gowalla. I'm not certain of the crossover between the two as I think they have separate audiences.

    Uruguay had 36, 124, 26, 33, 676, 142 total checkins. Not bad at all. Other teams didn't have three games above 100 and their low checkin games aren't the worst of the lot.

  • http://www.typeboard.com Valeri

    Sorry, I meant when you combine the results from both, thanks for sharing these results.

  • http://www.fanhistory.com LauraH

    I could probably combine total checkins but the numbers for Gowalla are so low that I don't think they would have much impact… hm. Well, I can try that. I'll just do averages and smush them together: each individual checkin for the average, so that you get an average of 12 “games” for say Germany and 6 for South Africa.

    Country Total Checkins
    Uruguay 104.40
    Ghana 83.60
    South Africa 66.83
    Germany 63.42
    Spain 58.17
    Mexico 57.50
    Argentina 53.00
    Portugal 40.75
    Netherlands 40.58
    England 39.00
    Nigeria 38.50
    Italy 32.17
    North Korea 29.67
    France 28.33
    Brazil 27.40
    Chile 27.13
    Honduras 24.33
    Denmark 23.83
    USA 22.40
    Paraguay 21.70
    Slovakia 20.00
    Cameroon 19.67
    South Korea 19.13
    Algeria 18.17
    Switzerland 16.17
    Slovenia 15.83
    Serbia 15.80
    Australia 14.83
    Côte d'Ivoire 14.83
    New Zealand 13.00
    Japan 11.50
    Greece 8.67

    That changes the order around a bit…

  • http://www.typeboard.com valeri

    Thanks for that LauraH, interesting to see the results, 4square and Gowalla seems to be the most popular geo-location apps right now so we could say Uruguay won the geo-location world cup :-)

  • bartdenny

    Interesting look at

  • bartdenny

    Interesting stuff, thanks for putting this together.

    We launched a World Cup version of our Map.pr iPhone app, which lets users check in with their team, no matter where they are watching. We then have a leaderboard, where not only can you see the most checkins per team worldwide, but also in a local area.

    We saw most checkins so far from the USA, followed by England. But Spain and Netherlands are in striking distance, and with the increased attention of the final, they may indeed emerge victorious in the checkin trophy as well. Check it out at map.pr.

  • http://www.fanhistory.com LauraH

    The other ones don't have the audience or are only US based. :(

blog comments powered by Disqus