Case study

Cloud-based Vertica Analytics Platform underpins most advanced AI retail promotion solution

Challenge

Today’s retail promotions often take a scattergun approach. They are unrelated to consumer’s needs, tend to over-discount and, as a result, replace planned purchases. Nielsen, the leading global measurement and data analytics company, estimated in 2016 that 59 percent of retail promotions fail to break even.

There is a growing trend for consumers to seek a more personalized service and to engage with companies that truly understand their needs and expectations. SO1 works with leading retailers around the world to provide this. Stephan Visarius, Director Customer Acquisition and Success for SO1, explains: “Our Artificial Intelligence (AI)-based solution delivers precisely this personalized promotion experience through a fully autonomous and self-learning promotion platform that efficiently influences individual purchase decisions. It flexibly adapts to our retail customer’s financial goals, and scales to millions of individual consumers’ needs.”

The AI engine is fully automated to minimize retailer’s complexity: looking into past history of customer purchases it can automatically identify products from bar codes and extract about 800 latent attributes per product – to correlate these with purchasing decision factors such as individual consumer preferences, willingness to pay, and buying intention.

The result is a personalized offer designed to meet a particular business goal for the retailer, be it revenue, customer satisfaction, churn avoidance, and increase in loyalty or profit. The promotions are delivered multi-channel, and could consist of recommendations, discounts, or brand promotions.

The key to success is the volume of data the SO1 solution processes. AI and machine-learning capabilities thrive on data. The more consumer data can be analyzed, the more accurate the promotional output will be. With retail customers ranging in size from 300 to 3,000 stores, the data analyzed through SO1 quickly runs into the Terabytes.

Andrei Strugaru, VP Engineering at SO1, comments: “A cloud environment gives us the flexibility and scalability we need to process the large data volumes. We used another data analytics product, but this was not compatible with Azure, which we decided to adopt as our cloud platform.”

Solution

With thousands of queries stored in the old solution, it was important for SO1 that any transition to a new analytics product be easy. They also wanted a stable and high-performance solution with straightforward management and administration, capable of dealing with large data volumes.

SO1 evaluated Vertica’s Community Edition (CE), which lets customers store and analyze up to 1TB of structured and semi-structured data for free, with no time limit. It gave SO1 the opportunity to test Vertica in the Azure environment. Azure is a neutral cloud provider with high security standards, and high availability with an SLA-backed uptime of 99.9%.

Mr Strugaru on the decision for Vertica: “From a technical perspective, there is plenty of research available to demonstrate scalability and robustness. Vertica’s standard SQL-support greatly simplified our transition. Amazingly, it only took a day to adapt our code base and port the whole pipeline with thousands of SQL code queries to Vertica. Even without any optimization, the query performance was comparable to before. Great documentation helped us set up a straightforward and stable cluster. We also felt reassured by the commercial support behind the platform.”

Since completing this migration, Vertica is now the centralized data repository for SO1’s solution. All retail customer data is uploaded to Azure, and then processed into Vertica. From there, Vertica integrates with a number of frontend Business Intelligence (BI) applications for advanced descriptive analytics and analyst reporting. Using Vertica as the engine behind these BI applications is critical to support the increasing demand for complex analysis required by the retailer managers. Vertica allows them to use their preferred visualization tool out of the box, without compromising underlying analytical performance.

Customer and product data stored in Vertica is also used to build accurate machine learning models, which are fed into AI solution to create the most compelling offers automatically. Leveraging a high-performance columnar database as their data repository allowed SO1 to increase productivity of machine learning model building by accelerating the upfront, time-intensive tasks of data analysis and preparation using simple SQL functions across large parts of their data processing pipeline. After the data is processed and prepared in Vertica, AI models are optimized externally. Final results are fed to scoring engines within the solution so customers can interact with the information in real time.

Results

SO1’s algorithmic learning improves over time, as Mr Visarius explains: “One of our leading retailers introduced a new loyalty card in its stores and asked us to provide users with 8 individual promotions per shopping trip. In the first week, we already hit a 42 percent conversion rate of these offers, while applying 22 percent average discounts. After 40 weeks, the average discount had dropped to 13 percent, and the offer conversion rate increased to 60 percent. It is very easy to demonstrate the ROI of our solution.”

As a key part of the SO1 technology stack, Vertica helps make these compelling offers a reality for retailers around the world. Mr Visarius concludes: “Our business is all about personalization; how do we move from segments of many to a segment of one? Leveraging Vertica’s integration capabilities, unparalleled scalability, and high performance, we have delivered an automated end-to-end solution which runs autonomously and requires little to no manual effort.”

How can Micro Focus help you to succeed?

SO1 case study

release-rel-2020-9-2-5123 | Tue Sep 15 18:06:14 PDT 2020
5123
release/rel-2020-9-2-5123
Tue Sep 15 18:06:14 PDT 2020