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.

MeasureCamp Prague 2024: Using Google Ads export in Google BigQuery
#
Blog post
10/9/2024
Anna Horáková
Analyst
Vašek Jelen
Lead Analyst & Co-Founder

On Saturday, the ČSOB building in Prague was buzzing with analytics topics. A large part of the MeasureDesign team showed up for the 10th anniversary edition of MeasureCamp Czech Republic — and Vašek and Anička gave a talk on working with the Google Ads dataset in Google BigQuery.

Data retention: Storing data in Google Analytics 4
#
Blog post
31/8/2024
Petra Súkeníková
Analyst

Data retention in GA4 determines how long information about users and events will remain available. By default, this period is only two months, which can limit your analysis options. In this article, you'll learn how to extend this period to up to 14 months (or 50 months with GA4 360) and what the retention setting does not affect.