Restricted Access
Incorrect password. Try again.
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 | 73 | −9 |
| Repeat purchase | 38% | 30% | −8pp |
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.
| Product Category | 2024 Conversion | 2025 Conversion | Change | 2025 Revenue Growth |
|---|---|---|---|---|
| Skincare | 24% | 16% | −8pp | 0% |
| Cosmetics | 24% | 21% | −3pp | +5% |
| Personal care | 23% | 22% | −1pp | +7% |
Skincare shows the sharpest conversion decline and flat revenue growth — the category most worth investigating first.
| 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 |
| Skincare Experience Attribute | 2024 Satisfied | 2025 Satisfied | Change |
|---|---|---|---|
| Ease of identifying a suitable product | 64% | 43% | −21pp |
| Clarity of product benefits | 61% | 42% | −19pp |
| Availability of personalised advice | 58% | 39% | −19pp |
| Overall value for money | 57% | 44% | −13pp |
| Price competitiveness | 65% | 63% | −2pp |
| Product quality | 78% | 76% | −2pp |
| Area | BeautyCo | Competitor or Market Signal |
|---|---|---|
| Headline skincare prices | Broadly comparable with major competitors | Limited change in market-level prices |
| Product information | Mainly ingredients, features and new-product information | Greater use of benefit explanations, routines and skin-concern guides |
| Skincare bundles | Available for selected products | Mix-and-match and routine-based bundles became more common |
| Samples and loyalty benefits | Selected samples and standard loyalty points | More frequent samples and bonus-point campaigns |
| Personalised advice | Available, but not consistently promoted or accessible | Short consultations and digital product finders increasingly promoted |
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 73→80 · Repeat purchase 30%→35% · Stock-out rate 14%→<8%.
Final insight: Traffic was not the problem. Conversion capability was the problem.