The State of The Sponge

I notice that the blog just passed it's 80,000 page load since I started using Statcounter to monitor it, and that's just one day short of its first anniversary so it's time for stats.

Looking at the statistics for the last 1000 visits, one-third of them come from Google searches — most seem to be to do with materialized views, oddly enough.

186 www.google.com
77  tkyte.blogspot.com
23  www.google.co.uk
23  www.bloglines.com
20  oracledoug.blogspot.com
19  www.google.co.in
14  www.google.com.au
10  www.google.ca
9   www.google.fr
8   thinkoracle.blogspot.com
7   blogs.oracle.com
7   orawin.info
6   www.google.de
6   oradot.com
6   www.rittman.net
5   www.google.es
5   www.blogger.com
5   www.petefinnigan.com
4   my5.statcounter.com
4   www.google.be
4   www.google.it
4   search.blogger.com
4   www.newsgator.co.uk
4   www.netvibes.com
3   www.google.com.tr
3   www.google.fi
3   uk.my.yahoo.com
3   www.edpadgett.com
3   ora-dev.blogspot.com
3   search.msn.com
3   www.google.se
2   www.google.com.sg
2   www.google.co.il
2   www.oracle-base.com
2   www.google.ru
2   www.google.ro
2   www.google.ch
2   search.yahoo.com
2   pjs-random.blogspot.com
2   www.google.ie
2   bloglines.com
2   www.google.com.ph
2   www.google.nl
2   oracle-base.com
2   discuss.joelonsoftware.com
2   www.google.com.sg
1   blogsearch.google.com
1   www.dbasupport.com
1   my2.statcounter.com
1   oramossoracle.blogspot.com
1   www.nomad8.com
1   www.google.co.za
1   my.yahoo.com
1   www.google.com.tw
1   www.google.com.hk
1   www.google.pl
1   www.google.co.kr
1   tkyte-test.blogspot.com
1   www.google.is
1   www.google.cl
1   idyller.blogspot.com
1   www.google.com.ar
1   www.google.co.jp
1   peec2006.blogspot.com
1   www.google.com.br
1   www.google.gr
1   portal.umbrialistens.com
1   www.google.co.ve
1   kdsatplay.blogspot.com
1   www.google.dk
1   www.google.com.eg
1   oraqa.com
1   www.google.com.co
1   ambigramania.blogspot.com
1   www.google.pt
1   www.surfwax.com
1   www.google.com.mx
1   www.alltheweb.com

Fifty-two countries are represented, if we ignore the unknowns …

402 41.66%   United States
132 13.68%   United Kingdom
80   8.29%   Canada
60   6.22%   Lithuania
39   4.04%   Netherlands
37   3.83%   India
26   2.69%   Australia
20   2.07%   Germany
17   1.76%   France
15   1.55%   Switzerland
13   1.35%   Spain
11   1.14%   Unknown   -
9    0.93%   Russian Federation
8    0.83%   Belgium
7    0.73%   Turkey
7    0.73%   Japan
6    0.62%   Norway
6    0.62%   Denmark
5    0.52%   Portugal
4    0.41%   United Arab Emirates
4    0.41%   Italy
4    0.41%   Sweden
4    0.41%   Israel
3    0.31%   Colombia
3    0.31%   Greece
3    0.31%   Singapore
2    0.21%   Romania
2    0.21%   Philippines
2    0.21%   Poland
2    0.21%   Austria
2    0.21%   Ireland
2    0.21%   Serbia And Montenegro
2    0.21%   Finland
2    0.21%   Latvia
2    0.21%   Bolivia
2    0.21%   Uruguay
2    0.21%   Argentina
2    0.21%   South Africa
2    0.21%   Puerto Rico
1    0.10%   Pakistan
1    0.10%   Bulgaria
1    0.10%   Estonia
1    0.10%   Kenya
1    0.10%   Chile
1    0.10%   Andorra
1    0.10%   Ukraine
1    0.10%   Iceland
1    0.10%   New Zealand
1    0.10%   Egypt
1    0.10%   Brazil
1    0.10%   Slovenia
1    0.10%   Korea, Republic Of
1    0.10%   Hong Kong

Good to see the Netherlands up there this time! Readership seems to be up to 13 Dutch people, unless some of them are cheating and using multiple computers.

The most frequently occuring city for Sponge readers is London, UK, then Calgary, Ontario, Arlington, Nieuwegein …

The most popular article is "Writing Good SQL". It's a perennial favourite with the Google crowd.

That's all — back to work people!

Advertisements

8 thoughts on “The State of The Sponge

  1. Not “Calgary, Ontario” in the “London, UK” sense, but in the “two-different-places-separated-by-a-comma” “Arlington, Nieuwegein” sense.

    Actually I just didn’t want anyone to get confused between the real London and the numerous American copies (Ohio etc), so the UK was my own addition. Confusing, perhaps.

  2. The most frequently occuring city for Sponge readers is London, UK, then Calgary, Ontario

    ;o)

  3. Hey, I don’t decide what geo-political entity gets classified as a city by Statcounter … i suspect that they use some internet authority as a lookup source but I can’t be bothered to research it.

  4. Pingback: Pete-s random notes » Blog Archive » More on keywords

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s