World Cup Social Project for Coca-Cola

The World Cup days are gone now and although Argentina could not make it to the finals, we are happy about one of our most recent projects: our social coverage and Twitter mashup for the World Cup celebration for Coca-Cola Latin America deployed at the fancy URL of http://celebra.cc

What we did

We captured tweets in real-time mentioning the teams playing each match, as well as tweets with photos taken near the designated stadiums. We also captured tweets using certain keywords and hashtags related to the World Cup and its celebration worldwide.

We developed a real-time chart with trends of mentions for each team playing during a match (called in Spanish "Juegómetro"), together with a slideshow of photos shared on Twitter.

Visitors to this site were able to discover cool photos taken worldwide by fans, specially by those in South Africa. See examples here, here or here.

Our goal was to let everybody, no matter where they were located, feel a little closer to this celebration, share it with friends on Twitter and Facebook and of course give their support to their teams.

To promote this application, which was built almost entirely during the first week of the World Cup, we also employed TweetDiscover to connect with users on Twitter and those checking in at certain venues on Foursquare. TweetDiscover allowed us to reach users in different locations in real-time and connect with them through @CocaColaLatam account. Here's Coca-Cola twitter account welcoming everybody to the Stadium

The results

During almost 3 weeks of World Cup we processed and displayed in real-time almost 17.000 photos shared on Twitter and published by users at these 3 main sites: Twitpic, Tweetphoto and Yfrog.

Average amount of processed tweets mentioning any of the teams playing during each match was around 150.000.

Total tweets mentioning teams only during the hours of matches processed at Celebra.cc was over 5 million.

Here is a more detailed chart of team mentions from the Round of 16 until the Final. Guess who's the winner on Twitter ? It's #JPN with more than 200.000 mentions during their match against Paraguay.

All these results are based on our usage of the Twitter Streaming API with its standard access limits.

Here is how the whole product looked like!