Adjusting bids in bulk: the math, the limits, the strategy

The single operation that pays for itself every month

Once your campaigns are live, bid adjustment is where most of your time goes. Every campaign — Auto, Keyword, Product Target — has dozens of individual bids (per keyword, per product target, per auto-targeting group) that need tuning based on performance. Doing it through the Seller Central UI means clicking into each campaign, each ad group, each keyword, one at a time. For an account with 20 campaigns and 30 keywords each — 600 individual bids — that's literally hours of clicking. The same adjustments take 5 minutes via bulk sheet.

This article walks through how to modify bids in bulk: the exact bulk sheet structure for updates (different from creates), the math of bid adjustment, the limits Amazon enforces, and the common strategies that actually work. The widget you've seen on the campaign-creation articles isn't on this page — bid adjustment is an operation on your existing bulk sheet, not a template-generated one. The workflow is: download your current sheet from Seller Central, modify the cells you want to change, set Operation to Update, and upload.

The Update operation: how modifying entities differs from creating

So far in this guide, every example has used Operation = Create. For modifications, the value is Update. This single column change tells Amazon "don't make a new entity — find the existing one with this ID and change it."

That's why the ID columns matter so much when updating. Where a Create row needed a unique ID you made up (which Amazon then assigned to the new entity), an Update row needs the real Amazon-assigned ID for the entity you want to modify. Where do these come from? They're already in the bulk sheet when you download it. Every existing campaign, ad group, keyword, and product target has its Amazon-internal ID filled in. You don't change those IDs — you change the values in the cells you want to update, leave everything else alone, and Amazon uses the ID to find and update the right entity.

The required columns when updating a keyword's bid (per Amazon's spec):

