Skip to content

takechanman1228/claude-ecom / skills/ecom

Ecommerce business review for D2C stores from order transaction CSVs. Runs the bundled Python engine (KPI trees, ~30 pass/watch/fail health checks, 30d/90d/365d windows), then interprets the results: either a full narrative business review written to REVIEW.md, or an inline answer to a focused question.

references/benchmarks.md

View on GitHub
# Vertical-Specific Benchmarks

This file contains pass/watch/fail thresholds, benchmark ranges, seasonal calendars, structural challenges, and strategy playbooks for six ecommerce verticals. Use the KPI tables to contextualize review findings by swapping in vertical-appropriate expectations for four high-variance metrics: Repeat Purchase Rate (repeat_purchase_rate), AOV, Discount rate (avg_discount_rate_trend), and Gross margin. Thresholds assume a typical ecommerce operator in a competitive market; apply additional modifiers for subscription, marketplace, dropship, luxury, or B2B business models. Modifier values are not yet codified and should be calibrated per engagement.

**Scope note:** This file covers four high-variance KPIs only. Customer acquisition cost (CAC) and LTV:CAC ratio are intentionally excluded; a store with low Repeat Purchase Rate but high per-order LTV (e.g., high-AOV electronics) may still be healthy when evaluated on a full-funnel basis. Do not use these thresholds as the sole basis for a pass/fail judgment without considering acquisition economics.

**Margin assumption:** Gross margin ranges for Fashion & Apparel and Beauty & Cosmetics assume brand-owned DTC operations, where the brand captures manufacturing-to-consumer margin. Multi-brand retailers, resellers, and marketplace sellers typically operate 10--20 pp lower; adjust thresholds accordingly.

**Discount rate methodology:** The discount rate KPI (avg_discount_rate_trend) measures the store's average realized discount rate across all orders in the review period -- not peak promotional markdown depth during events. Rationale sections reference peak event depths (e.g., holiday, BFCM) for context on consumer expectations, but these peaks are distinct from the year-round average that triggers pass/watch/fail.

---

## Fashion & Apparel

### KPI Pass / Watch / Fail Thresholds

| KPI | Pass | Watch | Fail |
|---|---:|---:|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | >= 25% | 15%--24.9% | < 15% |
| AOV | >= $160 | $120--$159 | < $120 |
| Discount rate (avg_discount_rate_trend) | <= 20% | 20.1%--30% | > 30% |
| Gross margin | >= 50% | 40%--49.9% | < 40% |

### Rationale

Fashion has structurally higher gross margins than electronics or grocery, supporting a higher fail threshold. The discount rate pass threshold (<=20%) targets the year-round average realized discount; peak seasonal markdown depths run higher (mid-20% range for apparel during major deal events, with consumers trained to expect 30%+ during Black Friday), but a store whose annual average exceeds 20% is likely running always-on promotions rather than event-led discounting.

### Seasonal Calendar

- **Peak months:** Aug--Sep (back-to-school), Nov--Dec (holiday), plus smaller spikes around mid-summer mega-sale events.
- **Pre-season prep timeline:** Begin merchandising, inventory positioning, and creative production 8--12 weeks ahead of peak, as consumers start shopping earlier and the peak holiday window is short.
- **Markdown windows:** Late Nov--early Dec (BFCM/Cyber Week), late Dec--Jan (post-holiday clearance), and mid-summer eventing (July) used to reset seasonal inventory and drive cash conversion.

### Top Structural Challenges

- Seasonal inventory risk: wrong depth/size curves show up as stockouts in winners and long-tail overstock in losers, forcing deeper markdowns in clearance windows.
- Discount dependency and "promo-trained" customers: heavy reliance on sitewide promotions compresses gross margin and can still fail to move aged units if merchandising is weak.

### Recommended Strategy Playbook

- Use **assortment discipline + lifecycle merchandising**: plan hero SKUs, chase winners early, and separate "core continuity" from "seasonal risk" so markdowns are targeted rather than blanket.
- Replace always-on discounts with a **promo architecture**: fewer, clearer moments; tiered thresholds; and clearance segmentation, aligned to consumer expectations for deep-event periods without training constant waiting.
- Increase repeat purchase rate by designing a **second-order path**: post-purchase styling flows, "complete the look" bundles, and customer-specific recommendations to pull second purchase inside your attribution window.

### Benchmark Ranges

