Posts Tagged United States

World Cup, end of the second round: Foursquare and gowalla checkin totals

Posted by Laura on Friday, 2 July, 2010

The second round came to an end and the third round is about to start.  My initial thinking was that as the tournament went on, you’d see more checkins at games.  My assumptions were that ticket prices would go up for later rounds, leading to a more affluent, social media connected audience attending these game.  I also assumed that the stadiums would be at capacity, where early first round games would not be. My assumption was South Africa would have the highest average checkins for all team, because of the home country advantage.  I also figured most of the teams left in would be big name team, which would have a wider audience than their own national base. I also thought that Foursquare would always beat Gowalla by a lot. I don’t quite know what I based these assumption on; it just felt like what I thought obvious patterns should be.

Some of these assumptions appeared to be a bit true.  Some of them not.  Appearing in the second round did not mean that a team climbed the ladder of total checkins.  Witness Japan, Paraguay, South Korea, Slovakia, Brazil and Germany who are averaging less than 50 checkins a game on Foursquare at the end of round 2.  Some of these are popular teams and they are all team who played in the second round.  Chile, Brazil, South Korea all appeared in the bottom 16 teams on Gowalla at the end of the second round.  South Africa wasn’t anywhere close to the top on Gowalla.  It should probably hold on to the top spot on Foursquare.  (Mexico has passed it though for total checkins.)  Patterns that I thought would emerge haven’t.

Anyway, on with the data…

Foursquare

Country Total Checkins Total Unique Visitors Average Checkins Average Unique Visitors Games played Grounds
South Africa 399 179 133.00 59.67 3 Soccer City Soccer Stadium; Loftus Versfeld Stadium; Free State Stadium
Mexico 453 199 113.25 49.75 4 Soccer City Soccer Stadium; Peter Mokaba Stadium ; Royal Bafokeng Stadium ; Soccer City
Argentina 367 155 91.75 38.75 4 Ellis Park Stadium; Soccer City ; Peter Mokaba Stadium ; Soccer City
Portugal 317 166 79.25 41.50 4 Nelson Mandela Bay Stadium; Cape Town Stadium ; Moses Mabhida 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
Netherlands 228 110 57.00 27.50 4 Soccer City Soccer Stadium; Moses Mabhida Stadium ; Cape Town Stadium ; Moses Mabhida Stadium
France 166 82 55.33 27.33 3 Green Point Stadium ; Peter Mokaba Stadium; Free State Stadium
Uruguay 219 110 54.75 27.50 4 Green Point Stadium ; Loftus Versfeld Stadium ; Royal Bafokeng Stadium ; Nelson Mandela Bay Stadium
Spain 218 133 54.50 33.25 4 Moses Mabhida Stadium; Ellis Park Stadium ; Loftus Versfeld Stadium ; Cape Town 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
Germany 190 98 47.50 24.50 4 Moses Mabhida Stadium; Nelson Mandela Bay Stadium ; Soccer City ; Free State 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
Brazil 174 109 43.50 27.25 4 Ellis Park Stadium; Soccer City ; Moses Mabhida 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
Paraguay 146 71 36.50 17.75 4 Cape Town Stadium; Free State Stadium; Peter Mokaba Stadium ; Loftus Versfeld Stadium
Ghana 143 88 35.75 22.00 3 Loftus Versfeld Stadium; Royal Bafokeng Stadium ; Soccer City
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
Netherlands 15 3.75 4 Soccer City ; Moses Mabhida Stadium ; Cape Town Stadium ; Moses Mabhida Stadium
Germany 13 3.25 4 Moses Mabhida Stadium ; Nelson Mandela Bay Stadium ; Soccer City ; Free State Stadium
Ghana 12 3.00 4 Loftus Versveld Stadium ; Royal Bafokeng Stadium ; Soccer City ; Royal Bafokeng Stadium
Spain 12 3.00 4 Moses Mabhida Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Loftus Versveld Stadium ; 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
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)
Argentina 9 2.25 4 Coca-Cola Park (Ellis Park Stadium) ; Soccer City ; Peter Mokaba Stadium ; Soccer City
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
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
Paraguay 7 1.75 4 Cape Town Stadium ; Free State Stadium ; Peter Mokaba Stadium ; Loftus Versveld Stadium
United States 7 1.75 4 Royal Bafokeng Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Loftus Versveld Stadium ; Royal Bafokeng Stadium
Uruguay 7 1.75 4 Loftus Versveld Stadium ; Cape Town Stadium ; Royal Bafokeng Stadium ; Nelson Mandela Bay 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
Brazil 5 1.25 4 Coca-Cola Park (Ellis Park Stadium) ; Soccer City ; Moses Mabhida Stadium ; Coca-Cola Park (Ellis Park 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: