Krisztián KorpaGA4 BigQuery SQL: How to Build Queries from ScratchThe art of querying your Google Analytics 4 raw data in BigQuery using SQL11 min read·Feb 20, 2024--1--1
Krisztián KorpaGA4 Query Optimization Strategies with DataformOptimize your GA4 queries with these Dataform settings. See how partitioning, clustering, or incrementality can help you reduce query costs6 min read·Dec 8, 2023--1--1
Krisztián KorpaA Comprehensive Guide to Error Handling and Alerting in DataformArticle outline: The Importance of Error Handling What Can Go Wrong? Handling Errors in Google Workflows Assertions in Dataform How to…5 min read·Dec 1, 2023----
Krisztián KorpaDataform JavaScript utility functions for GA4 tablesIn a previous article, we discussed why Dataform is a great addition to the marketing analytics tool stack and in another, we contemplated…6 min read·Nov 24, 2023----
Krisztián KorpaGA4 Sessionization and Traffic Source handling in BigQueryOne of the biggest changes from UA to GA4 is how the underlying data is modeled. If you still have a few blurry memories of the UA reports…9 min read·Nov 17, 2023--3--3
Krisztián KorpaDataform with GA4: The Unsung Hero of Marketing AnalyticsData orchestration is essential to turn your raw GA4 data into usable production tables in BigQuery. Learn how!4 min read·Oct 27, 2023--2--2
Rick DronkersDigital Analytics is Dead? Long Live Digital AnalyticsWhat is the future of Digital Analytics? Is it dead? In this post I dive into the trends threatening it’s survival and what I think is…7 min read·Oct 26, 2023--2--2
Rick DronkersYour Marketing Analytics Data ≠ Reality. And that is okay.The quest for more & perfect data is holding you back from achieving success. Accept reality and work with what you’ve got.6 min read·Oct 21, 2023----
Krisztián KorpaUnlocking the Power of AI for Google Shopping Feed OptimizationGoogle Shopping Feed Optimization with Generative AI using FeedGen10 min read·Oct 17, 2023----