Archive for June, 2010

Canberra Raiders data

Posted by Laura on Wednesday, 30 June, 2010

I’m a little late with this so I figured I would have a new top level post rather than edit my existing post.  If you wanted to see the data I presented the Canberra Raiders, it is available here in PDF format. It includes some Foursquare data, Gowalla data, Facebook data, Twitter data and some general NRL data.

If you want similar data related to a specific club, let me know and we can see if we can work out some sort of arrangement.  I’d love to be able to talk to more Canberra based professional, state and national teams.

Related Posts:

Problematic gathering of Foursquare data

Posted by Laura on Monday, 28 June, 2010

One of the challenges of social media metrics is identifying what numbers matter, how to get those numbers ,  how to organize that data in a way that facilitates quickly getting the data and making it useful, and making sure your data set is complete.  The latter can be problematic as people can always create new communities, groups, hashtags, accounts, etc. If you don’t organize your data in a useful way and regularly update it, you can create such a huge mess as to make your data almost unusable.

This is a problem I’ve run into with my AFL and NRL Foursquare data.  When I first started gathering this data in late April, I spent a day or two looking for all the venues.  Slightly problematic issue arose in that not all venues had been created.  I never went back to regularly check to see if these venues had been created.  What this means is that my NRL data has several huge holes in it, because venues don’t exist or the venue that does exist was not the more popular of the ones created.

Another problem was the data was not collected in a way that I found entirely logical when I revisited it to try to create a table to show the average number of checkins at home and away matches for the NRL.  (I wanted to do the NRL first, before I tackled the AFL because I’m focusing on the AFL and trial and erroring on the NRL seemed wiser.)  I gathered the total checkins and unique visitors every Thursday through Monday night for all venues that played NRL and AFL games that I had identified.  In hindsight, this wasn’t the best way to go about this.  I should have identified everything by games being played as it would have made processing the data much, much easier and I wouldn’t have as much “garbage” data that I have to wade through.  I’ve spent most of the morning correcting this mistake by identifying games and venue locations so I can more easily and efficiently track total checkins for AFL games and some NRL games.  (Later, I can try to do this when the A-League, W-League and NBL start up.)

Looking through existing Foursquare data though, I really don’t know if I will want to process it.  I’d almost rather go through the last quarter of the season, where I know I have a complete data set than try to piece together the data dating back to late April.  I probably won’t do that but I’ll likely have to figure out what to do.  It isn’t pretty and I’m really kicking myself for what could have been a lot of time wasted each data gathering data that I can’t use.

My gowalla data faces similar issues.  The big difference there is I’ve always known I haven’t had a complete data set and it was through processing World Cup data on Gowalla that I realized my collection issues with Foursquare data collection.  I’d love to use Gowalla for AFL/NRL analysis but it isn’t going to happen.  I mean, it really isn’t going to happen, especially as Foursquare is the bigger priority as it has greater penetration in Australia and I never had a complete venue list for Gowalla.

Related Posts:

Twitter Weekly Updates for 2010-06-27

