Catalog Profit Check
Find the ad-spend limit for each product.
Enter each product’s price, Amazon fees and landed cost to calculate break-even ACoS. Choose the margin to keep and add a conversion rate for a CPC limit. Optional current ACoS and ad sales estimate contribution after advertising.
Step 1
Your products
One row per product. Price, fees and landed cost are all you need for the break-even line. The last three columns are optional, and they turn the check into a diagnosis.
These are example products, so you can see how it works.
Where do I find these numbers?
- Price
- Your current selling price per unit, before tax.
- Amazon fees
- Referral fee plus FBA fulfillment fee, per unit. Look up one product in Amazon’s Revenue Calculator, or pull the whole catalog from the Fee Preview report in Seller Central (Reports, then Fulfillment).
- Landed cost
- What one unit costs you to get into Amazon’s warehouse: product, freight, duties and prep. Add storage and returns if you want a stricter line.
- Conversion rate
- Ad orders ÷ ad clicks for the product. It’s in Campaign Manager, or the Sponsored Products Advertised Product report.
- ACoS today
- The product’s ACoS over the last 30 days, from the same report.
- Ad sales / month
- The product’s ad-attributed sales over the last 30 days, from the same report.
| Product / SKU | Price$ per unit | Amazon feesReferral + FBA, $ | Landed cost$ per unit | Conv. rateOptional, % | ACoS todayOptional, % | Ad sales / monthOptional, $ | Remove |
|---|
Columns in this order: product, price, Amazon fees, landed cost, then (optional) conversion rate, ACoS today, ad sales per month. A header row is fine; it’s skipped.
Tip: you can also paste a block of cells straight into any box, the way you would in a spreadsheet.
Step 2
What your ads can cost
| Product | Profit before ads | Break-even ACoS | Target ACoS | Max CPC | ACoS today vs break-even | Ad profit / month | Read |
|---|
- ACoS today, at or under target
- Over target, under break-even
- Over break-even
- Break-even line
Products with ACoS today are listed first, biggest monthly loss at the top.
Share these results with your team
A short, plain summary for Slack or email. It’s written in your browser; nothing is sent anywhere. Edit it before you copy if you like.
Learn the idea first: find the ACoS your product can afford, lesson 1 of the PPC Playbook.
Next: When to Negate uses these products to check whether a search term is worth more clicks, and the Placement Bid Calculator uses their break-even ACoS to set placement adjustments.
How it’s calculated
Calculation formulas
The same math as the spreadsheet, so you can check any number by hand.
Also a free JSON API for your own reports or an AI agent, no key needed: GET https://profitfirstppc.com/api/catalog-profit-check?price=39.99&fees=11.20&cost=9.50. Details in the API spec.
Break-even ACoS
(Price − Amazon fees − landed cost) ÷ price. Past this line, every ad-driven sale loses money.
Target ACoS
Break-even minus the margin you want to keep after ads. This is what bids should aim for.
Max CPC
Price × target ACoS × conversion rate. The most a click can cost and still hit your target.
Ad profit per month
Ad sales × (break-even ACoS − ACoS today). What ad-driven sales leave you after product, fees and ad cost. It leaves out storage, returns and overhead, and any organic sales the ads help create.
Tell me what you want your ads to do.
In a free 30-minute call, we’ll discuss your business, your current advertising and whether an audit, a focused project or ongoing management would help.
Learn the decision behind the numbers.
Work through the example, then apply this tool to your own reports.