Restructuring data collection creates 7.5x faster launches for a global gaming brand

Summary

Facing disjointed data collection across their AAA title marketing sites, a leading video game company enlisted Quarry's expertise to streamline and standardize their process.

Team
Data
Team members / roles
Brendan Binger / Systems Architect
Simon Rahr Mortensen / Data Architect
Igor Rapoport / Project Lead
Puneet Maloo / Principal Engineer
Rafael Osorio / Senior Engineer
Released
February 2024
Duration
3 months
Data02.05.24

Photo by Alina Grubnyak on Unsplash

How innovative data collection transformed a major video game company’s approach to marketing efficiency and compliance

An abstract three dimensional render indicating complexity.
Photo by Vincentiu Solomon on Unsplash

The Challenge:

  • Diverse data collection challenges
  • Lack of centralized coordination
  • Marketing reporting difficulties and data loss issues

A well-known video game company faced challenges with its data collection with many different standalone marketing sites for individual AAA titles. 

Historically, different teams worldwide had a variety of data requirements and systems in play, leading to disjointed and inconsistent data gathering, with no uniformity in requirements or reporting throughout the company.

The absence of a centralized data collection team resulted in outdated practices and data inconsistencies, including significant gaps in data spanning months or years.

The lack of standardized data made it difficult for individual teams to report on marketing campaigns, efforts, or key performance indicators (KPIs). 

Additionally, blind spots and oversights were common, leading to data loss because data collection was not implemented effectively from the start of the project.

The Solution:

  • Innovative data collection template development
  • Global standardization and effortless updates
  • Comprehensive data strategy and custom reporting

Quarry modeled a data collection template on one of the global brand’s most successful fighting game franchises that had developed the most mature data collection infrastructure over the years. Basing the data collection templates off of this title allowed Quarry to produce a blue sky boilerplate for data collection that ensures maximal and consistent data for all new titles from day one.

Quarry developed a boilerplate container for Google Tag Manager,  incorporating every tag and piece of infrastructure, along with additional best practices.

This container could then be used for every product marketing site upon its launch and – most importantly –  retroactively applied to existing sites. This approach expedited the process of data collection for market entry, ensuring standardization of data across all properties.

This container can be thought of as a sort of “Git repository” that acts as a monorepo for the organization’s data collection instrumentation across all product marketing sites. Whenever a change or update was needed (i.e. a team in Europe requiring a new vendor tag), Quarry would add the new tag to this existing boilerplate and distribute it across all marketing sites. This ensured uniform updates with minimal effort, providing a global solution rather than isolated site-specific adjustments.

Quarry replicated this approach for server-side Google Tag Manager, which the organization hadn’t adopted before, and Quarry recommended its implementation as a best practice. Developing a similar boilerplate for server-side Google Tag Manager, produced the same benefits as its client-side counterpart.

Emphasizing a “maximal collection” approach to ensure data availability for any of marketing’s future requirements, we aimed to gather as much data as possible from each marketing site.

Quarry also overhauled the data schema in these containers for better organization, tidiness, and standardization. This made maintenance easier over time and ensured consistent data collection across all containers.

With a global data schema in place, Quarry created runbooks outlining specific best practices for data collection implementation across the organization. 

Additionally, Quarry developed a Standard Operating Procedure (SOP) for integrating data collection into the software development lifecycle. This SOP aimed to eliminate blind spots and oversights by incorporating data collection planning early in the development process.

Another key aspect of this project was creating custom reports for various teams to monitor their specific KPIs, marketing efficiencies, and campaign performances. These reports combined custom GA4 and Looker Studio reports. Given GA4’s limitations for non-technical team members, we often exported data to Looker Studio for a better user experience and easier report adjustments by clients and contributors.

A screenshot of a Google Tag Manager container import showing 27 tags, 24 triggers, 53 variables, and 7 templates.
The import of the client-side Google Tag Manager container that was developed.

The Results:

  • Streamlined data collection process
  • Uniform data standardization and improved measurement
  • Enhanced data privacy compliance

This new approach to data collection significantly reduces the costs of engineering and maintenance, particularly over time. 

There’s an 86% reduction in time spent on initial build and launch—what previously took 15 hours now takes just 1-2 hours with the new boilerplate process, now streamlined to a few simple steps. Importing with a few clicks, setting vendor-specific keys in the container, and then deploying it. 

This process, akin to infrastructure-as-code in engineering or DevOps, stands in stark contrast to the previous method where each vendor, tag, and variable was manually set up.

Data is now uniformly standardized across the organization’s entire product portfolio. While the business value of this standardization is hard to quantify, it offers significant benefits. It enables consistent measurement across different product marketing sites, facilitating direct comparisons and combined data analysis for effective A/B testing or apples-to-apples comparisons.

Measurement efficiency is dramatically improved, benefiting from standardized data and streamlined processes.

There’s also a significant benefit to data privacy compliance, a crucial factor for a global organization. 

Previously, compliance was managed manually, increasing the risk of human error. The new automated data collection instrumentation pipeline ensures compliance from the start, reducing the risk of fines from entities like the EU for data privacy violations. Data privacy is thoroughly integrated, offering significant risk management and predictability in data results moving forward.

Quarry is a bolt-on product and technology department for your organization, dedicated to crafting great digital products and experiences that bring real, measurable benefits. 
Reach out to us now to kickstart your project and see results.

Make the connection

Discover how Quarry's unique blend of design, technology, strategy, service, and economy can grow your digital product.

Learn More