Analytics
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
analytics
aov
payments
Report AOV by Payment Method
Compare average order value across the payment breakdowns your analytics actually expose — card type, digital wallet, BNPL where isolable — to see which map to bigger baskets.
📋 Prompt
Break down average order value (AOV) by payment method for orders placed in [LAST 90 DAYS]. Start by telling me which payment-related breakdowns my store’s analytics actually support — for example card type, digital wallet, or a specific gateway — and use those. If a payment method I care about ([SHOP_PAY / PAYPAL / OTHER_GATEWAY]) is not available as its own breakdown, say so plainly and give me the closest cut you can, instead of inventing a category or silently folding it into “other”. For each payment method available: Order count and % of total orders Total revenue and AOV % difference between that method’s AOV and the store-wide AOV for the same period If a buy-now-pay-later option such as Shop Pay Installments is separately identifiable in the data, give it its own row: does AOV on installment-paid orders run meaningfully higher than orders paid in full at checkout? If BNPL cannot be isolated, tell me that directly rather than approximating it. Output: Table: payment method, order count, % of orders, revenue, AOV, AOV vs store average One callout naming the highest-AOV and the lowest-AOV method A recommendation on whether to feature the highest-AOV method more prominently at checkout or in product-page messaging, grounded in what the data actually shows rather than a generic tip about payment options How many orders, if any, fell outside the breakdown, so I know the coverage If this is worth re-running monthly, tell me to save it as a Sidekick skill so I can call it as /[SKILL_SHORTCUT_NAME] instead of retyping the query.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions