Database and Decision Support – Retail
Challenge
RET is one of the top 10 companies in the product category that it sells. RET did not previously utilize a sophisticated near real-time reporting or querying tool set for sales, marketing or inventory management. The company promotes a wide range of products to both businesses and consumers within different lines. RET was spending vast amount of resources on manually creating trends based on dated static reports. This client did not use advanced analytics to design and deploy campaigns.
Solution
RET engaged Data Square to build a solution that would improve customer intelligence programs and capabilities by providing a single integrated database with reporting and campaign enhancement capabilities. Data Square used d2MDb to design and develop the MDb, which is a marketing database that integrates disparate data sources into a centralized repository that is optimized for reporting, analytics and campaign enhancement. In addition to detail-level views, the solution was designed to present critical data in a pre-summarized format to enable analytics, queries and ad-hoc reporting.
Results
The solution enabled the company to realize benefits in several key strategic areas including a 3% gain in customer retention (CRG); 11% increase in customer acquisition (CAG); 5% gain in net agreements; 10% gain in transaction amount; and 26-32% reduction in idle inventory.
