Longtail Optimization
SKU Volume Distribution (Pareto Chart)
Q1 High Runners
Q2
Q3
Q4 Longtail
Cumulative %
80% threshold
Quartile Analysis
| Metric | Q1 (High Runners) Target: Avg-5% | Q2 Target: Avg | Q3 Target: Avg+5% | Q4 (Longtail) Target: Avg+10% |
|---|---|---|---|---|
| SKUs | 12 | 28 | 48 | 68 |
| Avg Txns | 245 | 89 | 34 | 8 |
| Revenue | $1.4M | $710K | $480K | $240K |
| Avg Margin | 23.5% | 21.8% | 19.2% | 16.5% |
| Target | 22.0% | 24.0% | 26.0% | 30.0% |
| Below Target | 3 | 12 | 18 | 14 |
| Opportunity | $4,500 | $8,200 | $9,800 | $8,500 |
Longtail SKUs (Q4) should have higher margins to justify carrying costs. Target margins increase from Q1 to Q4 based on the overall average margin of 22.0%.