Migrated 3.6 billion customer data points for a fortune 500 leader in grooming products
Migrated 3.6 billion customer data points for a fortune 500 leader in grooming products
Data migrations

Problem

Our client, a Fortune 500 company, and a global leader in men’s grooming products, faced the following challenges.

  • The client had a hard deadline of three months to complete the migration from the legacy marketing automation platform to a nimbler mobile-first marketing platform.
  • All the marketing data (historical & recurring) of the client were from different data sources and funnelled by Kafka systems
  • The company wanted to push all the data to the new platform by converting from various formats to supported format

Solution

  • Lister underwent detailed discovery workshop to understand client’s use-cases and their data sources
  • We created a detailed design document to decide on how to deal with different data sources.
  • We defined each data source and mapped the relevant attributes to the respective data types.
  • We laid out a comprehensive data migration plan, outlining the following details: how to handle every kind of data, what is the volume, frequency of load and how to store it.
  • Lister then created a nimble AWS solution, using AWS S3, AWS glue, Python, AWS Lambda, to transform and load data.

Outcomes

  • We migrated about 3.6 billion data points within one month.
  • The client went live with the new platform before the hard deadline.
  • Since we launched campaigns with effective segmentation and personalization, the open rate was improved by 4% and the CTR by 2%.
Testimonial
Director, Email Marketing and CRM of a big American sports league

“I have worked with Lister for over a year, and they have proven to be an asset to our team. We have relied heavily on their services for a huge Email Service Provider migration, including both data transfers and campaign setups. Through this, I have found them to be extremely knowledgeable in not only email production but also data and technology needs.

Director, Email Marketing and CRM of a big American sports league
Sr. Director, Marketing Data & Technologies, Fortune 500 Retailer

“Congratulations, Team! As I look back, I feel proud of our accomplishment as a team. You are incredibly dedicated and accountable team members that I love to work on new projects again.”

Sr. Director, Marketing Data & Technologies, Fortune 500 Retailer
VP, Digital Experience, Global of a Fortune 500 software company

Thanks, Lister Team. Fantastic work so far. We had a review with the marketing leadership last week and showed the massive amounts of work done and was well received.

VP, Digital Experience, Global of a Fortune 500 software company
Director, Email Marketing & CRM of big American sports league

"I have worked with Lister for over a year, and they have proven to be an asset to our team. We have relied heavily on their services for a huge Email Service Provider migration, including both data transfers and campaign setups. Through this, I have found them to be extremely knowledgeable in not only email production but also data and technology needs.

Director, Email Marketing & CRM of big American sports league