Free Tool — No Signup

Placement Performance Analyzer

Almost every seller sets placement modifiers from ACOS. That is the wrong metric — placement ACOS is a blend of every keyword and modifier underneath it. This tool sets them from conversion rate, the way the maths actually works, then gives you the base bid change that has to move with them. It ends with a bulk file you can upload.

Modifiers from CVR, not ACOSTandem base bid calculation Upload-ready bulk file outHandles the Amazon Business overlay Flags compounding bid riskRuns in your browser

What This Tool Does

Reads the placement rows already sitting in your bulk file and works out what each modifier should be.

📊
Modifiers from conversion rateLowest-converting placement becomes the 0% baseline; the rest get their relative lift
The tandem base bidModifiers set allocation, bids set price level — changing one without the other breaks both
🧮
Significance gateA CVR gap that could be luck never becomes a modifier change
🔄
Amazon Business handled correctlyIt overlaps the other placements rather than adding to them — counting it four ways inflates your totals
Compounding risk flaggedUp-and-down bidding multiplies your modifier — a $1 bid can settle near $4
Upload-ready bulk fileOperation set to Update, IDs kept as text, placement names left exactly as Amazon wrote them

📋 How To Use

This uses the standard Sponsored Products bulk file — the same one the other tools take.

Open Campaign ManagerAmazon Advertising → Sponsored Ads
Go to Bulk OperationsSponsored Ads → Bulk operations
Set a 30–60 day date rangePlacement decisions need a month minimum — weekly changes are noise
Include performance dataWithout it the placement rows have no clicks or orders to read
Drop the .xlsx belowRead locally — nothing is uploaded anywhere
🎯

Drop Your Sponsored Products Bulk File Here

Bulk operations export with performance data included — .xlsx or .csv

🔒 Never leaves your browser✅ No row limit📝 No signup
It needs the performance columns. When you request the bulk file, pick a date range of 30–60 days and leave performance data switched on. The placement rows sit under the entity Bidding Adjustment and carry their own impressions, clicks, spend, sales and orders — that is what this tool reads. A settings-only export has the modifiers but nothing to judge them against.

Reading your bulk file

Parsing rows…

📄
The Real Problem

Placement ACOS is noise disguised as signal.

It is the number everyone optimises on, and it is measuring the wrong thing.

1

ACOS measures your bid, not the placement

A modifier multiplies every keyword bid underneath it. Placement ACOS is therefore a blend of every keyword and every modifier in the campaign — partly a record of your own past decisions rather than a property of the slot.

2

The instinct makes things worse

Top of Search often shows the highest ACOS and the highest conversion rate at once. Cutting its modifier surrenders your best-converting position and moves the same spend somewhere that converts worse.

3

It creates a spiral

Lower bids lose better placements, which lowers conversion rate, which makes the automation lower bids again. The rule that fired first produces the poor performance it was responding to.

4

Two levers get confused for one

Modifiers decide distribution. Bids decide price level. Change one without the other and you either inflate spend or lose the placement you were trying to win.

What Makes This Different

It uses the calculation that actually works

Conversion rate sets the modifier. Target ACOS sets the bid. They are not interchangeable.

The CVR method, not the ACOS habit

Your lowest-converting placement becomes the 0% baseline and the others receive their relative lift: ((placement CVR − lowest CVR) ÷ lowest CVR) × 100. Change your target ACOS from 15% to 40% and the modifiers do not move, because the target belongs to the bid. That is not a simplification — it is the whole point.

The tandem bid, calculated for you

Every recommendation ships as a pair: the modifiers and the ad group bid that has to move with them. The tool shows your blended multiplier before and after, so you can see exactly how much your effective CPC would drift if you changed the modifiers alone. Most tools hand you half the change and let you discover the other half on your invoice.

It argues against the obvious action

When Top of Search has your worst ACOS and your best conversion rate, the tool tells you plainly not to cut that modifier — it is a bid problem wearing a placement costume. A tool that only ever agrees with your first instinct is not adding anything.

Amazon Business handled properly

