Free editable template

Amazon ACoS vs TACoS calculator

See whether more ad spend is growing the business or just relabelling organic sales. Type ad spend and ad sales from Amazon Ads and total sales from Seller Central Business Reports; the workbook gives ACoS, TACoS, organic sales, profit after ads, extra sales per extra $1 of spend and a verdict for every week and every product.

By GaaS editorial · Sources checked · 5 worksheet rows

Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.

How to use the template

Set your margin

On Settings, type your margin before ad spend (after product cost, Amazon fees and shipping), which is also your break-even ACoS, the TACoS ceiling you want to stay under, and the minimum extra sales each extra $1 of ads must bring (default 3; 1 ÷ margin is the break-even).

Fill the Weekly tab

For each week, ad spend and ad-attributed sales from Amazon Ads and total sales from Seller Central > Reports > Business Reports > Sales and traffic. Same weeks, same marketplace. The tab works out organic sales, ACoS, TACoS, organic share, profit after ads and a verdict against week 1, and charts both.

Read the summary

First week against last week for spend, ad sales, organic sales, total sales, ACoS, TACoS and profit, plus how many dollars of total sales each extra $1 of ad spend bought.

Check your biggest products

On Products, one row per ASIN over one date range. Each gets a verdict: ACoS above its margin (ad sales lose money), over your TACoS ceiling, or fine.

Preview the worksheet

Every row shown here is included in the download. Scroll the table horizontally on a small screen.

WeekAd spendAd sales
Week 1$6,000$20,000
Week 4$7,364$28,182
Week 8$9,182$39,091
Week 12$11,000$50,000
Your week

Worked review example

Fictional cookware brand, 12 weeks: ad spend rose from $6,000 to $11,000 a week and ad sales from $20,000 to $50,000, so ACoS fell from 30.0% to 22.0%. Organic sales fell from $55,000 to $27,000, total sales rose only from $75,000 to $77,000, and TACoS rose from 8.0% to 14.3%.

Each extra $1 of ad spend bought $0.40 of extra sales. At a 35% margin before ads, weekly profit after ads fell from $20,250 to $15,950.

What this template does and does not establish

TACoS moves with anything that changes organic sales: seasonality, stock-outs, price, reviews and rank. Ad-attributed sales follow Amazon's attribution rules. The 35% margin, 12% ceiling and 3x minimum are example assumptions. This is arithmetic on your reports, not a causal test; a holdout (pausing a campaign for a set period) is stronger evidence. No account connection, macros or automatic changes.

Primary references

Continue the work