The first round has ended and we’ve now a fair amount of data for Foursquare and Gowalla. This can be used to try to figure out which fans were most likely to checkin. The top of the table surprised me a bit with who was there and who wasn’t there. The bottom of the table was also a bit surprising. I rather thought that there would be fewer English speaking countries near the bottom and that the Asian and African sides would be over represented. That doesn’t appear to be the case.
Foursquare
| Country |
Total Checkins |
Total Unique Visitors |
Average Checkins |
Average Unique Visitors |
Games played |
Grounds |
| South Africa |
399 |
179 |
133 |
59.66 |
3 |
Soccer City Soccer Stadium; Loftus Versfeld Stadium; Free State Stadium |
| Mexico |
375 |
163 |
125 |
54.3 |
3 |
Soccer City Soccer Stadium; Peter Mokaba Stadium ; Royal Bafokeng Stadium |
| Argentina |
289 |
119 |
96.3 |
39.66 |
3 |
Ellis Park Stadium; Soccer City ; Peter Mokaba Stadium |
| England |
260 |
130 |
86.66 |
43.3 |
3 |
Royal Bafokeng Stadium; Cape Town Stadium ; Nelson Mandela Bay Stadium |
| Nigeria |
228 |
89 |
76 |
29.66 |
3 |
Ellis Park Stadium; Free State Stadium; Moses Mabhida Stadium |
| Portugal |
189 |
101 |
63 |
33.66 |
3 |
Nelson Mandela Bay Stadium; Cape Town Stadium ; Moses Mabhida Stadium |
| Italy |
186 |
99 |
62 |
33 |
3 |
Cape Town Stadium; Mbombela Stadium ; Ellis Park Stadium |
| Uruguay |
186 |
98 |
62 |
32.66 |
3 |
Green Point Stadium ; Loftus Versfeld Stadium ; Royal Bafokeng Stadium |
| North Korea |
176 |
83 |
58.66 |
27.66 |
3 |
Ellis Park Stadium; Cape Town Stadium ; Mbombela Stadium |
| Netherlands |
176 |
81 |
58.66 |
27 |
3 |
Soccer City Soccer Stadium; Moses Mabhida Stadium ; Cape Town Stadium |
| USA |
171 |
75 |
57 |
25 |
3 |
Royal Bafokeng Stadium; Ellis Park Stadium ; Loftus Versfeld Stadium |
| Chile |
170 |
80 |
56.66 |
26.66 |
3 |
Mbombela Stadium; Nelson Mandela Bay Stadium ; Loftus Versfeld Stadium |
| France |
166 |
82 |
55.3 |
27.3 |
3 |
Green Point Stadium ; Peter Mokaba Stadium; Free State Stadium |
| Germany |
148 |
78 |
49.3 |
26 |
3 |
Moses Mabhida Stadium; Nelson Mandela Bay Stadium ; Soccer City |
| Honduras |
142 |
75 |
47.3 |
25 |
3 |
Mbombela Stadium; Ellis Park Stadium ; Free State Stadium |
| Denmark |
134 |
59 |
44.66 |
19.66 |
3 |
Soccer City Soccer Stadium; Cape Town Stadium ; Royal Bafokeng Stadium |
| Brazil |
133 |
81 |
44.3 |
27 |
3 |
Ellis Park Stadium; Soccer City ; Moses Mabhida Stadium |
| Paraguay |
127 |
56 |
42.3 |
18.66 |
3 |
Cape Town Stadium; Free State Stadium; Peter Mokaba Stadium |
| South Korea |
116 |
65 |
38.66 |
21.66 |
3 |
Nelson Mandela Bay Stadium; Soccer City ; Moses Mabhida Stadium |
| Serbia |
76 |
41 |
38 |
13.66 |
3 |
Loftus Versfeld Stadium; Nelson Mandela Bay Stadium ; Mbombela Stadium |
| Cameroon |
110 |
64 |
36.66 |
21.3 |
3 |
Free State Stadium; Cape Town Stadium ; Cape Town Stadium |
| Ghana |
109 |
61 |
36.3 |
20.3 |
3 |
Loftus Versfeld Stadium; Royal Bafokeng Stadium ; Soccer City |
| Algeria |
102 |
60 |
34 |
20 |
3 |
Peter Mokaba Stadium; Cape Town Stadium ; Loftus Versfeld Stadium |
| Slovakia |
100 |
66 |
33.3 |
22 |
3 |
Royal Bafokeng Stadium ; Free State Stadium ; Ellis Park Stadium |
| Switzerland |
94 |
55 |
31.3 |
18.3 |
3 |
Moses Mabhida Stadium; Nelson Mandela Bay Stadium ; Free State Stadium |
| Slovenia |
93 |
43 |
31 |
14.3 |
3 |
Peter Mokaba Stadium; Ellis Park Stadium ; Nelson Mandela Bay Stadium |
| Spain |
90 |
68 |
30 |
22.66 |
3 |
Moses Mabhida Stadium; Ellis Park Stadium ; Loftus Versfeld Stadium |
| Côte d’Ivoire |
88 |
59 |
29.3 |
11.185 |
3 |
Nelson Mandela Bay Stadium; Soccer City ; Mbombela Stadium |
| Australia |
85 |
44 |
28.3 |
14.66 |
3 |
Moses Mabhida Stadium; Royal Bafokeng Stadium ; Mbombela Stadium |
| New Zealand |
75 |
49 |
25 |
16.3 |
3 |
Royal Bafokeng Stadium ; Mbombela Stadium ; Peter Mokaba Stadium |
| Japan |
66 |
42 |
22 |
14 |
3 |
Free State Stadium; Moses Mabhida Stadium ; Royal Bafokeng Stadium |
| Greece |
55 |
29 |
17.3 |
9.666 |
3 |
Nelson Mandela Bay Stadium; Free State Stadium ; Peter Mokaba Stadium |
Gowalla
| Team |
Total Checkins |
Average Checkins |
Games |
Grounds |
| Netherlands |
13 |
4.33 |
3 |
Soccer City ; Moses Mabhida Stadium ; Cape Town Stadium |
| Germany |
11 |
3.66 |
3 |
Moses Mabhida Stadium ; Nelson Mandela Bay Stadium ; Soccer City |
| Denmark |
9 |
3 |
3 |
Soccer City ; Loftus Versveld Stadium ; Royal Bafokeng Stadium |
| Cameroon |
8 |
2.66 |
3 |
Free State Stadium ; Loftus Versveld Stadium ; Cape Town Stadium |
| England |
8 |
2.66 |
3 |
Royal Bafokeng Stadium ; Cape Town Stadium ; Nelson Mandela Bay 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) |
| Slovakia |
6 |
2 |
3 |
Royal Bafokeng Stadium ; Free State Stadium ; Coca-Cola Park (Ellis Park Stadium) |
| Spain |
6 |
2 |
3 |
Moses Mabhida Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Loftus Versveld Stadium |
| United States |
5 |
1.66 |
3 |
Royal Bafokeng Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Loftus Versveld Stadium |
| Uruguay |
5 |
1.66 |
3 |
Loftus Versveld Stadium ; Cape Town Stadium ; Royal Bafokeng Stadium |
| Ghana |
3 |
1.5 |
3 |
Loftus Versveld Stadium ; Royal Bafokeng Stadium ; Soccer City |
| 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 |
| Japan |
4 |
1.33 |
3 |
Free State Stadium ; Moses Mabhida Stadium ; Royal Bafokeng Stadium |
| Paraguay |
4 |
1.33 |
3 |
Cape Town Stadium ; Free State Stadium ; Peter Mokaba Stadium |
| Argentina |
3 |
1 |
3 |
Coca-Cola Park (Ellis Park Stadium) ; Soccer City ; Peter Mokaba Stadium |
| Chile |
3 |
1 |
3 |
Mbombela Stadium ; Nelson Mandela Bay Stadium ; Loftus Versveld Stadium |
| New Zealand |
3 |
1 |
3 |
Royal Bafokeng Stadium ; Mbombela Stadium ; Peter Mokaba Stadium |
| Nigeria |
3 |
1 |
3 |
Coca-Cola Park (Ellis Park Stadium) ; Free State Stadium ; Moses Mabhida Stadium |
| Portugal |
3 |
1 |
3 |
Nelson Mandela Bay Stadium ; Cape Town Stadium ; Moses Mabhida Stadium |
| Serbia |
3 |
1 |
3 |
Loftus Versveld Stadium ; Nelson Mandela Bay Stadium ; Mbombela Stadium |
| Switzerland |
3 |
1 |
3 |
Moses Mabhida Stadium ; Nelson Mandela Bay Stadium ; Free State Stadium |
| Brazil |
2 |
0.66 |
3 |
Coca-Cola Park (Ellis Park Stadium) ; Soccer City ; Moses Mabhida Stadium |
| North Korea |
2 |
0.66 |
3 |
Coca-Cola Park (Ellis Park Stadium) ; Cape Town Stadium ; Mbombela Stadium |
| Slovenia |
2 |
0.66 |
3 |
Peter Mokaba Stadium ; Coca-Cola Park (Ellis Park Stadium) ; Nelson Mandela Bay Stadium |
| South Africa |
2 |
0.66 |
3 |
Loftus Versveld Stadium ; Soccer City; Free State Stadium |
| South Korea |
2 |
0.66 |
3 |
Nelson Mandela Bay Stadium ; Soccer City ; Moses Mabhida Stadium |
| Côte d’Ivoire |
1 |
0.33 |
3 |
Nelson Mandela Bay Stadium ; Soccer City ; Mbombela Stadium |
| Mexico |
1 |
0.33 |
3 |
Peter Mokaba Stadium ; Soccer City ; Royal Bafokeng Stadium |
| Greece |
0 |
0 |
3 |
Nelson Mandela Bay Stadium ; Free State Stadium ; Peter Mokaba Stadium |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
Brazil,
Cameroon,
Chile,
Côte d’Ivoire,
Denmark,
England,
foursquare,
France,
Germany,
Ghana,
gowalla,
Greece,
Honduras,
Italy,
Japan,
Mexico,
Netherlands,
New Zealand,
Nigeria,
North Korea,
Paraguay,
Portugal,
Serbia,
Slovakia,
Slovenia,
South Africa,
South Korea,
Spain,
Switzerland,
Uruguay,
USA,
World Cup Category:
World Cup,
foursquare,
gowalla
On Foursquare, there were changes near the top and near the bottom of the ladder. Yesterday featured one swarm badge, which was the same as the day before and the day before that. It will be interesting to see how teams progress into the second and third games. After the first round, will totals probably matter more than averages? What audience is seeing second round games?
Foursquare
| Country |
Total Checkins |
Total Unique Visitors |
Average Checkins |
Average Unique Visitors |
Games played |
Grounds |
| South Africa |
371 |
164 |
185.5 |
82 |
2 |
Soccer City Soccer Stadium; Loftus Versfeld Stadium |
| Mexico |
349 |
148 |
174.5 |
74 |
2 |
Soccer City Soccer Stadium; Peter Mokaba Stadium |
| Argentina |
283 |
116 |
141.5 |
58 |
2 |
Ellis Park Stadium; Soccer City |
| Italy |
119 |
52 |
119 |
52 |
1 |
Cape Town Stadium; |
| Paraguay |
119 |
52 |
119 |
52 |
1 |
Cape Town Stadium; |
| Nigeria |
222 |
83 |
111 |
41.5 |
2 |
Ellis Park Stadium; Free State Stadium |
| England |
208 |
102 |
104 |
51 |
2 |
Royal Bafokeng Stadium; Cape Town Stadium |
| Chile |
104 |
49 |
104 |
49 |
1 |
Mbombela Stadium; |
| Honduras |
104 |
49 |
104 |
49 |
1 |
Mbombela Stadium; |
| Denmark |
96 |
34 |
96 |
34 |
1 |
Soccer City Soccer Stadium; |
| Netherlands |
96 |
34 |
96 |
34 |
1 |
Soccer City Soccer Stadium; |
| Uruguay |
160 |
83 |
80 |
41.5 |
2 |
Green Point Stadium ; Loftus Versfeld Stadium |
| USA |
159 |
66 |
79.5 |
33 |
2 |
Royal Bafokeng Stadium; Ellis Park Stadium |
| France |
138 |
67 |
69 |
33.5 |
2 |
Green Point Stadium ; Peter Mokaba Stadium |
| Brazil |
65 |
39 |
65 |
39 |
1 |
Ellis Park Stadium; |
| North Korea |
65 |
39 |
65 |
39 |
1 |
Ellis Park Stadium; |
| Australia |
59 |
27 |
59 |
27 |
1 |
Moses Mabhida Stadium; |
| South Korea |
110 |
59 |
55 |
29.5 |
2 |
Nelson Mandela Bay Stadium; Soccer City |
| New Zealand |
50 |
32 |
50 |
32 |
1 |
Royal Bafokeng Stadium ; |
| Slovakia |
50 |
32 |
50 |
32 |
1 |
Royal Bafokeng Stadium ; |
| Côte d’Ivoire |
49 |
37 |
49 |
37 |
1 |
Nelson Mandela Bay Stadium; |
| Portugal |
49 |
37 |
49 |
37 |
1 |
Nelson Mandela Bay Stadium; |
| Algeria |
90 |
51 |
45 |
25.5 |
2 |
Peter Mokaba Stadium; Cape Town Stadium |
| Germany |
90 |
45 |
45 |
22.5 |
2 |
Moses Mabhida Stadium; Nelson Mandela Bay Stadium |
| Spain |
40 |
33 |
40 |
33 |
1 |
Moses Mabhida Stadium; |
| Switzerland |
40 |
33 |
40 |
33 |
1 |
Moses Mabhida Stadium; |
| Ghana |
35 |
17 |
35 |
17 |
1 |
Loftus Versfeld Stadium; |
| Serbia |
66 |
35 |
33 |
17.5 |
2 |
Loftus Versfeld Stadium; Nelson Mandela Bay Stadium |
| Cameroon |
29 |
17 |
29 |
17 |
1 |
Free State Stadium; |
| Japan |
29 |
17 |
29 |
17 |
1 |
Free State Stadium; |
| Greece |
49 |
26 |
24.5 |
13 |
2 |
Nelson Mandela Bay Stadium; Free State Stadium |
| Slovenia |
41 |
15 |
20.5 |
7.5 |
2 |
Peter Mokaba Stadium; Ellis Park Stadium |
Gowalla
Gowalla doesn’t have the checkin strength of Foursquare. A big game on it doesn’t even get to the low count for foursquare and a lot of games have 0s. The ladder is also pretty much completely different.
| Team |
Total Checkins |
Average Checkins |
Games |
Grounds |
| Denmark |
5 |
5 |
1 |
Soccer City |
| Netherlands |
5 |
5 |
1 |
Soccer City |
| Australia |
4 |
4 |
1 |
Moses Mabhida Stadium |
| England |
7 |
3.5 |
2 |
Royal Bafokeng Stadium ; Cape Town Stadium |
| Ghana |
3 |
3 |
1 |
Loftus Versveld Stadium |
| Spain |
3 |
3 |
1 |
Moses Mabhida Stadium |
| Switzerland |
3 |
3 |
1 |
Moses Mabhida Stadium |
| Algeria |
5 |
2.5 |
2 |
Peter Mokaba Stadium ; Cape Town Stadium |
| Uruguay |
5 |
2.5 |
2 |
Loftus Versveld Stadium ; Cape Town Stadium |
| Argentina |
2 |
2 |
1 |
Coca-Cola Park (Ellis Park Stadium) |
| Chile |
2 |
2 |
1 |
Mbombela Stadium |
| Honduras |
2 |
2 |
1 |
Mbombela Stadium |
| Italy |
2 |
2 |
1 |
Cape Town Stadium |
| Paraguay |
2 |
2 |
1 |
Cape Town Stadium |
| France |
4 |
2 |
2 |
Cape Town Stadium ; Peter Mokaba Stadium |
| Germany |
4 |
2 |
2 |
Moses Mabhida Stadium ; Nelson Mandela Bay Stadium |
| Serbia |
3 |
1.5 |
2 |
Loftus Versveld Stadium ; Nelson Mandela Bay Stadium |
| United States |
3 |
1.5 |
2 |
Royal Bafokeng Stadium ; Coca-Cola Park (Ellis Park Stadium) |
| New Zealand |
1 |
1 |
1 |
Royal Bafokeng Stadium |
| Slovakia |
1 |
1 |
1 |
Royal Bafokeng Stadium |
| Nigeria |
2 |
1 |
2 |
Coca-Cola Park (Ellis Park Stadium) ; Free State Stadium |
| South Africa |
2 |
1 |
2 |
Loftus Versveld Stadium ; Soccer City |
| Mexico |
1 |
0.5 |
2 |
Peter Mokaba Stadium ; Soccer City |
| Slovenia |
1 |
0.5 |
2 |
Peter Mokaba Stadium ; Coca-Cola Park (Ellis Park Stadium) |
| Brazil |
0 |
0 |
1 |
Coca-Cola Park (Ellis Park Stadium) |
| Cameroon |
0 |
0 |
1 |
Free State Stadium |
| Côte d’Ivoire |
0 |
0 |
1 |
Nelson Mandela Bay Stadium |
| Greece |
0 |
0 |
2 |
Nelson Mandela Bay Stadium ; Free State Stadium |
| Japan |
0 |
0 |
1 |
Free State Stadium |
| North Korea |
0 |
0 |
1 |
Coca-Cola Park (Ellis Park Stadium) |
| Portugal |
0 |
0 |
1 |
Nelson Mandela Bay Stadium |
| South Korea |
0 |
0 |
1 |
Nelson Mandela Bay Stadium |
How different are these two tables? Teams were ranked based on total average checkins. The difference was then calculated and 12 teams had positions that differed by 10 or more places with only two teams sharing the same position.
|
Gowalla |
Foursquare |
Difference |
| Mexico |
23 |
2 |
21 |
| South Africa |
19 |
1 |
18 |
| Nigeria |
19 |
6 |
13 |
| Brazil |
25 |
15 |
10 |
| North Korea |
25 |
15 |
10 |
| Argentina |
10 |
3 |
7 |
| South Korea |
25 |
18 |
7 |
| Italy |
10 |
4 |
6 |
| Paraguay |
10 |
4 |
6 |
| United States |
17 |
12 |
5 |
| Côte d’Ivoire |
25 |
21 |
4 |
| Portugal |
25 |
21 |
4 |
| Chile |
10 |
7 |
3 |
| Honduras |
10 |
7 |
3 |
| New Zealand |
19 |
19 |
0 |
| Slovakia |
19 |
19 |
0 |
| England |
4 |
7 |
-3 |
| France |
10 |
14 |
-4 |
| Cameroon |
25 |
29 |
-4 |
| Japan |
25 |
29 |
-4 |
| Greece |
25 |
31 |
-6 |
| Uruguay |
5 |
13 |
-8 |
| Denmark |
1 |
10 |
-9 |
| Netherlands |
1 |
10 |
-9 |
| Slovenia |
23 |
32 |
-9 |
| Serbia |
17 |
28 |
-11 |
| Germany |
10 |
23 |
-13 |
| Australia |
3 |
17 |
-14 |
| Algeria |
8 |
23 |
-15 |
| Spain |
5 |
25 |
-20 |
| Switzerland |
5 |
25 |
-20 |
| Ghana |
5 |
27 |
-22 |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
Brazil,
Cameroon,
Chile,
Côte d'Ivoire,
Denmark,
England,
foursquare,
France,
Germany,
Ghana,
gowalla,
Greece,
Honduras,
Italy,
Japan,
Mexico,
Netherlands,
New Zealand,
Nigeria,
North Korea,
Paraguay,
Portugal,
Serbia,
Slovakia,
Slovenia,
South Africa,
South Korea,
Spain,
Switzerland,
Uruguay,
USA,
World Cup Category:
World Cup,
foursquare,
gowalla
Gowalla is the other major geolocation checkin site. I haven’t looked at it since the first day of the World Cup. I need to be a bit more proactive in checking it and updating but the total checkin volume is just so much lower that it is hard to see it as a contender during the cup. (Though, to be fair, Foursquare is falling and when the checkin rate has a difference of 18, that’s not many people.)
I’ve completed a table comparing the total and average checkins on Gowalla for all World Cup games to date. The rankings are rather different than for that of the Foursquare. I’d love speculation as to why.
| Team |
Total Checkins |
Average Checkins |
Games |
Grounds |
| Denmark |
5 |
5 |
1 |
Soccer City |
| Netherlands |
5 |
5 |
1 |
Soccer City |
| Australia |
4 |
4 |
1 |
Moses Mabhida Stadium |
| Germany |
4 |
4 |
1 |
Moses Mabhida Stadium |
| England |
3 |
3 |
1 |
Royal Bafokeng Stadium |
| Ghana |
3 |
3 |
1 |
Loftus Versveld Stadium |
| Serbia |
3 |
3 |
1 |
Loftus Versveld Stadium |
| Spain |
3 |
3 |
1 |
Moses Mabhida Stadium |
| Switzerland |
3 |
3 |
1 |
Moses Mabhida Stadium |
| United States |
3 |
3 |
1 |
Royal Bafokeng Stadium |
| Uruguay |
5 |
2.5 |
2 |
Loftus Versveld Stadium ; Cape Town Stadium |
| Argentina |
2 |
2 |
1 |
Coca-Cola Park (Ellis Park Stadium) |
| Chile |
2 |
2 |
1 |
Mbombela Stadium |
| Honduras |
2 |
2 |
1 |
Mbombela Stadium |
| Italy |
2 |
2 |
1 |
Cape Town Stadium |
| Paraguay |
2 |
2 |
1 |
Cape Town Stadium |
| France |
4 |
2 |
2 |
Cape Town Stadium ; Peter Mokaba Stadium |
| Algeria |
1 |
1 |
1 |
Peter Mokaba Stadium |
| New Zealand |
1 |
1 |
1 |
Royal Bafokeng Stadium |
| Slovakia |
1 |
1 |
1 |
Royal Bafokeng Stadium |
| Slovenia |
1 |
1 |
1 |
Peter Mokaba Stadium |
| Nigeria |
2 |
1 |
2 |
Coca-Cola Park (Ellis Park Stadium) ; Free State Stadium |
| South Africa |
2 |
1 |
2 |
Loftus Versveld Stadium ; Soccer City |
| Mexico |
1 |
0.5 |
2 |
Peter Mokaba Stadium ; Soccer City |
| Brazil |
0 |
0 |
1 |
Coca-Cola Park (Ellis Park Stadium) |
| Cameroon |
0 |
0 |
1 |
Free State Stadium |
| Côte d’Ivoire |
0 |
0 |
1 |
Nelson Mandela Bay Stadium |
| Greece |
0 |
0 |
2 |
Nelson Mandela Bay Stadium ; Free State Stadium |
| Japan |
0 |
0 |
1 |
Free State Stadium |
| North Korea |
0 |
0 |
1 |
Coca-Cola Park (Ellis Park Stadium) |
| Portugal |
0 |
0 |
1 |
Nelson Mandela Bay Stadium |
| South Korea |
0 |
0 |
1 |
Nelson Mandela Bay Stadium |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
Brazil,
Cameroon,
Chile,
Côte d’Ivoire,
Denmark,
England,
France,
Germany,
Ghana,
gowalla,
Greece,
Honduras,
Italy,
Japan,
Mexico,
Netherlands,
New Zealand,
Nigeria,
North Korea,
Paraguay,
Portugal,
Serbia,
Slovakia,
Slovenia,
South Africa,
South Korea,
Spain,
Switzerland,
Uruguay,
USA,
World Cup Category:
World Cup,
gowalla
The second round seems to have a lot fewer checkins than the first. Examples? South Africa and Mexico’s first game had 335 checkins. South Afraica’s second game had 36. Mexico’s second game had 14 checkins. Nigeria’s first game had 203 checkins. The second game had 19. What exactly is going on? Can anyone explain why there are no second round swarm badges? Is there a different audience attending these games that is less likely to use Foursquare?
Table is sorted by average checkins as that seems to better reflect what is going on. There are a number of changes from yesterday in ranking.
| Country |
Total Checkins |
Total Unique Visitors |
Average Checkins |
Average Unique Visitors |
Games played |
Grounds |
| South Africa |
371 |
164 |
185.5 |
82 |
2 |
Soccer City Soccer Stadium; Loftus Versfeld Stadium |
| Mexico |
349 |
148 |
174.5 |
74 |
2 |
Soccer City Soccer Stadium; Peter Mokaba Stadium |
| Argentina |
283 |
116 |
141.5 |
58 |
2 |
Ellis Park Stadium; Soccer City |
| England |
136 |
55 |
136 |
55 |
1 |
Royal Bafokeng Stadium; |
| USA |
136 |
55 |
136 |
55 |
1 |
Royal Bafokeng Stadium; |
| Italy |
119 |
52 |
119 |
52 |
1 |
Cape Town Stadium; |
| Paraguay |
119 |
52 |
119 |
52 |
1 |
Cape Town Stadium; |
| Nigeria |
222 |
83 |
111 |
41.5 |
2 |
Ellis Park Stadium; Free State Stadium |
| Chile |
104 |
49 |
104 |
49 |
1 |
Mbombela Stadium; |
| Honduras |
104 |
49 |
104 |
49 |
1 |
Mbombela Stadium; |
| Denmark |
96 |
34 |
96 |
34 |
1 |
Soccer City Soccer Stadium; |
| Netherlands |
96 |
34 |
96 |
34 |
1 |
Soccer City Soccer Stadium; |
| Uruguay |
160 |
83 |
80 |
41.5 |
2 |
Green Point Stadium ; Loftus Versfeld Stadium |
| France |
138 |
67 |
69 |
33.5 |
2 |
Green Point Stadium ; Peter Mokaba Stadium |
| Brazil |
65 |
39 |
65 |
39 |
1 |
Ellis Park Stadium; |
| North Korea |
65 |
39 |
65 |
39 |
1 |
Ellis Park Stadium; |
| Australia |
59 |
27 |
59 |
27 |
1 |
Moses Mabhida Stadium; |
| Germany |
59 |
27 |
59 |
27 |
1 |
Moses Mabhida Stadium; |
| South Korea |
110 |
59 |
55 |
29.5 |
2 |
Nelson Mandela Bay Stadium; Soccer City |
| New Zealand |
50 |
32 |
50 |
32 |
1 |
Royal Bafokeng Stadium ; |
| Slovakia |
50 |
32 |
50 |
32 |
1 |
Royal Bafokeng Stadium ; |
| Côte d’Ivoire |
49 |
37 |
49 |
37 |
1 |
Nelson Mandela Bay Stadium; |
| Portugal |
49 |
37 |
49 |
37 |
1 |
Nelson Mandela Bay Stadium; |
| Spain |
40 |
33 |
40 |
33 |
1 |
Moses Mabhida Stadium; |
| Switzerland |
40 |
33 |
40 |
33 |
1 |
Moses Mabhida Stadium; |
| Ghana |
35 |
17 |
35 |
17 |
1 |
Loftus Versfeld Stadium; |
| Serbia |
35 |
17 |
35 |
17 |
1 |
Loftus Versfeld Stadium; |
| Cameroon |
29 |
17 |
29 |
17 |
1 |
Free State Stadium; |
| Japan |
29 |
17 |
29 |
17 |
1 |
Free State Stadium; |
| Greece |
49 |
26 |
24.5 |
13 |
2 |
Nelson Mandela Bay Stadium; Free State Stadium |
| Algeria |
18 |
4 |
18 |
4 |
1 |
Peter Mokaba Stadium; |
| Slovenia |
18 |
4 |
18 |
4 |
1 |
Peter Mokaba Stadium; |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
Brazil,
Cameroon,
Chile,
Côte d'Ivoire,
Denmark,
England,
foursquare,
France,
Germany,
Ghana,
Greece,
Honduras,
Italy,
Japan,
Mexico,
Netherlands,
New Zealand,
Nigeria,
North Korea,
Paraguay,
Portugal,
Serbia,
Slovakia,
Slovenia,
South Africa,
South Korea,
Spain,
Switzerland,
Uruguay,
USA,
World Cup Category:
World Cup,
foursquare
We’ve got two games for two teams and the rankings have begun to change. As this World Cup goes on, it looks like fewer people are checking in…
| Country |
Total Checkins |
Total Unique Visitors |
Average Checkins |
Average Unique Visitors |
Games played |
Grounds |
| Mexico |
335 |
135 |
335 |
135 |
1 |
Soccer City Soccer Stadium; |
| Argentina |
203 |
74 |
203 |
74 |
1 |
Ellis Park Stadium; |
| Nigeria |
203 |
74 |
203 |
74 |
1 |
Ellis Park Stadium; |
| South Africa |
371 |
164 |
185.5 |
82 |
2 |
Soccer City Soccer Stadium;Loftus Versfeld Stadium |
| England |
136 |
55 |
136 |
55 |
1 |
Royal Bafokeng Stadium; |
| USA |
136 |
55 |
136 |
55 |
1 |
Royal Bafokeng Stadium; |
| France |
124 |
54 |
124 |
54 |
1 |
Green Point Stadium ; |
| Italy |
119 |
52 |
119 |
52 |
1 |
Cape Town Stadium; |
| Paraguay |
119 |
52 |
119 |
52 |
1 |
Cape Town Stadium; |
| Chile |
104 |
49 |
104 |
49 |
1 |
Mbombela Stadium; |
| Honduras |
104 |
49 |
104 |
49 |
1 |
Mbombela Stadium; |
| Denmark |
96 |
34 |
96 |
34 |
1 |
Soccer City Soccer Stadium; |
| Netherlands |
96 |
34 |
96 |
34 |
1 |
Soccer City Soccer Stadium; |
| Uruguay |
160 |
83 |
80 |
41.5 |
2 |
Green Point Stadium ; Loftus Versfeld Stadium |
| Brazil |
65 |
39 |
65 |
39 |
1 |
Ellis Park Stadium; |
| North Korea |
65 |
39 |
65 |
39 |
1 |
Ellis Park Stadium; |
| Australia |
59 |
27 |
59 |
27 |
1 |
Moses Mabhida Stadium; |
| Germany |
59 |
27 |
59 |
27 |
1 |
Moses Mabhida Stadium; |
| New Zealand |
50 |
32 |
50 |
32 |
1 |
Royal Bafokeng Stadium ; |
| Slovakia |
50 |
32 |
50 |
32 |
1 |
Royal Bafokeng Stadium ; |
| Côte d’Ivoire |
49 |
37 |
49 |
37 |
1 |
Nelson Mandela Bay Stadium; |
| Portugal |
49 |
37 |
49 |
37 |
1 |
Nelson Mandela Bay Stadium; |
| Spain |
40 |
33 |
40 |
33 |
1 |
Moses Mabhida Stadium; |
| Switzerland |
40 |
33 |
40 |
33 |
1 |
Moses Mabhida Stadium; |
| Ghana |
35 |
17 |
35 |
17 |
1 |
Loftus Versfeld Stadium; |
| Serbia |
35 |
17 |
35 |
17 |
1 |
Loftus Versfeld Stadium; |
| Greece |
30 |
17 |
30 |
17 |
1 |
Nelson Mandela Bay Stadium; |
| South Korea |
30 |
17 |
30 |
17 |
1 |
Nelson Mandela Bay Stadium; |
| Cameroon |
29 |
17 |
29 |
17 |
1 |
Free State Stadium; |
| Japan |
29 |
17 |
29 |
17 |
1 |
Free State Stadium; |
| Algeria |
18 |
4 |
18 |
4 |
1 |
Peter Mokaba Stadium; |
| Slovenia |
18 |
4 |
18 |
4 |
1 |
Peter Mokaba Stadium; |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
Brazil,
Cameroon,
Chile,
Côte d'Ivoire,
Denmark,
England,
foursquare,
France,
Germany,
Ghana,
Greece,
Honduras,
Italy,
Japan,
Mexico,
Netherlands,
New Zealand,
Nigeria,
North Korea,
Paraguay,
Portugal,
Serbia,
Slovakia,
Slovenia,
South Africa,
South Korea,
Spain,
Switzerland,
Uruguay,
USA,
World Cup Category:
World Cup,
foursquare
This is an update for matches played on June 15. No new games with 100+ checkins.
| Country |
Total Checkins |
Total Unique Visitors |
Average Checkins |
Average Unique Visitors |
Grounds |
| Mexico |
335 |
135 |
335 |
135 |
Soccer City Soccer Stadium |
| South Africa |
335 |
135 |
335 |
135 |
Soccer City Soccer Stadium |
| Argentina |
203 |
74 |
203 |
74 |
Ellis Park Stadium |
| Nigeria |
203 |
74 |
203 |
74 |
Ellis Park Stadium |
| England |
136 |
55 |
136 |
55 |
Royal Bafokeng Stadium |
| USA |
136 |
55 |
136 |
55 |
Royal Bafokeng Stadium |
| France |
124 |
54 |
124 |
54 |
Green Point Stadium |
| Uruguay |
124 |
54 |
124 |
54 |
Green Point Stadium |
| Italy |
119 |
52 |
119 |
52 |
Cape Town Stadium |
| Paraguay |
119 |
52 |
119 |
52 |
Cape Town Stadium |
| Denmark |
96 |
34 |
96 |
34 |
Soccer City Soccer Stadium |
| Netherlands |
96 |
34 |
96 |
34 |
Soccer City Soccer Stadium |
| Brazil |
65 |
39 |
65 |
39 |
Ellis Park Stadium |
| North Korea |
65 |
39 |
65 |
39 |
Ellis Park Stadium |
| Australia |
59 |
27 |
59 |
27 |
Moses Mabhida Stadium |
| Germany |
59 |
27 |
59 |
27 |
Moses Mabhida Stadium |
| New Zealand |
50 |
32 |
50 |
32 |
Royal Bafokeng Stadium |
| Slovakia |
50 |
32 |
50 |
32 |
Royal Bafokeng Stadium |
| Côte d’Ivoire |
49 |
37 |
49 |
37 |
Nelson Mandela Bay Stadium |
| Portugal |
49 |
37 |
49 |
37 |
Nelson Mandela Bay Stadium |
| Ghana |
35 |
17 |
35 |
17 |
Loftus Versfeld Stadium |
| Serbia |
35 |
17 |
35 |
17 |
Loftus Versfeld Stadium |
| Greece |
30 |
17 |
30 |
17 |
Nelson Mandela Bay Stadium |
| South Korea |
30 |
17 |
30 |
17 |
Nelson Mandela Bay Stadium |
| Cameroon |
29 |
17 |
29 |
17 |
Free State Stadium |
| Japan |
29 |
17 |
29 |
17 |
Free State Stadium |
| Algeria |
18 |
4 |
18 |
4 |
Peter Mokaba Stadium |
| Slovenia |
18 |
4 |
18 |
4 |
Peter Mokaba Stadium |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
Brazil,
Cameroon,
Côte d'Ivoire,
Denmark,
England,
foursquare,
France,
Germany,
Ghana,
Greece,
Italy,
Japan,
Mexico,
Netherlands,
New Zealand,
Nigeria,
North Korea,
Paraguay,
Portugal,
Serbia,
Slovakia,
Slovenia,
South Africa,
South Korea,
Uruguay,
USA,
World Cup Category:
World Cup,
foursquare
As the raw data set is getting quite big, I’m not going to include it in future posts. If you’re interested in seeing it, drop me an e-mail and I’ll happily send it along. Of the three games played on June 14, none of them cracked the top four positions in the leaderboard.
| Country |
Total Checkins |
Total Unique Visitors |
Average Checkins |
Average Unique Visitors |
Grounds |
| Mexico |
335 |
135 |
335 |
135 |
Soccer City Soccer Stadium |
| South Africa |
335 |
135 |
335 |
135 |
Soccer City Soccer Stadium |
| Argentina |
203 |
74 |
203 |
74 |
Ellis Park Stadium |
| Nigeria |
203 |
74 |
203 |
74 |
Ellis Park Stadium |
| England |
136 |
55 |
136 |
55 |
Royal Bafokeng Stadium |
| USA |
136 |
55 |
136 |
55 |
Royal Bafokeng Stadium |
| France |
124 |
54 |
124 |
54 |
Green Point Stadium |
| Uruguay |
124 |
54 |
124 |
54 |
Green Point Stadium |
| Italy |
119 |
52 |
119 |
52 |
Cape Town Stadium |
| Paraguay |
119 |
52 |
119 |
52 |
Cape Town Stadium |
| Denmark |
96 |
34 |
96 |
34 |
Soccer City Soccer Stadium |
| Netherlands |
96 |
34 |
96 |
34 |
Soccer City Soccer Stadium |
| Australia |
59 |
27 |
59 |
27 |
Moses Mabhida Stadium |
| Germany |
59 |
27 |
59 |
27 |
Moses Mabhida Stadium |
| Ghana |
35 |
17 |
35 |
17 |
Loftus Versfeld Stadium |
| Serbia |
35 |
17 |
35 |
17 |
Loftus Versfeld Stadium |
| Greece |
30 |
17 |
30 |
17 |
Nelson Mandela Bay Stadium |
| South Korea |
30 |
17 |
30 |
17 |
Nelson Mandela Bay Stadium |
| Cameroon |
29 |
17 |
29 |
17 |
Free State Stadium |
| Japan |
29 |
17 |
29 |
17 |
Free State Stadium |
| Algeria |
18 |
4 |
18 |
4 |
Peter Mokaba Stadium |
| Slovenia |
18 |
4 |
18 |
4 |
Peter Mokaba Stadium |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
Cameroon,
Denmark,
England,
foursquare,
France,
Germany,
Ghana,
Greece,
Italy,
Japan,
Mexico,
Netherlands,
Nigeria,
Paraguay,
Serbia,
Slovenia,
South Africa,
South Korea,
Uruguay,
USA,
World Cup Category:
World Cup,
foursquare
It is day three and the trend appears to be fewer Foursquare checkins. It is interesting to speculate why. The six teams at the bottom of the checkin ladder all played in games with one European side. Two of those matches were against African sides and one was against Asian side. Those six teams failed to earn their supporters a swarm badge. Is Foursquare less popular in Europe than it is in English speaking countries? Do football fans from those countries use other geolocation sites? Let me know.
Ladder Table
| Country |
Total Checkins |
Total Unique Visitors |
Average Checkins |
Average Unique Visitors |
Grounds |
| Mexico |
335 |
135 |
335 |
135 |
Soccer City Soccer Stadium |
| South Africa |
335 |
135 |
335 |
135 |
Soccer City Soccer Stadium |
| Argentina |
203 |
74 |
203 |
74 |
Ellis Park Stadium |
| Nigeria |
203 |
74 |
203 |
74 |
Ellis Park Stadium |
| England |
136 |
55 |
136 |
55 |
Royal Bafokeng Stadium |
| USA |
136 |
55 |
136 |
55 |
Royal Bafokeng Stadium |
| France |
124 |
54 |
124 |
54 |
Green Point Stadium |
| Uruguay |
124 |
54 |
124 |
54 |
Green Point Stadium |
| Australia |
59 |
27 |
59 |
27 |
Moses Mabhida Stadium |
| Germany |
59 |
27 |
59 |
27 |
Moses Mabhida Stadium |
| Ghana |
35 |
17 |
35 |
17 |
Loftus Versfeld Stadium |
| Serbia |
35 |
17 |
35 |
17 |
Loftus Versfeld Stadium |
| Greece |
30 |
17 |
30 |
17 |
Nelson Mandela Bay Stadium |
| South Korea |
30 |
17 |
30 |
17 |
Nelson Mandela Bay Stadium |
| Algeria |
18 |
4 |
18 |
4 |
Peter Mokaba Stadium |
| Slovenia |
18 |
4 |
18 |
4 |
Peter Mokaba Stadium |
Data Table
| Facility |
Name |
Type |
Link |
Checkins |
Unique Visitors |
Mayor |
Difference |
Difference |
Date |
Team 1 |
Team 2 |
| Soccer City |
Soccer City Soccer Stadium |
Stadium |
http://foursquare.com/venue/4410569 |
67 |
36 |
|
|
|
10-Jun-10 |
|
|
| Soccer City |
Soccer City Soccer Stadium |
Stadium |
http://foursquare.com/venue/4410569 |
402 |
171 |
ardyheijnekamp |
335 |
135 |
11-Jun-10 |
South Africa |
Mexico |
| Cape Town Stadium |
Green Point Stadium |
Stadium |
http://foursquare.com/venue/4410404 |
64 |
31 |
|
|
|
10-Jun-10 |
|
|
| Cape Town Stadium |
Green Point Stadium |
Stadium |
http://foursquare.com/venue/4410404 |
188 |
85 |
|
124 |
54 |
11-Jun-10 |
Uruguay |
France |
| Nelson Mandela Bay Stadium |
Nelson Mandela Stadium |
Stadium |
http://foursquare.com/venue/4410289 |
19 |
11 |
|
|
|
11-Jun-10 |
|
|
| Nelson Mandela Bay Stadium |
Nelson Mandela Stadium |
Stadium |
http://foursquare.com/venue/4410289 |
49 |
28 |
|
30 |
17 |
12-Jun-10 |
Greece |
South Korea |
| Ellis Park Stadium |
Coca-Cola Park (Ellis Park Stadium) |
Stadium |
http://foursquare.com/venue/278284 |
40 |
19 |
-1159291 |
|
|
11-Jun-10 |
|
|
| Ellis Park Stadium |
Ellis Park Stadium (Coca-Cola Park) |
Stadium |
http://foursquare.com/venue/4410611 |
243 |
93 |
-1159291 |
203 |
74 |
12-Jun-10 |
Argentina |
Nigeria |
| Royal Bafokeng Stadium |
Royal Bafokeng Stadium |
Soccer |
http://foursquare.com/venue/3949992 |
18 |
9 |
-511308 |
|
|
11-Jun-10 |
|
|
| Royal Bafokeng Stadium |
royal bafokeng stadium |
|
http://foursquare.com/venue/4668670 |
0 |
0 |
|
|
|
11-Jun-10 |
|
|
| Royal Bafokeng Stadium |
Royal Bafokeng Stadium |
Soccer |
http://foursquare.com/venue/3949992 |
151 |
61 |
-511308 |
133 |
52 |
12-Jun-10 |
USA |
England |
| Royal Bafokeng Stadium |
royal bafokeng stadium |
|
http://foursquare.com/venue/4668670 |
3 |
3 |
|
3 |
3 |
12-Jun-10 |
USA |
England |
| Peter Mokaba Stadium |
Peter Mokaba Stadium |
Soccer |
http://foursquare.com/venue/3949867 |
12 |
5 |
rickycatto |
|
|
12-Jun-10 |
|
|
| Peter Mokaba Stadium |
Peter Mokaba Stadium |
Soccer |
http://foursquare.com/venue/3949867 |
30 |
9 |
rickycatto |
18 |
4 |
13-Jun-10 |
Algeria |
Slovenia |
| Loftus Versfeld Stadium |
Loftus Versveld Stadium |
Stadium |
http://foursquare.com/venue/593221 |
31 |
21 |
-522247 |
|
|
12-Jun-10 |
|
|
| Loftus Versfeld Stadium |
Loftus Versveld Stadium |
Stadium |
http://foursquare.com/venue/593221 |
66 |
38 |
-522247 |
35 |
17 |
13-Jun-10 |
Serbia |
Ghana |
| Moses Mabhida Stadium |
Moses Mabhida Stadium Durban |
|
http://foursquare.com/venue/4570899 |
1 |
1 |
|
|
|
12-Jun-10 |
|
|
| Moses Mabhida Stadium |
Moses Mabhida Stadium Durban |
|
http://foursquare.com/venue/4570899 |
9 |
7 |
aussiegoldy |
8 |
6 |
13-Jun-10 |
Australia |
Germany |
| Moses Mabhida Stadium |
Moses Mabhida Stadium |
Stadium |
http://foursquare.com/venue/4408569 |
24 |
17 |
|
|
|
12-Jun-10 |
|
|
| Moses Mabhida Stadium |
Moses Mabhida Stadium |
Stadium |
http://foursquare.com/venue/4408569 |
75 |
38 |
|
51 |
21 |
13-Jun-10 |
Australia |
Germany |
| Moses Mabhida Stadium |
KEG – Moses Mabhida Stadium |
Pub |
http://foursquare.com/venue/1816495 |
3 |
3 |
|
|
|
12-Jun-10 |
|
|
| Moses Mabhida Stadium |
KEG – Moses Mabhida Stadium |
Pub |
http://foursquare.com/venue/1816495 |
3 |
3 |
|
0 |
0 |
13-Jun-10 |
Australia |
Germany |
Related Posts:
Tags:
Algeria,
Argentina,
australia,
England,
foursquare,
France,
Germany,
Ghana,
Greece,
Mexico,
Nigeria,
Serbia,
Slovenia,
South Africa,
South Korea,
Uruguay,
USA,
World Cup Category:
World Cup,
foursquare