| Metric | Typical range for Fashion & Apparel |
|---|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | ~15%--30% |
| AOV | ~$150--$220 |
| Discount rate (avg_discount_rate_trend) | ~10%--25% (event peaks higher) |
| Gross margin | ~45%--60% |

---

## Beauty & Cosmetics

### KPI Pass / Watch / Fail Thresholds

| KPI | Pass | Watch | Fail |
|---|---:|---:|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | >= 30% | 20%--29.9% | < 20% |
| AOV | >= $120 | $80--$119 | < $80 |
| Discount rate (avg_discount_rate_trend) | <= 15% | 15.1%--25% | > 25% |
| Gross margin | >= 65% | 55%--64.9% | < 55% |

### Rationale

Beauty converts strongly and product margins are structurally high (often ~55%--80%), supporting an aggressive gross margin floor. Loyalty fragility in a crowded market makes personalization and CRM flows disproportionately important to lift repeat purchase rate.

### Seasonal Calendar

- **Peak months:** Nov--Dec (holiday gifting) and Jul (major marketplace promo events that pull forward demand); replenishment categories remain steadier year-round than fashion.
- **Pre-season prep timeline:** 6--10 weeks before peak, ensure giftability (bundles, sets, minis), sampling strategy, and landing pages are ready because shoppers start earlier and concentrate purchases into a short holiday window.
- **Markdown windows:** BFCM/Cyber Week, then targeted post-holiday offers for self-care/routine resets, plus mid-summer deal events that increasingly resemble "Black Friday in summer."

### Top Structural Challenges

- Loyalty fragility in a crowded market (high switching), making personalization, routine-building, and CRM flows disproportionately important to lift repeat purchase rate.
- Shade/formula mismatch risk: incorrect product selection (especially in color cosmetics and skincare) drives returns and erodes trust, making guided selling and education a conversion prerequisite.

### Recommended Strategy Playbook

- Implement **guided selling** (shade finders, skin-type quizzes, regimen builders) and emphasize education on PDP/PLP to reduce mismatch and increase confidence.
- Drive AOV via **routine bundles** (AM/PM kits), "complete the routine" cross-sells, and free-sample thresholds instead of deeper discounts.
- Build for repeat purchases with **replenishment timing** (reorder reminders calibrated to product lifespan) and subscription/auto-ship options where appropriate.
- Protect margin by using promotions strategically during peak deal windows and shifting value to gifts-with-purchase, exclusives, or bundles when possible.

### Benchmark Ranges

| Metric | Typical range for Beauty & Cosmetics |
|---|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | ~20%--40% |
| AOV | ~$80--$170 |
| Discount rate (avg_discount_rate_trend) | ~10%--20% (event peaks higher) |
| Gross margin | ~55%--75% |

---

## Food & Beverage

### KPI Pass / Watch / Fail Thresholds

| KPI | Pass | Watch | Fail |
|---|---:|---:|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | >= 40% | 25%--39.9% | < 25% |
| AOV | >= $65 | $50--$64 | < $50 |
| Discount rate (avg_discount_rate_trend) | <= 10% | 10.1%--15% | > 15% |
| Gross margin | >= 25% | 18%--24.9% | < 18% |

### Rationale

Grocery/food retail margin is structurally low (mid-20s gross margin, large grocers often in the low-20s), which means discounting and shipping subsidies quickly become existential. Basket sizes are generally lower than categories like home goods, with industry snapshots showing ~$69 AOV in Q1. The AOV pass threshold is set at $65 to avoid penalizing typical operators in a structurally low-basket category.

### Seasonal Calendar

- **Peak months:** Nov (holiday food events), Dec (gifting/entertaining), and early Feb (Super Bowl snacks/party food).
- **Pre-season prep timeline:** 4--8 weeks before each peak, lock supply, packaging materials, and fulfillment capacity; short peak windows plus higher shipping sensitivity makes operational readiness a conversion lever.
- **Markdown windows:** Concentrate promo depth around BFCM/Cyber Week and major event weeks; otherwise bias toward bundles/thresholds rather than deep percent-off, because margins are thin.

### Top Structural Challenges

- Shipping economics vs. low AOV: free shipping thresholds that are too low (or hidden fees) produce margin leakage.
- Underutilized retention mechanics (reorder/subscription): many stores perform fine on acquisition but fail to capture the natural repeat cycle inherent to consumables.

