Lace Chantelle Rogers – Medium

Lace Chantelle Rogers

Pinned

Lace Chantelle Rogers

GA4 and BigQuery: how to match the Console traffic grouping metrics

Google Analytics 4 offers excellent functionality with its GA4 BigQuery dataset. However, you might find it challenging to align your GA4…

3 min readSep 4, 2023

--

1

GA4 and BigQuery: how to match the Console traffic grouping metrics

--

1

Lace Chantelle Rogers

Become a BigQuery pro by knowing the basics

Often, we’re eager to tackle complex challenges in programming, but laying a solid foundation in the fundamentals ensures our more advanced…

5 min readMar 23, 2024

--

1

Become a BigQuery pro by knowing the basics

--

1

Lace Chantelle Rogers

BigQuery and GA4 removing expiry dates across your dataset

As 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 readAug 21, 2023

--

1

BigQuery and GA4 removing expiry dates across your dataset

--

1

Lace Chantelle Rogers

Why does my Google Analytics 4 Conversion attribution differ from Universal analytics?

1. Why are my conversions attributed differently?

5 min readJul 7, 2023

--

Why does my Google Analytics 4 Conversion attribution differ from Universal analytics?

--

Lace Chantelle Rogers

GA4: 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 readNov 27, 2022

--

GA4: Why are my Looker Studio dashboards broken?

--

Lace Chantelle Rogers

BigQuery and GA4: how to redact parameters in code

As more and more people migrate from Universal Analytics to Google Analytics 4, we see more opportunities for people to use BigQuery to…

4 min readOct 3, 2022

--

2

BigQuery and GA4: how to redact parameters in code

--

2

Lace Chantelle Rogers

BigQuery: Easily manage dataset access permissions with DCL

As 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 readJun 29, 2022

--

1

BigQuery: Easily manage dataset access permissions with DCL

--

1

Lace Chantelle Rogers

BigQuery: A greener way to warehouse

Nowadays 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 readJun 11, 2022

--

BigQuery: A greener way to warehouse

--

Lace Chantelle Rogers

Google Analytics and BigQuery: setting up your project

With the onset of Universal Analytics sunsetting, and the fab Google Analytics 4 dataset, there has been a considerable uplift in users…

7 min readMay 19, 2022

--

Google Analytics and BigQuery: setting up your project

--

Lace Chantelle Rogers

BigQuery: Using GCP Audit Logs to estimate user level spend

Often Google Cloud Platforms billing dashboard suffices to capture and manage how much you are spending on the platform each month…

5 min readApr 22, 2022

--

1

BigQuery: Using GCP Audit Logs to estimate user level spend

--

1

Lace Chantelle Rogers

Lace Chantelle Rogers

https://www.bigquery.co.uk/ leading data and analytics . GCP, BigQuery and GA4 expert specialising in data engineering, data science and Brighton cloud events.

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams