Version 3 Private Beta Expanded

Ameet Wadhwani Analytics, Analytics Canvas Tool, Automation, Google Data Studio

Progress! Round one of the latest Analytics Canvas beta came to a close last week. Testers kicked around the new Data Studio connector and helped us to get it into really good shape. Round 2 is MUCH bigger, featuring: ✓ Analytics Canvas Cloud Automation ✓ Google Search Console ✓ Google Data Studio ✓ Cloud File I/O Analytics Canvas Cloud Automation …

7 Reasons to Start Report Automation

Olga Tsubiks Analytics Canvas Tool, Automation 1 Comment

Do you often find yourself spending hours manually extracting data cutting and pasting to create reports, and then have to repeat the whole thing, time and time again? Consolidating data across sources, crunching numbers and creating reports can be a tedious process. Nobody likes doing the same things over and over. How much better it would be if you could simply automate …

Google Analytics unsampled reporting Automation

James Standen Analytics, Automation, Avoiding sampling, Google Analytics Premium, unsampled reports Leave a Comment

If you are a Google Analytics Premium user and hate all the clicking and downloading involved with unsampled reporting, you’ll be happy to hear that Analytics Canvas fully supports the complete automation of unsampled reports thanks to functionality newly released by Google. As a Google Analytics technology partner and part of the trusted testers program, we’ve been working with a …

Analytics Canvas V1.6.4 released with Automation Wizard

James Standen Analytics Canvas Tool, Automation, Data warehousing Leave a Comment

Are you spending huge amounts of time just getting the data ready, rather than actually doing analysis? You can eliminate mindless work by automating your data extraction using Analytics Canvas Automation Wizard. Imagine coming in on Monday morning and being able to get right into analysis- rather than first having to spend hours or days exporting, cleaning and combining data …

Automating Google Analytics Cost Upload for Maximum Campaign ROI

James Standen Ad spend ROI, Automation Leave a Comment

Last week we released the latest version of Analytics Canvas which allows for the automation of uploading cost data into Google Analytics, even for the most sophisticated digital campaigns. Visits, clicks and pageviews don’t really matter – what matters is, for a given channel, is the value being created greater than the spend? Google Analytics lets you track this if …

Automating exports from Google Analytics for scheduled reporting

James Standen Analytics Canvas Tool, Automation 9 Comments

While usually the most important and valuable analysis is ad-hoc, and done by an analyst, very often there is the need for scheduled exports and reporting of Google Analytics data. Google Analytics provides some automation capabilities for custom reports, for a limited number of dimensions and metrics, but of course the results are subject to sampling (fast access mode). The …

4 reasons people think analytics data warehouses are super expensive and why they are not

James Standen Analytics, Automation, Data warehousing Leave a Comment

1) Reporting bias Maybe the main reason everyone thinks Data warehouses are expensive is because they’ve heard about a really expensive one. While one would think that you’d hear all about the really successful data warehouse projects, the reality often is that really spectacular failures catch our attention more and therefore get more widely reported/discussed 2) The need to buy …

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 …