Why ETL software is the BEST way to pull Google Analytics data

Ameet Wadhwani Analytics Canvas Tool, Google Analytics API

There are lots of good reasons to pull Google Analytics data into spreadsheets or databases for reporting and analysis.  You can get rich details not available in the web interface, you can blend it with internal data sources, you can extract large volumes of unsampled data in bulk, and so much more. For these reasons, Google Analytics APIs have been …

6 Ways to get data from SQL Server into Google Data Studio

Ameet Wadhwani Google Data Studio Leave a Comment

In late September 2018, Google announced that Data Studio had moved out of beta and into to general availability.  Millions of people have used Data Studio since the beta launch in 2016, and there’s an even bigger group of people who would use Data Studio, if only they could connect to their SQL Server databases with it. Data that exists …

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 …