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 …
We’ll show you the options for backing up your Google Analytics data, outline the challenges, and show you how easy it is using Analytics Canvas.
Export and save your Universal Analytics data to BigQuery or Sheets, and interact with the data in a Looker Studio report. From just $198 as a 1-time fee.
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 …
In Universal Analytics, reporting on the Users metric can be challenging. One of the most frequent questions we encounter with our Universal Analytics Backup Utility is: “Why doesn’t my Users metric align with the UA web reports?” This post aims to provide a clear understanding of the user metric in Universal Analytics.⚠️ Just like in GA4, the Users metric delivered …
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 …
As the transition to GA4 ramps up, many are wondering if they can blend UA data together with GA4 data, or if they can backfill GA4 BigQuery using the GA4 Data API. This article reviews the ways that you can blend Google Analytics data together and how to create both continuous and comparison reports between Google Analytics data sources. Table …
Starting on November 7th, 2022, Looker Studio users of the GA4 connector have been seeing various error messages. The errors include “Looker Studio cannot connect to your data set”, “Data Set Configuration Error”. Another is “Failed to fetch data from the underlying data set”. Read more about our GA4 BigQuery connector The reason is that Google has turned on quota …