FMCG · Pet nutrition · Global

A global migration without the gaps.

The client

Royal Canin is a Mars company and one of the best-known pet nutrition brands in the world, making breed and health-specific food for cats and dogs. Its website runs across many markets and local variations and draws a very large global audience every month.

The challenge

Universal Analytics was being retired, and the whole global site had to move to GA4. Many teams across markets depended on that measurement day to day, so the switch could not break their reporting.

The site ran in many markets and variations, each with its own history of tagging. A migration done market by market would have left inconsistencies everywhere.

Marketing reporting was only part of the need. Raw analytics data also had to reach internal data teams working in Azure and Databricks.

What we did
GA4 migrationAnalytics schemaData pipelinesTraining

Global analytics schema

We designed one analytics schema for the entire operation, covering events, parameters and naming. Markets could add local needs on top without changing the shared core.

GA4 migration through GTM

We migrated from Universal Analytics to GA4 through Google Tag Manager, applying the schema consistently across markets and site variations. Both systems ran in parallel during the transition.

Validation at every phase

Data accuracy was checked against legacy metrics at each phase of the rollout. Differences were explained or fixed before a market moved on, so teams could trust the new numbers.

Ingestion automation

We built Python and SQL workflows to ingest and transform analytics data from BigQuery on GCP. Jobs were scheduled and monitored so data arrived on time without manual steps.

Pipelines to Azure and Databricks

We worked with the internal data teams on pipelines connecting BigQuery to Azure and Databricks. Raw analytics data now flows into the enterprise platforms they already use.

Training and documentation

We delivered analytics training and documentation across subsidiary companies. Shared guides replaced knowledge that had sat with a few individuals.

What changed
  • The migration kept measurement continuous across markets.
  • Analytics data flows through automated pipelines into enterprise systems.
  • Standard analytics practices were adopted globally.
  • Siloed knowledge became documented, shared practice.
  • Data teams in Azure and Databricks receive the raw data they need.
Stack
Google AnalyticsGA4Google Tag ManagerGCPBigQueryAzureDatabricksPythonSQL

Related work

Next step

Get your first fix in 30 minutes

Bring the question your team can’t answer fast enough. The engineer who would do the work looks at your setup with you and tells you the first thing we would fix, plus a straight answer on whether you need us at all. It costs you half an hour, and you keep the fix either way.

Book a free discovery call