Subscribe to our newsletter

Get the State of Digital Newsletter
Join an elite group of marketers receiving the best content in their mailbox
* = required field
Daily Updates

Neil Walker’s Data Download July 2013

11 July 2013 BY

19 Flares Twitter 18 Facebook 0 Google+ 1 LinkedIn 0 Buffer 0 Email -- StumbleUpon 0 Pin It Share 0 19 Flares ×

If you are new to State of Search or this is the first time you have read one of my blog posts there is one thing I try and do once in a while, thats a data download.  In 2012 I spoke at SMX West with a presentation based on pulling Click Through rate data from over 100 independent Google Webmaster tools accounts and this time last year I wrote a post about the Mobile Revolution 2012 here on State of Search that used over 100 independent Google Analytics accounts. Well its about time to update the Google Analytics statistics with a focus on Mobile and Tablet usage for 2013

Tools you might Need

If your good with Google Docs or handling APIs then you can cut out the tools and go and have a look at:

There are other options.

Zag when everyone Zig's

There are a number of tools that are custom built for handling large data, in particular when it comes to Google Analytics; two of my choices are:

So what’s the point; well in this scenario I’ve used Next Analytics and quickly taken 16 independent Google Analytics Profiles and within minutes exported over 120,000 rows of data (This is a small data set, for bigger data-sets I would personally recommend Analytics Canvas.)

Now its time for Some Big Data Fun.

Big Data Fun

A Simple Answer to Enhanced Campaigns

Towards the end of this month Google is automatically upgrading all Adwords Accounts to Enhanced Campaigns. One of the main parts of enhanced campaign is that advertisers no longer have the choice of whether or not display ads to mobile device and tablets. Much as this has annoyed many an advertiser and the general consensus is that is has driven CPC’s up – See Adobe’s full report from June 2013.

So how is Mobile and Tablet Traffic increasing? A look across the data can give a glimpse into why they made such a choice.

Mobile Usage 2013

You can see the clear rise in Mobile devices from around 4% in January 2010 to actually superseding desktop briefly in May 2013 at 55%.

Key Events:

  • Iphone was first released in June 2007
  • The first commercial Android Phone was released in 2008
  • Ipad (Tablet) was first released in April 2010
  • Google’s Nexus 7 Tablet was released in 2012

So the Big data I have is a faction of what Google or the other big players are collecting just read Bas’s post “Yes your being spied on” but it does give us a guide on where things are headed.

Where do tablets fit in?

The graph below shows tablets and mobile devices separated as a percentage of visitors across the last 18 months.

  • We can see a steady increase, separating the devices does show desktop is still currently dominant.

Tablet Usage 2013

What is the Most Popular Device?

The table below shows the percentage of visitors by device over the past six months, there is only really four two players.

Mobile Device %
iOS 58.7%
Android 35.8%
BlackBerry 3.0%
Windows Phone 2.0%

The key to notice is the increase in Android usage, its predicted to be bigger than iOS, the graph below shows how it is changing. We see fluctuations in its usage but overall a steady increase.

Android Percentage

The same can not be said for Tablet devices as iOS is still the far out leader.

Tablet Device %
iOS 91.2%
Android 8.3%
BlackBerry 0.3%
Linux 0.1%

Usage by Location

It is important to note that the websites in my data set are UK based however the chart below shows the mobile usage of international visitors from the past 6 months.

  • South Korea shows a clear dominance of Mobile.

International Mobile Usage

That it for now, go and download some of your own data and let me now what it shows.


Neil started his own consultancy in 2009 of Quaero Media (formerly SEO Mad Ltd) where he works consulting with other Digital Agencies to affiliates or in-house teams. Neil original entered the world of Search in 2002 as the technical mind behind a start up by the name of Just Search.
19 Flares Twitter 18 Facebook 0 Google+ 1 LinkedIn 0 Buffer 0 Email -- StumbleUpon 0 Pin It Share 0 19 Flares ×

Nice job, you found it!

Now, go try out the 12th one:

Use Google Translate to bypass a paywall...

Ran into a page you can't read because it is blocked or paywalled? Here's a quick trick (doesn't always work, but often does!):

Type the page into Google translate (replace the example with the page you want):

How about that!?

Like this 12th trick? Tell others they need to look for this trick on our page:

Or Tweet: Found the secret 12th one!