I’ve received some feedback indicating that the last solution posted here may not be a good fit, especially if the campaign_id is used. While it’s true, today I’m introducing a more robust solution to solve the ga_session_id challenge in one go, period. In brief, the solution involves manipulating the table to unnest the ga_sesison_id into the ... Read More

Are you tired of spending a fortune on querying session data in Google Analytics 4 (GA4) BigQuery (BQ)? Well, I’ve got great news for you! I’ve discovered a clever workaround that can reduce your GA4 BQ SQL cost by over 90% when counting sessions. Let me show you how. The Problem with Counting Sessions in GA4 Counting sessions in GA4 typically... Read More

Why GA4 is a better tool than Universal Analytics (part 2) Introduction In this article, we will continue exploring why GA4 is a better tool than Universal Analytics. While this may not directly impact your daily life as an analyst, it is still important to establish your viewpoint on the matter. Let’s dive into the reasons why GA4 outshines Un... Read More

Why GA4 is a better tool than Universal Analytics (part 1), and why people hate GA4 Introduction People tend to resist change and prefer sticking to their familiar workflows. When something new is introduced, they often criticize it instead of evaluating what went wrong. One example of this is the criticism Apple faced before the launch of the ... Read More

I am ashamed; as an analyst, a core part of my job is to write proficient SQL. In fact, if you were to pose that question to ChatGPT, it would confirm the same. What are some technical skill sets required for an analyst? chatGPT response: Database Management: Understanding of SQL (Structured Query Language) for querying and managing dat... Read More

In the world of the internet, we need to be quicker than ever before. We want to make timely posts on social media and our website. To do this, we require instant information that gives us insights. If you are frustrated with the limitation from GA4 real time report in the interface, you have come to the right place. At the moment, there are t... Read More

If you have encountered this wonderful help center article[UA→GA4] Possible reasons for conversion differences in GA4 vs. UA , chances are you still very confused. This is very understandable, the help center article aren’t for end user to interpret but more for partner like us to study the platform limit. How should I expect the discrepanc... Read More