Download PDF
Alteryx > Case Studies > Quantitative Marketing & CRM Enablement
Alteryx Logo

Quantitative Marketing & CRM Enablement

Technology Category
  • Analytics & Modeling - Data-as-a-Service
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Retail
Applicable Functions
  • Business Operation
  • Sales & Marketing
Use Cases
  • Predictive Maintenance
Services
  • Data Science Services
  • System Integration
The Challenge
Sally Beauty, a global retailer with 3,673 stores worldwide, was facing challenges with its customer relationship management (CRM) and marketing analytics. The company's reporting was done in Access and Excel, and the transactional and customer data was not in a central location. The sales/transactional data was pulled from an application that did not support ad hoc reports and was no longer supported by IT. The company relied on IT to pull flat files for customer level analysis, which took days to weeks. Campaign data was not stored for performance trends or historical view, and month-end reporting took 2-3 weeks to pull all data and analyze.
About The Customer
Sally Beauty is a global retailer with 3,673 stores worldwide. The company's top categories include hair color, hair care, and appliances. Its customers include professional stylists and retail consumers. The company has 12 million active loyalty members. The Marketing Database and Analytics Manager at Sally Beauty has been with the company for 4 years and has over 6 years of experience in the marketing industry. The majority of her experience is in channel (email, direct mail, and digital) marketing and customer insights.
The Solution
Sally Beauty implemented Alteryx, a leading platform for self-service data analytics, and Tableau for data visualization. Alteryx was used for reusable monthly reporting workflows, demographic data, predictive tools, and complex ad hoc data analysis. 60% of monthly reports were built in Alteryx for reusable workflows, including customer migration reports, channel reports, and loyalty member metrics. Reporting time was cut in half and complicated ad hoc data questions could be answered in hours, not days. Tableau was used for dashboards, data visualization, and simple ad hoc questions. The dashboard gave the leadership team the ability to track results and customer groups easily. Visualization showed trends that weren't seen on a flat spreadsheet and allowed non-data people to answer their data questions.
Operational Impact
  • The implementation of Alteryx and Tableau has significantly improved Sally Beauty's reporting and analytics capabilities. The company is now self-sufficient and no longer needs to rely on IT to pull flat files. The reporting time frame has been cut in half and the company can answer complicated ad hoc data questions in hours, not days. The company can also output finished reports and does not have to build a report in one tool and polish it in another.
  • The use of Tableau has provided the leadership team with the ability to track results and customer groups easily. Visualization has revealed trends that were not seen on a flat spreadsheet and has allowed non-data people to answer their data questions.
  • The company has also been able to enhance its marketing data sciences capabilities. It has used demographic analysis tools to append ethnicity, occupation, hobbies and interests, and household information to its customer data. This data, along with 24 months of transactional data, was used to identify different and distinct clusters of customers. Personas were developed around the clusters to identify the key characteristics/differences of each cluster. This has enabled various cross/up sell, retention, and lifecycle modeling to be done at the cluster level.
Quantitative Benefit
  • The reporting time frame has been cut in half.
  • Month end reporting now takes 5-7 business days, down from 2-3 weeks.
  • An estimated 1.5% growth on monthly revenue from converting one-time customers into multiple time buyers.

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.