Corios recently helped a client transform their customer analytics database from a virtually unusable resource into one that is agile, responsive and fast, making it a highly valuable asset for the business to drive more effective and profitable campaigns.
Challenge
Our client had developed a large customer database containing more than 10 million active credit card accounts and billions of records of detailed transactions. The database platform included specialized functions for customer analytics, including customer value calculation and opportunity identification. However, using these analytics functions to design and execute marketing campaigns took more than a day to run. This is because the customer analytics literally required an average 26 hour run time each time they needed to refresh the database or add a new group of customer records. The database platform wasn’t optimally designed or executed, and required movement of data to multiple places, rather than only leverage their data appliance.
As a result, this condition made the customer analytics platform virtually unusable by the marketing analytics team, and this potentially valuable asset sat mostly idle. When we started working with our client, this platform was composed as a hybrid of a legacy database and a set of sophisticated analytics functions that ran as separate and distinct processes. The client and Corios team agreed this was the source of the challenge. The client had the opportunity to move this entire process into a modern data appliance, but lacked the capabilities and knowledge to do so without advisory, design and build assistance.
Read More