Analytics πŸ’Ž Built for Sidekick ⚑ Sidekick does this for you
shopify sidekick analytics aov shipping

Report AOV on Paid vs Free Shipping Orders

Compare average order value between orders that paid for shipping and orders that shipped free, to check whether your free-shipping threshold is actually lifting baskets.

πŸ“‹ Prompt
Run in Sidekick
Compare average order value (AOV) between orders that paid a shipping charge and orders that shipped free, for orders placed in [LAST 90 DAYS].

For each group (shipping charge paid / no shipping charge):

  Order count and % of total orders
  Total revenue and AOV
  Average shipping charge paid, where applicable
  % difference between that group’s AOV and the store-wide AOV for the same period


Then answer the question my free-shipping threshold is supposed to be solving. My threshold is currently [FREE_SHIPPING_THRESHOLD]. Do orders that shipped free sit above the AOV of orders that paid for shipping? If free-shipping orders cluster just above [FREE_SHIPPING_THRESHOLD], tell me β€” that is customers topping up to clear the bar, which means the threshold is doing its job. If they cluster well above it, the threshold may be set too low and I am giving away shipping I did not need to.

If my analytics cannot split orders by whether a shipping charge was paid, say so plainly and give me the closest supported cut instead of approximating it.

Output:

  Table: group, order count, % of orders, revenue, AOV, average shipping charge, AOV vs store average
  2-3 sentence summary naming which group carries the higher AOV
  One concrete lever grounded in the data β€” for example, if free-shipping orders cluster right at [FREE_SHIPPING_THRESHOLD], suggest testing a higher threshold; if the gap is not meaningful, say so plainly instead of forcing a recommendation

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions