When you start working with GA4 data in BigQuery, you’ll hear that you should avoid connecting your dashboards directly to the raw data export tables. The reasons behind this include query performance and cost optimization. The need for optimizing your data sources is especially true when working with item-level ecommerce data. In this post, I’ll […]
GA4 BigQuery – Ecommerce Table with Item List Attribution Read More »
Incremental tables allow maintaining tables based on large source data by only performing small periodic queries. In this post, I’ll share three different methods for performing an incremental refresh. The code examples are all based on the GA4 BigQuery export data.
Incremental Refresh Techniques for Dataform – GA4 Read More »
The daily BigQuery export schedules for GA4 are notoriously random. Sometimes the data is processed in the early-morning hours, sometimes at noon, and sometimes not even during the next day. In this article, I’ll walk you through how to set up a Cloud Workflow that compiles and executes the selected queries in your Dataform project.
Run Dataform queries immediately after the GA4 BigQuery export happens Read More »