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 …

Introducing Analytics Canvas Premium- get full API access to premium features including the upcoming Big Query

James StandenData warehousing, Google Analytics Premium, Google BigQuery

Enterprises that have serious analytics needs can invest in Google Analytics Premium for a true enterprise solution. Now, to ensure that they can take advantage of a wide range of new features Google has provided for GA Premium, Analytics Canvas announces Analytics Canvas Premium. This special edition of Analytics Canvas is specially created to deal with the serious data needs …

Analytics Canvas V1.6.4 released with Automation Wizard

James StandenAnalytics Canvas Tool, Automation, Data warehousing

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 …

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

James StandenAnalytics, Automation, Data warehousing

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 …