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 |