If you’ve set up your first GA4 export to BigQuery and want to dive deeper into your store’s purchase data, you’re in the right place. In this tutorial, I’ll walk you through how to query purchase revenue effectively using BigQuery …
How to Track GA4 Purchase Revenue in BigQuery (Made Simple) Read more →
Are you looking to track how many conversions your website gets by analyzing raw Google Analytics 4 (GA4) data directly in BigQuery? You don’t need complicated models or advanced machine learning techniques to do this. With just a simple condition …
BigQuery GA4 Conversions Tutorial: How to Count Events with Simple SQL Read more →
If you’ve ever wondered how to analyze your Google Analytics 4 (GA4) data by device type in BigQuery, you’re in the right place. Understanding whether your users come from desktop, mobile, or tablet devices is crucial for tailoring marketing strategies …
How to Filter GA4 Users by Device in BigQuery (Step-by-Step) Read more →
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 →
0 items in the cart (0 €)