Wednesday, June 4, 2008

Facebook statistics and Google Motion Chart

Time again for an update of the statistics of Facebook usage, penetration and growth. What has happenend since I last wrote about this in February? (And here are all my posts about Facebook statistics, including this one.)

The news includes:
  • Statistics for more countries
    During May Facebook added 26 countries to the SocialAd tool, bringing up the total to 81 countries.
    New countries are: Bangladesh, Bolivia, Bulgaria, Costa Rica, Cyprus, Czech Republic, Ecuador, El Salvador, Guatemala, Honduras, Hungary, Jamaica, Kenya, Lithuania, Luxembourg, Morocco, Nicaragua, Paraguay, Portugal, Qatar, Romania, Slovakia, Slovenia, Sri Lanka, Trinidad and Tobago, and finally Uruguay.
  • Facebook translated into more languages
    Spanish was first out, followed by German and French. Now a total of 16 languages are supported, including all of the Nordic languages. See list to the right.

  • New numbers used for population and Internet usage
    I updated the country population numbers used with the July 2008 estimate from the CIA Factbook. And also for the numbers on internet penetration I used the latest information from Internet World Stats.

  • Gapminder tool available as Google Motion Chart
    Since I started collecting the Facebook statistics I have been waiting for this. You might recall my post about Statistical Storytelling, where I mentioned the Gapminder tool that was acquired by Google. Now this tool is available as a graph option inside Google Spreadsheets, and naturally that's what I now use to present the information.

So, on to the statistics! This time I only made a chart for a single date (March 30th, 2008), but naturally the next step is to take advantage of the Motion Chart capabilities by adding historical data, so we can see how the patterns changes over time.

Below you will find the interactive chart. (If you are reading the feed of this blog the embedded chart might not turn up, go here instead).

A larger version is available here. Play around with it and see what you find, to guide you I have made some screenshots further down. Also an explanation of the available indicators are below.

If you find something interesting, or have a suggestion for further data that might be interesting to add, let me know!




The chart should initially look like the screenshot below, except for the country names. You can get the country name for each bubble by hoovering over it, and by clicking on a bubble the name will stick.


This view has the number of Facebook users per country on the x-axis, and the Facebook penetration (of country population) on the y-axis. The size of the bubble is the population of the country, and the colour is simple which region the country belongs to.

US, UK and Canada are the top three countries when you look at numberof Facebook users. looking at the Facebook penetration among the population in a country the top three are Canada, Norway and UK. The two large blue bubbles bottom left are India and China.

Now, let's keep the data for the two axis (each country will keep its position) and change the colour to represent the relative growth the last two weeks, and the size to represent the absolute growth the same period.You see three rather big bubbles (Canada, UK and Chile), representing the countries which added more that 400 000 users since March 16th. And notice the red colour of Chile, indicating the highest relative growth (close to 60%) - the blueish colour of UK and Canada represents a relaive growth of only 4.4%

