Workflow · Search and ads · Opening soon

ROAS by campaign

See ad spend and order revenue by campaign in one weekly view. ROAS is revenue divided by spend, with a simple status for each campaign.

Book a demo

Someone typed

“show every google ads campaign by week matched to our shopify orders by utm campaign, calculate roas as revenue divided by spend, and show status Agrees at 2 or more, No revenue at 0, Low ROAS below 2”

The agent read it as

show every Google Ads campaign spend campaign by week matched to our Shopify orders by utm campaign, calculate roas as revenue divided by spend, and show status Agrees at 2 or more, No revenue at 0, Low ROAS below 2

What the agent built

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

File

Google Ads campaign spend

CSV export · 21 rows

File

Shopify orders

CSV export · 23 rows

Step

Sum spend by week and campaign

Step 1

Step

Sum orders by week and campaign

Step 2

Join

Add Shopify revenue

19 of 21 paired

Step

Set roas status

Step 4

Result

Campaign ROAS by week

21 rows · 9 flagged

Schedule

Runs when you say

Proposed

File
Google Ads campaign spend
CSV export · 21 rows
File
Shopify orders
CSV export · 23 rows
Step
Sum spend by week and campaign
Step 1
Step
Sum orders by week and campaign
Step 2
Join
Add Shopify revenue
19 of 21 paired
Step
Set roas status
Step 4
Result
Campaign ROAS by week
21 rows · 9 flagged
Schedule
Runs when you say
Proposed

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

Download Google Ads campaign spend sample (21 rows)Google Ads: Reports > Predefined reports (Dimensions) > Campaigns > Download
Download Shopify orders sample (23 rows)Shopify: Orders > Export

What you get back

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

Campaign ROAS by weekSample data21 rows

12 agrees7 low ROAS2 no revenue

Week	Campaign	Spend	Revenue	ROAS	Status
2026-10-05	search_generic	710	0	0	No revenue
2026-10-26	shopping_core	500	0	0	No revenue
2026-09-07	search_generic	680	1,240	1.82	Low ROAS
2026-09-14	search_generic	720	1,350	1.88	Low ROAS
2026-09-21	retargeting_video	260	320	1.23	Low ROAS
2026-09-21	search_generic	700	1,180	1.69	Low ROAS
2026-09-28	search_generic	690	1,260	1.83	Low ROAS
2026-10-12	search_generic	735	1,300	1.77	Low ROAS
2026-10-26	search_generic	680	1,280	1.88	Low ROAS
2026-09-07	search_brand	420	1,740	4.14	Agrees
2026-09-07	shopping_core	510	1,620	3.18	Agrees
2026-09-14	search_brand	390	1,750	4.49	Agrees

21 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you calculate ROAS by campaign?

Export campaign spend from Google Ads and order data from Shopify. Match rows by week and utm campaign, then divide revenue by spend to get ROAS. The workflow also marks each campaign as Agrees at 2 or more, Low ROAS below 2, or No revenue at 0.

How it works

How to use the Campaign ROAS by week 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.

Campaign ROAS by week: questions

Which export should you use?

Use a Google Ads export with campaign spend by date, and a Shopify export with orders and revenue. The files need the campaign name or utm campaign and a date field so rows can be grouped by week.

What happens to rows that do not match?

Rows that do not find a match stay out of the joined result for that rule. You can still keep them in the source tables or review them separately, depending on how you set up the workflow.

How do you change the rules?

Edit the rule text in plain words, then rerun the workflow. For example, you can change the week grouping, the match field, the ROAS threshold, or the status labels.