Lister's data model was able to handle 45 million customer preferences information of daily data without any issues.
Lister's data model was able to handle 45 million customer preferences information of daily data without any issues.
Data modeling

Problem

A US-based convenience store giant wanted to bring the preference data of customer onto the Responsys platform. The daily data feed is about 45 million with a one-to-many relationship. The marketing platform was unable to handle a huge volume of data for segmentation as it had to scale the whole table for result-set.

Solution

  • Lister conducted detailed data discovery sessions with the client data team to understand pain points.
  • We revamped the data model to handle a daily preference feed of 45 million
  • Lister set up an internal job to make sure only required data is filtered out on daily basis and loaded into temporary table
  • The temporary table is truncated and loaded on daily basis for optimized segmentation instead of the whole raw table

Outcomes

  • Lister's data model was able to handle 45 million customer preferences information of daily data without any issues.
  • The result set for segmentation was now generated in seconds
  • No campaign launch was delayed due to effective data model and segmentation
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