Avoid this costly mistake when connecting GA4 BigQuery to Looker Studio

James Standen GA4, Google BigQuery, Google Data Studio, Looker Studio

Having made the BigQuery export available to all GA4 users, a lot of people will be using BigQuery for the first time. Many of them will be connecting GA4 BigQuery to Looker Studio without knowing the risks and without first optimizing their workflows.  If you have a large number of daily events in Google Analytics 4 [GA4] and a handful …

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 …

Content Analysis on high traffic websites using BigQuery

James Standen Analytics, Analytics Canvas pro tips, Google BigQuery Leave a Comment

Using Analytics Canvas and Google BigQuery, it is possible to do detailed content analysis for sites with 10s of millions of annual visitors, even with Google Analytics Standard. In this blog post we outline how to avoid sampling and load detailed content analysis data into BigQuery. Analytics Canvas provides the solution. Google Analytics Premium obviously gives you many more options …

BigQuery SQL Generation demo at GA Summit

James Standen Analytics, Google Analytics Premium, Google BigQuery Leave a Comment

A few weeks ago, hundreds of die hard Google Analytics types converged on San Francisco from all over the world for the Google Analytics Summit. The attendees included Google Analytics Certified Partners, Google Analytics Premium customers, and a small group of Technology partners (including Analytics Canvas). We were invited by Google to present our latest developments to the attendees, and …

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

James Standen Data warehousing, Google Analytics Premium, Google BigQuery Leave a Comment

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 …

Google Analytics and Google BigQuery- Oh My!

James Standen Analytics Canvas Tool, Google Analytics Premium, Google BigQuery Leave a Comment

Googles announcement at Google IO that session and hit data was going to be available in Google BigQuery marks a significant milestone in Google Analytics relentless drive into the Enterprise analytics market. UPDATE: Check out how Analytics Canvas is the tool for BigQuery GA Premium integration with SQL Generation. Google mentions a number of scenarios that become possible with this …