Automating a manual reporting process, streamlining data from different sources, and creating best practices for tracking and evaluating key metrics across franchise stores
Häagen-Dazs franchise owners and business managers relied on time-consuming, manually created spreadsheets from different data sources for tracking and reporting store performance. They needed more accurate, timely, and automated reporting in an accessible format.
Client
Häagen-Dazs
Services
Industry
Retail
↓ time
Less time spent on manual work
↓ errors
Reporting process resulted in fewer errors
What we did
- Performed a deep-dive discovery to understand how Häagen-Dazs runs business with franchise stores and the systems they use.
- Mapped out data formatting differences between three systems, cleaned up the data, and developed governance best practices for the future.
- Enabled a no-dev solution that pulls Häagen-Dazs-only sales data from co-branded shops.
- Designed a business metrics dashboard for managers and franchisees to access via HDScoops, an internal app for training, operations, and communications.
- Developed a series of calculations and algorithms that highlight when stores are meeting goals or need improvement for each KPI.
Outcomes
We improved the existing app and reporting process with less time spent on manual work resulting in fewer errors. Our client said, “Overall, I’ve had positive feedback from both shops and corporate team members… it’s a great way to evaluate the “wins” and “opportunities” from the previous month and then create a plan to improve.”

Every project started with a conversation.
Let’s talk
More work like this

.webp)



