We use cookies. You have options. Cookies help us keep the site running smoothly and inform some of our advertising, but if you’d like to make adjustments, you can visit our Cookie Notice page for more information.
We’d like to use cookies on your device. Cookies help us keep the site running smoothly and inform some of our advertising, but how we use them is entirely up to you. Accept our recommended settings or customise them to your wishes.
×

Major Theme Park Entertainment Company Transforms its customer data ecosystem on AWS​

Challenge

A major theme park entertainment company sought to build a 360-degree view of its guests to gain more insights in order to drive personalized marketing campaigns. The brand wanted to integrate guest data from disparate marketing systems and transform the guest view from transaction-centric to person-centric. Additionally, the theme park's data quality only gave an acute view of their guests with only fractioned pieces of information being provided by their systems. Previous attempts to create such a 360-degree view was met with limited success due to lack of scalable, highly performant, and economic computing platform.  

Approach

Merkle and the themes park entertainment company mutually concluded that Amazon Web Services (AWS) would be the ideal platform to build the proposed solution. AWS provides fully managed storage, computing, and analytics services on its platform, thereby resulting in faster time to value, and ease of development.  

Merkle helped the themes park entertainment company integrate the park's guest data, transactions and interactions on an AWS-based, cloud-native solution while enabling its data science team to segment guests more granularly to create personalized offers. 

As part of this, Merkle developed a marketing data platform on AWS that allowed the theme park company to ingest guest data from multiple source systems, resolve guest identity across systems and link them together. The cloud-based environment served as the focal point for data consumption by various theme park company teams to understand guest activity and experience in the park, to segment guests for marketing purposes, import marketing lists into a campaign tool for personalized offers, and for deriving analytical insights such as guest propensity to visit the park, perform certain activities, etc. 

Further, to enhance existing data quality, Merkle generated global unique identifiers for guests, standardized and cleansed all PII information through various different Merkle proprietary tools under its Merkury suite of products. Having a global identifier attached to each guest allowed the park to link the guest activity across disparate systems and generate insights which were previously not possible. 

Merkle also leveraged its data asset called Data Source for reverse email and phone appends to create a more complete PII profile of an individual. Data Source also helped enrich the PII profile with demographic elements which were previously not available to the themes park entertainment company, such as age, household income, number of children in the household, etc. These additional elements provide important information to marketers to granularly segment the audiences for personalized campaigns.

Merkle used the following services from AWS services to build the solution:

  • Redshift: Cloud based database to build and host guest 360 view 

  • AWS Elastic Computing Cloud: Compute machines to build Python based data pipelines using Merkle proprietary Data Loading Framework (DLF) 

  • AWS Simple Storage System: Landing area for raw data acquired from disparate source systems 

  • Elastic Container Service: Airflow containers for orchestration of data pipelines 

  • Relational Database Service: Postgres database to store metadata from Airflow and Microsoft SQL Server for data pipeline metadata 

Results

150M

records were processed from 15 different raw feeds  

10M

records were enriched with additional demographic attributes 

20M

Ability to analyze 20M identified guests on an annual basis 

MVP

deployed to production in 3 months

Keys to success

Integrating guest transactions and ticketing data to develop Guest 360 view on AWS
Enabling personalized campaign capabilities in a flexible, nimble, scalable, high-performing Cloud environment
Rapid deployment to enable media and CRM teams with faster time to value
Focus on business-critical use cases for Minimum Viable Product (MVP)
Continuous enhancements to MVP over time for additional features and functionalities

Discover how we did it. Contact us today.