Workflow · Stock and products · Opening soon

Discount code performance

Compare discount codes from your Shopify orders export. See orders, revenue, discount given and average order value in one result.

Book a demo

Someone typed

“compare discount codes by orders, revenue, discount given and average order value”

The agent read it as

Compare discount codes by orders, revenue, discount given and average order value in Shopify orders export, using Total after discounts for revenue.

What the agent built

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

File

Shopify orders export

CSV export · 24 rows

Step

Compare discount codes

Step 1

Result

Discount Code Performance

8 rows

Schedule

Runs when you say

Proposed

File
Shopify orders export
CSV export · 24 rows
Step
Compare discount codes
Step 1
Result
Discount Code Performance
8 rows
Schedule
Runs when you say
Proposed

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

Download Shopify orders export 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.

Discount Code PerformanceSample data8 rows

Discount code	Orders	Revenue	Discount given	Average order value
BUNDLE20	4	489.60	122.40	122.40
FALL15	3	309.40	54.60	103.13
FLASH30	3	112.00	48	37.33
HOLIDAY18	2	195.16	42.84	97.58
SAVE10	4	338.40	37.60	84.60
VIP25	2	375	125	187.50
WELCOME10	4	370.80	41.20	92.70
WINBACK20	2	350.40	87.60	175.20

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

How do you compare discount code performance?

Export your Shopify orders file, then upload it to Mammoth. It groups rows by discount code and compares orders, revenue, discount given and average order value, using Total after discounts for revenue.

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

What export should you use?

Use your Shopify orders export. The workflow reads the order rows and uses the discount code and order values in that file.

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

Rows without a usable discount code are left out of the grouped comparison. They do not change the results for the codes that do match.

How do you change the rules?

Change the rule in words, then run the workflow again. For example, you can ask it to group by a different field or compare a different set of measures.