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)

Facebook statistics - an update

It has been a while since I last posted a updated statistics about Facebook usage, growth and penetration. But now it's time again.

If you have missed my earlier posts please have a look here for all posts on Facebook stats (including this post).

Please note - all tables and graphs might be missing if you are reading the feed of this blog. Please go to TheKillerAttitude.com to ensure you see everything.

This time I post a number of "top ten" lists to highlight some aspects. In the end I enclose a complete table, all countries, all statistics.

Recently there has been a number of posts around declining usage of Facebook in the US and UK, based on figures from eg. comScore and Nielsen Online. It might be partially because of a saturation among the users for Social Networking activities. Read the update in this post though, where Facebook states they are measuring active users, not unique visitors.

Also recently, Facebook launched a Spanish translation in the beginning of February. Will non-english versions help continue to drive the growth? Read on for an indication.

And finally, Facebook just added a few countries to the SocialAd utility. Brazil, Croatia, Hong Kong, Nigeria, Poland, Serbia and Taiwan was added. When I looked at the numbers last week these countries where represented, but did not have any data yet.

What do we measure?
But first, some thoughts on what numbers we are following.

I have been looking into the numbers provided by Facebook through the SocialAd utility. As the target group for these figures are potential advertisers I believe Facebook are keen to keep the numbers as accurate as big as possible but also as accurate as possible.

As indicated both in the post from ReadWriteWeb I mentioned above, and in Robert Scoble's interview with Marc Zuckerberg, Facebook seems to define a "active user" as someone who has signed in over the last 30 days. Thus I do believe the SocialAd numbers reflects "active users".

But then, in this post Michael Arrington quotes Matt Cohler (VP Facebook), stating that there's 600 000 active users in Germany. The number in SocialAd is 480 000 currently. Oh well...

I have also used the member count in some country networks. Not for all countries, see overall tabel at the end to find out which countries.

The "networks" are something each user selects to join or not. Thus not all users based in a country is expected to be part of the country network. Also, a user can join a different network than the home country.

On the other hand, I do believe the country as stated in the SocialAd utility is based on the country the user selects when signing up for Facebook.

We should also note that the "network" figure probably are not taking into account which users are considered active or not.

If you look at the growth week per week, and compare the growth in SocialAd's numbers and the networks, you see this:

The networks I have looked at (yellow bars) shows a growth every week. The SocialAds data (blue - all countries, red - only countries with "network" data) are more bumpy. Every second week or so you see a growth, in between you only see minor changes.

And last, when calculating benchmark figures I have used population data from the CIA factbook and data on internet usage from Internet World Stats.

Enough introduction, on to the stats.

Countries with highest usage
So, which country is "most Facebooked"?

Depends on how you define it, of course. We'll use the data from the Social Ad utility.
If you look at number of user you get this top ten list:

US in the top, no surprise.

If you on the other hand look at Facebook penetration per country population you get this top ten list:

US falls down to #8. Note that several Nordic countries are among the top ten.

If you however use the penetration among the internet users ina country as benchmark you see a few countries which might be unexpected:

Canada ranks high whatever metrics you use though.

Where's the growth?
It is always interesting to see where the growth is. Let's see the top ten list of growth rate since beginning of the year, using Social Ad data.

So there is still growth according to the numbers. But of course the highest growth potential is where the penetration is lower.

What if you look at the growth in absolute numbers?

Well, US and UK in the top. So this is where most users are added, according to SocialAds. Not the same message as in the articles referenced in the beginning of this blog post.

Translation matters?
Before we look at all countries in one table, what about the Spanish translation? Did it have any effect?

To give an answer I turn to the "networks" data. As seen in the graph above no significant changes in the SocialAds data can be seen the last few weeks, so we will probably not see the potential effect here. Let's have a look at the top ten networks with regards to growth rate. (Note that I have not looked at all networks, but it is an indication.)

Hm, what's the language in the countries on the top half of the list?
It will be interesting to follow how this evolves. For Spanish, and for other translations as they are introduced. Stay tuned for next update.

The big picture
And for you who would like to see all countries. Here is a table to look into.


(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 Pakistan Dominican Republic Japan Sweden South Korea, Republic of Korea United Kingdom 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 )

More facebook statistics

Time for some more Facebook statistics. You might remember my other posts on the topic?

This time we will look at several aspects:

• Did the Facebook growth continue to decline as I noticed last time?
  In my last post with Facebook statistics I noticed that the growth had declined, and actually turned into a decrease. What happened since then?
  
• New countries added to the set of data - what does the penetration league look like?
  To the initial list of 31 countries an additional 16 is added. Who's in the lead for largest Facebook penetration right now?
  
• But is the data for the new 16 countries complete?
  Hey, there seems to be something odd with the data for new countries added. What? Can you spot it?
  

