Market Comparison: Average Order Value, Contribution per Order and a Weighted Score
This lesson is part of the course
In this lesson
You compare three foreign markets on average order value and contribution per order with AVERAGEIFS and SUMIFS, combine three 1–5 scores into a weighted attractiveness score with SUMPRODUCT and rank the markets.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Currency Conversion: What You Really Receive from a Foreign Order Locked
- Localised Price Points: Charm Prices and Round Prices per Market Locked
- Duties & Import Taxes at Checkout: Duty-Paid vs Duty-Unpaid Offers Locked
- International Shipping: Zone Rate Cards, Free-Shipping Thresholds and the Gap Locked
- Returns from Abroad: Return Rates, Return Shipping and Refunds Without a Return Locked
- Delivery Promise: Handling + Transit Working Days and the Late Share Locked
- Market Comparison: Average Order Value, Contribution per Order and a Weighted Score Locked
- Expansion Check: Fixed Costs per Market, Break-Even Orders and the Verdict Locked