If you’ve ever wondered how to distinguish new users from returning users in your GA4 data within BigQuery, you’re not alone. By default, GA4 exports to BigQuery don’t provide this classification directly, but with a simple timestamp comparison, you can …
BigQuery GA4 Tutorial: Distinguish New and Returning Users Easily Read more »
If you’ve been diving into Google Analytics 4 (GA4) data and want to uncover which pages on your website drive the most views, conversions, or other key actions, querying GA4 data in BigQuery is a powerful approach. In this tutorial, …
How to Query GA4 Top Pages in BigQuery by Event: A Step-by-Step Tutorial Read more »
If you’ve connected your Google Analytics 4 (GA4) property to BigQuery, you’ve already unlocked a powerful way to analyze your website’s event data. But what’s next? How do you start exploring your raw GA4 data in BigQuery to get meaningful …
How to Get GA4 Event Count in BigQuery: A Simple Step-by-Step Tutorial Read more »
If you’ve been diving into your Google Analytics 4 (GA4) data in BigQuery, you might have noticed that key metrics like purchase revenue seem elusive — hidden away inside nested event parameters. Don’t worry, you’re not alone! This guide will …
How to Extract GA4 Event Parameters in BigQuery: A Step-by-Step Guide Read more »
If you’ve been working with Google Analytics 4 (GA4) data exported to BigQuery, you might have noticed that GA4 doesn’t provide a direct session count column in its raw export tables. This can make tracking sessions a bit tricky when …
How to Calculate GA4 Sessions in BigQuery: A Simple Step-by-Step Guide Read more »
Are you curious about how conversational analytics can transform your data analysis workflow in Looker Studio? In this article, I’ll walk you through my personal experiment using Looker Studio Pro’s conversational analytics feature powered by Gemini AI. If you want …
From Data to Insight: How to Use Looker Studio’s Conversational AI Read more »
If you’re a marketer or data analyst who regularly works with Looker Studio dashboards, you know how time-consuming it can be to create presentation slides for your reports. What if there was a way to automate this process and generate …
Marketing Reports Made Easy: Looker Studio Pro + Gemini AI Slides Read more »
If you’ve been using Looker Studio (formerly Google Data Studio) for creating dashboards, you might be excited by the new responsive layout mode introduced recently. This feature promises dashboards that automatically adjust to different screen sizes, making them more user-friendly …
How to Use Looker Studio’s Responsive Layout for Mobile Dashboards Read more »
If you’ve just started working with Google Analytics 4 (GA4) data in BigQuery, you might be wondering how to extract key metrics like daily active users and sessions. This tutorial will guide you step-by-step through writing SQL queries to analyze …
BigQuery GA4 Tutorial: How to Get Daily Users and Sessions with SQL Read more »
If you’ve recently set up your GA4 export to BigQuery, you’re probably eager to start querying your data efficiently. In this guide, I’ll walk you through how to create your first query using the _TABLE_SUFFIX pseudo-column, a powerful method to …
How to Query GA4 Data in BigQuery Using _TABLE_SUFFIX (Full Tutorial) Read more »
0 items in the cart (0 €)
* Your contact data is confidential and may be used only to reach you.