(Note: If you don't see any tables below it is probably because you are reading this post via a feed reader. For some reason not all my embedded stuff seems to get through. If so, visit TheKillerAttitude.com to see the tables.)

Did the decline contine?
Have a look at the table below:

This is the growth rate each week for 31 countries (growth of number of users as found in the Social Ad utility).

The countries are ranked according to the overall growth since 1st of November. At the top Turkey has increased the number of users with almost 600%. At the bottom of the list you find Canada with a 10% increase.

The quite red column for Nov. 22nd was when I blogged about this last time. You see that the growth came back the two following weeks.

Dec. 13th is an all-nil column. Apparently the data was not updated at all. This was also the day I noticed the 16 new countries added (see below).

The Dec. 20th column is a very moderate growth week. Why? And compare the discussion on the new countries further down!

What is the usage penetration per country?
That is outlined in the table below. Country population figures are from the CIA factbook.
Note that Canada (with the lowest growth above) comes out on top.

Now, in this table you also find the 16 new countries for which the data is available (as no historic data was around the growth rate could not be calculated). The new countries are marked with yellow in the table.

Among the top ten on the list the only rank change is that Singapore overtook US (!) in penetration. Sweden is still at #4.

Is the data for the new countries complete?
Hm, well. Let us take in consideration the number of Facebook users that have registered in a national network. Next calculate the ratio between the number of people registered in the national network and the number of users in the country.

Below is a table with this ration for all the 16 new countries and some of the other. The list is sorted in descending order of this ratio.

See something strange?
All the new countries come out on the top, all with a ratio higher than 1 (100%).
Meaning that there is more people registered in the national network than user from the country. And this for all of the new countries.

I can't resist to quote Shakespear: "Something is rotten in the state of Denmark" (Hamlet, Act 1, scene 4), as Denmark is among these new countries.

Surely this indicates that the number of users for these 16 new countries are lower than the actual figure. Expect these to grow as Facebook fixes the data. We'll keep an eye on this!

Can this also explain the somewhat low overall growth the last week?

(As the tables will not get indexed I add this: Facebook statistics 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 Pakistan Dominican Republic Japan Sweden South Korea, Republic of Korea United Kingdom 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)

Is Facebook growth declining?

I have been following the numbers available through Facebook's ad utility since it became available.

When I looked at the numbers last week (Thursday 22nd) I noticed that the number of users per country had decreased for most countries. Why?

The growth, sampled every week, is summarized in the table below (actual numbers available here).

Hm, why is this? Is the hype over? Or what does Facebook really measure?

Have people actually cancelled their Facebook accounts? Or does Facebook somehow measure active users (ie users who have logged in during the last x month). Has Facebook cleaned up the data, or is this a temporary glitch in the numbers?

It is also interesting to compare with Jeff Pulver's recent statistics, where he measures the growth the last month. The decrease is not visible here, as it occured the last week. Also, Jeff's numbers are from Sunday 25th, and seems to be slightly higher (number of users) for most countries.

No way to tell right now what the long term trend is, let's follow up over time. Also note that the numbers are only available for 31 countries, and the selection of these 31 is not clear.

Note that Alexa also shows a decrease in number of pageviews the last few days:

Over one million Facebook users in Sweden

After my post last week with some details of the Facebook statistics in Sweden I noticed today that Sweden now has over one million Facebook users. At least according to the same source I used last time.
And if you look at Alexa you see that Facebook is number two among the most visited sites in Sweden.

So, it is not a surprise that Expressen, a major newspaper targeting the broad population, offers "share on Facebook" as an option for each article on the web.

Update 071107: Also Aftonbladet, the other "major tabloid newspaper" in Sweden, has a "show on Facebook" option for the articles. Thanks Bengt for mentioning this in a comment. I actually looked at this at Aftonbladet when writing the post, but apparently missed it.

Facebook statistics in Sweden

Update 071101: I have made a few corrections and clarificatons of the post. I had put references to "November" in several places, where it should have been "October" (Guess I am ahead of my time?). Some other notes and corrections are also added, see more inline below.

As a follow up on my post around overall Facebook uptake I have done some digging around the Facebook penetration in Sweden.

I did one round of statistics collection end of last week, just when Jeff Pulver posted that Sweden was number four in overall Facebook penetration, and number two among all countries where English is not the primary language.

So, I can confirm the 9% penetration last week, and also state that today the penetration is 11% (close to 1 million users).

(Note: I use a slightly different figure for the Swedish population (9,169,673 compared with Jeff's 9,031,088. My figure is from a prognosis of the population by the end of 2007, which gave me the age and gender breakdown. The latest actual figure I found is from August 2007: 9,160,182. However these small variations does not affect the main findings.)

It is interesting to graph out the growth rate (I got the figure for Oct. 12th from this post):

Update: I initially stated that "The number of users have more than doubled in less than three weeks." Now I believe that the number for Oct. 12th is probably based on the number of people in the "Sweden network". This number for Oct. 31st is around 620k users. Still an impressing growth, but not "more than 100%".
I decided to keep the data point in the graph anyway.

Usage per age group

What is the demographics of the Swedish Facebook users? Let's map the penetration per age group:

As you can see the largest coverage is in the age span 20-24.

In the span 15-64 we see a 16% penetration, and between 15-39 we have 31% penetration. The usage is still very niche from my age and up...

I did the same breakdown for the data collected Oct. 25th - if we compare we see where the growth is last week:

Looks like a fairly even distributed growth per age group by visual inspection.

Usage per gender

Overall in Sweden we have more female users than male (396,700 vs. 320,820; or 9% vs. 7% penetration). However a large group of users (27%) have not defined their gender.

I have made a graph where I map gender distribution on the age groups:

You can note that the older you are, the less likely to state your gender you seem to be.

Final notes

There is probably some measurent errors in the numbers. However they should give a good indication of the current usage.

The metrics from Facebook is taken from the Facebook Flyers Pro utility. Nice of Facebook to reveal such statistics (and you can do other dataming as well)

It will be interesting to follow the evolution in Sweden.

(And once upon a time my dream was to work at Statistiska Centralbyrån :-)