Blending data between UA, GA4 API, and GA4 BigQuery

Ameet WadhwaniGA4

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 …

Why Looker Studio cannot connect to your GA4 data set

James StandenGA4, Google Data Studio, Looker Studio

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 …

Avoid this costly mistake when connecting GA4 BigQuery to Looker Studio

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

3+ reasons your GA4 data doesn’t match

James StandenGA4

When comparing data from the 4 different GA4 data sources, you may find that your GA4 data doesn’t match. There are a number of possible reasons depending on what queries and reporting tools you are using, but some of those reasons are built into GA4. Two are related to how GA4 defines and calculates sessions, and one is a common …

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 …