Average Order Value Trends

### name AOV Trends — Average Order Value Over Time, New vs. Returning ### oneLiner Tracks AOV across daily, weekly, or monthly buckets and segments by new vs. returning customers — measures the impact of upsells, bundles, and free shipping thresholds. ### whenToUse - After raising a free shipping threshold, to verify AOV actually lifted in the following week. - Monthly during P&L review, to check whether customer loyalty is translating into higher basket value. - Before a bundle campaign — to establish a baseline AOV for post-campaign comparison. ### howToRun ``` Run skill: shopify-admin-average-order-value-trends Store: yourstore.myshopify.com days_back: 90 bucket: week ``` ### whatYouGet CSV file `aov_trends_YYYY-MM-DD.csv` with columns: `period`, `order_count`, `aov`, `new_customer_orders`, `new_customer_aov`, `returning_orders`, `returning_aov`, `currency`. Each row is one time bucket. Returning customers have `numberOfOrders > 1`. Guest checkout orders count toward overall AOV but cannot be segmented. A free shipping threshold change or bundle launch should show as an AOV lift in the week it launched — use `bucket: week` for that measurement. ### polishContext ### safetyNote