Analytics Canvas Tool — Analytics Canvas

By: Analytics Canvas  09-12-2011
Keywords: Web Traffic

Google Analytics data is incredibly valuable stuff.

But there is a way to make it radically more useful. Combine it with other data, from outside Google Analytics.

If you are not doing this now, then using data that is external to Google analytics will bring your “Analytics Game” to the next level. If you are doing it, push it further.

Example 1: Understanding web traffic in terms of Product attributes

Say you have different areas of your website that relate to different products. Those products have attributes that are stored in your marketing systems. If you can link pages to products, and products to attributes, you can now understand trends in online traffic and behavior in terms of higher level marketing concepts- which lets your analysts quickly explore new possibilities and hypothesis.

You do this by maintaining a page to product cross reference table in an external database or spreadsheet.

In a more sophisticated scenario, you can cross reference each page to a given member of a product hierarchy, so that pages that are overviews, or dealing with an entire product group, are accurately mapped.

Example 2: Enriching analysis by building dimensions on geography

Another example is the geography dimension. While location information by its nature is not pinpoint accurate in Google analytics, it often can be very useful- but particularly if it is connected to other data sets.

A brick and mortar retailer might, for example, want to analyze web traffic behavour based on the likely rough distance from a store, or based on the concentration of stores in a given region. Again, a reference table is built, perhaps with store density by state in the US, for example. It is now possible to see how website visitors behave based not on location, but on retail store density.

How to do it

While you can store a small amount of data in Google analytics itself, to do any serious analysis, you need to get the data out, and into another system.

Spreadsheets, spreadsheets, spreadsheets!

In some cases, a simple export from Google analytics into excel might work. Once in excel you might need to either do some manual cut and paste, or delve into some VLOOKUP action. Anyone who has tried to do anything sophisticated knows the pitfalls- and when you want to update the data, you have to mess with it all again.

There is also an issue with data volumes with this approach- while some addins will let you pull up to 10,000 rows, very large spreadsheets can get cumbersome.

Databases, databases databases!

A more powerful possibility is to load your Google analytics data into a database, either by exporting and then loading, or by developing using the Google GData API.

Usually, this means you’ve got some pretty serious database and programming skills, or you’ve got the cash to hire someone who does.

A new, faster, cheaper, easier way.

By enabling easy querying of data from Google analytics using the API as well as files, spreadsheets and databases, and then providing a visual data transformation environment to combine it, Analytics canvas is going to change the way people get at Google analytics data.

Lots of Analytics data.

It will be available in a range of editions, with different capabilities, making it affordable no matter what the complexity of your needs. The higher end editions will be capable of pulling hundreds of thousands of rows of data from multiple accounts and profiles, as well as data from multiple databases and files.

Keywords: Web Traffic

Other products and services from Analytics Canvas


Google Analytics Premium — Analytics Canvas

The service guarantees in the form of SLAs, the more formalised arrangements with certified partners for support, attribution analytics, but perhaps most importantly, more data and less sampling. Google Analytics, for a very long time, as been a remarkably powerful tool, particularly for its price. Google Analytics premium offers a number of key advantages.


Automation — Analytics Canvas

ETL is a key process in the business intelligence and data warehousing arena- it’s all about automating data movement and building repeatable, robust processes that take raw data, clean it, fix it, enrich it, and then load it into a location where it can be easily queried and analyzed.


Keyword Analysis — Analytics Canvas

Because you can pull huge amounts of data from Google Analytics easily, you can include ALL your keywords, and calculate segmentation across the enter data set, with a day by day breakdown, if you like. There are lots of keyword tools available to help you pick which keywords to target, and who is searching for what, but what is actually happening on your site- which keywords are converting.


Google Analytics API — Analytics Canvas

If you have significant search from, and if that traffic is different than your existing search traffic, all your metrics could have a step change for the search category. The next time you see a step change in your data, it doesn’t hurt to consider the possibility that your traffic hasn’t changed, but the way that Google Analytics is reporting it has.


Analytics Canvas Tool — Analytics Canvas - analytics canvas tool

In Analytics Canvas you go to the “Add data” toolbar menu, then select Google Analytics, and pick which of the profiles you want to do the analysis on. For some reason, when google sends image search visits, they get marked as referrals, not organic- and the referral path is set to “/imgres”. What we want to do is organize this data into more meaninful groups by defining the rules for that segmentation block.