Häagen-Dazs

The challenge

Automate a manual reporting process, streamline data from different sources, and create 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.

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.