Latest posts

BigQuery: How to move a GA4 dataset to another GCP project
#
Blog post
1/11/2025
Petra Súkeníková
Analyst

Sometimes you need to move historical data from a Google Analytics 4 export to a different BigQuery project – for example, when changing your project structure, switching to a new billing account, or consolidating data. In this article, we’ll show how to copy GA4 datasets using BigQuery Data Transfer Service (there are other methods as well).

How to calculate the date of Easter in BigQuery
#
Blog post
16/4/2025
Anna Horáková
Analyst

Easter is a movable feast, and its date changes every year. If you work with data — whether you are analyzing seasonal traffic trends, comparing campaign performance, or planning marketing activities — it can be useful to know the exact dates of the Easter holidays. That is where a simple SQL script for BigQuery can come in handy.