A premium beauty and skincare retailer with 18 physical stores, an e-commerce platform, a loyalty programme and heavy investment in acquisition marketing. Traffic is growing strongly — but revenue is nearly flat, and conversion, satisfaction and repeat purchase are all declining. Why isn't increased traffic translating into stronger outcomes, and what should BeautyCo do next?
BeautyCo is a premium beauty and skincare retailer operating across 18 physical stores plus an e-commerce platform.
Traffic is growing strongly, but:
"Why is increased traffic not translating into stronger business outcomes, and what should BeautyCo do next?"
| KPI | 2024 | 2025 | Change |
|---|---|---|---|
| Footfall | 220,000 | 282,000 | +28% |
| Revenue | $4.8M | $5.0M | +4% |
| Conversion | 24% | 18% | −6pp |
| CSAT | 82 | 71 | −11 |
| Repeat purchase | 38% | 29% | −9pp |
Performance is not uniform — this is the kind of variation Colab or Sheets analysis should surface in Templates 2 and 4.
| Store | Traffic YoY | Revenue YoY | Conversion |
|---|---|---|---|
| Orchard | +18% | +3% | 18% |
| Vivo | +22% | +5% | 19% |
| Bugis | +28% | +2% | 16% |
| Tampines | +11% | +10% | 23% |
| Jurong | +15% | +8% | 22% |
| Northpoint | +9% | +9% | 24% |
The highest-traffic stores (Bugis, Vivo, Orchard) have the lowest conversion — traffic growth is not the constraint.
| Store | Stock-Out Rate |
|---|---|
| Orchard | 14% |
| Vivo | 16% |
| Bugis | 17% |
| Tampines | 8% |
| Jurong | 9% |
| Northpoint | 7% |
| Store | CSAT |
|---|---|
| Orchard | 70 |
| Vivo | 68 |
| Bugis | 66 |
| Tampines | 79 |
| Jurong | 76 |
| Northpoint | 80 |
The same stores — Orchard, Vivo, Bugis — show the highest traffic growth, the lowest conversion, the highest stock-out rates, and the lowest CSAT. Tampines, Jurong and Northpoint (lower traffic growth) show the opposite pattern across all four metrics.
| Theme | Mentions |
|---|---|
| Product unavailable | 312 |
| Long waiting time | 205 |
| Poor consultation | 184 |
| Loyalty benefits weak | 122 |
| Competitor | Initiative | Result |
|---|---|---|
| GlowLab | AI Skin Diagnostics | Conversion +29% |
| SkinStudio | Subscription Model | Retention +24% |
| BeautyHub | Omnichannel Fulfilment | Revenue +15% |
| Trend | 2024 | 2025 |
|---|---|---|
| Research before purchase | 48% | 69% |
| Expect personalization | 55% | 73% |
| Loyalty usage | 46% | 68% |
| Abandon due to stock-out | 18% | 35% |
Diagnosis: Traffic generation is not the primary issue — conversion capability is. Three root causes are confirmed with high or medium confidence: Service Capacity Constraints (High), Inventory Availability Issues (High), Loyalty Programme Weakness (Medium).
Recommended option: Integrated Service + Inventory Improvement — fix conversion capability before driving more traffic.
90-day initiatives: Service Capacity (workforce scheduling, queue management, advisor training) · Inventory Availability (inventory forecasting, automated replenishment, stock visibility) · Loyalty Enhancement (personalized promotions, AI-assisted recommendations, tiered rewards).
Targets: Conversion 18%→22% · CSAT 71→80 · Repeat purchase 29%→35% · Stock-out rate 14%→<8%.
Final insight: Traffic was not the problem. Conversion capability was the problem.