Analytics
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
analytics
aov
Report Average Order Value Trend
Track average order value week over week or month over month and flag what's driving the trend.
📋 Prompt
Pull my Average Order Value (AOV) trend for the period [LAST 12 WEEKS / LAST 6 MONTHS]. What to calculate: AOV per [WEEK / MONTH] = total order revenue ÷ number of orders, excluding cancelled and fully refunded orders % change vs the prior period and vs the same period last year AOV split by new vs returning customers AOV split by discounted vs full-price orders Output format: A table: period, order count, total revenue, AOV, % change Call out the single period with the biggest AOV jump or drop and name the likely driver (a discount campaign, a bundle launch, a specific high-ticket product spiking, seasonality) Diagnostic questions to answer: Is AOV trending up, down, or flat over the window? Are discounts eating into AOV gains, or are they lifting it (bundle/upsell effect)? Which single product or collection contributed most to any AOV swing? Deliverables: The trend table 3-4 sentence summary of the trend and its main driver One concrete lever to raise AOV next period (e.g. a bundle, a free-shipping threshold, an upsell) based on what the data shows is already working
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