Amazon PPC Audit Dashboard
Upload an Amazon Ads bulk file (and optional Child ASIN / TRAF report) to auto-build a clean audit.
1. Bulk File Required
Use the Sponsored Ads bulk file export for the date range you want to audit.
No file selected
2. Child ASIN / TRAF Report Optional
Used for Total Sales, Sessions, and TACOS. Leave empty if you only want ad data.
No file selected
The app tries to detect columns for Sessions, Ordered Product Sales, and Total Order Items (case/spacing tolerant).
If your Branded ASINs box is empty, it will auto-fill with all Child ASINs from TRAF (one per line).
3. Branded Filters Optional
Define your branded terms so the audit can split performance into branded vs non-branded.
Branded Keywords (one per line)
Branded ASINs (one per line)
Keyword match uses the Keyword Text column. Product targeting match looks for
asin="B0XXXXXXX" inside the targeting expression.
4. Run & Export
Everything runs locally in your browser. No data is uploaded to a server.
Account Overview
Metrics for selected ad type. TACOS is always account-level (Total Spend ÷ Total Sales).
Spend by Ad Type
SP Spend by Match Type
Branded vs Non-Branded Spend
Branded vs Non-Branded — Spend, Sales & ACOS (point)
Sponsored Products — Keyword / Targeting Summary
Keyword + Product Targeting rows, including Auto targets.Filter Sponsored Products by branded terms.
| Segment | Impr | Clicks | CTR | ACOS | Spend | Spend % | Ad Sales | Ad Sales % | CVR | Orders | CPA | CPC | # Targets |
|---|
Click any column header to sort. Total row stays pinned at the top.
ASIN Level — Top Advertised Products
View ASIN-level metrics as All, Branded-only, or Non-Branded-only (based on SP targeting).
Rows per page.
| ASIN | Impr | Clicks | CTR | ACOS | Spend | Ad Sales | Orders | CVR | CPA | CPC | PPC Sales %* | Total Sales* | Sessions* |
|---|
Default sort: Spend high → low. Click any header to sort. Click an ASIN row to expand details.
* Total Sales/Sessions from TRAF. PPC Sales % = Ad Sales ÷ Total Sales (ASIN-level).
Keyword Coverage Checker
Paste keywords and/or ASINs to see what is actively targeted + totals. Sort any column.Keywords / ASINs to check (one per line)
Matches keywords by exact text equality (case-insensitive). ASIN checks look inside Product Targeting Expression for asin="B0XXXXXXXX".
Optional: DataDive keywords CSV
No file selected
Adds Search Volume (SV) + Suggested Bid to keyword rows (based on DataDive “Search Terms”).
| Term | Type | SV* | Suggested Bid* | Exact | Phrase | Broad | Prod Targeting | Impr | Clicks | CTR | Spend | Sales | Orders | CVR | ACOS | CPC |
|---|
Totals row is pinned at the top. Click any header to sort ascending/descending.
* SV + Suggested Bid populate only if you upload a DataDive CSV.
We optimize many Amazon workflows to drive results, but specialize in shaving off the branded traffic of our competitors with programmatic targeting campaigns. Everyone else does the opposite.