### Recommended Strategy Playbook

- Make **subscription-first** where appropriate (staples, coffee/tea, supplements-adjacent consumables) with low-friction skip/pause; pair with reorder reminders for non-subscription buyers.
- Push AOV through **bundles and thresholds** (variety packs, "build-a-box," subscribe-and-save) to reduce shipping as % of revenue instead of relying on discounts.
- Treat event weeks as mini-seasons (holiday, Super Bowl): pre-build landing pages and email/SMS flows, and coordinate inventory + promo so you don't discount items you can't fulfill.

### Benchmark Ranges

| Metric | Typical range for Food & Beverage |
|---|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | ~25%--45% |
| AOV | ~$55--$90 |
| Discount rate (avg_discount_rate_trend) | ~5%--15% |
| Gross margin | ~18%--35% |

---

## Electronics & Gadgets

### KPI Pass / Watch / Fail Thresholds

| KPI | Pass | Watch | Fail |
|---|---:|---:|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | >= 12% | 8%--11.9% | < 8% |
| AOV | >= $180 | $120--$179 | < $120 |
| Discount rate (avg_discount_rate_trend) | <= 15% | 15.1%--25% | > 25% |
| Gross margin | >= 25% | 15%--24.9% | < 15% |

### Rationale

Electronics is structurally margin-thin compared to beauty and apparel; large electronics retailers commonly operate with gross margins in the low-20% range, so gross margin should not be audited against beauty-like expectations. Repeat purchase rates are structurally low due to long replacement cycles; the pass threshold is set at 12% (rather than the top of the typical range) to avoid flagging healthy stores whose customers simply don't need to buy again soon. The discount rate pass threshold (<=15%) targets the year-round average realized discount; peak event markdown depths for electronics are considerably higher (~30% during holiday deal events), but persistent high average discount depth outside deal windows signals price-matching stress and weak differentiation.

### Seasonal Calendar

- **Peak months:** Jul (major deal events often tied to back-to-school shopping) and Nov--Dec (holiday).
- **Pre-season prep timeline:** 6--10 weeks ahead -- ensure pricing strategy, supplier availability, and fulfillment SLAs are locked because consumers compare prices heavily and the peak window is short.
- **Markdown windows:** Highest discount depths cluster around Prime-like summer events and BFCM/Cyber Week, with category peak discounts reported around ~30% for electronics during holiday.

### Top Structural Challenges

- Low gross margins + price transparency drive a "race to the bottom," so shipping leakage or heavy discounting quickly breaks contribution margin.
- Long replacement cycles and low natural repeat: most electronics purchases are one-off or multi-year, making accessory attach and ecosystem lock-in critical to lifetime value.

### Recommended Strategy Playbook

- Make PDPs "decision-complete": rich specs, compatibility matrices, side-by-side comparisons, and transparent warranty/return terms to reduce uncertainty-driven abandonment.
- Shift value from discounts to **bundles and services** (warranty extensions, setup, accessories kits) to lift AOV while protecting gross margin.
- Treat promo as event-led (summer deal weeks + BFCM) and avoid constant markdowns; persistent deep discounts are often unsustainable in low-margin categories.

### Benchmark Ranges

| Metric | Typical range for Electronics & Gadgets |
|---|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | ~8%--15% |
| AOV | ~$120--$250+ |
| Discount rate (avg_discount_rate_trend) | ~10%--25% (event peaks higher) |
| Gross margin | ~15%--30% |

---

## Home & Living

### KPI Pass / Watch / Fail Thresholds

| KPI | Pass | Watch | Fail |
|---|---:|---:|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | >= 15% | 10%--14.9% | < 10% |
| AOV | >= $250 | $150--$249 | < $150 |
| Discount rate (avg_discount_rate_trend) | <= 15% | 15.1%--25% | > 25% |
| Gross margin | >= 35% | 25%--34.9% | < 25% |

### Rationale

Home & furniture categories have structurally high AOV (~$266 in one benchmark snapshot), making merchandising clarity more valuable than chasing visits. Gross margins for large home-focused ecommerce retailers are commonly around ~30%, supporting a mid-30s pass goal but a lower fail floor than beauty/apparel.

### Seasonal Calendar

