Advertising / Free CSV analyzer
Amazon PPC Audit Tool
Analyze a Sponsored Products search-term CSV locally. Review spend without orders, target ACOS exceptions and weighted advertising metrics.
Private report workspace
A few steps to clarity.
- 1Add your CSV
- 2Confirm the columns
- 3Explore your findings
Drop your CSV here
Or choose a file from your device
CSV · up to 2 MB · 10,000 rowsCSV format and number guidance
Comma, semicolon and tab delimiters; quoted cells and UTF-8 BOM supported. Use a decimal point and optional comma thousands groups (quote these in comma CSVs). No currency symbols, percentages, negative numbers or decimal commas. Blank optional cells mean unknown. Normalize signed credits into net costs before import.
Understand the numbers
How this analyzer works
Supported input: Amazon Sponsored Products search-term CSV, or the normalized template. Map Customer Search Term and Spend, then optionally matched-window attributed sales, total orders and Clicks. ACOS = spend ÷ sales × 100; ROAS = sales ÷ spend; CPC = spend ÷ clicks; conversion rate = orders ÷ clicks × 100. Aggregate ratios use sums, never averages of row percentages. Rows remain separate, including repeated terms across campaigns.
See the method in practice
Worked example
The sample spends $290 for $750 attributed sales, 19 orders and 210 clicks: ACOS 38.67%, ROAS 2.59, CPC $1.38 and conversion rate 9.05%. The $80 travel-bottle row has zero attributed orders. That is a review signal, not proof the spend is wasted.
Assumptions and limitations
Use one marketplace, currency, reporting period and attribution window. Recently recorded clicks may convert later and reports can be revised. Attribution is not proof of incremental sales. Missing fields suppress dependent metrics. A search-term report may not reconcile to all account activity. TACOS is intentionally not calculated because total business sales are not collected. This is a report review, not an account-access audit.
Reference: Amazon Ads campaign reporting. Check your exported report’s attribution definitions before comparing periods.
A little help with the inputs
Input guide
Use consistent currencies, units and periods. Select a field for its definition.
Search term
Customer search term; a product identifier can also appear. Normalized column: term.
Spend
Ad spend in one currency. Normalized column: spend.
Attributed sales (optional)
Choose one attribution window and use its matching orders column. Normalized column: adSales.
Attributed orders (optional)
Orders, not units sold; same attribution window as sales. Normalized column: orders.
Clicks (optional)
Clicks in the selected report period. Normalized column: clicks.
Before you make your next move
Frequently asked questions
Should I pause every term with no orders?
No. Check attribution maturity, sample size, relevance, bids, product conversion and your testing strategy before making changes.
Which Amazon columns should I map?
Map Customer Search Term, Spend and Clicks. For sales and orders choose matching columns such as 7 Day Total Sales and 7 Day Total Orders, or matching 14-day fields. Never combine windows or substitute units sold for orders.
Do I have to share my data or email address?
No. Core results and exports work without an account or email. An enquiry is optional, with a separate unchecked choice to share an aggregate summary. Raw report rows stay local.
Keep investigating
Related tools and support
Explore amazon ppc review and management →
Break-Even ACOS Calculator
Calculate break-even ACOS, target ACOS and ROAS from your product economics before changing Amazon PPC bids.
Open tool →Ecommerce Profit Calculator
Build a transparent sales-to-contribution breakdown for one product unit or a business period, with optional operating overhead.
Open tool →Inventory Reorder Calculator
Estimate stock cover, reorder timing and replenishment quantities using daily demand, lead time, safety stock and dated incoming inventory.
Open tool →