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:
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