The Challenge
When a shopper's preferred national brand yogurt is out of stock, the retailer's system should do one thing: show them the own-brand equivalent. In a dairy category where private label gross margins run 12 to 16 percentage points higher than national brand equivalents, that moment of substitution is one of the most commercially valuable interactions in the category. A large European grocery retailer was consistently failing to capture it.
The retailer had set a strategic target of increasing private label penetration across dairy, covering yogurt, cream, butter, and soft cheese, where private label share sat 9 percentage points below the company's own internal benchmark. The intent was clear. The operational visibility was not. When a national brand product went out of stock, the substitution module typically offered another national brand. Where an own-brand equivalent existed, it was often linked incorrectly or absent from the substitution flow entirely. Category reviews addressed the topic quarterly, based on manual comparison of sales reports, and produced a map of national brand / private label relationships that was 40% incomplete and wrong in roughly 30% of cases where links did exist.
European grocery retailers with strong private label programmes consistently outperform on gross margin by 3 to 5 percentage points at the category level. Private label penetration in European dairy ranges from 45% to 65% across markets, well above where this retailer was positioned.
The Solution
Zenline's Substitutes Agent analysed the full dairy range, approximately 1,400 active SKUs, to build a complete national brand / private label equivalence map based on the attributes that actually drive shopper substitutability: fat content, base ingredient, format, texture, pack size, and price tier.
What the Agent did:
- Built a full national brand / private label relationship graph across all dairy sub-categories
- Identified national brand SKUs with no private label equivalent, ranked by sales volume to produce a prioritised development target list
- Detected and corrected wrong links in the existing substitution and recommendation modules, and flagged private label products absent from all recommendation surfaces despite having a credible national brand match
- Enabled one-click review for low-confidence pairs; high-confidence matches published automatically into the recommendation layer
What it found:
- 43% of national brand SKUs in the top-selling yogurt and cream sub-categories had no private label equivalent in the range
- 31% of existing private label links in recommendation modules were incorrect at the attribute level
- The top 12 national brand SKUs with no private label alternative represented €4.2 million in annual revenue, a direct map of where development investment would have the greatest return
The Impact
- Private label penetration in dairy increased by 6.3 percentage points within the 12-week pilot period
- Private label average selling price in yogurt increased 4.8%, as shoppers given a credible like-for-like comparison evaluated own-brand on quality rather than defaulting to lowest price
- Category gross margin improved by approximately 2.2 percentage points
- Substitution acceptance rate at out-of-stock moments increased by 34% versus the prior period
- The prioritised target list of 12 national brand gaps was adopted directly as the private label development roadmap for the following financial year
"We knew private label was underleveraged in dairy. What we didn't know was exactly where: which national brand products had a gap, which private label links on site were wrong, and where we were actively sending shoppers away from our own brand. Having that map, ranked by volume impact, changed how we run category planning entirely."
— Category Director, Chilled & Dairy, European Grocery Retailer
Manual national brand / private label mapping at SKU level is a significant effort across 1,400 products, requires continuous maintenance, and produces a static snapshot outdated by the next range review. The Substitutes Agent converts data into a continuously maintained data layer. A corrected recommendation module improves private label conversion in a week.