BigQuery
![Elevate your data and analytics game using BigQuery - Measurelab](https://www.measurelab.co.uk/wp-content/uploads/2024/07/Analytical_Training_banner_.png)
Elevate your data analytics game with BigQuery
What is BigQuery? What is BigQuery? BigQuery is a powerful data warehousing tool within the Google Cloud Platform designed to…
![](https://www.measurelab.co.uk/wp-content/uploads/2022/02/Analytics-sub_big-query-1200x400-Blog.png)
Connecting GPT to BigQuery: Zapier AI actions
Unless you have lived under a rock for the last 12 months, you have probably heard of a little old…
How to debug your SQL in BigQuery
How often have you run your code in BigQuery only to find a bit of data missing that you KNOW…
![Measurelab](https://www.measurelab.co.uk/wp-content/uploads/2021/11/Measurelab-Blog-GA4-streaming-to-BigQuery_1200x400-Blog-2.png)
The Google Cloud tools of the marketing analytics trade
The Google Cloud Platform (GCP) is vast. It is composed of over 100 services which serve purposes across countless industries…
![Changing a GA4 Data Stream name](https://www.measurelab.co.uk/wp-content/uploads/2022/05/Analytics-sub_big-query-1200x400-Blog.png)
Backing up Universal Analytics data in BigQuery
No point kicking up a fuss about it now, Universal Analytics (UA) is on life support. It still contains all…
![types of GA4 events](https://www.measurelab.co.uk/wp-content/uploads/2022/05/Analytics-sub_UAGA4-1200x400-Blog.png)
GA4 property and data stream setup best practices
Google’s own guide on how to structure GA4 properties can be a great resource, but only if you have a…
![](https://www.measurelab.co.uk/wp-content/uploads/2022/10/katie-measurefest-october-2022-blog.png)
MeasureFest October 2022: Why GA4 means you need to get on board with BigQuery
This is my first time speaking at any analyics conference, let alone MeasureFest, and I'm looking forward to sharing my…
![Changing a GA4 Data Stream name](https://www.measurelab.co.uk/wp-content/uploads/2022/05/Analytics-sub_big-query-1200x400-Blog.png)
How to review SQL code in BigQuery for duplication and errors
Sometimes we can spend hours, days or even weeks writing SQL in BigQuery. Hopefully what you have ended up with…
![layering data studio scorecards](https://www.measurelab.co.uk/wp-content/uploads/2022/05/Analytics-sub_Sheets-1200x400-Blog.png)
Change your Google Analytics data retention settings
It may be news to some: Google Analytics does not keep all of your data forever. The data storage and…
![](https://www.measurelab.co.uk/wp-content/uploads/2022/05/Analytics-sub_GTM-1200x400-Blog.png)
How to access BigQuery data from server-side GTM (via Firestore)
This solution allows for data, contained within BigQuery to be queried and stored in Firestore where it can then be…