To dig further into where the Facebook growth is at the moment we keep all settings but for the x-axis, which we make represent the rank of the relative growth (each country get the position of its current relative growth, meaning the highest growth (#1) is the leftmost bubble). To further focus on the high growth countries we turn the scale of the x-axis into a log scale.

This makes it easy to see that the current high growth countries are Chile, Venezuela, Uruguay and Lebanon. Note that the US seems to be at the bottom (far right) - actually US ens up on position #79. Iceland and Jamaica have lower growth, but their bubbles (in this case) are too small to be visible.

This way you can visualize up to four parameters in the same graph and look for patterns and trends. It is easy to create scattered views that not really adds any value, so be careful.

You can also have a look at a single parameter only. Below we used the region as the colour and set the size to be the same for all bubbles. On the y-axis we map the penetration of Facebook users among the internet users in each country, and on the x-axis we simply used the rank of the same indicator (no log scale this time). This makes it easy to study this single parameter.

Here you see Panama and Trinidad and Tobago in top before Canada.

In a similar way you can view the two parameters we used initially (Facebook penetration per country population and the number of Facebook users) separately.

Notice that Sweden has lost one position when looking at the penetration (down to 5th place with Denmark closing in) and lost 3 positions when looking at the total number of Facebok users (down to 10th place with the high growth country of Chile ahead).

Now it's your turn. Play around and find some facts! There's more parameters available than the ones we used above. When you find something worth noticing leave a comment here. Also let me know if I shall add any further data to play around with.

And stay tuned for next post, adding the historical data will make this even more fun.

Here is an explanation of available parameters:




(As the tables will not get indexed I add this: Facebook statistics, usage, penetration for Turkey Israel France Malaysia Singapore China Switzerland Colombia Italy Germany India Spain Ireland Netherlands Australia Saudi Arabia New Zealand Mexico Egypt Lebanon United Arab Emirates UAE Pakistan Dominican Republic Japan Sweden South Korea, Republic of Korea United Kingdom UK Norway United States (US) South Africa Canada Philippines Indonesia Russian Federation (Russia) Greece Denmark Finland Chile Belgium Argentina Venezuela Austria Jordan Peru Kuwait Thailand Panama Brazil Croatia Hong Kong Nigeria Poland Serbia Taiwan Bangladesh, Bolivia, Bulgaria, Costa Rica, Cyprus, Czech Republic, Ecuador, El Salvador, Guatemala, Honduras, Hungary, Jamaica, Kenya, Lithuania, Luxembourg, Morocco, Nicaragua, Paraguay, Portugal, Qatar, Romania, Slovakia, Slovenia, Sri Lanka, Tinidad and Tobago,Uruguay)

Labels:

6 Comments:

Blogger TrendCompass said...

Dear Sir,

Epic Systems together with Beemode (www.beemode.com) have developed a Data Visualization software "Trend Compass" almost ready to be released soon. It is an extension to Gapminder which was invented by a Swedish Professor.

We are looking to promote that software in various sectors. It is a new concept in viewing statistics and trends in an animated way. It could be used in presentation, analysis,research, decision making, etc.

Here are some links :
- Ads Monitoring on TV Sattelite Channels during April 2008. Pick Duration (Ads daily duration) vs Repeat (Ads repetition per day). Check the Trail Box to get a better view.

http://www.epicsyst.com/ads3/allchannels.swf

- A project we did with Princeton University on US unemployment :
www.epicsyst.com/main3.swf

- April 2008 Media Monitoring on Cars TV ads (ad duration vs occurences over time) :
www.epicsyst.com/ads/cars.swf

I hope you could evaluate it and give me your comments. So many ideas are there.

You can test the software by uploading data on our website and getting the corresponding Flash charts. This is for a limited number of users.

Regards.

Eng. Hisham Abdel Maguid
Epic Systems
www.epicsyst.com

June 17, 2008 at 11:49 PM  
Anonymous Anonymous said...

More links on Trend Compass :

- US Population from 2004 till 2030 for ages 0 - 83 focus on Baby Boomers and turn the Trails off (uncheck)
http://www.epicsyst.com/Pop/Babyboomer.swf

- April 2008 Media Monitoring on Cars and Beverages TV ads (ads Duration vs Repetition per Day over time) :
http://www.epicsyst.com/ads/cars.swf
http://www.epicsyst.com/ads2/bev.swf

- Ads Monitoring on TV Sattelite Channels during April 2008. Pick Duration (Ads daily duration) vs Repeat (Ads repetition per day).
http://www.epicsyst.com/ads3/allchannels.swf

Next one is my favourite it covers a lot (change the X and Y coordinates) and it accumulates his earnings too, 43 Million USD :
http://www.epicsyst.com/sampras/sampras1.swf

Ossama Hamed
www.epicsyst.com

December 21, 2008 at 5:11 PM  
Blogger TrendCompass said...

Dear Sir,

Epic Systems has developed a Data Visualization software "Trend Compass". It is an extension to Gapminder which was invented by a Swedish Professor. You can view it :
- www.gapminder.org

It is a new concept in viewing statistics and trends in an animated way and displaying 4 axis instead of just the traditional X and Y axis. It could be used in analysis, research, presentation etc.

Here are some links :

- A project we did with Princeton University on US unemployment :
http://www.epicsyst.com/main3.swf
A 3 minutes video presentation of above by Professor Alan Krueger Bendheim Professor of Economics and Public Affairs at Princeton University :
http://epicsyst.com/trendcompass/princeton.aspx?home=1

- US Population from 2004 till 2030 for ages 0 - 83 focus on Baby Boomers and turn the Trails off (uncheck)
http://www.epicsyst.com/Pop/Babyboomer.swf

- April 2008 Media Monitoring on Cars and Beverages TV ads (ads Duration vs Repetitions (occurences) per Day over time) :
http://www.epicsyst.com/ads/cars.swf
http://www.epicsyst.com/ads2/bev.swf

- Ads Monitoring on TV Satellite Channels during April 2008. Pick Duration (Ads daily duration) vs Repeat (Ads repetition per day).
http://www.epicsyst.com/ads3/allchannels.swf

Next one is my favourite it covers a lot (change the X and Y coordinates) and it accumulates his earnings too, 43 Million USD :
http://www.epicsyst.com/sampras/sampras1.swf

Latest financial links on the Central Bank of Egypt like the Federal Reserve Bank in US :

http://www.epicsyst.com/trendcompass/samples/balance-sheet
http://www.epicsyst.com/trendcompass/samples/banks-deposits-by-maturity/
http://www.epicsyst.com/trendcompass/samples/currency-by-denomination/
http://www.epicsyst.com/trendcompass/samples/egyptian-banks/
http://www.epicsyst.com/trendcompass/samples/tourism/

I hope you could evaluate it and give me your comments. So many ideas are there.

You can test the software by uploading data on our website and getting the corresponding Flash charts.This is for a limited number of users. You can also download a trial version. It has a feature to export EXE,PPS,HTML and AVI files. The most impressive is the AVI since you can record Audio/Video for the charts you create.

http://epicsyst.com/trendcompass/FreeVersion/TrendCompassv1.2_DotNet.zip

All the best.

Ossama Hamed
Epic Systems
www.epicsyst.com

October 1, 2009 at 7:16 PM  
Anonymous Anonymous said...

Dear Sir,

I am sending you links on the newly expected Trend Compass which is still in our Lab.

http://www.epicsyst.com/test/v2/babyboomers/

http://www.epicsyst.com/test/v2/bank-trx/

http://www.epicsyst.com/test/v2/advertising/

How to use the zooming :

1. Press the Zoom button on top (the Middle one)
2. Go to the chart hold the Left click, then create a square shape for the area you wish to zoom by dragging.
3. To reset it back, press the Reset button on top (the Right one)

Tell me what you think of the new look and feature.

Please feel Free to contact me. I will be glad to help you.

Regards.

Ossama Hamed
Trend Compass Team
Epic Systems
www.epicsyst.com

October 1, 2009 at 7:16 PM  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

January 5, 2010 at 3:12 PM  
Blogger Carl-Johan Sveningsson said...

Hi there, I love this post!

I have been looking a bit at Alexa data, to try to sift out what are the fastest rising sites globally, catching memes and whatever, would you apply Motion Chart to this as well?

Oh and by the way, I was also spammed (on skitch!) by Trend Compass with the same messages, they don't deserve to survive spam deletion.

March 25, 2010 at 1:50 PM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home