Published inThe Data to Value BlogHow I Optimized 70TB of GA4 Data in BigQuery Using DataformOne way to handle when execution time becomes the bottleneck of a data pipeline with Dataform5d ago5d ago
Published inThe Data to Value BlogHow to Migrate Your Google Analytics 4 BigQuery Export to Another GCP ProjectDetailed how-to explaining how to successfully copy your Google Analytics 4 Raw Data Export in BigQuery to another GCP Project.Feb 17Feb 17
Published inThe Data to Value BlogHands-on Guide to External Tables in BigQuery using DataformDo you find yourself looking at data in Google Cloud Storage or Google Drive thinking: “If only this was in BigQuery, I could analyze it…Feb 10Feb 10
Published inThe Data to Value BlogHow To Think About Your (GA4) Data (in BigQuery): There’s Levels To ThisUnderstand GA4 data in BigQuery with a new perspective. Dive into a framework to grasp your data’s structure and enhance your skillsMay 30, 2024A response icon1May 30, 2024A response icon1
Published inThe Data to Value BlogGA4 BigQuery SQL: How to Build Queries from ScratchThe art of querying your Google Analytics 4 raw data in BigQuery using SQLFeb 20, 2024A response icon1Feb 20, 2024A response icon1
Published inThe Data to Value BlogGA4 Query Optimization Strategies with DataformOptimize your GA4 queries with these Dataform settings. See how partitioning, clustering, or incrementality can help you reduce query costsDec 8, 2023A response icon1Dec 8, 2023A response icon1
Published inThe Data to Value BlogA 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…Dec 1, 2023Dec 1, 2023
Published inThe Data to Value BlogDataform 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…Nov 24, 2023Nov 24, 2023
Published inThe Data to Value BlogGA4 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…Nov 17, 2023A response icon3Nov 17, 2023A response icon3
Published inThe Data to Value BlogDataform 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!Oct 27, 2023A response icon2Oct 27, 2023A response icon2
