Analytics Workshops at Agencies

With the rise of server-side measurement, we are increasingly implementing server-side tracking for our clients not only for analytics, but also for advertising platforms. In this article, I want to share our experience with a server-side implementation of media tags for a larger client - what we learned along the way, which templates we used, and what to watch out for.

This year, I led several workshops at digital and media agencies. The scenario was usually similar: at some community data/analytics event (or more often at the afterparty), I'd connect with the team leader of their analytics department and we'd arrange a workshop aimed at helping their internal team level up. The goal was to share not only current technical know-how and best practices, but also how to demonstrate the value of digital analytics to clients and which measurement use cases deliver the greatest real-world impact.

I studied economics and spent many years working as a project manager in an agency. But coordinating other people’s work wasn’t enough for me — I wanted to truly master something myself. I’ve always enjoyed math, so I gradually, almost naturally, shifted into analytics. I started around 2014 as a self-taught analyst, later began working with Vašek Jelen, and in 2020 we founded MeasureDesign together. I quickly realized this field was exactly what I’d been looking for — it satisfies my curiosity, my need to dig into details, and my desire to bring a bit of “ordnung” into things. In the whirlwind of running a household, taking care of kids, and navigating global chaos, data feels oddly calming. At the same time, it lets me use my creativity when I play detective and hunt down measurement issues like a modern-day Miss Marple. I genuinely believe analytics is a great career for women in general. And yet, there still aren’t many of us in the field.

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).

Reshoper advisory zone and several hours of consultations for trade fair visitors - this year held in the pleasant surroundings of the Křižík Pavilions at the Prague Exhibition Grounds. This year, I had the opportunity to experience Reshoper both as an advisor in the advisory zone and as a participant in the Roundtables.

From Idea to App in 48 Hours 🚀 I spent the third weekend of September at the Clubco CZ coworking space in Brno, taking part in the #HackYourWeekend hackathon. In a group of 60 people split into eight teams, we spent Friday through Sunday afternoon developing eight applications addressing real-world needs. We built everything in AI/LLM-supported development environments (our team used VS Code + Claude Code). The participants ranged from developers already building with AI to people like me who wanted to dive in and really try this kind of workflow for the first time.

On September 6, another edition of MeasureCamp - our favorite community event - took place at Brno’s Gen. We were thrilled to see that 74 women attended this year’s MeasureCamp (5.4% of them from our team 🙂), and it’s clear that the number of women in data and analytics continues to grow 🚀.

I'd like to add to the wave of positive reactions to the PPC Camp. It's an event where several dozen PPC specialists come together for a weekend to share their know-how through presentations. The event has a wonderfully positive vibe, and it was interesting for me to see that knowledge sharing, collegiality, and solidarity work just as well in the PPC community as they do in the analytics community. But it doesn't happen on its own - my respect belongs to uLab, Markéta Kabátová and Petr Bureš for the energy they put into organizing the event and bringing people together.

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.

I received an invitation from Robin Stržínek at VISIBILITY DIGITAL to speak at their regular Visi Thursday event. I had the opportunity to share my experience with the practical applications of connecting GA4 with Google BigQuery and other Google Cloud Platform services.

Socials podcast and 80 minutes of conversation with Daniel Bauer and Otakar Lucák about digital analytics, with a focus on e-commerce. The guys deal with a number of specific topics in their client work and had some great questions. Thanks to this, I think we kept it very practical, and the podcast includes our opinions on how to resolve real-life situations from practice.

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 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.

On the last day of May, we spent time with the team from the Tereza non-profit organization, focusing on the basics of Google Analytics 4. We concentrated on the practical use of data, especially for the Učíme se venku ("Learning Outdoors") program, which helps teachers bring lessons from the classroom to the outdoors.

At the Reshoper conference, I had the opportunity to give a talk where I summarized new opportunities for e-commerce analytics. In the presentation, I shared my experience and approaches on how to get the most out of Google Analytics 4 — especially when combined with BigQuery and other Google Cloud services.

This workshop focused on working with GA4 data in BigQuery and Google Cloud. My goal was to help participants move beyond the GA4 interface and show that working with raw GA4 data is not rocket science :) On the contrary, it is a valuable skill that is worth learning, because raw GA4 data hold huge potential for monetization and activation. I also shared real-world examples and reporting concepts from companies that rely entirely on BigQuery data. The participants were fantastic, and it was great to see how many people are actively exploring BigQuery and GCP. It felt like we were all on the same wavelength.

A recording of the public webinar we hosted with Marek Čech for Shoptet. The main topic was practical recommendations for evaluating campaigns in GA4 in connection with the upcoming Black Friday and Christmas season.

Together with Vašek Ráš, we hosted a public webinar on evaluating campaigns using the GA4 dataset in Google BigQuery. Our guest speaker was Honza Tichý, who presented a section on DBT.