Example Output
Here is what Claude produces when you use this skill with sample data.
**Funnel Analysis — Beauty/Skincare DTC:**
| Stage | Count | Step Rate | Cumulative | Benchmark | Gap | Priority |
|-------|-------|-----------|-----------|-----------|-----|----------|
| Homepage | 95,000 | — | 100% | — | — | — |
| PDP Views | 33,000 | 34.7% | 34.7% | 40-45% | -5 to -10pp | HIGH |
| Add to Cart | 2,640 | 8.0% | 2.8% | 9-11% | -1 to -3pp | HIGH |
| Checkout | 1,585 | 60.0% | 1.7% | 62-68% | -2 to -8pp | MEDIUM |
| Purchase | 1,030 | 65.0% | 1.1% | 68-75% | -3 to -10pp | MEDIUM |
**Overall conversion: 1.08%** (benchmark for beauty DTC: 1.8-2.5%)
**Estimated monthly revenue (at $85 AOV): $87,550**
**Revenue Impact of 10% Improvement at Each Stage:**
| Stage | If +10% relative | Additional Purchases | Revenue Impact |
|-------|------------------|---------------------|---------------|
| Homepage → PDP | 34.7% → 38.2% | +106 purchases/mo | +$9,010/mo |
| PDP → ATC | 8.0% → 8.8% | +103 purchases/mo | +$8,755/mo |
| ATC → Checkout | 60.0% → 66.0% | +103 purchases/mo | +$8,755/mo |
| Checkout → Purchase | 65.0% → 71.5% | +67 purchases/mo | +$5,695/mo |
**#1 Biggest Opportunity: Homepage → PDP (34.7% vs. 40-45% benchmark)**
This is your largest leak. For every 100 visitors, only 35 even look at a product. You are losing ~5,000-10,000 potential PDP views per month at the very top. Beauty/skincare benchmarks show 40-45% of homepage visitors should reach a PDP. The gap represents $9K-$18K/month in unrealized revenue.
**Quick Wins (this week):**
1. Add a "Best Sellers" or "Shop by Concern" section above the fold on homepage — reduce decision paralysis by curating entry points (expected +3-5pp)
2. Make hero CTA link to a specific collection, not a generic "Shop Now" to a cluttered catalog page
3. Add "As seen in" press logos or UGC carousel to the homepage hero — beauty shoppers need social validation before browsing
**Strategic Improvements (this quarter):**
4. Implement quiz-based navigation ("Find your routine in 60 seconds") — skincare quizzes convert 3-5x better than generic browsing
5. Personalize homepage based on traffic source: paid social visitors see trending products, returning visitors see "continue browsing" with their last-viewed items
**#2 Priority: PDP → Add to Cart (8.0% vs. 9-11% benchmark)**
Quick wins:
1. Add ingredient spotlight with benefit callouts (beauty shoppers research ingredients heavily)
2. Show "X people bought this in the last 24 hours" social proof on PDP
3. Add before/after photos or short video demos — increases ATC rate by 20-30% in skincare
**#3 Priority: Checkout → Purchase (65.0% vs. 68-75% benchmark)**
Quick wins:
1. Add trust badges (SSL, secure payment icons) directly above the payment form
2. Show a clear "Free returns within 30 days" guarantee at checkout — reduces purchase anxiety
3. Add express checkout (Apple Pay, Shop Pay) — reduces friction for mobile users
**Summary Action Plan:**
| Priority | Stage | Current | Target | Tactic | Expected Revenue |
|----------|-------|---------|--------|--------|-----------------|
| 1 | Home → PDP | 34.7% | 40% | Best-sellers above fold + quiz | +$12K-$15K/mo |
| 2 | PDP → ATC | 8.0% | 9.5% | Social proof + video | +$6K-$8K/mo |
| 3 | Checkout → Purchase | 65.0% | 70% | Trust badges + express pay | +$4K-$5K/mo |
| **Total** | | | | | **+$22K-$28K/mo** |
If you hit all three targets, overall conversion moves from 1.08% to ~1.7%, and monthly revenue increases from $87,550 to ~$112K.
