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

Getting your Google Analytics data and databases together

James Standen Analytics Canvas Tool, analytics database, Google Analytics Data Leave a Comment

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 …