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 V4.5.0 Change LogThis update is for Analytics Canvas Online and Desktop Online: UA Backup feature available for private beta testers. Online and Desktop:GA4 API- new dimensions added: continent, continent ID, Day of week name, ISO week of year, ISO year, ISO week of ISO year, item list position, item location ID, item promotion creation slot, landing page + …

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 …

Google Analytics Calculated Metrics: Why limit yourself to 5 metrics per view when you can get as many as you want?

Olga TsubiksAnalytics, GA Metrics and Dimensions

Currently in beta and available only for properties using Universal Analytics, Calculated Metrics are user-defined metrics that are calculated from existing Google Analytics metrics, such as sessions or hits. If you are using Universal Analytics, you can set up Calculated Metrics by going to Admin > View > Calculated Metric. You will then be asked to define the formula, provide …