• Keyword Id — the real Amazon-assigned ID, already populated when you downloaded.
• State — the current state (or a new state if you're also pausing).
• Bid — the new bid value.
• Operation — set to Update (was blank on the downloaded sheet).

Other columns can stay as-is. You're not required to clear them or change them. Amazon only acts on what you explicitly want to change.

The typical bulk bid adjustment workflow

Five steps:

1. Download a fresh bulk sheet from Seller Central. Always start from current data — bidding decisions based on stale numbers are bidding decisions made on wrong premises. Seller Central → Advertising → Bulk Operations → Download.
2. Open the sheet in Excel (or Google Sheets). The sheet has thousands of rows. Use Excel's filtering to narrow down to the rows you want to modify — typically by Entity (filter to just Keyword rows), and then by performance criteria (high ACoS, low ACoS, zero orders, etc.) using performance columns if present.
3. Modify the Bid cells for the rows you've identified. New bid values go directly in the Bid column. Numeric only — no dollar signs, no comma separators.
4. Set Operation to Update for every row you modified. This is the single most important step — leaving Operation blank means Amazon ignores your change. Easiest method: filter to your modified rows, type Update in the first row's Operation cell, then drag-fill down the column.
5. Save and upload. Save as .xlsx (preserving the original sheet structure), then upload via Seller Central → Bulk Operations → Upload.

The whole process takes 10–20 minutes for a typical optimization cycle, regardless of how many bids you're adjusting. Adjusting 5 bids takes about as long as adjusting 50, because the bottleneck is making good bidding decisions, not entering them.

The math: how to think about new bid values

The most common framework for bid adjustment is ACoS-driven. You have a target ACoS (Advertising Cost of Sales) for your account or category — say, 25%. Your current campaign data shows each keyword's actual ACoS over the last 30 days. The basic logic:

• If actual ACoS is well above target, the keyword is spending too much per order. Lower the bid.
• If actual ACoS is well below target, the keyword is converting profitably but might be capped on volume. Raise the bid.
• If actual ACoS is near target, leave it alone.

A widely-used formula for the new bid is:

new_bid = current_bid × (target_ACoS / actual_ACoS)

So a keyword with a $1.00 bid and 40% actual ACoS, targeting 25% ACoS, would adjust to $1.00 × (25 / 40) = $0.63. A keyword with a $0.50 bid and 15% actual ACoS, targeting 25% ACoS, would adjust to $0.50 × (25 / 15) = $0.83.

This formula assumes performance is roughly linear with bid, which is approximate. In practice, lowering a bid usually reduces position (which lowers CTR and CVR), and the new ACoS won't drop in perfect proportion to the bid change. A common safety margin is to move bids halfway toward the formula target:

new_bid = current_bid + 0.5 × (formula_target - current_bid)

This makes smaller incremental changes — useful when you have many keywords to adjust and don't want to over-correct. After two or three cycles of half-moves, you converge on the right bid without overshooting.

Decision rules vs raw math

A pure formula is rarely the whole strategy. Most experienced sellers layer decision rules on top:

• Don't raise bids on keywords with fewer than 10 clicks. Statistical noise dominates at that sample size. Wait for more data before increasing.
• Don't lower bids on keywords with fewer than 5 clicks. Same reason — the actual ACoS might just be variance.
• If a keyword has zero orders after 20+ clicks, lower the bid significantly (50%+) or pause. Zero conversions despite traffic is a strong signal the keyword isn't a fit.
• Don't make changes greater than 30% in a single cycle. Big swings are hard to interpret in the next cycle's data — you can't tell what moved performance vs. what was natural variation.
• Cap raises during seasonal periods. If ACoS dips in Q4 because of high CVR from holiday shopping, your formula will recommend raising bids dramatically. Resist — the ACoS will revert in January and you'll be stuck with high bids.

These rules don't replace the math — they bound it. The formula tells you the direction; the rules keep you from doing dumb things at the edges.

Percentage adjustments vs absolute bids

Two ways to set new bids in a bulk sheet:

Absolute — type the exact new bid value in the Bid column. $1.20 → $0.85. Most accurate for surgical changes on specific keywords.

Percentage adjustment in Excel — use a formula in the Bid column to apply a uniform change. For example, to lower all bids in a filtered set by 20%:

=ROUND(B2 * 0.80, 2)

Where B2 is the original Bid cell. After applying the formula, copy → paste-as-values to convert the formulas to plain numbers (Amazon's parser doesn't accept formulas in bulk sheet cells).

Percentage adjustments are useful when you want to apply the same rule to many keywords without computing each one individually. For example, "lower all keyword bids by 15% across this campaign" because you're hitting daily budget every day and want to stretch it.

Amazon's bid limits and constraints

A few hard constraints to respect:

• Minimum bid: $0.02. Anything below fails to upload. If your formula tells you to bid $0.014, round up to $0.02 (or pause the keyword if it doesn't justify even that).
• Maximum bid: $1,000. Very unlikely to hit this in practice, but it exists.
• Bid must be at or above any per-placement multiplier base. If you have a placement adjustment of "+50% on Top of Search," your effective bid for top-of-search placements is bid × 1.5. Your base bid must still respect the $0.02 minimum even after the multiplier is applied.
• Bid changes propagate within 5–30 minutes. Don't expect instant change — there's a processing delay.

Where to set the bid: keyword vs ad group default

Two places a bid can be set:

• Ad Group Default Bid — applies to any targeting (keyword or product target) in the ad group that doesn't have its own specific bid. Set on the Ad Group row.
• Per-keyword (or per-product-target) bid — overrides the default for that specific target. Set on the Keyword or Product Targeting row.

The interaction is: Amazon uses the per-keyword bid if one is set; otherwise falls back to the Ad Group Default Bid. So you can have an ad group with default $0.75, and individual keywords with bids of $1.00, $0.50, or blank (which uses the $0.75 default).

When you adjust bids in bulk, you can change either or both. A common pattern:

• Across-the-board adjustments via the Ad Group Default Bid. Useful when you want to shift the whole ad group's spend up or down.
• Surgical adjustments via per-keyword bids on the specific keywords you've identified as needing change.

If you've been leaving per-keyword bids blank (relying on the default), and you suddenly start filling them in, you're switching that ad group's bidding model from "uniform default" to "keyword-specific." Both work, but be deliberate about which you're using.

Common mistakes when adjusting bids in bulk

• Forgetting to set Operation to Update. The single most common failure. You change the Bid cell but leave Operation blank — Amazon treats the row as read-only and ignores your change. Always set Operation on every row you modify.
• Modifying rows for entities you didn't intend to. Excel's filter-and-paste workflow can accidentally affect filtered-out rows if you're not careful. Always verify which rows have Update in Operation before uploading.
• Bid values formatted as text. If you copy-paste from another source, the Bid cells might be text type rather than number. Excel sometimes shows a small green triangle in the cell corner indicating this. Convert to number before uploading.
• Currency symbols or thousands separators. $1.20 fails; 1.20 works. 1,000 fails (comma); 1000 works.
• Bid below $0.02. Your formula might output $0.018 for a heavily-down-adjusted keyword. Round up to $0.02 or pause the keyword.
• Excel auto-rounding to whole dollars. If a column is formatted as Currency with 0 decimal places, $0.75 displays as $1 and exports as 1. Set the column to display 2 decimal places before working with it.
• Cleaning up too many columns. Some sellers delete the Performance columns or other metadata when editing. Don't — leave the sheet structure as Amazon delivered it. Only change the cells you intend to change.

Reviewing your changes before upload

Before clicking Upload in Seller Central, a 30-second sanity check saves real money:

1. Filter to rows where Operation = Update. Count them. Does the count match what you expected to change?
2. Sort by Bid (descending) within the Update rows. Highest new bids at top — are they reasonable? A $5.00 keyword bid in a category where $1.20 is normal is probably a typo.
3. Sort by Bid (ascending) within the Update rows. Lowest new bids at top — any below $0.02? Any zeros or blanks where there shouldn't be?
4. Spot-check 5 random rows. Does the new Bid make sense given the keyword and the old bid?

If everything looks right, save and upload. Bulk uploads can't be easily undone — they apply to live campaigns spending live money. A 30-second review prevents the worst mistakes.

What happens after upload

Amazon validates and applies bids within 5–30 minutes. New bids take effect for impressions served after the change propagates — old impressions and their CPCs are locked in. So if you lowered a bid at 2pm, the spend you've already accumulated that day stays the same, but bids on impressions starting at ~2:30pm onward use the new value.

The full impact of a bid change isn't visible for 7–14 days, because the rolling 7-day or 30-day metrics in your performance reports include data from before the change. Wait at least a full week before re-evaluating whether the change worked. Re-adjusting too quickly creates whipsaw — you keep changing bids before you've measured the previous change.

The optimization cadence

A common rhythm:

• Monthly: A full bid review across every campaign. Pull the bulk sheet, identify the rows that meet your decision rules (high ACoS, no orders, etc.), apply formula adjustments, upload.
• Weekly: Spot-check the previous month's adjustments. Pull a fresh sheet, see if the changes had the intended effect, fine-tune.
• Quarterly: Re-evaluate the target ACoS itself, decision rules, and overall strategy. Tactical adjustments are weekly/monthly; strategy is quarterly.

If you find yourself adjusting bids more frequently than weekly, you're probably reacting to noise rather than signal. Bid adjustment is a low-frequency, high-impact operation. Slow down and let data accumulate.

Next steps

Bid adjustment dovetails with several other bulk operations:

• Negative keywords — for terms with high spend and no orders, sometimes the right answer isn't lowering the bid but adding the search term as a negative. Covered in the next article.
• Bulk pause — for keywords that have failed across multiple bid-adjustment cycles, pausing is cleaner than continuing to bid at $0.02. Covered in its own article.
• Placement multipliers — when a keyword performs much better in one placement than another, placement-specific bid multipliers extract more value than uniform bids alone.

And the big-picture point: bid adjustment at any meaningful scale is one of the strongest arguments for moving beyond manual bulk sheet edits. BulkSheet Pro applies decision rules across thousands of keywords in a single pass, with the math, sample-size filters, and safety caps built in. It's the operation where the time savings compound fastest. Try it free →