Digital Analytics Expert
HTML, CSS & JS Lover
Apps Script Developer
Problem-Solving Oriented
Running inefficient queries in BigQuery can lead to high costs and slow performance. Here’s how you can optimize your queries and reduce costs by 40-50% while speeding up execution.
Continue reading...Google Analytics 4
Not all NULLs are the same NULLs
When working with BigQuery, especially with data from GA4, it’s crucial to understand a subtle but important concept: NULLs are not generic, they are tied to specific data types.
Continue reading...
Case Study: Analyzing GA4 Session Durations in BigQuery with RANGE_BUCKET
Introduction Understanding how users engage with your website or app is critical for improving their experience. Session durations are an excellent metric for assessing engagement. In this case...
Continue reading...
Which AI Search Engines your Target audience prefers?
Applying this setting in GA4 to a high-traffic website resulted in the report you see in the screenshot, but the value of traffic from AI was 0.00001% of the total traffic.
Continue reading...
GA4 documentation has been updated but Google forgot to update GA4
I retrieved earlier versions of GA4’s channel rule documentation from webarchive and in 2024 the channel rule for Organic Search changed twice.
Continue reading...
BUG in GA4 Organic Search Channel
I carried out some tests and discovered that not only “google / (not set)” is associated with the Organic Search channel…
Continue reading...
[GA4] Combining infinite Reports in Google Sheets
We will make sure that the tool automatically creates a report with a specific name every day and collects the results of all generated reports in one sheet.
Continue reading...
[GA4/GAds] How to identify if you are impacted by incorrect campaign data in reports (and fix it)
The problem is basically related to the campaign name in the Acquisition report. If you also have this problem you will see campaign names like (organic) or (not set) for Google Ads traffic
Continue reading...
[GA4 Bug] Sessions started without events are not Entrances!
This is a side effect of sessions that only have session_start as an event, and is added to the cases that increase the values of (not set).
Continue reading...
[GA4 Bug] Midnight Sessions are worth Double
Since a Landing Page may or may not contain this string, we would expect a total consistent with that shown earlier. Actually, the result is completely different!
Continue reading...
Commenti recenti