Workflow · Search and ads · Opening soon

Blended ROAS across Google and Meta Ads

Use weekly exports from Google Ads, Meta Ads, and Shopify to build one blended ROAS view. You get one clean row per week, with duplicate spend and order rows flagged before the final calculation.

Book a demo

Someone typed

“show one clean row per week with google plus meta spend and shopify revenue for blended roas; dedupe repeated spend or orders first; status says Agrees, Duplicate spend, or Duplicate order”

The agent read it as

show one clean row per week with Google Ads daily performance plus Meta Ads daily performance spend and Shopify orders revenue for blended roas; dedupe repeated spend or orders first; status says Agrees, Duplicate spend, or Duplicate order

What the agent built

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

File

Google Ads daily performance

CSV export · 18 rows

File

Meta Ads daily performance

CSV export · 20 rows

File

Shopify orders

CSV export · 23 rows

Step

Roll Google up by week

Step 1

Step

Roll Meta up by week

Step 2

Join

Add Meta spend

6 of 6 paired

Step

Combine week columns

Step 4

Step

Roll Shopify up by week

Step 5

Join

Add Shopify revenue

8 of 8 paired

Step

Finish weekly ROAS

Step 7

Result

Weekly blended ROAS

8 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
Google Ads daily performance
CSV export · 18 rows
File
Meta Ads daily performance
CSV export · 20 rows
File
Shopify orders
CSV export · 23 rows
Step
Roll Google up by week
Step 1
Step
Roll Meta up by week
Step 2
Step
Roll Shopify up by week
Step 5
Join
Add Meta spend
6 of 6 paired
Step
Combine week columns
Step 4
Join
Add Shopify revenue
8 of 8 paired
Step
Finish weekly ROAS
Step 7
Result
Weekly blended ROAS
8 rows · 2 flagged
Schedule
Runs when you say
Proposed

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

Download Google Ads daily performance sample (18 rows)Google Ads: Reports > Predefined reports > Campaigns > Campaign performance > Download
Download Meta Ads daily performance sample (20 rows)Meta Ads Manager: Ads Reporting > Export table
Download Shopify orders sample (23 rows)Shopify: Orders > Export

What you get back

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

Weekly blended ROASSample data8 rows

6 agrees1 duplicate order1 duplicate spend

Week	Google spend	Meta spend	Total spend	Shopify revenue	Blended ROAS	Status
2026-10-12	877.11	973.75	1,850.86	529	0.29	Duplicate spend
2026-10-26	0	821.11	821.11	475	0.58	Duplicate order
2026-09-07	2,420.18	1,218.01	3,638.19	667.50	0.18	Agrees
2026-09-14	1,253.87	898.17	2,152.04	457	0.21	Agrees
2026-09-21	561.40	157.41	718.81	263	0.37	Agrees
2026-09-28	744.76	765.94	1,510.70	340	0.23	Agrees
2026-10-05	1,512.87	950.71	2,463.58	522	0.21	Agrees
2026-10-19	0	525.63	525.63	187	0.36	Agrees

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

How do you calculate blended ROAS across Google and Meta Ads?

Export daily performance from Google Ads and Meta Ads, plus Shopify orders. Roll each source up by week, dedupe repeated spend and orders, then compare total ad spend with Shopify revenue for each week.

How it works

How to use the Weekly blended ROAS 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.

Weekly blended ROAS: questions

What export should I use from each tool?

Use a Google Ads daily performance export, a Meta Ads daily performance export, and a Shopify orders export. The workflow reads the exported files and groups the rows by week.

What happens to repeated rows or values that do not match?

Repeated spend rows and repeated order rows are flagged before the weekly totals are calculated. The status can show Agrees, Duplicate spend, or Duplicate order.

How do I change the matching or rollup rules?

You change the rules in words, for example by choosing which columns to roll up by week, which spend fields to add, and how to treat duplicate rows. The workflow then follows those instructions on the exported files.