Google Analytics Data Retention explained for UA and GA4

Ameet WadhwaniAnalytics

Over the past year we’ve been offering our UA backup utility, a number of people have been surprised to find that certain datasets don’t contain the full history of data.  On the GA4 side, I routinely get inquiries from people wanting to backup their GA4 data before it expires.   This post will explain the implications of Google Analytics Data …

The trouble with Users in GA4

Ameet WadhwaniAnalytics

Marketers have long used Google Analytics as a cornerstone tool. With the introduction of Google Analytics 4 (GA4), there’s been a significant shift in how data is collected, processed, and presented. One of the most frequent questions we encounter with our software product, Analytics Canvas, especially from marketing agencies and developers, is: “Why can’t we summarize on the Users metric …

Moving to GA4 together with Analytics Canvas

Ameet WadhwaniAnalytics

Analytics Canvas has been the most powerful connector for Google Analytics for over a decade. Having worked with the Google Analytics API team since 2010 as Trusted Testers, developing extensively on GA APIs including the new Google Analytics Data API for GA4 and the GA4 BigQuery event export, we have yet to come across a connector as comprehensive and capable …

Product release log

Ameet WadhwaniAnalytics

Analytics Canvas V5.5.0 Change LogThis update is for Analytics Canvas Online Online: GA4 API campaignName date issue resolved for all accounts  Online: GA4 API Sampling handling and indication available in UA and in data UA Backup Utility: optimizations and performance enhancements Analytics Canvas V5.3.0 Change LogThis update is for Analytics Canvas Online Online: UA Backup eliminate 2025 data glitch in …

GA4 Bug with Unassigned Users

James StandenAnalytics, GA4

UPDATE:  This issue has been resolved by Google.  For more GA4 content, check out our blog. If you are seeing very large user counts on the session default channel report in GA4 in the last few days, you are not alone.  And it’s not only in the last few days that this has been an issue; it’s a problem that has …

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

James StandenAnalytics, 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 …

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 …

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

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 …

TWB vs TWBX in Tableau

Olga TsubiksAnalytics, Analytics Canvas Tool, Tableau

Tableau Workbook File (TWB) is an XML document. It contains the information about your sheets, dashboards and stories. The TWB file references a data source file such as Excel or TDE, and when you save the TWB file, it is linked to the source. The most important thing to remember about TWB files is that they don’t contain any data …

Understanding Google Analytics Conversion Funnels with Analytics Canvas

Olga TsubiksAnalytics, Analytics Canvas Tool, ecommerce

The beauty of analyzing conversion funnels in Analytics Canvas is that you don’t have to wait for the data to be collected after you’ve set up your goals. You can create any funnel you want. Start by identifying your biggest funnel. Look at how the majority of visitors end up on your site: where they came from, and where they …