Alteryx Case Studies Test and Control: Solution Development

Edit This Case Study Record

	Test and Control: Solution Development Alteryx

Test and Control: Solution Development

Alteryx

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Retail
Applicable Functions	Sales & Marketing Business Operation
Use Cases	Predictive Replenishment Demand Planning & Forecasting
Services	Data Science Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Retail

Applicable Functions

Sales & Marketing

Business Operation

Use Cases

Predictive Replenishment

Demand Planning & Forecasting

Services

Data Science Services

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 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.

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.

Impact #1	The company was able to effectively test the impact of discontinuing the Sunday flyer in a representative market.
Impact #2	The use of Alteryx allowed for a comprehensive analysis of the test and control stores, providing detailed reports for each metric analyzed.
Impact #3	The process allowed for the identification and exclusion of stores that could skew the results due to high sales volatility or competitive events.

Impact #1

The company was able to effectively test the impact of discontinuing the Sunday flyer in a representative market.

Impact #2

The use of Alteryx allowed for a comprehensive analysis of the test and control stores, providing detailed reports for each metric analyzed.

Impact #3

The process allowed for the identification and exclusion of stores that could skew the results due to high sales volatility or competitive events.

Benefit #1	The company identified potential cost savings by discontinuing the Sunday flyer in certain areas.

Benefit #1

The company identified potential cost savings by discontinuing the Sunday flyer in certain areas.

Download PDF Version

Overview

Test and Control: Solution Development

Operational Impact

Quantitative Benefit