Posted by Laura on Sunday, 27 June, 2010
  • Day two of no swarm badge for the World Cup. #
  • 611 fans of UCanberra StalkerSpace on Facebook: bit.ly/adutDN #
  • Based on member interests, looks like Ghana's Black Stars are the most popular #worldcup team on BlackPlanet. #
  • Based on profile interests, Italy's national team is the most popular on LiveJournal. #worldcup #
  • Off task task for the day: Getting social media stats for #worldcup teams. #
  • No #foursquare Swarm badges awarded at any of the 4 #worldcup matches today. #
  • South Africa moved out of the top rankings for total #worldcup #foursquare checkins. Honduras now claims that spot. #
  • The dreaded vuvuzela claims its first victim : bit.ly/9GacmV #
  • Socceroos merchandise on sale at belconnen mall. Guess stores think they will lose… #
  • Anyone have details about IFAF World Cup of Women’s tackle gridiron? #
  • Australian PM news has killed my productivity for the day. :( Still working on typing up interview notes. #
  • An interview with the @RaidersCanberra : bit.ly/bwdbLI #
  • Booked accommodation for #dss10 and got confirmation that funding is coming shortly for it from my department! Yay! #
  • Paper I need to write on Sunday: The effect ofJulia Gillards being PM on Western Bulldogs fan base. #
  • For the #PAR #NZ game at the #worldcup More checkins on Foursquare than on Gowalla. I boggle. #
  • RT @PressSec POTUS on the phone with US soccer team congratulating them on their big win yesterday – hoping for another big win on Saturday #
  • Ealy stats suggest Western Bulldogs/Julia Gillard news did not help Bulldogs grow their online community. #
  • Are Labor people not Western Bulldogs fans? This will seriously bug me all weekend. #
  • Through 3 #worldcup rounds: Netherlands averaging most per game checkins on Gowalla. #ger 2nd, #gre last. #
  • #gre on bottom of the ladder for average per #worldcup game checkins on Foursquare. South Africa & #mex ranked 1, 2. England 4. #USA 11. #
  • Support USA Soccer, add a #twibbon to your avatar now! – bit.ly/b8TMKQ #
  • Is there a list of AFL/NRL players on Facebook? #
  • Why is web traffic down so much for AFL clubs? #
  • Tonight's question: When to wake up to see #usa play #gha in the #worldcup ? 4am start times are slightly better than midnight. #
  • Conclusions I had about Julia Gillard negatively impacting the Bulldogs? Doh! Weird drop patterns in the AFL. Do not understand. #
  • Data absent context can change the meaning: Did Julia Gillard hurt the Bulldogs? bit.ly/d7YodH #spill #

Powered by Twitter Tools

Related Posts:

Data absent context can change the meaning: Did Julia Gillard hurt the Bulldogs?

Posted by Laura on Sunday, 27 June, 2010

I’m not writing this up as a particularly long post, although I could. I was curious as to the impact that Julia Gillard had on the Western Bulldogs. Her name had been linked with them a lot the day of and after she became Prime Minister. I have a paper that I’m trying to figure out what to do with that shows that Jason Akermanis’s comments regarding how gays should stay in the AFL closet didn’t hurt his team. (Though it could have hurt him. That’s a different story.) The US media also made a big deal of Obama being a White Sox fan and there is some evidence to suggest that his presidency helped the team.

The ways I wanted to determine this were to measure the Alexa traffic for the Western Bulldogs site, the number of followers for Bulldogs related accounts on Twitter, the number of fans for the official page and unofficial fan pages on Facebook, the number of and membership increase for fan pages that mention both Julia Gillard and the Western Bulldogs, possibly demographic differences between the Gillard groups and Buldogs only fanpages, the number of mentions for the Western Bulldogs on bebo, the number of people listing the team as an interest on LiveJournal and its clones, the number of pages mentioning Julia Gillard and the Western Bulldogs on google.com.au, and the number and geographic location of edits to the Western Bulldogs article on Wikipedia.

Some of this data on its own might suggest that Julia Gillard hurt the Bulldogs.  Heck, that was my initial assessment.  One of the Western Bulldogs fan pages on Facebook lost 30 people, an anti-Akermanis group lost two people, a pro-Akermanis group lost two people, the Twitter growth was almost non-existent despite Tweets mentioning Gillard, and the Western Bulldog’s site rank on Alexa for Australia fell almost 2,000 places between the 25th and 26th.  Toss in the fact that the Gillard created communities on Facebook were fewer and had much less growth than the anti-Akermanis over the same period.   All of these appear to be really good indicators that Gillard’s effect on the team online was not a great one.

I really want to draw that conclusion.  I almost think I could make a really strong argument that this is exactly the case.  The problem involves putting this into the context of the rest of the AFL.  The Brisbane Lions don’t appear to have an official Facebook fan page but one of their biggest ones lost 30 members the day after the Bulldogs lost 30 members.  Between June 22 and June 26, only one AFL team hasn’t had their Alexa traffic rank for Australia rise; that is the Melbourne Demons.  For that period, three teams saw a rank drop of over 1,000.  Twitter follow gains are about even for all teams.  Official Facebook fan page growth is also pretty close.  In that context, it is hard to say that Julia Gillard had much impact at all.  In fact, for the Alexa data, the big drop could probably be attributed to the fact that they only had half the teams playing a game for this weekend and the weekend before that.  The impact of Gillard on the growth of the Western Bulldogs just probably isn’t there.

In the wider context, no effect.  In a limited context of the team she barracks for, possible effect.  Which conclusion is the right one?

Related Posts:

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

Posted by Laura on Saturday, 26 June, 2010

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:

An interview with Ben Pollack from the Canberra Raiders

Posted by Laura on Thursday, 24 June, 2010

On Wednesday, June 23, 2010, I had the pleasure of talking to Ben Pollack and another staff member at the Canberra Raider.  I really appreciated the opportunity to talk to them as it was provided additional insight into how sport clubs view fandom and social media. I’ve tried to convey as accurately as possible what they have told me based on my memory and I asked their permission to reference them in my blog and paper while I met with them.

If you’re not familiar with the Canberra Raiders, they are a Rugby League team that competes at the top level in the National Rugby League in Australia.  They are based in Australia’s capital, Canberra, and play their home games at Bruce Stadium.  The NRL has a profit sharing scheme, where revenues are shared between all teams.

My purpose in talking to them was to help provide background knowledge for my literature review and to generally enhance my understanding of Australian team sport as it may apply other parts of my research.  Going in, I had four questions I wanted answers to.  These questions were:

1. How do you define fandom?
2. How do you reach out to the fan community?
3. How much influence does league management provide in terms of defining fandom and how to engage in outreach?  Do they give guidance on social media policies?
4. How much do other sports, teams and leagues play a role in development and implementation of concepts related to fan engagement and social media?

The Canberra Raiders define fandom very broadly as people who barrack for them and who attend games.  Their goal is to have this definition encompass all ages, both genders and across the demographic spectrum.  They focus on the Canberra area. They want to take interest in the club and translate that into getting people into the stadium, with bums on seats.  They did not mention trying to get fans to watch on television or buy their merchandise.  It may be something that they define as fandom but I did not follow up to ask about that.

When I inquired about the regional aspect in the NRL helping teams by enabling them to develop a local fanbase, they said that this worked a lot in their favor as the Canberra area was very supportive of the team.  This may not be as true for some of the Sydney based teams where there is much more market overlap and a few teams play at the same venue.  There, clubs need to market more towards traditional understandings of who composes their fanbase.  Sydney based teams are much like many of the Melbourne based AFL clubs in this regard.

I had some data from Facebook that said that there were roughly twice as many UCanberra students and alumni who were fans of the club compared to ANU.  I asked them why their fanbase was stronger at the University of Canberra, if it had to do with different cultures or possibly class related affiliations that each university has.  The club responded that they thought they probably had more fans at UC because the university has a well-known sport program and tends to attract more sport fans than ANU.

I had some bebo related geographic data.  It showed that there were a number of fans from the Brisbane area.  I asked the Raiders if they could explain that.  They told me that this geographic fanbase dates to the club’s founding, when several of the players came from Brisbane.  The club has managed to maintain this fanbase in Queensland over time.

The club primarily reaches out to their fanbase using traditional advertising: Newspapers, television and mail outs.  They have a member list and every week they send out a newsletter to their members.  The newsletter contains injury information, game summaries and information on any special deals that the club has.  They do some outreach on social media, but that is primarily confined to Facebook.

The NRL is a huge influence in how the club handles their website and their social media.  The league requires that clubs post certain types of web and video content every week.  This includes a match report and the post-game press conference.  The NRL has incentivized clubs to try to draw traffic to their websites; at the end of the season, revenues earned by the clubs on their sites are distributed to the clubs.  According to the Raiders, the league brought in Bernie Mullin to help it develop a plan regarding their online activities.  The NRL also guides clubs by encouraging them to push to increase their membership.  Some of this push is based around the idea of local clubs and increasing attendance at local grounds and keeping that local identity.

The Canberra Raiders thus use social media as a way to drive traffic to their site.  Based on our conversation, I did not get the feeling that using social media to develop a fanbase was a goal unto itself.  Rather, I was left with the impression that social media was a tool to drive traffic to their site to help increase their revenue.

The NRL does watch other leagues to see what they are doing in terms of social media.  The Raiders do less of this and spend less time developing their own social media strategy.  This is largely because the Raiders feel the NRL has better resources and more money to handle this.  The Raiders also do not have much time to do this on their own.

One of the major areas where the team has acted regarding social media is in giving in their players training in the use of social media training.  The Australian Federal Police conducted this training.  Details about the training can be found on the club’s website at www.raiders.com.au/default.aspx?s=article-display&id=27038 .  This was something the club felt was important because a number of their players are on Facebook.  Some have 2,000 to 3,000 friends, many of whom they do not know personally.  There have been a number of high profile incidents involving players getting negative media attention as a result of their comments on social media sites like Facebook and Twitter; they want to avoid that.  In general, the club advises players to be careful, not to talk about the team and to keep things personal.  The club does not ban the use of it and the NRL is aware of these problems and is encouraging training.

After getting my questions answered, I asked the Raiders about specific aspects of their social media strategy and asked the club if they had any questions based on the data packet I had provided.  The club does have an official Facebook page and Twitter account.  Ben is most familiar with Facebook, which is one of the reasons they use it more than Twitter.  The club’s original Facebook strategy involved creating a user account, friending people and trying to convert these friends into fans of the official fanpage.  The conversion rate was very low and they did not find it very effective in accomplishing their goals.

They are not entirely certain how Twitter fits into their social media strategy and there is a question of how they chose people to follow.  (Compared to other teams in the NRL, they follow almost no one.)  They were interested in increasing their number of followers but were not certain how to do it.  They also did not think that anyone had replied to them or reTweeted them, though this could be a result of not being familiar enough with the site.

We also discussed Foursquare and Gowalla, how they were used and if it was worth it for the team to explore using them.  They were unsure in this regard, as their time is limited.  If it is the next big thing, it might be worth them investigating.

I asked the club about their web traffic, citing some traffic data from Compete.  They said that a number of teams in the NRL share names with other sport teams.  In the case of the Canberra Raiders, it is the Oakland Raiders.  During the season for the other team, they often see an increase in traffic from US based visitors who mistakenly find their site.

I asked if the club had considered using YouTube.  They had.  One of their ideas involved uploading preview clips to Youtube, with attached notices that the full clip could be viewed on their site. They were not certain of the potential ROI and in the end did not use it.  I then asked them if visitors could embed official Raiders videos on their own blogs.  They were not certain but said that fans could definitely link to their videos.

While social media is a big potential audience for the club, most of their dedicated fans online congregate on a message board not controlled by the club.  They do monitor it and find it occasionally to be a concern because of that lack of control.  The club is aware of the fact that the media also monitor this message board and occasionally use it to generate less than favorable story ideas about the site.

In preparation for talking with the Canberra Raiders, I completed an overview of the size of the online community for the team.  If you are interested in this document, please contact me at laura[@]fanhistory[dot]com or my university e-mail address, [email protected]

One of their ideas involved uploading preview clips to Youtube, with attached notices that the full clip could be viewed on their site.  I then asked them if visitors could embed official Raiders videos on their own blogs.

Related Posts:

Twitter Weekly Updates for 2010-06-20

Posted by Laura on Sunday, 20 June, 2010
  • Ouch. Germany scores vs. Socceroos… but was a beautiful goal. #worldcup #
  • As much as I'm cheering for the Aussies, got to admire how beautifully the Germans are playing. GER 2 – AUS 0 #worldcup #
  • World Cup, day 3: Foursquare checkin totals: bit.ly/d14R76 #
  • three #worldcup games and no swarm badge on #foursquare . What does that say about those games? #
  • RT @zora_aisling Female volunteers living in Canberra requested for MA research in facial recognition. Enquiries to Kim: [email protected] #
  • Bringing American mustard to an Aussie barbecue in self defense. #
  • Anyone have a contact with the Western Bulldogs? Finished a paper about them that I'd love to talk to them about. #
  • What does it say about the Melbourne Storm that the Perth Glory, not currently playing, get more web traffic than they do? #
  • PHD comic: 'World Cup vs. PhD' : bit.ly/bgV74J Ah ha ha! :D #
  • What match was played last night at the MCG? #
  • World Cup, day 4: Foursquare checkin totals: bit.ly/9dMbJr #worldcup #foursquare #sa2010 #
  • RT @Foot_Marketing A Women Social League in a Digital World – bit.ly/ctSM1c #
  • The Essendon Bombers have the most popular official club fan page on Facebook, with almost 13,000 more fans than #2 Adelaide Crows. #
  • World Cup, day 5: Foursquare checkin totals: bit.ly/c9kd2r #
  • Official AFL club Twitter accounts have less sponsor branding than their Facebook just in terms of background and logos… #
  • Social media research is creative research: Get what you think you need, fix that later, evaluate based on what you have. #
  • There is no getting wrong data. There is just learning what to get and to live with that. Or I realized I missed important Twitter data. #
  • Based on full team name, Adelaide Crows most popular AFL club for people uploading videos on YouTube. Magpies are number 2. #
  • Delaying putting out paper. Supervisor wants to do things to it. :) D: Scary. Doing stuff. #
  • World Cup, day 6: Foursquare checkin totals: bit.ly/azVbUY #worldcup #wc2010 #
  • At some point, I will need to write a paper about the W-League. I love women's sport. :D #
  • Alternate World Cup Rankings by Floating Sheep: bit.ly/bkENh7 #
  • Alexa suggests Essendon has the most popular AFL club website, Collingwood #2 Swans #3 Hawks #4 Lions #5 Tigers #6 #
  • First game for South Africa? 335 people checked in on Foursquare. Game two? 36. Why are there fewer checkins for the second round? #
  • World Cup, day 7: Foursquare checkin totals : bit.ly/a5yE0o #
  • World Cup, day 7: Gowalla checkin totals : bit.ly/bdCB8R #
  • Things to do: Create a budget, write out what data I can produce, summarize Canberra Raiders social media community size. #
  • Other things to do: Work on lit review, summarize W-League Melbourne Victory community size, attend writing workshops. #
  • Is anyone blogging about geolocation and the World Cup? :( #worldcup #gowalla #geolocation #
  • World Cup, day 8: Foursquare and gowalla checkin totals : bit.ly/cSeGr0 #
  • Size of socceroos community on bebo has had almost no growth since May 14, 2010. #
  • Blogger has had one erson add the Socceroos as an interest since May 14, 2010. #
  • Does anyone know what happened to Australia Athletics's @australianflame ? #
  • Got Foursquare/Gowalla date for WC. No swarm badges today. :/ Too lazy to post. #

Powered by Twitter Tools

Related Posts:

World Cup, day 8: Foursquare and gowalla checkin totals

Posted by Laura on Saturday, 19 June, 2010

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:

World Cup, day 7: Gowalla checkin totals

Posted by Laura on Friday, 18 June, 2010

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:

World Cup, day 7: Foursquare checkin totals

Posted by Laura on Friday, 18 June, 2010

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: