Workflow · Search and ads · Opening soon

Influencer campaign ROI

Use your Shopify orders export and your Shopify influencer payouts export. Match each influencer’s discount code sales to what you paid them, then calculate ROI.

Book a demo

Someone typed

“match each influencer in the shopify influencer payouts to their discount code sales in shopify orders, calculate roi as sales divided by paid amount, and show influencer, sales, paid amount, and roi”

The agent read it as

match each influencer in Shopify influencer payouts to their discount code sales in Shopify orders, calculate roi as sales divided by paid amount, and show influencer, sales, paid amount, and roi, using Order Total after discounts

What the agent built

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

File

Shopify influencer payouts

CSV export · 8 rows

File

Shopify orders

CSV export · 24 rows

Step

Total sales by discount code

Step 1

Step

Make payout code key

Step 2

Join

Add discount code sales

8 of 8 paired

Step

Calculate influencer ROI

Step 4

Result

Influencer ROI

8 rows

Schedule

Runs when you say

Proposed

File
Shopify influencer payouts
CSV export · 8 rows
File
Shopify orders
CSV export · 24 rows
Step
Make payout code key
Step 2
Step
Total sales by discount code
Step 1
Join
Add discount code sales
8 of 8 paired
Step
Calculate influencer ROI
Step 4
Result
Influencer ROI
8 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 8 of 8 rows.

Download Shopify influencer payouts sample (8 rows)Shopify admin: Analytics > Reports > Custom report export
Download Shopify orders sample (24 rows)Shopify admin: Orders > Export

What you get back

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

Influencer ROISample data8 rows

Influencer	Sales	Paid amount	ROI
Ava Mercer	394.20	180	2.19
Liam Cho	402.05	260	1.55
Mia Cole	114	300	0.38
Kai Bennett	420.30	220	1.91
Rhea Singh	646.20	240	2.69
Mila Park	411.20	1,200	0.34
Zoe Lane	114	300	0.38
Noah Patel	394.20	160	2.46

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

How do you calculate influencer ROI from Shopify exports?

Export your Shopify orders and your Shopify influencer payouts, then upload both files. Mammoth matches each influencer to their discount code sales, uses order total after discounts, and calculates ROI as sales divided by paid amount.

How it works

How to use the Influencer ROI 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.

Influencer ROI: questions

Which export should I use from Shopify?

Use the orders export for sales and the influencer payouts export for payments. The workflow uses the order total after discounts from orders, and the paid amount from payouts.

What happens if a row does not match?

Rows that do not match are left out of the matched result until you add a rule that links them. You can review the unmatched rows and use them to adjust the workflow.

How do I change the matching rules?

You can edit the rules in words. For example, you can change which column is used as the key, which values are matched, and how ROI is calculated.