Total purchase amount · which category drives the most revenue?
Electronics$486,367 · 637 orders · avg $764
Accessories$194,867 · 1,404 orders · avg $139
Clothing$183,188 · 1,883 orders · avg $97
Footwear$111,236 · 752 orders · avg $148
Outerwear$18,524 · 324 orders · avg $57
Electronics dominates at $486K (48.9% of revenue) despite only 637 orders — highest avg ticket at $763.53. Clothing has the most orders (1,883) but lowest avg ($97). Inventory & marketing should prioritise Electronics for revenue impact.
Revenue by Gender
Total spend and average order value by gender segment · Q3
Male · 2,989 orders
$390,965
avg $131
Female · 1,649 orders
$352,060
avg $214
Other · 362 orders
$251,158
avg $694
Q2 · Q7 — Discount Impact & Subscription Value
Do Discounts Increase Purchase Value?
Revenue totals and average order value — with vs without discount
Yes — by 20.3%. Discounted orders avg $219.22 vs $182.24 without. Both groups generate near-equal total revenue ($492K vs $502K), confirming discount buyers are genuinely higher-intent spenders — not just bargain hunters.
Subscriber vs Non-Subscriber Spend
Average order value and total revenue comparison · Q7
Subscribers spend 63.3% more. Avg $270.58 vs $165.72 for non-subscribers. 1,579 subscribers (31.6%) generate $427K — 43% of total revenue. Subscription program has strong ROI and should be aggressively expanded.
61.7% are Loyal customers — a healthy base. New customers at 11.2% (561) suggest decent acquisition. Focus retention on Returning (27.1%) to convert them to Loyal.
Revenue Contribution by Age Group
Total revenue per age band with average order value overlay · Q12
51+ dominates with $399K (40.2% of revenue) driven by volume — 1,917 orders. Average order value is consistent across all age groups ($189–$208), meaning order frequency, not ticket size, is the revenue lever to target per age cohort.
Q5 · Q6 — Product Ratings & Shipping Intelligence
Average Purchase Value by Shipping Type
All 6 shipping methods ranked by average order value · Q6
⚡ Express
$358.12
1,199 orders
📦 Standard
$340.57
1,201 orders
🚚 2-Day Shipping
$60.73
627 orders
🆓 Free Shipping
$60.41
675 orders
🏪 Store Pickup
$59.89
650 orders
✈️ Next Day Air
$58.63
648 orders
Express & Standard buyers spend 5.7–6× more than other types ($358 vs $60 avg). High-value customers self-select premium shipping. Use this as a premium upsell trigger at checkout.
Product Review Ratings — Top 5 & Bottom 5
Average customer review rating per product (max 5.0) · Q5
▲ Top Rated
Gloves
3.86
Sandals
3.85
Boots
3.82
Hat
3.80
Skirt
3.79
▼ Needs Improvement
Laptop
3.19
Bag
3.17
Watch
3.10
Headphones
3.08
Phone
2.94
Q8 — Discount Dependency Risk by Product
51.7%
Laptop
74 of 143 orders
51.5%
Phone
88 of 171 orders
51.2%
Headphones
85 of 166 orders
50.0%
Hat
77 of 154 orders
49.7%
Watch
78 of 157 orders
Critical overlap: Laptop, Phone, Headphones, and Watch are the same products that have the lowest review ratings AND the highest discount dependency (50–52%). Discounts are likely masking product dissatisfaction rather than driving genuine demand. Recommend: quality review before further discounting on these SKUs.
Bonus — Season · Payment Method · Purchase Frequency