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…Sep 4, 20231Sep 4, 20231
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…Mar 231Mar 231
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…Aug 21, 20231Aug 21, 20231
Lace Chantelle RogersWhy does my Google Analytics 4 Conversion attribution differ from Universal analytics?1. Why are my conversions attributed differently?Jul 7, 2023Jul 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?Nov 27, 2022Nov 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…Oct 3, 20222Oct 3, 20222
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…Jun 29, 20221Jun 29, 20221
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…Jun 11, 2022Jun 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…May 19, 2022May 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…Apr 22, 20221Apr 22, 20221