Building GA4 Ecommerce Segments in BigQuery

Manisha MistryAnalytics, ecommerce, GA4, Google Analytics Data, Google BigQuery

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 …

The Trouble with Users in Universal Analytics

Ameet WadhwaniGoogle Analytics Data, Universal Analytics

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 …

Answer These 4 Questions To Help Uncover Your Conversion Funnels

Olga TsubiksAnalytics, Google Analytics API, Google Analytics Data

What is it that turns website visitors into paying customers? What is the process they go through to become subscribers or customers? These two questions are of paramount importance for e-commerce companies, but what if your website does not have a shopping cart? How do you analyze conversion funnels for non e-commerce websites? Chances are, you’ve found the answers to …

Google Analytics isMobile and isTablet have left the building

James StandenGoogle Analytics API, Google Analytics Data

Google has announced a very important change is coming to your Google Analytics data- if you track device types using isMobile and isTablet dimensions they have been eliminated. But don’t worry, you’ll still be able to understand what devices are being used by using the new deviceCategory dimension, and you have at least 6 months as per the Google Analytics …

Google Analytics Premium- Showing the value of data

James StandenGoogle Analytics API, Google Analytics Data, Google Analytics Premium

The interwebs are a-buzz today with the announcement by Google that there is now a Premium, paid version of their web analytics product. Google Analytics premium offers a number of key advantages. The service guarantees in the form of SLAs, the more formalised arrangements with certified partners for support, attribution analytics, but perhaps most importantly, more data and less sampling. …

Is it your traffic changing- or how Google Analytics Tracks it?

James StandenAnalytics, Google Analytics API, Google Analytics Data

Google Analytics is a fantastic web analytics tool- and it is improving constantly. One result of improvements and evolution, however, is that how data is collected and stored changes, and can change your metrics. Usually these step changes are subtle- in certain cases, depending on your traffic and situation they could be earth shifting. While these changes can sometimes be …

How To Aggregate Traffic Sources in Google Analytics

James StandenAnalytics Canvas Tool, Google Analytics Data

If you have to do reporting of your website traffic sources, you’ll notice that the raw data from Google Analytics is often somewhat, well, raw. For example, you might want to report how many visitors came to your website via Twitter- but google analytics will have multiple sources for this- “twitter.com”, “mobile.twitter.com”, as well as other clients- “twittergadget.com” or “hootsuite.com”. …