PPC REPORTS – ecommroots

PPC Lens — Amazon Advertising Report Dashboard

PPC Lens.

Amazon Advertising · analyze & strategize

Drop any Amazon PPC report — search term, targeting/keyword, campaign, placement, advertised & purchased product, or performance-over-time. It auto-detects the report type, cleans the data, and turns it into KPIs, charts, and a ranked action list.

Drop your PPC report here

or click to browse — your file never leaves this browser tab

Choose report file

Accepts .csv · .xlsx · .xls · .tsv | Sponsored Products, Brands & Display

Report types it understands

Search Term ReportFinds wasted spend & negative-keyword candidates

Targeting / Keyword ReportBid up winners, rein in high-ACOS targets

Campaign ReportSpend vs sales & ACOS per campaign

Placement ReportTop-of-search vs rest-of-search performance

Advertised Product ReportPer-SKU / per-ASIN efficiency

Purchased Product ReportHalo & cross-sell purchases

Performance Over TimeSpend & sales trend lines

Bulk Operations FileReads the data rows generically

What's the goal of this analysis? Pick one — the action list reorders to put your goal first.

Target ACOS %

Currency

Min clicks for negative flag

Organic sales optional

Gross margin % optional

Report 0 rows

Target keyword watchlist 0

Add the main keywords you want this product to win. The dashboard checks how each one is actually performing in this report.

Phrase match: “silicone spatula” also catches “best silicone spatula uk”. Add search volume (a CSV column, or after a comma) to see total volume targeted, missing & opportunity.

Action list 0

Ranked findings based on your target ACOS — work top to bottom.

Performance overview

Aggregated by campaign.

Cleaned data 0

Sortable & searchable. ACOS, ROAS, CTR, CPC & CVR are recalculated so they are always correct.

Drop your keyword research export here

Helium 10 Cerebro / Magnet, Jungle Scout, Data Dive — or any keyword list with volume & competition

Choose keyword file

Accepts .csv · .xlsx · .xls · .tsv | or skip and build without keyword data

What the strategy builder reads

Search volumeMonthly searches — sizes the opportunity per keyword

PPC competitorsRivals advertising (sponsored) on page 1 — your bid-pressure signal

Organic rankersRivals ranking organically on page 1 — drives the relevancy score

Relevancy 1–10From your tool's score, or from page-1 organic-ranker density

Suggested bid / CPCUsed to project clicks, spend and ACOS

Title densityHow hard the keyword is to rank organically

What are you tracking toward?

Pick the goal for this product/account. Your daily task list and the colour of every change is judged against it.

Target ACOS %

Currency

Report date auto

Drop today's PPC reports

Drag in one or several reports at once — campaign, search term, targeting, placement, product. They merge into a single dated snapshot, so you get keyword and campaign tracking from the same day.

Add today's reports

Select multiple files together · each fills the levels it has · .csv .xlsx .xls .tsv

No snapshots saved yet.

Report 0 snapshots

Trends over time

Your whole history, snapshot by snapshot.

Today's PPC tasks 0

Generated from what changed since your last snapshot, ranked for your goal. Tick them off as you go.

Performance tracker

Every item's latest numbers and the change since your previous snapshot. Switch levels to drill in.

Watchlist only