Released! Analytics Canvas 1.0: Data KUNG FU for Google Analytics

James Standen Analytics Canvas Tool Leave a Comment

We’re very pleased to announce that Analytics Canvas V1.0 is now available! To Our Beta Testers: A big Thank You to you all for helping us get here! We’re grateful for all your feedback. Analytics Canvas is available in a number of different plans: We believe you’ll find one that gives you the extra Google Analytics data crunching power you …

ETL vs Making a bunch of really hacked together crazy spreadsheets

James Standen Analytics Canvas Tool, Automation Leave a Comment

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 Leave a Comment

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. …