- **Peak months:** Jul--Sep (move-in / dorm / home refresh) and Nov--Dec (holiday). Back-to-school shopping starts early for many consumers (early July), which matters for dorm basics and small home goods.
- **Pre-season prep timeline:** 8--12 weeks ahead -- ensure catalog hygiene, delivery promises, and inventory visibility are correct because purchases are high-consideration and shoppers start earlier.
- **Markdown windows:** BFCM/Cyber Week (giftable home goods + decor), plus targeted clearance on seasonal decor and end-of-line SKUs; avoid blanket promos that destroy margin with bulky-ship items.

### Top Structural Challenges

- "Ops is the product": delivery fees, lead times, damage risk, and poor post-purchase comms become conversion drivers.
- Low purchase frequency and long consideration cycles: customers may buy furniture once every few years, making LTV-building through cross-category expansion (decor, textiles, accessories) and post-purchase nurture essential.

### Recommended Strategy Playbook

- Upgrade "confidence merchandising": dimension clarity, material details, room photography, and UGC; treat PDP completeness as a conversion lever.
- Show **transparent delivery economics** early (shipping costs, thresholds, white-glove options) to prevent late-stage abandonment from unexpected fees.
- Lift AOV without margin collapse via **bundled rooms/collections**, accessories attach, and financing where relevant, rather than deeper discounts.
- Segment promos: use event promotions for giftable items but protect bulky/low-margin SKUs with targeted markdowns and controlled clearance.

### Benchmark Ranges

| Metric | Typical range for Home & Living |
|---|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | ~10%--20% |
| AOV | ~$200--$350+ |
| Discount rate (avg_discount_rate_trend) | ~10%--20% (event peaks higher) |
| Gross margin | ~25%--35% |

---

## Health & Wellness

### KPI Pass / Watch / Fail Thresholds

| KPI | Pass | Watch | Fail |
|---|---:|---:|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | >= 30% | 18%--29.9% | < 18% |
| AOV | >= $75 | $55--$74 | < $55 |
| Discount rate (avg_discount_rate_trend) | <= 15% | 15.1%--25% | > 25% |
| Gross margin | >= 50% | 40%--49.9% | < 40% |

### Rationale

Health & wellness is a blended vertical: consumable products (supplements, routine items) behave like high-repeat DTC, while durable goods (equipment) behave more like electronics/home. Regulatory/compliance and trust are unusually material -- misleading health claims can trigger enforcement actions and reputational damage, making claims hygiene a structural concern. Seasonality is pronounced around behavior-change moments, with a meaningful share of annual new gym memberships occurring in January (~12%), correlating with demand spikes for fitness/wellness products.

### Seasonal Calendar

- **Peak months:** Jan (New Year behavior change / resolution spike), Sep (back-to-routine after summer), and Nov--Dec (holiday gifting and deal season).
- **Pre-season prep timeline:** 6--10 weeks before Jan and holiday: validate claims/labeling, refresh educational content, and make subscription/refill mechanics prominent to capture routine-building intent.
- **Markdown windows:** BFCM/Cyber Week plus New Year promotions; keep routine products focused on subscription/refill value rather than deep markdown dependence.

### Top Structural Challenges

- Claims and compliance risk: supplement and health-related stores often overreach on marketing claims, creating failures that matter beyond performance.
- Trust deficit and anxiety purchasing: consumers want proof (testing, certifications, clear ingredients), so weak credibility signals depress purchase rates.
- Retention is available but not captured: routine products can generate strong repeat, yet many stores lack reorder/subscription UX and lifecycle communications to convert first-time buyers into ongoing customers.

### Recommended Strategy Playbook

- Build a **trust stack**: transparent ingredients, third-party testing and disclaimers where appropriate, and rigorous claim language review; treat this as a KPI precondition.
- Prioritize **subscription + adherence UX** (skip/pause, reminders, reorder in 1--2 clicks) for consumables to lift repeat purchase rate without discounting away margin.
- Use education as conversion: condition-specific guides, dosage FAQs, and "what to expect" timelines reduce uncertainty and preventable returns.
- Plan around **January**: preload landing pages and lifecycle flows for the resolution spike, similar to how retailers plan early for compressed peak seasons.

### Benchmark Ranges

| Metric | Typical range for Health & Wellness |
|---|---:|
| Repeat Purchase Rate (repeat_purchase_rate) | ~18%--40% (higher for consumables) |
| AOV | ~$55--$90 (routine products) |
| Discount rate (avg_discount_rate_trend) | ~5%--20% |
| Gross margin | ~40%--60% |
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall