Skip to main content

PIVOT: a five-step process for your GA4 migration

George Mendham3 September 20213 min read
PIVOT: a five-step process for your GA4 migration

There are many famous acronyms designed to help people follow a recommended procedure. For example, ‘DR ABC’ is commonly used by first responders to help them triage and treat patients. Now we’re definitely not suggesting our new PIVOT acronym will save lives, but it could save you time (and probably a few headaches!) when migrating to Google Analytics 4 (GA4).

PIVOT. Plan, Implement, Validate, Onboard, Transform. It sounds simple, maybe even a bit obvious. We prefer the term ‘delightfully intuitive’. It’s helping us and our clients understand what phase of a GA4 migration they’re currently in and what they need to do to progress smoothly to the next.

You can download a PDF of the PIVOT migration framework featuring a summary of the key tasks, our top tips and potential pitfalls. We've also summarised each stage in the process in this blog - just scroll down the page 👇

Measurelab's PIVOT GA4 migration framework
Measurelab's PIVOT GA4 migration framework

Planning

Failing to plan is planning to fail, right? Will your aim simply be to replicate your current UA set-up, recreating existing events within the new GA4 taxonomy? Or will you seize the opportunity to define an entirely new analytics strategy? Is this the time to finally bring web and app analytics together? Don’t miss the opportunity presented by a blank canvas, but beware of planning paralysis and an unnecessary delay to beginning dual tracking.

Implementation

With a clear, comprehensive plan, implementation can be swift and painless. New GA4 properties and data streams can be set up, with the enhanced measurement events, recommended events and custom events implemented in turn. Perhaps you’ll take the opportunity to spring clean those containers. Where it gets messy is when you start making decisions on the fly or expanding the scope as you begin to discover what’s actually possible.

Validation

The data is streaming. The moment of truth. Are your UA and GA4 properties returning consistent counts and matching metrics? Or is there a disparity you need to explore and explain? One thing’s for certain: you’ll want to have complete confidence in the data before exposing it to scrutiny - or using it as the basis for optimising investments.

Onboarding

It’s time to extend access and roll out the new reports and dashboards. Training may be required to familiarise users with the new schema, interface and capabilities - as well as explaining what’s missing, “Where’s the bounce rate gone?!” Your UA reports may need to be maintained for some time before GA4 becomes your sole ‘system of record’.

Even now, GA4 is evolving and advancing, so it’s worth considering how you can go about providing regular updates, and how you’re going to collate and prioritise the new requests that will undoubtedly come your way.

Transformation

This is where it gets interesting. The free built-in connector to Google BigQuery data warehouse opens up a number of new possibilities. For starters, you’re able to overcome the limitations of sampling in Google Analytics and analyse across an unlimited number of custom dimensions. It becomes truly transformative when you combine your web and app analytics data with campaign data, CRM and ERP data, and other data sets and make the leap from descriptive to predictive analytics.

Where are you on your GA4 journey? Whether you’re pondering the P, vacillating with the V, or tempted by the T, we can probably help you PIVOT. Get in touch to chat about your requirements.


Suggested content

Measurelab awarded Google Cloud Marketing Analytics Specialisation

At the start of the year, if you’d asked us whether Measurelab would be standing shoulder to shoulder with Europe’s biggest consultancies by September, we would've been surprised. Not because we don't believe in ourselves, but because these things feel so distant - until suddenly, they’re not. So, here it is: we’ve been awarded the Marketing Analytics Services Partner Specialisation in Google Cloud Partner Advantage. What’s the big deal? In Google’s own words (with the obligatory Zs): “Spec

Will Hayes11 Sept 2025

BigQuery AI.GENERATE tutorial: turn SQL queries into AI-powered insights

BigQuery just got a major upgrade, you can now plug directly into Vertex AI using the new AI.GENERATE function. Translation: your analytics data and generative AI are now best friends, and they’re hanging out right inside SQL. That opens up a whole world of new analysis options for GA4 data, but it also raises some questions: * How do you actually set it up? * What’s it good for (and when should you avoid it)? * Why would you batch the query? Let’s walk through it step by step. Step 1: H

Katie Kaczmarek3 Sept 2025

How to start forecasting in BigQuery with zero training

If you’d told me five years ago that I’d be forecasting product demand using a model trained on 100 billion time points… without writing a single line of ML code… I probably would’ve asked how many coffees you’d had that day ☕️ But its a brand new world. And it’s possible. Let me explain What is TimesFM? TimesFM is a new foundation model from Google, built specifically for time-series forecasting. Think of it like GPT for time, instead of predicting the next word in a sentence, it predicts t

Katie Kaczmarek14 Jul 2025