At a glance
Average order value bucketed by ship-to country. Shows where premium baskets actually live and where the brand should consider opening or doubling-down on a market.
| What it counts | AVG(totalPrice) GROUP BY shippingAddress.countryCode over the 90D window. Each country bucket is the arithmetic mean of totalPrice for orders shipped there. |
| VAT / tax treatment | Same caveat as parent AOV: VAT-inclusive markets show inflated AOV vs VAT-exclusive markets unless normalised. |
| Shipping | Included (sits in totalPrice). International orders typically include higher shipping, inflating apparent AOV vs domestic. |
| Discounts | Deducted (post-discount). Country-specific promo codes can lower one country’s AOV without reflecting customer behaviour. |
| Refunds | NOT deducted. |
| Cancelled / voided orders | Included if Shopify indexed them. |
| Currency | Multi-currency arithmetic without FX. Each country aggregates its native currency; the card doesn’t normalise across currencies, so cross-country comparisons require manual FX conversion. |
| Channels / sources | Order’s ship-to country is the bucket; channel doesn’t change attribution. POS orders typically tag to the store-location country. |
| Time window | 90D (default 90D rolling) |
| Alert trigger | None; descriptive distribution. |
| Roles | owner, marketing |
Calculation
Calculated automatically from your Shopify data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK natural-skincare DTC brand on Shopify, ships globally, presentment currency GBP for UK and USD for US. 90D window 12 Feb 26 to 12 May 26.| Country | Orders | Avg Order Value | Note |
|---|---|---|---|
| United Kingdom | 18,420 | £58 | Home market, free shipping over £40 |
| United States | 4,210 | $94 (~£74) | Higher tier, longer shipping = higher avg |
| Germany | 1,180 | €72 (~£62) | DACH market, premium-positioned |
| France | 920 | €68 (~£59) | EU central, similar profile to UK |
| Australia | 510 | A$135 (~£70) | International shipping inflates avg |
| Canada | 480 | C$108 (~£62) | Similar to US patterns, smaller scale |
| Ireland | 380 | €54 (~£47) | EU-Brexit cousin, stable AOV |
| United Arab Emirates | 95 | AED 540 (~£115) | Premium markets, low volume |
| Switzerland | 48 | CHF 142 (~£128) | Similar to UAE, premium niche |
- The home market sets the floor. UK at £58 is the volume + AOV anchor. Most countries cluster between 1.0× and 1.3× home AOV; outliers >1.5× are usually small-volume premium markets.
- Shipping inflates international AOV. US, AU, CA all show 25-40% higher AOV than UK. Some of that gap is genuine (customers buy more per order to amortise shipping cost), some is structural (international shipping is included in the basket). Subtract average international shipping cost to compare like-for-like.
- The UAE / Switzerland pair is the premium-niche signal. ~£115-128 AOV at low volume; these markets are buying differently, not just shipping more. Worth investigating: are these ambassador-recommended, gift-purchases, or repeat-VIP-buyers? Each has a different growth playbook.
- DACH (DE/CH) is healthy. Germany volume + Switzerland premium is a typical European-DTC story; combined with Austria they often justify a localised storefront with country-specific pricing.
- Currency-display matters. The presentment currency for each country shapes basket expectations. If the brand is displaying everything in GBP for non-UK customers, the AOV will look lower than if it priced in EUR/USD natively.
- Country-specific promos distort. A “WELCOME10” code that disproportionately landed in France pulls France AOV down. Pair with Top Discount Codes to confirm.
Sibling cards merchants should reference together
AOV by country is one geographic slice. The companions:| Card | Why pair it with AOV by Country |
|---|---|
| Average Order Value | The blended-headline cousin. Weight each country’s AOV by its order count to reconcile to total AOV. |
| Customer Countries | Customer count per country; pair to see the volume side of each market. |
| Top Cities | Drills further than country into city; useful for high-AOV markets to find the urban / affluent clusters. |
| Total Revenue | The £ context; AOV × Orders per country = country revenue. |
| Shipping Methods | International method mix per country influences AOV through shipping inclusion. |
| Customer Segments | Cohort context; some countries skew toward gifting, others toward repeats. |
| Currency mix | The currency caveat for cross-country comparisons. |
Reconciling against the vendor’s own dashboard
Where to look in Shopify Admin:Shopify Admin → Analytics → Reports → “Sales by billing country” or “Sales by destination country” (under Sales)The closest equivalent. Pick the same window. The report exposes total sales and order count per country; divide one by the other for AOV. Should match this card to within sync-lag and currency-handling tolerances. Other Shopify Admin views:
- Customers → Filter by country: gives the customer count per country, not orders.
- Orders → Filter by ship-to country: order list filtered to one country.
- Markets (Shopify Markets / Shopify Plus): per-market analytics if Markets is configured for international.
| Reason | Direction | Why |
|---|---|---|
| Currency normalisation | Either | Shopify’s “Sales by country” report can apply FX conversion to a single store currency. Vortex IQ shows raw amounts per presentment currency. |
| Billing vs ship-to country | Either | Shopify exposes both report variants; we use ship-to. Customers ordering on a UK card to ship abroad differ between the two. |
| Time zone | Boundary | Shopify Admin in store time zone; Vortex IQ in UTC. |
| Channel filter | Either | Reports filtered to “Online Store” only differ from this blended figure. |
| Sync lag | Ours lower for “today” | Most-recent 5 to 15 minutes of orders may not be in. |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
google_analytics.ga_revenue_by_country | Should track within ±10% per country | GA4 misses 10-25% of orders due to ad blockers and consent rejection; the rate varies meaningfully by country (continental Europe rejects more, US accepts more). |
google_ads.gads_revenue_by_geo | Indirect | Ads revenue attribution is last-non-direct-click; not directly comparable to ship-to revenue but useful for spend-allocation decisions. |
Known limitations / merchant FAQs
Why is my US AOV double my UK AOV? Three usual causes:- Shipping inclusion. US-international shipping is £8-15 per order; that gets baked into
totalPrice. UK domestic free-shipping over £40 means UK basket includes zero shipping. - Pricing strategy. Many UK brands price US in USD without converting at parity (£20 product → 25.40 at FX). The premium captures USD-purchasing-power.
- Buyer-mix difference. US customers buying from UK brands are typically intentional buyers (sought you out, willing to pay premium); UK customers may include impulse buyers via Instagram. Higher-intent buyers spend more.
- Volume (Customer Countries): is there enough demand to justify investment?
- Margin per order: high AOV with high shipping cost is not high profit. Audit shipping economics.
- Repeat rate: a one-off buyer at high AOV is a different proposition from a repeat buyer at moderate AOV.
- Competitive density: is the country well-served by local brands?
- Customers start completing checkouts they previously abandoned (the GBP price was a friction). New cohort of slightly more price-sensitive buyers enters; AOV may dip per country.
- Round-number pricing. A £19.50 product converted to €23.10 looks awkward; merchants typically set €25 or €22. The new round prices change AOV.
- Higher disposable income for relevant segments.
- Brand-recognition skew: small luxury / niche brands often gain disproportionate UAE / CH momentum.
- Gift culture: UAE often features high-AOV gift purchases.
- Shipping inclusion: international rates plus duties.
totalPrice; the card under-counts their economic value.
Action playbook for using AOV-by-country:
- Identify your top-3 AOV markets: are they getting your localised marketing attention? Most brands undervalue small high-AOV markets.
- Identify your bottom-3 AOV markets where volume is significant: is shipping cost or pricing strategy holding them back?
- Test localised pricing on top-3 AOV markets: if they’re paying premium prices already, structured premium positioning typically boosts both AOV and conversion.
- Audit your free-shipping thresholds per country: a £40 threshold makes sense for UK but produces low AOV in US where shipping is £15. Raise US threshold to $75-100.
- Cross-reference with ad-spend by country: are you spending in proportion to AOV × volume per country, or just by volume?