Percentage Change
1. The problem is to calculate the month-over-month percentage change for each metric from September (Q3) to October (Q4).
2. The formula for percentage change is:
$$\text{Percentage Change} = \frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100\%$$
3. Calculate for each metric:
- NMV:
$$\frac{336,738 - 208,533}{208,533} \times 100 = \frac{128,205}{208,533} \times 100 \approx 61.48\%$$
- ORDERS:
$$\frac{397 - 163}{163} \times 100 = \frac{234}{163} \times 100 \approx 143.56\%$$
- TRAFFIC:
$$\frac{37,930 - 28,645}{28,645} \times 100 = \frac{9,285}{28,645} \times 100 \approx 32.42\%$$
- CR (Conversion Rate):
$$\frac{1.05\% - 0.57\%}{0.57\%} \times 100 = \frac{0.48\%}{0.57\%} \times 100 \approx 84.21\%$$
- AOV (Average Order Value):
$$\frac{848.21 - 1,279.34}{1,279.34} \times 100 = \frac{-431.13}{1,279.34} \times 100 \approx -33.72\%$$
- REFUND:
$$\frac{0.15\% - 0.65\%}{0.65\%} \times 100 = \frac{-0.50\%}{0.65\%} \times 100 \approx -76.92\%$$
- AFTERSALE Rate:
$$\frac{0.00\% - 0.01\%}{0.01\%} \times 100 = \frac{-0.01\%}{0.01\%} \times 100 = -100\%$$
4. Final answers:
- NMV: 61.48%
- ORDERS: 143.56%
- TRAFFIC: 32.42%
- CR: 84.21%
- AOV: -33.72%
- REFUND: -76.92%
- AFTERSALE Rate: -100%
These values represent the month-over-month percentage change from September to October.