#
Blog post
23/9/2025

Hack Your Weekend

Hack Your Weekend

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.

There’s a big difference between spinning up an MVP in Lovable with a single prompt and spending an entire weekend working hands-on with Claude Code Max - versioning, MCPs, documentation, staging, app security, and everything in between. In our team, I took care of the backend, deployment, and app tracking (our tech stack was React + Next.js + Supabase Postgres DB + Vercel hosting + Git, plus tracking via a Cloud Run endpoint writing to BigQuery, along with a dashboard and data interpretation through a BigQuery MCP).

The event was organized by Jindrich Faborsky (probably Jindra’s smallest event ever :). Jindrich is really pushing hard into AI-assisted development - he genuinely lives it - and it’s great that he openly shares his journey while onboarding both the community and people from the outside. If you’re looking for an intro to the topic, I can highly recommend Jindrich’s AI First Course - an authentic course about the core principles, the tooling, and how to actually work this way. It was also great that the event brought in mentors from different areas of expertise who supported the teams - people like Petr Bureš, Lukas Mehnert, Dima Melnik, or Petr Simecek, who helped us with Git. Jindra himself actively supported the teams too - helping some with development or strategy and nudging others (like us) toward even bolder features. 🙂

At #HackYourWeekend, our Keshu team (Klára Fottová, Jiří Pavlas, Petra Schönfeldová, Michal Pecánek, Vito Nikolič + me) built an application for listing and searching dog-friendly places - kind of like a European Coffee Trip, but for dogs. (Keshu was the dog/mascot.) My role was backend development and deployment (a dream come true for me - finally getting to try the role of a backend engineer :). The other roles covered design, development, business, and marketing. We designed a nice data model (pro tip: the schema was written in Mermaid, which Git can automatically render from a .md file), and before the rest of the team jumped into the app, I pushed the first 30 commits.

Keshu team on Friday while we were fine-tuning the strategy
Team roles

Our tech stack was React + Next.js + Postgres DB (Supabase) + Vercel hosting + Git. On Sunday, once the app was deployed with the basic functionality and admin panel in place - and my teammates were working on new features and design (respect to Michal Pecánek for your fully working geolocation 👌) and I built a custom tracking setup using Cloud Run and BigQuery.

Deployed app
App admin panel
Design elements

Other teams built, for example, a weather-check app for hobby pilots to use during pre-flight preparation (Briefly.ai) or an app for sharing routes and rides within the cycling community (Bike Meet). The project that caught my attention the most was an app with the working title “Střídavka” (“Shared Custody”), designed to help separated parents organize shared custody - managing handovers, schedule changes, and day-to-day coordination. It’s a powerful topic and an app that truly makes sense and brings real value, and I genuinely hope its development continues.

Interesting Bits from Development & Lessons Learned

We eventually had to switch to Claude Code Max, because the standard PRO version disconnects you after a few hours - not ideal for a hackathon - and it burns through tokens fast. I honestly can’t imagine building a fully robust solution this way yet, at least not without splitting it into well-isolated components so the model can keep the context under control. One of the highlights for me was having the time to really try out a bunch of MCPs. Supabase and Vercel both have their own MCPs, which makes development so much easier, and we also plugged in others (Context7, Sentry, etc.). Honestly, I wouldn’t bet too much on the future of services that don’t have an MCP - and don’t plan to build one.

Version control turned out to be one of our biggest challenges. We didn’t really have a good branch strategy, and we lacked the experience to merge everything properly across a six-person team. What helped me a lot was having Claude connected directly to Git. I committed straight from Claude and had it check in advance whether my commit would break the build. It wasn’t exactly professional - and proper tests should be done differently - but we didn’t have much time to fine-tune things.

Git repo

One thing that didn’t work very well for me was the project instructions in .claude.md. I wanted Claude to automatically update the prod.md file after every functionality update, but I couldn’t get it to work. It only worked when using an agent - and even then, I had to trigger it manually.

App Tracking

We built our own tracking (GA4 would’ve been way too easy :). We sent events through a secure cloud endpoint on Cloud Run directly into BigQuery. In a real-world scenario, I got to try building a Claude Code endpoint that processes incoming events and writes them to BigQuery - plus hooking up and testing the BigQuery MCP. GCP has something called the MCP Toolbox for Databases, which includes several MCPs for working with data, including the BigQuery MCP. Thanks to that, we were able to prompt our way to full dashboards, and we were even ready for on-the-fly data queries (for now just in the console, but the next step would be wrapping that in a UI and deploying it into the app’s admin panel).

The initial prompted dashboard

There were folks from Keboola at the event (huge thanks for their support and sponsorship 🙏), and apparently the Keboola MCP is already capable of handling most tasks - including full end-to-end workflows. I didn’t know that, and I’m definitely planning to try it out.

Claude Code + Gemini on the same project

I experimented with combining two models on the same app. I built the tracking layer separately using Gemini CLI and the Google Cloud SDK. I then used Claude Code for deployment, because I didn’t want to deploy from two different CLIs or spin up the Vercel MCP inside Gemini. I was a bit worried whether having two models working on the same codebase would cause issues.

But if the second model is working on a contained component, you avoid major structural changes, and you document everything properly so the other model can always reload the context, I think it’s totally fine.

I documented all changes in tracking/tracking.md and always let Claude review what Gemini did and confirm that everything looked good from its perspective.

What I learned - and what I’m taking away from the hackathon for my work and personal growth

I left the event tired, but happy - and grateful for the chance to take part. I had already tried building with AI before the hackathon (thanks, FOMO), but what I took away from Brno most was the experience of building something as a team. And also getting more comfortable controlling things in Google Cloud Platform directly through Gemini or preparing Cloud Shell commands via the model.

Honestly, I’m not sure I’d feel confident building an app intended to serve a large number of users without some human code review. But there were people at the hackathon who do have ambitions to push their apps further - and thanks to the hackathon, they can now build an MVP themselves and really take off. For me, this approach feels more useful for various smaller data tasks, system integrations, test agents, utilities, pipelines, and similar. Basically for things that aren’t mission-critical but save us a lot of time at MeasureDesign.

It massively democratizes access to technology and removes the barriers created by not knowing a technology in depth - or not having time to build something complex in it. What matters is knowing what the tools can do, what you want from them, and what you need to keep an eye on. What worked well for us was keeping the AI within boundaries, avoiding too much “creativity,” and breaking development into detailed steps for the model to execute. With that approach, the results were genuinely good.

Jindřich during the final presentations
App tracking presentation
Vito and final slide

Fun fact to wrap it up: I ended up sleeping in my car 🚘 on the street in front of Clubco both nights, because at 9 p.m. on Friday I realized that my accommodation wasn’t booked from September 19th, but from October 19th 🤦. I even tried sleeping in a meeting room - you know, since it was a hackathon (like my teammate in the photo) - but I couldn’t fall asleep there, so the car won. In the end, it didn’t matter at all - actually the opposite. There wasn’t much time to sleep anyway, let alone head somewhere to check into a hotel. :)

Authors

#
Blog post
Analytics is a great career path for women — including moms returning from (or during) maternity leave
20/11/2025

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.

#
Blog post
BigQuery: How to move a GA4 dataset to another GCP project
1/11/2025

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

#
Blog post
Hack Your Weekend
23/9/2025

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.

#
Blog post
MeasureCamp Brno 2025
10/9/2025

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

#
Blog post
How to calculate the date of Easter in BigQuery
16/4/2025

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.

#
Podcast
Socials: Vašek Jelen discusses GA4, server-side tracking, BigQuery and connecting customer data with campaign performance
19/11/2024

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.

#
Blog post
MeasureCamp Prague 2024: Using Google Ads export in Google BigQuery
10/9/2024

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.

#
Blog post
Data retention: Storing data in Google Analytics 4
31/8/2024

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.

#
Blog post
Workshop: GA4 basics for the Tereza non-profit organization
3/6/2024

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.

