World Cup, through quarter finals: Foursquare and gowalla checkin totals
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 |
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?
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.
Sorry, I meant when you combine the results from both, thanks for sharing these results.
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…
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
Interesting look at
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 http://map.pr.
The other ones don't have the audience or are only US based.