ETL Your AdWords Data to a Data Warehouse

Jason ThibaultData warehousing

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 …

Version 3 Private Beta Expanded

Ameet WadhwaniAnalytics, 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 …

Connect to data in Amazon Redshift with Analytics Canvas

Olga TsubiksAmazon Redshift, Google BigQuery, Tableau

Since many Analytics Canvas users connect to data in Amazon Redshift, we decided to let you know how you can best make sense of your data in Amazon Redshift using Analytics Canvas. Recently we announced a new connector to Amazon Redshift to support users that adopted this cloud analytics solution. Amazon Redshift provides a massively scalable, cloud-based data warehouse, with …

Unload Data from Amazon Redshift

Olga TsubiksAnalytics

In Amazon-speak, you don’t export data, you unload it, and today we are excited to announce that you can now unload data from Amazon Redshift directly to Analytics Canvas! Unload data from Amazon RedshiftAmazon Redshift is a fast, fully managed data warehouse that makes it cost-effective to analyze data using SQL. It allows you to run queries against petabytes of …

How to report on multiple Google Analytics accounts and currencies

Olga TsubiksAnalytics

Dealing with multiple Google Analytics accounts and currencies is something international ecommerce companies have to deal with on a daily basis. With some organizations tied to an official currency exchange rate constantly varying and different than those set in Google Analytics 360, working with multiple Google Analytics accounts, currencies, and maintaining dashboards, can be a challenge. One of our customers, …

Converting your time zone to local time in Google Analytics

Olga TsubiksGoogle Analytics Data

Visitors come to a website at different times of day. The heat map below represents a typical profile of a B2B company in North America. Users mostly come to the website during the week, whilst weekends have low traffic. The busiest time of the day is the morning, between 9:00 AM and 12:00 midday. This makes sense, as businesses engage …

Detecting and avoiding sampling in Google Analytics just got easier

James StandenAnalytics Canvas Tool, Avoiding sampling

Sampling in Google Analytics helps speed up the response from GA, but it can serious affect the accuracy of the data you are looking at. Fortunately, Google Analytics has a great API, and with Analytics Canvas you can use a visual interface to get at your data, know when sampling is happening, and in many cases eliminate it. In our …

How to create an In-Page Analytics Report using Google Analytics API and Tableau

Olga TsubiksAnalytics, Google Analytics API, Tableau

The In-Page Analytics Report provides a valuable visual representation of the performance of a particular web page. It is very handy for making a quick visual assessment of how users are interacting with the page. And it is a crucial report for web page optimization and testing. Do you want to include In-Page Analytics into your Tableau reports? We are …