Amazon Advertising Report Analyzer
Amazon sellers download advertising reports with hundreds of rows showing spend, sales, impressions, and clicks for every keyword and campaign. This analyzer reads those CSV files and calculates ACOS, ROAS, cost per click, and conversion rate across campaigns so you can see which keywords are profitable and which are burning budget. Upload your report and get instant analysis—no signup required for basic breakdowns, or subscribe for campaign tracking and historical comparisons.
Upload your Amazon advertising report and DataMimi instantly calculates ACOS, ROAS, and conversion rates across every campaign, highlights unprofitable keywords, and shows you exactly where your budget is going—no formulas or pivot tables required.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountSee it on a sample file
What DataMimi shows for a Amazon orders report
2,799 rows, Jul 2025 – Aug 2026. Computed by DataMimi from a sample export with the same columns as yours — the data is invented, the figures are exactly what the app produces from it.
What this export contains
| Campaign Name |
| Ad Group Name |
| Targeting |
| Match Type |
| Customer Search Term |
| Impressions |
| Clicks |
| Click-Thru Rate (CTR) |
| Cost Per Click (CPC) |
| Spend |
| 7 Day Total Sales |
| Total Advertising Cost of Sales (ACOS) |
| Total Return on Advertising Spend (ROAS) |
Common questions
What is a good ACOS for Amazon ads?
It depends on your profit margin. If your margin after Amazon fees and product cost is 30%, an ACOS under 30% means the ad is profitable. Many sellers target 20-25% to leave room for other costs. New product launches often accept 40-60% ACOS to build reviews and ranking.
How do I find keywords with high spend and low sales?
Sort the report by the Spend column in descending order, then look at the 7 Day Total Sales column next to it. Any keyword in the top twenty rows of spend that has zero or very low sales is burning budget. This analyzer highlights those automatically.
Should I pause keywords with ACOS over 100%?
Usually yes, unless it is a brand defense keyword or a new campaign still gathering data. An ACOS over 100% means you spent more on the ad than you made in attributed sales, so every click lost money. Pause it or lower the bid.
How do I calculate ROAS from my Amazon advertising report?
ROAS is sales divided by spend. If a keyword generated fifty dollars in sales and cost ten dollars in ad spend, the ROAS is 5.0. Amazon includes ROAS in newer reports, but older downloads only have ACOS, which is the inverse: ROAS = 1 / (ACOS / 100).
What is the difference between Customer Search Term and Targeting?
Targeting is the keyword you bid on in your campaign. Customer Search Term is the actual phrase the shopper typed into Amazon. For broad and phrase match, these are often different — you bid on "yoga mat" but the shopper searched "extra thick yoga mat purple" and your ad still showed.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file