Documentation

Everything you need to know

A complete, plain-language guide to PPC Optimizer Pro โ€” from your first upload to reading every number the tool gives you back. No PPC background required.

Start here

Getting started

PPC Optimizer Protakes the Amazon Ads bulk file you already export from Seller Central, applies a rules engine to it, and hands back a ready-to-upload file with smarter bids, budgets, placements and pauses โ€” no spreadsheet formulas required. It's built for Amazon sellers and agencies running Sponsored Products campaigns who want to stop manually adjusting bids every week.

Who it's for

Anyone managing Amazon Sponsored Products campaigns โ€” from a single-ASIN seller to an agency managing several accounts โ€” who wants faster, more consistent bid and budget decisions than doing it by hand in a spreadsheet.

Creating your account

  1. 1
    Click Start free trial on the homepage or go to /register.
  2. 2
    Enter your full name, choose a username, add your email, and set a password.
  3. 3
    Choose Monthly or Yearly billing and add a payment method to activate your 7-day free trial (see Account & billing โ€” you won't be charged until the trial ends).
  4. 4
    Check your inbox for a verification email and click the link to verify your address.
  5. 5
    Log in and you'll land on your Dashboard.

[SCREENSHOT: Signup form with plan selection step]

Uploading your first bulk file

๐Ÿงพ

What you'll need before starting

An Amazon Sponsored Products bulk file exported from Seller Central: Campaign Manager โ†’ Bulk Operations โ†’ Request Spreadsheet for Download โ†’ select Sponsored Products โ†’ download the .xlsx once it's ready (Amazon emails you when it is).
  1. 1
    Go to Upload & Process in the sidebar.
  2. 2
    Drag your bulk file onto the upload box, or click to browse for it.
  3. 3
    Pick a rules time period โ€” 14, 30, or 60 days (see Bulk File Optimizer for what this means).
  4. 4
    Click Process and wait โ€” most files finish in under 60 seconds.
  5. 5
    Review the change summary, optionally tweak any suggested bid, then download your Amazon-ready file.
  6. 6
    Re-upload that file to Seller Central the same way you always upload bulk files. Changes go live within a few hours.
Plans & payments

Account & billing

Plans

There is one plan โ€” PPC Optimizer Pro โ€” billed either monthly ($19.99/mo) or yearly ($149/yr, ~38% cheaper than monthly). Every plan includes all features: the Bulk File Optimizer, Rules Manager, Auto โ†’ Manual Campaign Builder, and TACoS Analyzer. There are no separate feature tiers โ€” upgrading only changes your billing cycle, not what you can access.

New accounts get a 7-day free trial. A payment method is required to start the trial, but you are not charged until the trial period ends, and you can cancel any time before then from Settings with no charge.

Upgrading, downgrading, and switching billing cycle

Go to Settingsand use the subscription section to change your plan or update your payment method. Payment method updates for past-due accounts are handled through Paddle's secure customer portal (linked from Settings).

Cancelling

  1. 1
    Go to Settings in the sidebar.
  2. 2
    Find the subscription section and click Cancel Subscription.
  3. 3
    Confirm the cancellation. Your Pro access continues until the end of the billing period you already paid for โ€” you are not cut off immediately.

Invoices & billing history

Your Settings page includes a billing history table with every billing event, its status, transaction ID, amount, and a link to the receipt/invoice where available.

Two-factor authentication (2FA)

Also managed from Settings: scan the QR code with an authenticator app, enter the 6-digit code to activate 2FA, and enter a current code any time you want to disable it again.

Account security notes

Each account can only be logged in on one device at a time. Logging in from a new device automatically ends the previous session (you'll see a "Session Expired" notice there). Passwords are hashed with bcrypt and are never visible to anyone, including our team.

Core feature

Bulk File Optimizer

๐Ÿงพ

What you'll need before starting

An Amazon Sponsored Products bulk file (.xlsx) exported from Seller Central's Bulk Operations tool. Requires an active subscription or an active free trial.

Supported file format

Upload the original .xlsx Sponsored Products bulk file exactly as Amazon exports it โ€” don't edit column headers or re-save it in another program first.

Step-by-step upload

  1. 1
    Go to Upload & Process.
  2. 2
    Drop or select your bulk file.
  3. 3
    Choose a rules time period: 14, 30, or 60 days. This tells the tool which set of rules (from your Rules Manager) to apply โ€” shorter windows react faster to recent performance, longer windows smooth out day-to-day noise.
  4. 4
    Optional โ€” upload a "validation" bulk file from a different, usually longer, lookback window. This is a safety check: before applying a change, the tool cross-references this second file so a rule doesn't act on a false positive (for example, pausing a keyword that only looks bad over 14 days but has been converting steadily over 30). For a 14-day primary file you can choose a 30- or 60-day validation window; a 30-day primary always validates against 60 days; a 60-day primary has no longer window to validate against.
  5. 5
    Optional โ€” set the Magic Placement maximum percentage (defaults to 40%), which caps how high the tool will raise Top-of-Search / Product Page placement percentages.
  6. 6
    Click Process.

[SCREENSHOT: Upload & Process page with file dropzone, time period selector, and Magic Placement slider]

How bid recommendations are calculated (plain language)

Behind the scenes, your Rules Managerholds 150+ prebuilt rules (plus any custom rules you write). Each rule looks at a condition โ€” for example "ACOS between 40% and 100%, at least 1 click, no orders" โ€” against every keyword/target/campaign row in your bulk file. When a row matches a rule's condition, that rule's action is applied: raise the bid, lower it, set it to a specific formula-based value, adjust a budget, adjust a placement percentage, or pause the row entirely. Every rule also has minimum and maximum bid guardrails so a formula can never push a bid to an unreasonable extreme. We don't publish the exact internal formulas here since they're part of the product, but every single change the tool makes is fully explained in plain language in the debug output (see below) โ€” nothing is a black box.

Reading the before/after output

After processing finishes, you get:

  • Change summary โ€” total rows processed, rows changed, pauses, bid changes, placement changes, and how many rows were protected by the validation guard.
  • Amazon-ready file โ€” the file you re-upload to Ads Console. Contains only what Amazon's bulk upload format expects.
  • Debug file (.xlsx and .csv) โ€” a row-by-row breakdown showing the old bid, the new bid, which rule triggered the change, and the reason. Use this if you want to understand or audit exactly why something changed.

Before downloading, you can also manually override any individual suggested bid directly on the results screen if you want the final say on a specific keyword or target.

Downloading & re-uploading to Amazon Ads Console

  1. 1
    Review the summary and, optionally, adjust any bid inline.
  2. 2
    Click download on the Amazon-ready file. This is a one-time, AES-256-GCM encrypted download โ€” once downloaded, the file is deleted from our servers.
  3. 3
    In Seller Central, go to Campaign Manager โ†’ Bulk Operations โ†’ Upload Spreadsheet, and upload the file you just downloaded.
  4. 4
    Amazon typically applies bulk changes within a few hours.

Rules Manager

The Bulk File Optimizer is powered by your Rules Manager (in the sidebar). Each rule is defined by an entity, which match types it applies to (Exact, Phrase, Broad, PAT, and more), a campaign type filter (All / Sponsored Products / Sponsored Brands / Sponsored Display), metric range filters (impressions, clicks, spend, sales, orders, ACOS, CTR, CVR, CPC), a formula/action, and min/max bid guardrails. You can enable or disable any rule per time period (14/30/60-day sheet), or build entirely custom rules with your own conditions.

Free tool

Search Term Analyzer

๐Ÿงพ

What you'll need before starting

A Search Term report exported from Amazon Ads Console. This tool is free and available without logging in at /free-tools/search-term-analyzer.

Upload your search term report and the tool ranks every search term by wasted ad spend โ€” search terms that have burned budget with little or no conversions โ€” so you know exactly what to cut first, ordered from the most expensive waste down.

Exporting negative keywords

  1. 1
    Upload your Search Term Report (.xlsx).
  2. 2
    Review the ranked list of wasted-spend search terms.
  3. 3
    Enter your email address when prompted (required once, to unlock the download).
  4. 4
    Download the negative keyword export and upload it to your campaigns to block those search terms going forward.
Pro feature

Auto โ†’ Manual Campaign Builder

๐Ÿงพ

What you'll need before starting

An Amazon Bulk Entity file that includes your Auto campaigns' search term data. This is a Pro feature โ€” it requires an active subscription or trial, whether you access it from the dashboard or from its public-facing page at /free-tools/auto-to-manual. That page lives under the free-tools URL for discoverability, but it's not a free tool โ€” you'll be asked to log in, and then to subscribe if you don't already have an active plan, before you can actually use it.

When to use it

Automatic campaigns are great at discovering new converting search terms, but leaving winners running only inside Auto campaigns means you can't control their bids precisely by match type. Use this tool once your Auto campaigns have enough history to have found some real winners โ€” typically after they've been running a few weeks.

What "graduating" a search term means

"Graduating" a search term means taking a search term that's already proven itself inside an Auto campaign (enough orders, low enough ACOS) and giving it its own dedicated targeting in a new Manual campaign โ€” as an Exact, Phrase, and/or Broad match, each with its own bid. This gives you precise bid control over your best-performing terms instead of leaving them at the mercy of Amazon's automatic targeting.

Step-by-step walkthrough

  1. 1
    Go to Auto โ†’ Manual in the sidebar.
  2. 2
    Upload your Amazon Bulk Entity file.
  3. 3
    Set your thresholds: Min Orders (how many orders a search term needs before it "graduates"), Max ACOS % (the highest ACOS a term can have and still qualify), and Daily Budget for each new campaign created.
  4. 4
    Set a Bid Increase % per match type (Exact, Phrase, Broad) โ€” the new campaign's starting bid is calculated from the search term's existing CPC plus this percentage.
  5. 5
    Choose which match types you want generated (Exact, Phrase, and/or Broad).
  6. 6
    Generate the file โ€” it creates new, separate Manual campaigns for the qualifying search terms without duplicating anything you've already built manually.
  7. 7
    Download and upload the resulting bulk file to Seller Central.

[SCREENSHOT: Auto โ†’ Manual results table showing graduated search terms grouped by ASIN and match type]

Pro feature

TACoS Analyzer

๐Ÿงพ

What you'll need before starting

A bulk/business report export that includes both advertising data and total sales data per ASIN. Requires an active subscription or trial.

ACOS vs. TACoS

ACOS (Advertising Cost of Sales) only looks at sales that Amazon directly attributes to an ad click โ€” it tells you how efficient your ad spend is against ad-driven sales alone. TACoS (Total Advertising Cost of Sales) divides your ad spend by all sales for that ASIN โ€” organic and ad-driven combined โ€” so it tells you how much of your total business is being funded by advertising, and whether your ads are helping organic sales grow over time.

How the tool connects ad spend to total sales

Upload your report and the analyzer matches campaign-level ad spend and ad sales to each ASIN, then combines that with the ASIN's total sales, orders, returns and royalties to calculate ACOS, TACoS, gross profit, and net profit per ASIN โ€” plus a breakdown of Sponsored Brands and Sponsored Display spend/sales where available.

Reading the trend view

The results table is sortable by any column and color-codes ACOS and TACoS โ€” green for healthy, amber for borderline, red for a value worth investigating โ€” so you can scan a large ASIN list and immediately spot which products are burning budget without contributing organic growth.

Bulk-pausing underperforming ASINs

  1. 1
    Select the checkbox next to any ASIN(s) you want to pause.
  2. 2
    Click the pause action to open the pause dialog.
  3. 3
    Re-upload your Amazon Bulk File when prompted โ€” the tool marks every campaign containing the selected ASINs as paused and returns an Amazon-ready file.
  4. 4
    Upload that file to Bulk Operations in Seller Central.
Home base

Dashboard overview

Your Dashboard is the first thing you see after logging in. It shows:

  • Subscription status card โ€” your current plan status (Free, Trialing, Active, Canceled, Past Due) with a button to upgrade or manage your plan.
  • Processing stats โ€” Total Jobs, Completed, Rows Processed, and Rows Changed, filterable by Last 7 Days, Last 30 Days, or a custom date range.
  • Detailed stats โ€” Bid Changes, Placement Changes, Paused rows, and Average Processing Time.
  • Recent Jobs table โ€” your latest processed files with status, row counts, processing time, and date.
  • Quick actions โ€” one-click shortcuts to Manage Rules, Upload & Process, Auto โ†’ Manual, and Processing History.

[SCREENSHOT: Dashboard with subscription card, stat cards, and recent jobs table]

Processing History

The Historypage (in the sidebar) keeps a full log of every file you've processed, including completed vs. failed job counts, so you can look back at what you ran and when.

When something goes wrong

Troubleshooting

My file failed to process

Make sure you're uploading the original Amazon Sponsored Products bulk file (.xlsx) exactly as exported from Seller Central's Bulk Operations tool โ€” don't rename column headers, delete columns, or re-save it in Excel/Google Sheets first, since that can change the file's internal formatting.

I'm not seeing any changes in the output

Check that you have rules enabled for the time period (14/30/60-day) you selected in the Rules Manager, and that your campaign data actually meets the conditions of your active rules โ€” if nothing in your file matches a rule's condition, nothing will change, and that's expected behavior, not a bug.

The download button isn't working

Downloads only become available once a job's status shows completed. Failed jobs have no output to download โ€” re-upload the original file and try processing again. Also remember downloads are one-time: once you've downloaded a file, it's deleted from our servers, so re-process the file again if you need another copy.

I can't log in

Make sure your email is verified โ€” check your inbox and spam folder for the verification email. Remember accounts are limited to one device at a time, so logging in elsewhere will end any other active session. If you're still stuck, contact support.

My validation file was ignored

A 60-day rules sheet has no longer window available to validate against, so the validation upload is hidden for that time period by design โ€” that's expected, not an error.

Common questions

FAQ

Is my advertising data safe?+
Yes. Files are encrypted with AES-256 at rest and over HTTPS in transit, and every processed file is deleted from our servers after you download it once.
How does the 7-day free trial work?+
Sign up, verify your email, and add a payment method. You get full access for 7 days and won't be charged until the trial ends โ€” cancel any time before then from Settings and you pay nothing.
Can I share my account with a teammate?+
Not simultaneously โ€” each account is limited to one active device/session at a time, and a new login automatically ends the previous session.
What happens if I cancel?+
Your access continues until the end of the billing period you already paid for. You won't be charged again after that.
Which Amazon marketplaces are supported?+
All of them โ€” US, UK, CA, DE, FR, IT, ES, JP, IN, AU, and any other marketplace that supports Sponsored Products bulk files.
How long does processing take?+
Most files up to 30,000 rows finish in under 60 seconds. Larger files may take a bit longer.
Do I need a separate plan for each feature?+
No โ€” every plan includes the Bulk File Optimizer, Rules Manager, Auto โ†’ Manual Builder, and TACoS Analyzer. There are no feature-gated tiers.
Terminology

Glossary

New to Amazon PPC? Here are the terms used throughout this documentation and the app.

ACOS (Advertising Cost of Sales)
Ad spend รท ad-attributed sales ร— 100. Measures how efficiently your ad spend converts into ad-driven revenue.
TACoS (Total Advertising Cost of Sales)
Ad spend รท total sales (organic + ad-driven) ร— 100. Measures how much of your overall business is funded by advertising.
Bid
The amount you're willing to pay for a click on a keyword or product target.
Match type
How closely a shopper's search has to match your keyword to trigger your ad โ€” Exact, Phrase, or Broad (from most to least strict).
Search term vs. keyword
A keyword is what you targeted; a search term is what the shopper actually typed. Broad and Phrase match can trigger your ad on search terms that don't exactly match your keyword.
Bulk sheet / bulk file
The .xlsx spreadsheet exported from Amazon Ads Console's Bulk Operations tool, containing every campaign, ad group, keyword, and target โ€” the file this tool reads and rewrites.
Placement
Where your ad shows on the search results or product page โ€” Top of Search, Rest of Search, or Product Pages. You can bid a percentage higher for specific placements.
Negative keyword
A keyword you explicitly block your ads from showing for, usually because it's been burning spend with no conversions.
CTR / CVR / CPC
Click-Through Rate (clicks รท impressions), Conversion Rate (orders รท clicks), and Cost Per Click (spend รท clicks).
Auto vs. Manual campaign
Auto campaigns let Amazon choose what search terms to target; Manual campaigns let you target specific keywords or products yourself with full bid control.

Still need help?

Can't find what you're looking for? Our team is ready to help.

๐Ÿ“ฉ Contact Support