ETL Your AdWords Data to a Data Warehouse

Jason Thibault Data warehousing Leave a Comment

Advertising on the Google Search and Display Networks via Google Ads has become incredibly data-driven. Data-driven marketing is built on insights pulled from the analysis of data, collected through site visitor actions and engagements. Today we’re going to discuss how you can extract your Google Ads data using the AdWords API and get it loaded into a data warehouse. This …

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 …

Analytics Canvas Version 3.1 Released

Ameet Wadhwani Analytics Canvas Tool, Avoiding sampling, Google Analytics API, Google Data Studio Leave a Comment

We are pleased to announce the release of Analytics Canvas Version 3.1, featuring the Google Analytics Reporting API v4 and enhancements to our Data Studio community connector. Canvas is well known amongst Google Analytics professionals for how robust our GA connector is. With the Reporting API V4 we’ve taken things to a whole new level! Nobody likes a sampled dataset. …