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.Connecting to your data …

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.New in Analytics Canvas Version 3.1Google Analytics Reporting API v4Automatically detect and eliminate samplingAutomatically detect and eliminate Report Query LimitingAbility to use Resource Quota for Analytics 360 accounts (get up to 100M sessions unsampled)ODBC …

Analytics Canvas V3.0 Released

Ameet Wadhwani Analytics Canvas Tool, Cloud

We are pleased to announce the release of Analytics Canvas V3.0, featuring Analytics Canvas Cloud Automation! New In Analytics Canvas 3.0Analytics Canvas Cloud AutomationCloud File Connectors (Dropbox, Amazon S3, Google Drive, Google Cloud Storage)Google Data Studio Community ConnectorGoogle Search ConsoleBigQuery to TDE Export (for large TDEs)Google Analytics Core Reporting API v4 connector now in betaJSON ExportTableau Hyper ExportEasy Incremental LoadAutomation …

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 …