Amazon Ads ACoS by campaign against target
“give me amazon sponsored products acos by campaign for the last thirty days against each campaign's target acos, and flag campaigns over target, campaigns with spend and no sales, and campaigns whose budget ran out on most days”
Give me Amazon sponsored products ACoS by campaign for the last thirty days against each campaign's target ACoS, and flag campaigns over target, campaigns with spend and no sales, and campaigns whose budget ran out on most days from Amazon Ads Sponsored Products campaign report by day against Amazon Ads Sponsored Products ACoS targets.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileAmazon Ads Sponsored Products campaign report by dayCSV export · 45 rows
- FileAmazon Ads Sponsored Products ACoS targetsCSV export · 10 rows
- StepTotal the last 30 daysStep 1
- StepPrepare target campaign keyStep 2
- JoinBring in target ACoS10 of 10 paired
- StepFlag campaign resultsStep 4
- ResultCampaign ACoS Flags10 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 10 rows.
- Download Amazon Ads Sponsored Products campaign report by day sample (45 rows)Amazon Ads: Reports > Sponsored Products campaign report > By day > Date range 2026-10-22 to 2026-11-20 > Export
- Download Amazon Ads Sponsored Products ACoS targets sample (10 rows)Amazon Ads: Campaign manager > Targets sheet maintained by seller > Export
What you get back
The result of that run, the rows to look at first.
| Campaign | ACoS % | Target ACoS % | Spend | Sales | Days reported | Budget exhausted days | Target status | Sales status | Budget status |
|---|---|---|---|---|---|---|---|---|---|
| Brand Defense - SP | 14.3 | 15 | 80 | 560 | 4 | 4 | At or below target | Sales recorded | Budget ran out most days |
| Clearance - SP | · | 8 | 20 | 0 | 4 | 0 | No sales | Spend with no sales | Budget did not run out most days |
| Competitor Conquest - SP | 18 | 10 | 27 | 150 | 3 | 0 | Over target | Sales recorded | Budget did not run out most days |
| Generic Nonbrand - SP | 10 | 12 | 48 | 480 | 4 | 0 | At or below target | Sales recorded | Budget did not run out most days |
| Holiday Gifts - SP | 8.4 | 10 | 32 | 380 | 4 | 0 | At or below target | Sales recorded | Budget did not run out most days |
| Home Decor - SP | 10 | 11 | 30 | 300 | 3 | 0 | At or below target | Sales recorded | Budget did not run out most days |
| Kids Toys - SP | 12.2 | 14 | 42 | 345 | 3 | 0 | At or below target | Sales recorded | Budget did not run out most days |
| New Launch - SP | 8.6 | 9 | 27 | 315 | 3 | 0 | At or below target | Sales recorded | Budget did not run out most days |
| Remarketing - SP | 13 | 16 | 45 | 345 | 3 | 0 | At or below target | Sales recorded | Budget did not run out most days |
| Spring Sale - Search | 14.1 | 18 | 96 | 680 | 4 | 0 | At or below target | Sales recorded | Budget did not run out most days |
How it works
How to use the Campaign ACoS Flags workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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 ACoS Flags: questions
How do you check Amazon Ads ACoS by campaign against target?
Which export should you use?
What happens if a row does not match a target?
How do you change the rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template
- Customer segmentation by revenueSegment Stripe customers into revenue tiers from exported customer, charge, and threshold files, then count customers and revenue in each tier.See the workflow Built by the agent