Skip to content
Workflow · Track and forecast · Opening soon

Amazon Ads ACoS by campaign against target

Export your Amazon Ads Sponsored Products campaign report by day and your ACoS targets, then upload both files. Mammoth totals the last 30 days, brings in each campaign target ACoS, and flags campaigns over target, with spend and no sales, or where budget ran out on most days.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Amazon Ads Sponsored Products campaign report by day
    CSV export · 45 rows
  2. File
    Amazon Ads Sponsored Products ACoS targets
    CSV export · 10 rows
  3. Step
    Total the last 30 days
    Step 1
  4. Step
    Prepare target campaign key
    Step 2
  5. Join
    Bring in target ACoS
    10 of 10 paired
  6. Step
    Flag campaign results
    Step 4
  7. Result
    Campaign ACoS Flags
    10 rows
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 10 rows.

What you get back

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

Campaign ACoS FlagsSample data10 rows
CampaignACoS %Target ACoS %SpendSalesDays reportedBudget exhausted daysTarget statusSales statusBudget status
Brand Defense - SP14.3158056044At or below targetSales recordedBudget ran out most days
Clearance - SP·820040No salesSpend with no salesBudget did not run out most days
Competitor Conquest - SP18102715030Over targetSales recordedBudget did not run out most days
Generic Nonbrand - SP10124848040At or below targetSales recordedBudget did not run out most days
Holiday Gifts - SP8.4103238040At or below targetSales recordedBudget did not run out most days
Home Decor - SP10113030030At or below targetSales recordedBudget did not run out most days
Kids Toys - SP12.2144234530At or below targetSales recordedBudget did not run out most days
New Launch - SP8.692731530At or below targetSales recordedBudget did not run out most days
Remarketing - SP13164534530At or below targetSales recordedBudget did not run out most days
Spring Sale - Search14.1189668040At or below targetSales recordedBudget did not run out most days
10 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Campaign ACoS Flags workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your Amazon Ads Sponsored Products campaign report by day and your ACoS targets, then upload both files. Mammoth totals the last 30 days, brings in each campaign target ACoS, and flags campaigns over target, with spend and no sales, or where budget ran out on most days. You get a campaign ACoS review from your Amazon Ads dashboard data.
Which export should you use?
Use the campaign report by day for performance and the targets export that includes each campaign’s target ACoS. The workflow reads those exported files and matches them by campaign key.
What happens if a row does not match a target?
The workflow keeps the campaign row and leaves the target fields blank. You can then review those rows and decide whether the campaign name or key needs to be corrected in the source files.
How do you change the rules?
Edit the steps in words, then rerun the workflow. You can change the lookback period, the target match fields, and the flags for over target, no sales, or budget runout.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →