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.

Alfred Gabaldon, founder of Stratum PPC
Built by Alfred Gabaldon
Founder & Lead PPC Operator · read more

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.

Your bulk file is parsed in your browser. The raw spreadsheet never uploads. Only the aggregated numbers your report needs are sent to our server, processed in memory, then discarded. Nothing is stored.

Generating Audit Dashboard...

Crunching your campaign data.

Reading campaign structure...
Calculating ad type performance...
Analyzing match types & placements...
Identifying wasted spend...

Brand Name(s)

Used for branded vs. non-branded classification

Separate multiple brand names with commas. Must match how customers search for your brand.

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 Est. Impact

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

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

ASIN Performance

ASIN-level data reflects Sponsored Products only. SB/SD spend is attributed at campaign level and not included here. For full multi-ad-type ASIN attribution, use the Advertised Product Report from Seller Central.
ASIN Spend % of Spend Sales % of Sales Orders Clicks ACOS CVR RPC CPC Gap

Strategy Overview

ACOS Targets
%
%
%
%
Default ACOS Target: --
Intent-Level Targets
%
%
%
Bid Rules
%
$
Search Term Rules
Adds underperforming search terms (excl. Exact & ASIN-Exact) as negative exact in the bulk export.
How New Bids Are Calculated

Determine Target ACOS

  1. If Account Target is enabled, use that ACOS for all targets.
  2. Otherwise, match the campaign name against Objective names (Rank, Defensive, Auto) or Intent names (High / Medium / Low Intent). First match wins.
  3. Auto-targeting rows (close-match, loose-match, substitutes, complements) use the Auto ACOS target if enabled.
  4. If nothing matches, fall back to the Default ACOS (= Account Target value).

Calculate the Raw Bid

ConditionFormulaCriteria 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.

Bid Optimization Preview

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

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.

Performing Search Terms

Underperforming Search Terms

Branded STs in Auto, Broad, Phrase

N-Gram Analysis