Download PDF
Alteryx > Case Studies > Test and Control: Solution Development
Alteryx Logo

Test and Control: Solution Development

Technology Category
  • Analytics & Modeling - Predictive Analytics
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Retail
Applicable Functions
  • Business Operation
  • Sales & Marketing
Use Cases
  • Demand Planning & Forecasting
  • Predictive Replenishment
Services
  • Data Science Services
The Challenge
Delhaize America, a part of Delhaize Group with food supermarkets in 6 countries, was spending $1.5M/week on Sunday flyers. The company wanted to test the effectiveness of these flyers and determine whether they were providing a return on investment. The challenge was to conduct a test in a market representative of all Food Lion stores, where the test market would not receive a Sunday flyer. The company needed to understand the business reasons for the test, define criteria for success and failure, align on dates, stores, products that are involved, and identify blackout periods and other business initiatives that could potentially impact the test or control results.
About The Customer
Delhaize America is part of the Delhaize Group, which operates food supermarkets in six countries. Delhaize America itself consists of three banners with over 1,500 food supermarkets. The company's Consumer Insights team is tasked with delivering and driving the voice of the consumer throughout the organization by providing actionable insights. The Shopper Insights sub-team delivers insights based on transaction and customer level data, supporting the analytical needs of various departments including strategy, marketing, pricing, category management, merchandising, finance, and legal.
The Solution
The company decided to use Alteryx to create a comprehensive test and control environment. The process involved meeting with business owners to understand the reasons for the test and define criteria for success and failure. Stores to be excluded from the test were identified, such as those with high sales volatility or competitive events. Test and control stores were matched based on a number of metrics, with the goal of having test and control stores close to each other. The test was then performed and the results evaluated. Alteryx was used to generate individual reports for each metric analyzed, and some control stores required additional inspection. The results were then presented to the business owners.
Operational Impact
  • The company was able to effectively test the impact of discontinuing the Sunday flyer in a representative market.
  • The use of Alteryx allowed for a comprehensive analysis of the test and control stores, providing detailed reports for each metric analyzed.
  • The process allowed for the identification and exclusion of stores that could skew the results due to high sales volatility or competitive events.
Quantitative Benefit
  • The company identified potential cost savings by discontinuing the Sunday flyer in certain areas.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.