Amazon Sponsored Products: The Campaign Structure That Saved Me 10 Hours a Week

William — Sat, 09 May 2026 05:54:29 +0000

I've built over 200 Amazon SP campaigns in the past two years. Here's the structure I settled on after wasting thousands on poorly organized ads.

The problem with most campaign setups
New sellers usually do one of two things:

Throw everything into one auto-targeting campaign and hope for the best
Create a separate campaign for every single keyword (unmanageable after 5 products)
Both approaches fall apart at scale. The first gives you zero control. The second buries you in data.

My 3-campaign structure (per product)
Campaign 1: Exact Match (Harvest)

5-10 proven keywords that already convert
Bid 20% above Amazon's suggested bid
Top of Search placement adjustment: +50%
This is your money-maker. Tight targeting, maximum visibility.
Campaign 2: Broad Match (Discovery)

20-30 keywords, lower bids
Purpose: find new search terms you haven't thought of
Check the Search Term Report weekly
Any term that converts 3+ times → move to Campaign 1
Campaign 3: Auto Targeting (Scout)

Close Match + Substitutes: enabled
Loose Match + Complements: paused (not deleted — Amazon rejects the file if you remove these rows)
Run for 2 weeks minimum before judging performance
Harvested terms go to Campaign 1 or Campaign 2
The weekly loop
Every Monday, 15 minutes:

Pull the Search Term Report for the past 7 days
Any search term with 3+ conversions → add to Exact campaign
Any search term with 10+ clicks and 0 conversions → add as negative keyword
Repeat
After 4 weeks of this cycle, ACOS stabilizes without daily bid adjustments.

The setup bottleneck
This structure works. But setting it up manually is painful.

3 campaigns × 5 ad groups × keywords, bids, negatives, placement adjustments... for each product. Amazon's bulk sheet template has 30+ columns and no forgiveness for formatting errors.

I built AMZTool specifically to eliminate this bottleneck. You configure the campaigns in a form, click generate, and get a ready-to-upload .xlsx file. Free tier covers 12 generations per month.

But even if you set everything up manually — use this structure. It works.

How an Amazon Ad Operator Became an Indie Developer (Without Knowing How to Code)

William — Thu, 30 Apr 2026 02:04:26 +0000

The Problem

Running Amazon PPC campaigns = building dozens of campaigns per product launch, each with budgets, keywords, match types, targeting groups. Manual process: 6-8 hours for 12 products.

The Learning Path

Month 1: HTML + CSS + JS → ugly CSV generator
Month 2-3: React → component-based app
Month 4: Python FastAPI + Supabase
Month 5-6: Polish + deploy

What Surprised Me

Building is the easy part — marketing is the real grind
Users don't care about your code
Best features come from support conversations
Free tier > paid marketing

Knowing the domain deeply makes up for weak coding skills.
AMZTOOL

DEV Community: William

Amazon Sponsored Products: The Campaign Structure That Saved Me 10 Hours a Week

How an Amazon Ad Operator Became an Indie Developer (Without Knowing How to Code)

The Problem

The Learning Path

What Surprised Me