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.
| Week | Ad spend | Ad 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.
