Amazon Ads

Amazon Bulksheets: Bulk Bids, Keywords, Negatives and New Campaigns

The bulksheets workflow for Amazon Ads: download, edit bids, keywords and negatives, build new campaigns, upload, fix the error file, and decide when to use bulk, the console or an AI assistant.

Cover: Thousands of edits, one upload. a spreadsheet with Product, Entity and Operation columns highlighted, feeding an upload arrow into an Amazon campaign list.

Bulk, console or assistant: which one?

Checked 19 Nov 2026

Pick the tool for the job

 ConsoleBulksheetClaude via MCP
Change 5 bidsBestOverkillFine
Change 2,000 bids by formulaNoBestGood if the rule needs analysis first
Add 300 negatives from search termsSlowGoodBest: it can pick them from the report too
Build 20 campaigns from a planSlowBest for large buildsGood, with a preview of each
Rename to a new naming conventionSlowBestGood
Pause everything for an out-of-stock productSlowGoodBest: find and pause in one request
First new Sponsored Brands adRequired (assets)Needs asset IDs firstNeeds assets uploaded first

Bulksheets cover all sponsored ads campaign types (Amazon’s bulksheets FAQ). The legacy template was deprecated on 28 September 2023, so any file or macro older than that needs rebuilding (bulksheets overview).

The bulksheets workflow

How to

Edit Amazon campaigns with bulksheets

The download, edit, upload and fix loop an agency team uses.

⏱ About 30 minutes

  1. 01

    Open Bulk operations

    In the Amazon Ads console go to Sponsored ads > Bulk operations. Sellers can also reach it from Seller Central under the campaigns view.

  2. 02

    Create a custom spreadsheet

    Pick a date range (up to 60 days) and tick what you need: campaign items with zero impressions for keyword clean-ups, placement data, Sponsored Products search term data, brand assets data for Sponsored Brands builds.

  3. 03

    Keep an untouched copy

    Save the download as your rollback file before editing anything.

  4. 04

    Filter and edit

    Filter the Entity column to what you are changing (Keyword, Product targeting, Campaign). Edit values and set Operation to Update, Create or Archive only on rows that change.

  5. 05

    Follow the format rules

    Dates as YYYYMMDD, percentages as whole numbers (Sponsored Brands placement multipliers take the % sign), no currency symbols or thousands separators, bids to two decimals.

  6. 06

    Upload and read the result

    Upload on the same page. If the history shows "Finished with errors", download the error report, fix the rows in that file and upload it again.

  7. 07

    Check in the console

    Spot-check a few campaigns and keep the edited file with the date in your change log.

Column cheat sheet

Checked 19 Nov 2026

Sponsored Products bulksheet columns that matter

 What it doesGotcha
ProductSponsored Products, Sponsored Brands or Sponsored DisplayOne tab per ad product
EntityCampaign, Ad group, Product ad, Keyword, Negative keyword, Product targeting, Bidding adjustmentOne row per entity
OperationCreate, Update or ArchiveBlank = row ignored
Campaign ID / Ad Group IDLinks child rows to parentsNew: any text, same in every child row. Existing: numeric bulksheet ID, not the console ID
Campaign NameThe name shown in the consoleRename with Operation = Update
Stateenabled or pausedPause instead of Archive
Daily BudgetCampaign budgetNo symbols or commas
Bid / Ad Group Default BidKeyword or target bid; ad group defaultTwo decimals
Keyword Text / Match TypeThe keyword and broad, phrase, exact or negative matchWatch special characters
Bidding StrategyDynamic bids - down only, Dynamic bids - up and down, Fixed bidExact wording
Placement / PercentageOn a Bidding adjustment row: top of search, rest of search or product pageWhole numbers
Product Targeting ExpressionASIN, category or auto group (close-match, loose-match, substitutes, complements)Auto groups appear as rows you can bid on
Eligibility statusWhether each product ad can serve, with the reasonRead-only, but the fastest eligibility audit

Three recipes

Bulk bid changes by formula

Download keywords and product targets with 30 to 60 days of data. A common formula is new bid = (sales ÷ clicks) × target ACOS: what a click earns, times the share you can spend. Cap changes to a set percentage per round (starting point: 20 to 30%), skip rows with too few clicks, set Operation to Update on changed rows only.

Negatives from search terms

Tick Sponsored Products search term data in the download. The tab carries campaign and ad group IDs, so you can turn chosen terms into Negative keyword rows with Operation = Create. Remember the tab’s fixed 7-day lookback (Amazon); use the console report for longer windows.

A new campaign from a template

Write a Campaign row with a text ID such as "AE_SP_GEN_EXACT_Knives", then Ad group, Product ad, Keyword and Bidding adjustment rows using the same text IDs (create a Sponsored Products campaign). The start date can’t be in the past, so a file prepared on Monday and uploaded on Tuesday fails if it says Monday.

Where this goes wrong

  • Console IDs in an update. Amazon says bulksheet IDs differ from console IDs (FAQ). Always update from a fresh download.
  • Editing a stale file. A colleague or a rule changed bids since your download, and your upload overwrites them. Download again just before you upload.
  • Archiving to "clean up". Archived entities "cannot be changed in any way" (error reports). Pause.
  • Spreadsheet software reformatting IDs. Long numeric IDs can turn into scientific notation or lose digits. Format ID columns as text before saving.
  • Sponsored Brands without assets. Logos and videos must already be in your creative assets library before a bulksheet can use them.
  • One huge file. Split by ad product or portfolio so one error doesn’t block everything and the error report stays readable.

Do it faster with Whathead

Whathead doesn’t read or write bulksheet files. Instead, Claude or ChatGPT makes batch changes through the Amazon Ads MCP: adding keywords and negatives, changing bids and budgets, pausing product ads, across Sponsored Products, Brands and Display. Use it when the change needs analysis first; for thousands of plain edits you already have in a sheet, the bulksheet is still the right tool. Whathead is our product.

  • “Find every enabled product ad for these three ASINs across all campaigns in the UAE profile and pause them. Show me the list and the preview.”
  • “For keywords with 20+ clicks in the last 30 days, set bid = sales per click × my target ACOS of [Y]%, capped at ±[Z]% from today. Preview the changes as a table with old and new bids.”

Each batch comes back as a dry-run preview of the exact change before anything is sent, and destructive actions such as deletes need an extra confirmation. For the same safety habits on any platform, see bulk editing ads safely.

Related: the weekly search term harvest, campaign structure and naming, and the bulk upload guides for Facebook Ads and creatives across platforms.

Amazon bulksheets: common questions

Why did my Amazon bulk upload fail?

Download the error report from the Bulk operations history. The most common causes are console IDs instead of bulksheet IDs, a child row whose temporary ID doesn’t match its parent, a start date in the past, and formatting such as currency symbols or commas.

Can I create new campaigns with bulksheets?

Yes, for Sponsored Products, Sponsored Brands and Sponsored Display. Use text temporary IDs for new campaigns and ad groups. Sponsored Brands also needs brand assets already in your creative assets library.

What changed in Bulksheets 2.0?

The template now starts with Product, Entity and Operation columns, and the legacy template stopped working on 28 September 2023. Old files and macros need rebuilding.

Can I fix errors without starting again?

Yes. Amazon lets you edit the rows in the error report file and upload that file again. Rows that failed only because a parent failed are fixed once the parent row is fixed.

Do bulksheets show whether a product is eligible to advertise?

Yes. A custom download includes Eligibility status and Reason for ineligibility next to product ads, which makes it the quickest catalogue-wide eligibility check.

Sources

Written by Ahmed Shahin, founder of Whathead. Last reviewed 19 November 2026.