ETL vs Making a bunch of really hacked together crazy spreadsheets

James Standen Analytics Canvas Tool, Automation 0 Comments

ETL stands for “Extract, Transform and Load”. 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. The opposite of ETL …

Google Analytics sampling data

James Standen Analytics Canvas Tool, Avoiding sampling, Google Analytics API 0 Comments

Google Analytics is being used by some very large websites. The result is that there is a lot of data, and one of the realities of tracking a high traffic website with Google Analytics is that often data will be returned as a statistical sample, rather than exact metrics. Ask for too much data and you will get an estimate. …

Getting your Google Analytics data and databases together

James Standen Analytics Canvas Tool, analytics database, Google Analytics Data 0 Comments

While Google analytics is a great way to collect data about web traffic, there is lots of data in other places that you probably need to be looking at too. Where is it? It’s in databases and files. in that SQL Server database that marketing uses to track all its promotions in that MS Access database over in sales where …

Google Instant Previews in your data

James Standen Google Analytics Data 2 Comments

Are you suddenly getting lots of traffic from Google Inc. to your site? What you might not know, is it might be affecting your pageviews and your bounce rate in Google analytics. Google Analytics seems to be recording previews (in some cases at least, not yet clear exactly how) as page views. Take a look at your Google Analytics data. …

Analytics Canvas enters private Beta!

James Standen Analytics Canvas Tool 0 Comments

Huzzzah! We are declaring the Alpha over, and starting the private Beta for the Analytics canvas tool. We’ll start contacting the first private Beta testers who have signed up over the coming week, and we’ll get them up and running with the Beta1. We just don’t have the bandwidth to have everyone who has signed up test at first, so …