PinnedLace Chantelle RogersGA4 and BigQuery: how to match the Console traffic grouping metricsGoogle Analytics 4 offers excellent functionality with its GA4 BigQuery dataset. However, you might find it challenging to align your GA4…·3 min read·Sep 4, 2023--1--1
Lace Chantelle RogersBecome a BigQuery pro by knowing the basicsOften, we’re eager to tackle complex challenges in programming, but laying a solid foundation in the fundamentals ensures our more advanced…·5 min read·Mar 23, 2024--1--1
Lace Chantelle RogersBigQuery and GA4 removing expiry dates across your datasetAs you’ll probably already be aware, Google Analytics 4 (GA4) provides an fantastic dataset for BigQuery for all your raw user and event…·4 min read·Aug 21, 2023--1--1
Lace Chantelle RogersWhy does my Google Analytics 4 Conversion attribution differ from Universal analytics?1. Why are my conversions attributed differently?·5 min read·Jul 7, 2023----
Lace Chantelle RogersGA4: Why are my Looker Studio dashboards broken?Google recently announced it would be enforcing its GA4 API quota limits, so what does this mean in plain English?·3 min read·Nov 27, 2022----
Lace Chantelle RogersBigQuery and GA4: how to redact parameters in codeAs more and more people migrate from Universal Analytics to Google Analytics 4, we see more opportunities for people to use BigQuery to…·4 min read·Oct 3, 2022--2--2
Lace Chantelle RogersBigQuery: Easily manage dataset access permissions with DCLAs we all know one of the biggest challenges of managing a data warehouse is permission to access data. Often this can be challenging to…3 min read·Jun 29, 2022--1--1
Lace Chantelle RogersBigQuery: A greener way to warehouseNowadays it’s incredibly easy to upload, store query and edit data, however, how often do we consider the carbon (and other) footprints in…6 min read·Jun 11, 2022----
Lace Chantelle RogersGoogle Analytics and BigQuery: setting up your projectWith the onset of Universal Analytics sunsetting, and the fab Google Analytics 4 dataset, there has been a considerable uplift in users…7 min read·May 19, 2022----
Lace Chantelle RogersBigQuery: Using GCP Audit Logs to estimate user level spendOften Google Cloud Platforms billing dashboard suffices to capture and manage how much you are spending on the platform each month…5 min read·Apr 22, 2022--1--1