Vantwyn
Profit-anchored PPC
Amazon advertising

What am I doing wrong? Upload three reports and find out.

Amazon shows you what happened. It will not tell you which part of it was a mistake, which product cannot afford the ads pointed at it, or what to change first. You get the answers as a file you upload straight back into Amazon.

No login and no Amazon account to connect. Your data stays yours: we do not sell it, share it, compare it against anybody else’s, or train anything on it — and nobody here goes looking through it.

Free · no login
Work from your reports

Three files Amazon already gives you. Back comes the sheet below, filled in: bid changes, a harvest list, negatives, budget calls and a diagnosis of what moved and why.

Free · no files
Price a single SKU

No files, no account, nothing to download. Type in one product's numbers and find out what it can afford to spend on advertising — and what a click is worth.

Or keep scrolling — the file writes itself

0 of 1,412 rows written
RecordCampaignKeyword or targetMatch BidNew bidOperationWhy
UploadedSeller Central · Bulk operations
The file

This is the sheet Seller Central accepts.

Empty, it is a thousand cells nobody has time to fill on a Sunday. Keep scrolling and the engine fills it, one decision at a time, with the reason beside each.

Bids

Every bid, priced against a real margin.

One formula, everywhere: target ACOS × conversion rate × order value, and no single move larger than 15%. Not a target you typed in and hoped about.

Terms

Harvest with the other half attached. Negate on clicks, never on ACOS.

A term that earns its place is promoted to exact and negated where it came from. A term that converts but loses money is repriced, never thrown away.

Refusals

And the rows it would not write.

Under ten clicks it will not price from a conversion rate. A conversion problem never gets a bid change. It says so in the file, rather than filling the gap with something plausible.

Done

1,412 rows. One upload. Yours takes three reports.

That was an example account. Everything it does, and every number that went into the file, is one page on.


THE FORMULA —
Keyword · exact · Scale — skillets
cast iron skillet 10 inch
the first row the sheet wrote
One keyword

What is this click actually worth?

Not what you are bidding, and not what the category charges. What this keyword can earn on this product, at this product's margin.

Three numbers

Its conversion rate, your order value, your target.

The target is not typed in. It comes down from this product's breakeven of 38.0% — what is left after Amazon's cut, the FBA fee and what the unit costs you.

Worth 96¢

Target ACOS × conversion rate × order value.

One line of arithmetic, the same on every keyword in the account. 24% × 11% × $36.50 = $0.96.

You pay $1.40

So you are paying 46% over the target.

At $1.40 this keyword runs at 35% ACOS — under the 38.0% breakeven, so it is not losing money. It is making about 13¢ a click where it could be making 57¢, on every click, for as long as nobody works it out.

What it writes

$1.19, not $0.96.

No bid moves more than 15% at once. A bigger cut would make the result unreadable — you would not know whether the keyword changed or you did. It steps, and checks again.

Every recommendation arrives with the line it was measured against.

AMAZON GIVES YOU
what happened, on every term you paid for
The report

This is everything Amazon hands you.

Impressions, clicks, spend, sales, ACOS. Five columns of what happened, on every search term you paid for.

And then it stops

35%, 42%, 17%. Which one is the problem?

There is no answer in this table. The same figure is money well spent on one product and a loss you are paying to repeat on another, and nothing here says which.

The column it never has

What the unit costs you.

It is the only figure no Amazon report contains, and it is the one that decides every other number on the row. Two columns — the ASIN, and what one unit costs you landed. That is the whole of what we ask for.

Now it is a decision

One cost. Three different answers.

Nothing above changed. Two of these are being overpaid for and one is being starved — and the table only says which once it knows what the unit costs you.