Average order value by channel
“calculate average order value by sales channel and month from our shopify orders”
Calculate average order value by sales channel and month from our Shopify orders, paid orders only.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileShopify ordersCSV export · 24 rows
- StepCalculate monthly order valuesStep 1
- ResultChannel Order Value18 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 18 rows came out.
- Download Shopify orders sample (24 rows)Shopify Admin: Orders > Export > All orders > CSV for Excel, Numbers, or other spreadsheet programs
What you get back
The result of that run, the rows to look at first.
| Sales channel | Month | Average order value | Sales | Orders |
|---|---|---|---|---|
| Amazon | 2026-09-01 | 415 | 415 | 1 |
| 2026-09-01 | 42 | 42 | 1 | |
| 2026-09-01 | 125 | 125 | 1 | |
| 2026-09-01 | 58 | 58 | 1 | |
| Online Store | 2026-09-01 | 75 | 150 | 2 |
| 2026-10-01 | 76 | 76 | 1 | |
| 2026-10-01 | 47 | 47 | 1 | |
| 2026-10-01 | 138 | 138 | 1 | |
| 2026-10-01 | 63 | 63 | 1 | |
| Online Store | 2026-10-01 | 84 | 252 | 3 |
| Wholesale | 2026-10-01 | 295 | 590 | 2 |
| 2026-11-01 | 74 | 74 | 1 |
How do you calculate average order value by sales channel and month from your Shopify orders?
Export your Shopify orders from Shopify, then upload the file. The workflow calculates monthly order values for paid orders only, then groups them by sales channel and month to give you average order value by channel and month.
How it works
How to use the Channel Order Value workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Channel Order Value: questions
What export should you use?
What happens to rows that do not match?
How do you change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Find the few products that make most of your sales, what sells together, and the stock that sits too long.
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the workflow Template
- Inventory turnover and days on handEach product's turnover and days of stock on hand, month by monthSee the workflow Template
- Demand forecast by SKUForecast next month’s demand for each SKU from your Shopify order line export using recent monthly averages and trend.See the workflow Built by the agent
- Economic order quantityCalculate economic order quantity for each item from a NetSuite item cost and demand export.See the workflow Built by the agent