#
Blog post
Reshoper 2024: New opportunities in analytics
20/5/2024

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.

#
Blog post
Marketing Festival 2024: Learn to work with GA4 data in BigQuery and GCP
22/2/2024

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.

#
Webinar
Tips and tricks for GA4 not just for Shoptet users
25/11/2023

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.

#
Webinar
Webinar: Evaluating GA4 Data in BigQuery
21/6/2023

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.

Martina Kvasničková
AI & Data Research
Anna Horáková
Analyst
Zuzana Mikyšková
Analyst & Co-Founder
Vašek Jelen
Lead Analyst & Co-Founder
Blanka Hejduková
Back Office
Markéta Svěráková
Analyst
Petra Súkeníková
Analyst
Klára Belzová
Analyst
Martina Kvasničková
Martina Kvasničková
AI & Data Research

Marťa helps integrate AI into everyday work—making it faster, more efficient, and accessible to every team member. What excites her most is finding practical ways to use AI and turning new technologies into useful tools.

Anna Horáková
Anna Horáková
Analyst

Anička has over 7 years of experience in the agency world, where she has managed social media ad campaigns for clients, and especially for content-driven websites, her favorite. Wanting to broaden her perspective beyond campaign data, she gradually shifted her focus toward web analytics. She joined our team in 2022 and now specializes in data analytics, using GA4, BigQuery, Looker Studio, and other tools to connect and dig deeper into data — delivering insightful analyses and valuable input for business decisions.

Zuzana Mikyšková
Zuzana Mikyšková
Analyst & Co-Founder

Zuzka's career path led her through corporate innovation and research management, running word-of-mouth projects, and later to a digital agency, where she managed website development projects. However, Zuzka is naturally curious and wanted to understand how a website actually works once it is launched into the world. That curiosity led her to study web analytics — and eventually to a key collaboration with Vašek. In 2019, they founded the company together.

Vašek Jelen
Vašek Jelen
Lead Analyst & Co-Founder

Vašek has been working in digital analytics for over 15 years — from setting up tracking to data storage, visualization, and interpretation. He helps companies bring organize their data and make full use of it. He focuses primarily on data from digital platforms such as websites, apps, and client zones, and on connecting that data with other business data like media and customer data. After years of freelancing, he co-founded the analytics studio MeasureDesign, where, in addition to working on analytics projects and bespoke training sessions, he also mentors and educates new analysts.

Blanka Hejduková
Blanka Hejduková
Back Office

Blanka joined our team in 2024 and has been responsible for back-office operations, including invoicing and administrative tasks, ever since. She draws on her experience from the Czech Post and her background in financial management to keep everything running smoothly. In her free time, she enjoys traveling with her two children and finds relaxation in working in her garden.

Markéta Svěráková
Markéta Svěráková
Analyst

Markéta started out in marketing, but then came maternity leave — and with it, total chaos. In an effort to hold on to the last bits of sanity, she turned to data. After all, numbers don’t yell, spill cereal into your keyboard, and at least they make some sense. She completed a data analytics course at Engeto Academy, where she bonded with SQL, Power BI, Excel, and Python, and started looking for patterns outside the bounds of children’s coloring books. Today, at MeasureDesign, she helps clients understand what their numbers are really saying.

Petra Súkeníková
Petra Súkeníková
Analyst

She joined MeasureDesign in 2023, specialising in measurement implementation and reporting. Her favourite moment is when, after all the setup and testing, the first data finally starts flowing in. Her biggest challenge? The unexpected (and often undocumented) changes from Google – those are the times when every analyst turns into a paranormal behaviour expert. 👻

Klára Belzová
Klára Belzová
Analyst

Klára has been with the company since 2019. She focuses mainly on web analytics but is not afraid to dive into data work in BigQuery. What she enjoys most is guiding clients through the entire process — from defining their needs to implementing tracking and creating the final data visualizations. She gets an almost suspicious amount of joy from a clean and well-organized GTM container or a report full of useful data.