Statistics
State of Drupal presentation (August 2008)
Last week at DrupalCon Szeged I gave my traditional state of Drupal presentation. The video of the presentation is provided below, and you can download a copy of my slides (PDF, 11MB) as well.
The presentation discusses the results of the recent survey that I conducted; the survey ran for 30+ days and collected more than 1300 responses so it should provide a good idea of the community's current thinking. I'll provide more color and details about the survey results in a number of follow-up posts.
Google insights on Drupal
Recently, Google launched Google Insights. Like with Google Trends, you can just type in a search term to see search volume patterns over time, as well as the top related and rising searches. You’ll also have the ability to compare search volume trends across multiple search terms, categories (commonly referred to as verticals), geographic regions, or specific time ranges. Great for marketing people.
Below are some examples specific to Drupal ...
The numbers on the graph reflect how many searches have been done for a particular term, relative to the total number of searches done on Google over time. See Google Insights results for Drupal.
In China, Wordpress is winning hands down. See Google Insights results for Drupal.
In my home country, Belgium, Drupal is almost as strong as Wordpress but not nearly as strong as Joomla. See Google Insights results for Drupal.
Regional Drupal interest by country. Google uses the term 'search volume index' for these heatmaps, meaning that they normalized the data by the total traffic from each respective region. In other words, just because two regions show the same percentage for a particular term doesn't mean that their absolute search volumes are the same. See Google Insights results for Drupal.
In the US, the west coast beats the east coast. Based on 'search volume index'. See Google Insights results for Drupal.
Regional Drupal interest by city. Based on 'search volume index'. See Google Insights results for Drupal.
The top search on Drupal -- great for marketing people. Breakout means that the search term has experienced a change in growth greater than 5000%. See Google Insights results for Drupal.
Drupal download statistics
Each year around this time, I share the download statistics for Drupal core (see also: 2006 statistics and 2007 statistics). In other words, time for this year's update.
The last 12 months, from July 2007 to June 2008, Drupal core was downloaded more than 1.4 million times. The year before, from July 2006 to June 2007, Drupal core was downloaded 620,000 times. The number of downloads doubled in one year's time! And while Drupal 5 continues to be popular, the Drupal 6 core download is already a lot more popular.
These numbers do no include betas, release candidates or CVS checkouts. Also, we can't track downloads from mirrors, such as various Linux distributions, nor can we track installations through control panel software for hosting like cPanel or Plesk. Contributed themes or modules are not included in these numbers: we only looked at Drupal core.
Mollom volume segmentation
When people sign up to protect their website against spam with Mollom, they are asked to categorize each of their sites. So far, almost 2,000 Drupal sites have been categorized. The available categories are: a company website (22%), a site built for a customer (7%), a non-profit website (27%) or a personal website (44%).
Based on a sample of roughly 2,000 Drupal sites that use Mollom.
It is only one data point and a relatively small sample so I don't know if it is safe to generalize, but I figured it was an interesting nugget that could help us understand Drupal's install base.
Drupal.org country demographics
Where is the Drupal community from? Every registered user on http://drupal.org can optionally specify what country he or she is from. I've used that information to render the table below. How is your country doing?
| Current | One year ago | Two years ago | ||||
|---|---|---|---|---|---|---|
| Country | Rank | % | Rank | % | Rank | % |
| United States | 1 | 33.12 | 1 | 35.54 | 1 | 31.36 |
| India | 2 | 5.68 | 3 | 4.89 | 4 | 4.14 |
| United Kingdom | 3 | 5.14 | 2 | 5.8 | 2 | 5.07 |
| Canada | 5 | 4.23 | 4 | 4.79 | 3 | 4.26 |
| Germany | 6 | 3.03 | 5 | 2.78 | 6 | 2.32 |
| Australia | 7 | 2.22 | 7 | 2.47 | 7 | 2.14 |
| China | 8 | 1.95 | 6 | 2.59 | 5 | 2.36 |
| Spain | 9 | 1.91 | 8 | 2.16 | 8 | 1.91 |
| Netherlands | 10 | 1.84 | 10 | 1.91 | 10 | 1.66 |
| Italy | 11 | 1.83 | 9 | 1.95 | 9 | 1.71 |
| France | 12 | 1.79 | 12 | 1.53 | 12 | 1.31 |
| Russian Federation | 13 | 1.59 | 14 | 1.29 | 14 | 1.06 |
| Indonesia | 14 | 1.58 | 17 | 1.1 | 17 | 0.93 |
| Brazil | 15 | 1.58 | 11 | 1.69 | 11 | 1.49 |
| Belgium | 16 | 1.35 | 15 | 1.25 | 15 | 1.04 |
| Hungary | 17 | 1.03 | 18 | 0.92 | 19 | 0.78 |
| Philippines | 18 | 0.99 | 19 | 0.9 | 18 | 0.79 |
| Turkey | 19 | 0.97 | 16 | 1.12 | 16 | 0.99 |
| Poland | 20 | 0.91 | 22 | 0.74 | 23 | 0.63 |
| Sweden | 21 | 0.81 | 20 | 0.83 | 20 | 0.72 |
| Viet Nam | 22 | 0.77 | 27 | 0.62 | 26 | 0.54 |
| Thailand | 23 | 0.75 | 24 | 0.71 | 25 | 0.59 |
| Malaysia | 24 | 0.72 | 21 | 0.76 | 21 | 0.68 |
| Mexico | 25 | 0.69 | 23 | 0.71 | 24 | 0.6 |
| South Africa | 26 | 0.69 | 25 | 0.7 | 22 | 0.64 |
| Czech Republic | 27 | 0.65 | 29 | 0.59 | 28 | 0.52 |
| Argentina | 28 | 0.57 | 26 | 0.63 | 27 | 0.53 |
| Romania | 29 | 0.57 | 32 | 0.53 | 33 | 0.45 |
| Ukraine | 30 | 0.54 | 41 | 0.43 | 42 | 0.35 |
| Denmark | 31 | 0.52 | 33 | 0.52 | 32 | 0.46 |
| Portugal | 32 | 0.52 | 28 | 0.59 | 29 | 0.52 |
| Switzerland | 33 | 0.5 | 39 | 0.45 | 41 | 0.36 |
| Israel | 34 | 0.47 | 36 | 0.47 | 39 | 0.39 |
| Norway | 35 | 0.46 | 30 | 0.55 | 31 | 0.48 |
| Iran | 36 | 0.46 | 42 | 0.43 | 40 | 0.37 |
| New Zealand | 37 | 0.45 | 37 | 0.46 | 36 | 0.41 |
| Singapore | 38 | 0.44 | 31 | 0.54 | 30 | 0.49 |
| Pakistan | 39 | 0.44 | 44 | 0.4 | 45 | 0.33 |
| Austria | 40 | 0.43 | 43 | 0.41 | 43 | 0.34 |
Update: snufkin used this data to create some cool pie charts.
Drupal Association 2008 wishlist
Since we launched the Drupal Association in January 2007, roughly one year ago, we (i) improved the drupal.org infrastructure, (ii) we helped organize two international Drupal conferences, (iii) we established a relation with an accounting firm, (iv) we funded Drupal's presence at a number of events, (v) we started setting up fundraising campaigns, (vi) we entered into a relation with the Software Freedom Law Center, (vii) we are close to launching a Drupal Association membership model, etc.
In January 2008 we have to elect our second Board of Directors. We are looking for people that want to become either a Permanent Member or a member of the Board of Directors, and that can provide leadership and experience to expand the reach of the Drupal Association and its activities. If you are interested in helping to drive Drupal's explosive growth or if you want to help make a change in this world, you can submit your candidacy by following the instructions on drupal.org.
A few months ago, I asked more than 1,000 Drupal users what they think the Drupal Association should focus on. The results are provided below and might be a good source of inspiration when considering to submit your candidacy.
Drupal.org wishlist
I asked more than 1,000 existing Drupal users (not Drupal prospects) what they would like to see improved on drupal.org. A prioritized wish list is provided below.
We also created a drupal.org redesign group: if you are interested in collaborating on a drupal.org redesign or helping with the drupal.org infrastructure, you know where to start. We have work to do!