Analytics Canvas Online revealed at SheetsCon 2020

Ameet Wadhwani Analytics Canvas Online

Imagine Google Sheets without cell limits and BigQuery without SQLAs a data-prep tool with lots of connections into the Google ecosystem, we have quite a lot of customers using Google Sheets together with Google BigQuery, Google Data Studio and a number of other data sources. So we were delighted when we heard that Ben L Collins, a Google Developer Expert …

Connecting Google Data Studio to a Database? Avoid These 3 Serious Challenges

James Standen Analytics, Google Data Studio

Data Studio makes great looking reports and dashboards, and at a price point of free for everyone, Google is obviously making it easy to afford.  But many organisations find a number of key challenges and “connection does not exist” errors when connecting Google Data Studio to a database. Also, if you’re interested, you can read more about all the ways you …

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 …

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 …

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 …

Connect to data in Amazon Redshift with Analytics Canvas

Olga Tsubiks Amazon 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 Tsubiks Analytics

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 …