PinnedLace Chantelle Rogers·Mar 29, 2022BigQuery: The art of unnesting google analytics 4 event parametersWhen you first catch a glimpse of the BigQuery Google Analytics or Firebase BigQuery tables, you may be instantly taken aback by the…A response icon4A response icon4
PinnedLace Chantelle Rogers·Sep 4, 2023GA4 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…A response icon2A response icon2
Lace Chantelle Rogers·Sep 26From Measurement to Optimisation: How the Mobile App Stack Fits TogetherIn my previous post, I focused on why app measurement should start before instrumentation — defining what success looks like, mapping the…
Lace Chantelle Rogers·Sep 26Design Your App for Measurement from Day OneBefore You Build Your App, Define How You’ll Measure Success
Lace Chantelle Rogers·Mar 23, 2024Become 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…A response icon1A response icon1
Lace Chantelle Rogers·Aug 21, 2023BigQuery 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…A response icon1A response icon1
Lace Chantelle Rogers·Jul 7, 2023Why does my Google Analytics 4 Conversion attribution differ from Universal analytics?1. Why are my conversions attributed differently?
Lace Chantelle Rogers·Nov 27, 2022GA4: 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?
Lace Chantelle Rogers·Oct 3, 2022BigQuery 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…A response icon2A response icon2
Lace Chantelle Rogers·Jun 29, 2022BigQuery: 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…A response icon2A response icon2