Your bulk file carries four placement rows, but Amazon Business overlaps the other three rather than adding to them. Sum all four and your placement spend exceeds your campaign spend. It is reported separately and excluded from every calculation, which is why the totals here reconcile.

Significance before precision

A conversion gap between two placements can be a real difference or an ordinary run of luck. A two-proportion test decides which, and a gap that fails it leaves the modifier where it is rather than receiving an invented percentage. Placements under the click threshold are never used as the baseline, since everything else is measured against it.

It leaves as a file you can upload

The export is a real bulk sheet: Operation set to Update, IDs written as text so 15-digit campaign IDs survive Excel, and the placement names left exactly as Amazon wrote them rather than helpfully rewritten into the spelling that gets uploads rejected. Nothing else in the file is touched.

Questions

Frequently Asked Questions

Which file do I need, exactly?
The Sponsored Products bulk file: Campaign Manager → Bulk operations → request a file with a date range of 30–60 days and performance data included. The placement rows sit under the entity Bidding Adjustment and carry their own impressions, clicks, spend, sales and orders. A settings-only export contains the modifiers but nothing to judge them against, and the tool will tell you so rather than producing numbers from nothing.
Why conversion rate instead of ACOS?
Because conversion rate is a property of the placement and ACOS is not. Shoppers at the top of search are further along than shoppers browsing a competitor's detail page, and that difference shows up as conversion rate regardless of what you bid. ACOS, by contrast, is spend divided by sales — and your spend at each placement is your keyword bid multiplied by your placement modifier. Optimising modifiers on ACOS means optimising partly on your own previous modifier settings. It is circular, and it is why so many accounts oscillate.
My target ACOS is 20%, not 30%. Does that change the modifiers?
No, and that surprises people. The modifiers describe the relative value of each placement, which does not depend on your profit goal. Your target ACOS sets the base bid — the absolute price you are willing to pay for a click. Change the target in the controls and you will see the recommended ad group bid move while the modifier column stays exactly where it was. That separation is the correct behaviour, not a bug.
Top of Search has my worst ACOS. Shouldn't I reduce it?
Usually not. If Top of Search also has your best conversion rate — and it very often does — then the high ACOS means you are paying too much per click, not that the placement is bad. Reducing the modifier gives up your best-converting position and pushes the same budget toward placements that convert worse, so ACOS gets worse rather than better. Lower the keyword bid instead. The tool detects this pattern and flags it explicitly on the campaigns where it applies.
What is Amazon Business doing in my bulk file?
It is a bid adjustment for B2B shoppers, and it is an overlay rather than a fourth placement — that traffic already appears inside Top of Search, Rest of Search and Product Pages. If you add all four rows together, your placement spend comes out higher than your campaign spend, which is how you can tell something is wrong. This tool reports it on the Placement Mix tab and excludes it from every calculation.
How often should I change placement modifiers?
Monthly at most, on 30 to 60 days of data. Placement data accumulates slowly, and weekly adjustment is one of the more expensive habits in Amazon PPC — you end up measuring your own changes rather than the market. The tool reads the date range out of the bulk filename and warns you when the window is too short to support a decision.
Can I upload the export straight back to Amazon?
Yes. It contains only the placement rows whose modifier changed, with Operation set to Update and every other value carried over untouched from your own file — including the placement names, which are deliberately not rewritten. Review it first, as you should with any bulk upload, then submit it through Bulk operations. Nothing else in your account is affected.
What about Sponsored Brands and Sponsored Display?
Not yet. Sponsored Brands uses a different placement vocabulary and Sponsored Display has no placement modifiers at all, so folding them in would mean three different sets of rules behind one button. This tool reads the Sponsored Products sheet only. If your bulk file contains the other tabs they are simply ignored rather than misread.
Is my data uploaded anywhere?
No. The file is read by JavaScript in your browser and discarded when you close the tab. There is no server and no account. Load this page, disconnect from the internet, and everything still works — which is the only proof of that claim worth anything.
Go Deeper

Related Guides & Tools

Want someone to make these changes for you?

Placements are one lever of about forty. If you would rather have all of them managed properly — and measured afterwards — that is what I do.