Posts Tagged Mexico

Gowalla World Cup Checkins

Posted by Laura on Saturday, 12 June, 2010

This post is similar to the Foursquare Checkins for the World Cup in terms of content and purpose.  The only real difference is that it looks at a different service.  Gowalla is popular with a number of people in the US and elsewhere because it allows users to upload pictures to the location page and allows friends to easily comment in reply to people who are at that location.  It just doesn’t have as many total users as Foursquare. I thought it would be interesting to track the differences in checkins on Gowalla as they appear to cater to a different type of user than Foursquare.  This leads to a question of if and how the checkin patterns between the services will differ?  (They do appear to after the first set of games as the total checkins are the same.)  Gowalla is different than Foursquare in that you can retrospectively go in and get by date data so long as you get it in the past 30 days.  Foursquare requires manually getting this information every day. Also worth noting, it looks like Gowalla also updated their World Cup venues to merge duplicate locations. This was done some time between June 7 and June 12, 2010. As a researcher, I find this less problematic than Foursquare because of how Gowalla shows its checkins. Either way, as I can see by date checkins, it doesn’t effect historical checkins.

Below are the tables for total checkins and raw data.

Total and Average Checkins

Totals Total Checkins Average Checkins Grounds
South Africa 2 2 Soccer City Soccer Stadium
Mexico 2 2 Soccer City Soccer Stadium
Uruguay 2 2 Green Point Stadium
France 2 2 Green Point Stadium

Raw Data

Facility Name Link Date checked Checkins Date Team 1 Team 2
Soccer City Soccer City gowalla.com/spots/653944 12-Jun-10 2 11-Jun-10 South Africa Mexico
Cape Town Stadium Cape Town Stadium gowalla.com/spots/127362 12-Jun-10 2 11-Jun-10 Uruguay France

Related Posts:

Foursquare Checkins for the World Cup

Posted by Laura on Saturday, 12 June, 2010

To anyone who reads this regularly, I apologize in advance.  I may update this information with new posts on a fairly regular basis during the World Cup.   A question I’ve had prior to the World Cup was: Will certain teams have more foursquare checkins than other teams?  This has some interesting side questions that are not available from the data but are interesting to speculate about: Who is checking in to these games?  Are checkins by game reflective of the composition of a nation’s supporters who made the trip? (Or because certain national contingents are more likely to have smart phones that are compatible with South Africa’s mobile network?) Are tech savvy South Africans more likely to show up for certain games involving certain nations?

Only two games have been played so far.  There isn’t much data.  Both groups of fans should have earned swarm badges.  Below are two charts.  The first is the totals by team. The second is my raw data.

Totals and Averages by Team

Totals Total Checkins Total Unique Visitors Average Checkins Average Unique Visitors Grounds
South Africa 335 135 335 135 Soccer City Soccer Stadium
Mexico 335 135 335 135 Soccer City Soccer Stadium
Uruguay 124 54 124 54 Green Point Stadium
France 124 54 124 54 Green Point Stadium

Raw data

Facility Name Type Link Checkins Unique Visitors Mayor Difference Difference Date Team 1 Team 2
Soccer City Soccer City Soccer Stadium Stadium foursquare.com/venue/4410569 67 36 10-Jun-10
Soccer City Soccer City Soccer Stadium Stadium foursquare.com/venue/4410569 402 171 ardyheijnekamp 335 135 11-Jun-10 South Africa Mexico
Cape Town Stadium Green Point Stadium Stadium foursquare.com/venue/4410404 64 31 10-Jun-10
Cape Town Stadium Green Point Stadium Stadium foursquare.com/venue/4410404 188 85 124 54 11-Jun-10 Uruguay France

Related Posts: