Managing Sponsored Brands campaigns by ACOS alone misses a critical lever: actual profitability per campaign. When you have a large catalog with overlapping SKUs (blenders, food processors, kitchen gadgets), ACOS targets can mislead you into pausing profitable products or scaling unprofitable ones. Amazon’s Attributed Purchases Report for Sponsored Brands now gives you the visibility to calculate real profit and set dynamic, data-driven bids instead.
The Problem with ACOS-Only Targets
- ACOS is an approximation based on assumed margins — you don’t actually know which products sold from your ad spend
- High-margin products may appear “inefficient” under a blanket ACOS target and get paused unnecessarily
- Low-margin products can hide behind acceptable ACOS while bleeding profit after ad spend
- Multi-ASIN campaigns make guessing even more unreliable
How to Calculate Real Campaign Profit
- Download the Attributed Purchases Report for each Sponsored Brands campaign — shows units sold and revenue by ASIN
- Add your true COGS (product cost + shipping + Amazon FBA fees) in a separate sheet
- Calculate total COGS per campaign: Units sold × (COGS + FBA fees) = total cost to earn that revenue
- Gross profit = Sales − COGS (before ad spend)
- Gross margin % = Gross profit ÷ Sales — this is your breakeven ACOS for that campaign
- Net profit = Gross profit − Actual ad spend
- Bonus: Sum across all campaigns to see account-level profitability
Actionable Next Steps
- Double down on high gross-margin campaigns: Raise bids, add more keyword/category targets, A/B test creative
- Cut or restructure low/negative-profit campaigns: Lower bids, remove unprofitable ASINs from landing pages, or shift to different product combinations
- Set dynamic ACOS targets per campaign based on actual margin, not guesses
How Squatio helps
Squatio Optimize (PPC intelligence) pulls campaign spend and performance data into one view, so you can layer in your COGS and margin calculations without manually exporting across spreadsheets. For sellers managing catalogs with overlapping niches, Cortex (AI niche & category analysis) can also help you identify which product clusters drive the best margins, so you know which ASINs to feature or test in your Sponsored Brands creative.
For sellers looking to validate which products in your catalog actually have the margins you think they do, how do you currently track COGS across your full product range — and how often do you discover a product’s true profitability differs from your initial estimate?
Source: Reddit