Workflow · Stock and products · Opening soon

Shopify discount codes report

Use your Shopify orders export to review discount code performance. See orders, revenue, total discount, and average order value with and without a code.

Book a demo

Someone typed

“from the shopify orders export, show each discount code with orders, revenue, and discount total, plus average order value with vs without a code”

The agent read it as

From the Shopify orders export, show each discount code with orders, revenue, and discount total, plus average order value with vs without a code.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Shopify orders export

CSV export · 20 rows

Step

Summarize by discount code

Step 1

Result

Discount Code Performance

7 rows

Schedule

Runs when you say

Proposed

File
Shopify orders export
CSV export · 20 rows
Step
Summarize by discount code
Step 1
Result
Discount Code Performance
7 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 7 rows came out.

Download Shopify orders export sample (20 rows)Shopify admin: Orders > Export > Current page of orders (CSV)

What you get back

The result of that run, the rows to look at first.

Discount Code PerformanceSample data7 rows

Discount code	Orders	Revenue (USD)	Discount total (USD)	Average order value (USD)
BUNDLE5	2	138.84	25	69.42
FREESHIP	2	284.96	28	142.48
LAUNCH12	2	320.88	59.20	160.44
No code	5	353.46	0	70.69
SAVE10	3	296.56	42.40	98.85
VIP20	3	515.28	124.72	171.76
WELCOME15	3	284.04	34	94.68

7 rows in the result. Sample data: illustrative figures, not business results.

How do you report on Shopify discount codes?

Export your Shopify orders file, then summarize by discount code. The report shows orders, revenue, total discount per code, and average order value with and without a code.

How it works

How to use the Discount Code Performance 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.

Discount Code Performance: questions

Which export do I use?

Use the orders export from Shopify. The workflow reads the rows in that file and groups them by the values in each order.

What happens to rows that do not match a discount code?

They stay in the data, but they are grouped separately or left out of the discount code summary, depending on the rule you set. That lets you compare orders with a code and orders without one.

How do I change the rules?

Edit the steps in words, then rerun the file. You can change which column is used, what gets grouped together, and which totals or averages are shown.