Amazon PPC Analyzer

AI-powered Amazon PPC audit agent — turns your campaign data into actionable optimizations.

Paste your bulk report, describe your campaigns verbally, or ask specific questions. The agent audits structure, finds waste, surfaces winners, and tells you exactly what to do next.

Commands

CODEBLOCK0

What Data to Provide

The agent works with:

• - Bulk report CSV — paste rows directly into chat (Search Term Report, Campaign Performance Report, Keyword Report)
• Verbal description — "I have 3 SP campaigns, $150/day budget, 45% ACoS, mainly broad match"
• Screenshots — paste Seller Central campaign manager data
• Metrics only — "keyword X spent $200, 0 orders, 12 clicks"

No API keys needed. No setup required.

Workspace

Creates ~/amazon-ppc/ containing:

• - memory.md — saved campaign profiles and account history
• INLINECODE2 — past audit reports (markdown)
• INLINECODE3 — raw data snapshots for trend tracking

Analysis Framework

1. Campaign Structure Audit

• - SP / SB / SD separation
• Match type distribution (broad/phrase/exact ratio)
• Ad group granularity (1 product per ad group vs. lumped)
• Auto vs. manual campaign relationship

2. Wasted Spend Detection

• - Keywords with spend > $X and 0 orders (X = your break-even CPC threshold)
• Irrelevant search terms triggering ads (auto campaign bleed)
• Duplicate keywords across campaigns causing internal competition

3. Bid Optimization

• - Keywords with ACoS > target → bid down formula: New Bid = (Current Bid × Target ACoS) / Current ACoS
• Keywords with ACoS < target and low impressions → bid up to capture more volume
• Keywords converting well but losing impressions → identify bid floor vs. auction pressure
• ROAS equivalent: Target ROAS = 1 / Target ACoS (e.g. 25% ACoS = 4x ROAS target); same bid formula applies

4. Search Term Harvesting

• - Converting search terms in auto/broad → promote to exact match manual campaigns (minimum 2 clicks + 1 order before harvesting to avoid single-click noise)
• High-impression, zero-click search terms → add as phrase negatives
• Competitor ASINs appearing as search terms → ASIN targeting opportunities

5. Negative Keyword Mining

• - Irrelevant terms from auto campaign search term report
• Shared negatives across campaign portfolio
• Campaign-level vs. ad group-level negative placement logic

6. Budget & Dayparting Analysis

• - Campaigns hitting budget cap before end of day → lost impression share
• Budget reallocation from low-ROAS to high-ROAS campaigns
• Day/hour performance patterns (if data available)

Benchmarks Used

Weekly Report Format

INLINECODE4 generates a consistent 7-day performance summary:

1. 1. Spend vs. Last Week — total spend delta and budget utilization %
2. ACoS Trend — overall ACoS this week vs. last week, direction arrow
3. Top 5 Performing Keywords — ranked by orders, with ACoS each
4. Top 5 Wasted Spend Keywords — spend with 0 orders, sorted by $ wasted
5. Search Term Wins — new converting search terms worth harvesting
6. Actions Taken / Pending — changes made and outstanding items
7. Next Week Focus — 2–3 priority optimizations for the coming week

Saves to ~/amazon-ppc/reports/weekly-YYYY-MM-DD.md automatically.

Output Format

Every audit outputs:

1. 1. Executive Summary — 3-bullet account health snapshot
2. Quick Wins — actions you can take in the next 30 minutes
3. Structural Issues — longer-term fixes
4. Data Table — keywords sorted by priority (waste / opportunity)
5. Next Audit Checklist — what to check again in 7 days

Rules

1. 1. Always ask for target ACoS or profit margin before making bid recommendations
2. Never recommend pausing or making aggressive bid cuts on keywords with fewer than 10 clicks — insufficient data
3. Flag when data sample is too small for reliable conclusions
4. Distinguish between launch phase (high ACoS acceptable) vs. optimization phase
5. Show math behind every bid recommendation
6. Save audit findings to ~/amazon-ppc/reports/ when asked