Table of Contents The Problem with Manual SQL Analytics data rarely comes in the format you need. Specifically, GA4 exports combine values that you need separated (like sessionSourceMedium), use date formats that don’t match your reports, or include data ranges you don’t want. That’s where an AI SQL generator can help you quickly transform exported data for your analysis. Common …
Introduction The primary goal of Consent Mode V2 in GA4 is to help website owners comply effectively with data privacy laws, such as the European Union’s General Data Protection Regulation (GDPR) and California’s Consumer Privacy Act (CCPA). It works by allowing users the choice over whether their sessions can track certain personally identifiable information. So how does this affect reporting? …
Introduction One powerful feature in Google Analytics 4 (GA4) is the Funnel Exploration tool. This tool allows you to analyze user behavior by creating segments based on specific actions. In a Funnel Exploration, a segment in GA4 is a defined series of steps that users take within a session. These steps can lead toward a conversion or key event. This …
When looking at historic Google Analytics data, both Universal Analytics and GA4, people are often surprised to find that certain datasets don’t contain the full history of data. This is because of the Data Retention settings on the Property or View, and will depend on where the user is accessing the data as well as the query for the data …
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 …
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 …
Analytics Canvas V5.5.0 Change Log This 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 Log This update is for Analytics Canvas Online Online: UA Backup eliminate 2025 data …
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 …
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 …
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 …
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 Redshift Amazon 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 …
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, …