Your campaign view is lying to you.
Upload your bulk file. See exactly where your ad spend is going, what's converting, and what's quietly bleeding money you can't see from the campaign view. Free, no email.
Don't want to upload yet? See a sample report with real-shape data.
How to download your bulk file
Amazon Ads Bulk Sheet (last 60 days)
Go to Amazon Ads > Bulk Operations > Download, and include:
- Sponsored Products: Targeting & Keywords (Status: Enabled + Paused)
- Paused Campaigns
- Placement Data for Campaigns
- Sponsored Products Data
- Sponsored Brands Multi-Ad Group Data
- Sponsored Display Data
- Sponsored Products Search Term Data
- Sponsored Brands Search Term Data
Missing tabs grey out affected metrics, not a hard error. The last 60 days is enough.
Separate multiple brand names with commas. Used for branded vs. non-branded analysis.
Drop your bulk file here
Accepts .xlsx files from Amazon Ads Bulk Operations. Typical size: 2–40 MB.
Account Health Snapshot
Key metrics scored against the right targets for your strategic phase (awareness, growth, or profitability)
| Focus Area | Key Metric | Current Value | Status | Benchmark |
|---|
Ad Type Performance
Sponsored Products vs. Brands vs. Display breakdown (campaign-level data)
| Ad Type | Spend | % Spend | Sales | Orders | ACOS | ROAS | CPC | CVR | RPC |
|---|
Branded vs. Non-Branded
SP Search Term Report classification
Comma-separated. Match how customers actually search for your brand.
| Type | Spend | Sales | Orders | ROAS | ACOS | CVR |
|---|
Placement Performance
SP Campaigns by ad placement
| Placement | Spend | % Spend | Sales | ACOS | ROAS | CVR | RPC |
|---|
Match Type Performance
SP Search Term Report broken down by keyword match type
| Match Type | Spend | % Spend | Clicks | Sales | Orders | CPC | ROAS | ACOS | CVR |
|---|
Keyword Category Distribution
Every keyword classified into one of four buckets using the Stratum RPC methodology. Shows where your keyword portfolio health sits at a glance.
| Category | # Keywords | Spend | % of Spend | Sales | ACOS | Avg RPC | Avg CPC |
|---|
Budget Management
Campaigns hitting budget caps and campaigns constrained from scaling. These are the easiest wins in the account.
Budget-Capped Winners growth opportunities
| Campaign Name | Daily Budget | Avg Daily Spend | Utilization | ACOS | Suggested Budget |
|---|
Budget Bleeders wasteful campaigns
| Campaign Name | Daily Budget | Avg Daily Spend | Utilization | ACOS | Target CPC |
|---|
Wasted Spend Analysis
Top 20 campaigns by zero-order spend (campaigns with spend > $10)
| Campaign Name | Ad Spend | PPC Revenue | ACOS | Spend (No Orders) | Spend (With Orders) | Wasted % | Negated Keywords | Search Term Count |
|---|
A 30-minute call with me, not a sales team. No obligation and no black-box "trust us" nonsense. You keep the full audit either way.
ASIN Performance
| ASIN | Spend | % of Spend | Sales | % of Sales | Orders | Clicks | ACOS | CVR | RPC | CPC |
|---|---|---|---|---|---|---|---|---|---|---|
Strategy Overview
How New Bids Are Calculated
Determine Target ACOS
- If Account Target is enabled, use that ACOS for all targets.
- Otherwise, match the campaign name against Objective names (Rank, Defensive, Auto) or Intent names (High / Medium / Low Intent). First match wins.
- Auto-targeting rows (close-match, loose-match, substitutes, complements) use the Auto ACOS target if enabled.
- If nothing matches, fall back to the Default ACOS (= Account Target value).
Calculate the Raw Bid
| Condition | Formula | Criteria Label |
|---|---|---|
| Low Clicks enabled, sales = 0, clicks < threshold | Current Bid + $increase |
Low Clicks +$X.XX |
| Zero Sales enabled, sales = 0, clicks ≥ threshold | Current Bid × (1 − decrease%) |
Zero Sales −X% |
| No spend or no sales yet | Current Bid (no change) |
No Sales Yet, Still Gathering Data |
| Has spend, sales & clicks (normal case) | RPC × Target ACOS where RPC = Sales ÷ Clicks |
Target ACOS X% |
Apply Guardrails
- Max Bid Change %: caps the swing to ±X% of the current bid, preventing sudden jumps.
- Max Bid $: hard ceiling. The new bid will never exceed this dollar amount.
Final bid is rounded to the nearest cent.
All three ad types
Sponsored Products, Sponsored Brands, and click-priced (CPC) Sponsored Display targets all use the same math above. Sponsored Display reach bids (vCPM / impression-priced) are not click-based, so the tool will not fabricate a bid for them: it holds the current bid, flags the row “review manually,” and leaves it out of the export. The bulk file is written as up to three Amazon-formatted sheets, one per ad type.
Sponsored Products
Status |
Campaign Name▲▼ | Ad Group Name▲▼ | Targeting▲▼ | Match Type▲▼ | New Bid▲▼ | Old Bid▲▼ | Criteria▲▼ | Impressions▲▼ | Clicks▲▼ | Spend▲▼ | Orders▲▼ | Sales▲▼ | ACOS▲▼ | CVR▲▼ | CTR▲▼ | CPC▲▼ | ROAS▲▼ |
|---|
Campaign Overview
Sponsored Products
| Campaign Name▲▼ | Spend▲▼ | Sales▲▼ | ACOS▲▼ | Target ACOS▲▼ |
|---|
Download Bulk Upload File
Generate an Amazon-formatted .xlsx bulk file with your optimized bids from the Strategy Overview. Covers all three ad types (Sponsored Products, Brands, Display) as separate sheets. Sponsored Display reach bids (vCPM / impression-priced) aren't click-based, so we hold them for your manual review rather than fabricate a number.