A monthly bulk operations workflow for Amazon Ads

The cadence that ties everything together

The individual bulk operations — bid adjustments, negative keywords, harvesting, pausing, placement multipliers — are each useful on their own. The real return on investment, though, comes from running them as a coordinated monthly cycle. Each operation reinforces the others. Harvesting feeds Keyword campaigns; bid adjustment fine-tunes them; negatives prevent waste; pausing cleans up failures; placement multipliers boost the winners. Run all of these once a month with consistent rules and the account compounds in performance over time.

This article lays out a practical monthly workflow. It assumes you've read the individual articles for each operation; if some are still new to you, jump back to them as you read. The workflow synthesizes them into a single cadence you can run on your account each month in 60–90 minutes.

The overview: one monthly cycle, four phases

The full cycle has four phases, run in order:

1. Phase 1 — Pull data (~10 min). Download a fresh bulk sheet and the relevant performance reports. Open them, get oriented.
2. Phase 2 — Harvest and prune (~25 min). Identify positive and negative harvest candidates from the search term report. Build the harvest rows.
3. Phase 3 — Optimize active campaigns (~25 min). Adjust bids, update placement multipliers, pause non-performers. Operate on existing entities.
4. Phase 4 — Review and upload (~10 min). Pre-upload checks, upload, verify.

Total time, for a typical account with 15–25 campaigns: about 70 minutes if you're moving steadily. New users take longer the first few cycles; experienced users get it under an hour.

Phase 1: Pull data (10 minutes)

From Seller Central:

• Bulk sheet: Download a 30-day Custom Spreadsheet, all ad products, with performance metrics included. Save it as account-2026-MM-DD.xlsx with today's date. This is your working copy and your backup. If anything goes wrong this cycle, the file is your rollback.
• Customer Search Term Report: Download from Reports → Advertising → Search Term Report. 30-day window. This is what you'll use for harvest decisions.
• Placement Report: Download from Reports → Advertising → Placement Report. 30-day window. This is what you'll use for placement multiplier decisions.

Open all three files. Verify dates and that data is fresh. Look at high-level account numbers — total spend, total sales, blended ACoS — to set context for the cycle.

Phase 2: Harvest and prune (25 minutes)

The harvest phase has two parallel tracks: positive harvests (new keywords) and negative harvests (search terms to block). Work both in the search term report simultaneously.

Positive harvests. Apply your decision rules:

• 2+ orders in the period, OR
• 1 order with ACoS ≤ target and 5+ clicks, OR
• 1 order with CVR ≥ 8% (or your category-specific equivalent)

Exclude duplicates (terms already in your existing Keyword campaigns) and obviously off-topic terms.

For each survivor, create a Keyword row in your bulk sheet — typically in a dedicated "Harvested Keywords" ad group of an existing Keyword campaign, or in a new harvest-specific campaign. Match type usually exact. Bid 130–150% of the Auto campaign's bid for the relevant group.

Negative harvests. Apply your decision rules:

• 10+ clicks, 0 orders, OR
• 5+ clicks, 0 orders with high spend, OR
• 1 order with ACoS > 100%, OR
• Obviously off-topic (any data)

For each, create a Negative Keyword row in the source campaign. negativeExact for specific terms; negativePhrase for variations.

Expected output: 5–25 positive harvests and 10–40 negative harvests per cycle for a healthy mature account. Larger accounts produce more; brand-new accounts produce more in their first few cycles.

Phase 3: Optimize active campaigns (25 minutes)

With the harvest rows done, switch focus to existing entities. Three sub-phases:

3a: Bid adjustment (~15 min).

Filter the bulk sheet to Keyword and Product Targeting rows. Apply your bid formula and decision rules:

• Keywords with clicks ≥ 10 and ACoS significantly above target: lower bid by formula × 0.5 (the half-move safety variant).
• Keywords with clicks ≥ 10 and ACoS significantly below target: raise bid by formula × 0.5.
• Keywords with clicks < 10: no change. Insufficient sample.
• Cap any single adjustment at 30% to prevent overshoot.
• Don't lower below $0.02 minimum.

Set Operation to Update on every adjusted row. Verify the Bid column changes are reasonable.

3b: Pause non-performers (~5 min).

For keywords/targets that have failed across multiple cycles (30+ clicks, 0 orders, already at min bid or close), change State to paused and Operation to Update. These are the entities your bid adjustment can no longer save.

Also pause any product targets or keywords where you discovered the targeting was simply wrong (off-topic, wrong category, wrong audience). Don't wait for performance data on obvious mismatches.

3c: Placement multipliers (~5 min).

For each campaign with sufficient placement-level data (100+ clicks per placement), check the Placement Report:

• Is one placement converting dramatically better than the campaign average? → Boost it with a multiplier (start at 20–40%, increase in subsequent cycles if data continues to support).
• Is one placement way worse? → Lower the base bid and add positive multipliers elsewhere. (Amazon doesn't allow negative multipliers; you can only boost.)

Build Bidding Adjustment rows for campaigns where you're changing multipliers. Use Operation = Update for existing multipliers; Create for first-time multipliers.

Phase 4: Review and upload (10 minutes)

You now have a bulk sheet with many modifications across:

• New Keyword rows (positive harvests)
• New Negative Keyword rows (negative harvests)
• Updated Keyword rows (bid changes)
• Updated Keyword and other rows (pauses)
• New or Updated Bidding Adjustment rows (placement multipliers)

Pre-upload checks:

1. Filter Operation to Create. Count visible rows. Does the count match what you expected (harvests + multipliers)?
2. Filter Operation to Update. Count visible rows. Does it match (bid changes + pauses + multiplier updates)?
3. Sort Bid descending (within Update rows). Highest new bids at top. Spot-check 5 — any way out of range? Any $50 instead of $0.50?
4. Sort Bid ascending (within Update rows). Lowest new bids at top. Anything below $0.02? Any zeros or blanks?
5. Eyeball the State column on Update rows. Confirm the entities you intended to pause are marked paused; the rest remain enabled.

If checks pass, save and upload. Wait for the result file. Filter to Status = ERROR; if any errors, fix and re-upload just those rows. Most cycles have 0–3 errors.

After successful upload, spot-check 3 campaigns in the UI to confirm changes are live. Done.

What to do between monthly cycles

The monthly cycle is the heavy lift. Between cycles:

• Weekly: A 5-minute UI spot-check. Are any campaigns spending dramatically out of pattern? Any major issues (out-of-stock SKUs still advertising, daily budget caps consistently hit)? Address with a small one-off upload if needed.
• Event-driven: Product launches, big inventory shifts, or unusual market events sometimes warrant off-cycle work. Limit to the change being addressed; don't do a full optimization cycle out of rhythm.
• Daily: Nothing, generally. Daily adjustments on Amazon Ads is whipsaw — too much noise per day to make good decisions.

The quarterly review

Every three months, in addition to the monthly cycle, do a structural review (~30 min extra):

• Are your target ACoS goals still right? If margins have shifted, if a new product line has different economics, target ACoS may need revisiting.
• Are your decision-rule thresholds still right? Click thresholds, conversion thresholds, harvest criteria — review and adjust based on three months of data on whether your rules are producing good harvests and good adjustments.
• Should any campaigns be archived? Long-paused campaigns (90+ days) that you have no plans to revive are candidates for archive. Cleans up the bulk sheet.
• Should any new campaigns be created? New product launches, new strategic priorities, new geographic expansions. Build via the campaign-creation articles.
• Are Sponsored Brands and Sponsored Display getting their share of attention? The monthly cycle naturally biases toward SP because that's where most of the volume is. Make sure SB and SD aren't getting neglected.

The quarterly review is strategic; the monthly cycle is tactical. Both matter.

Adapting the workflow to your account

The cycle above is a default. Modify based on your situation:

• Smaller accounts (under 5 campaigns): The cycle takes 30 minutes, not 70. Same phases, less data.
• Larger accounts (50+ campaigns): The cycle takes 2–3 hours. Consider splitting it across two sittings — harvest one day, optimize the next. Or compress by setting tighter decision thresholds (only harvest the strongest signals; only adjust the most outlier bids).
• Multi-account agencies: A 60-minute cycle per account × 10 accounts = a full week of work per month. This is where tooling pays off; without it, the cycle becomes either rushed (bad decisions) or skipped (no decisions).
• High-velocity accounts (rapid product launches, daily inventory changes): Bi-weekly cycle instead of monthly. More cycles = faster iteration but more noise per cycle. Use tighter thresholds to compensate.

Common pitfalls in workflow execution

• Skipping cycles. "I'll do it next month" → 60 days pass → the account has drifted, the harvest backlog is huge, and the cycle takes 4 hours instead of 1. Run cycles on a calendar even when it's not convenient.
• Adjusting bids without enough data. Especially common when you skip cycles. Bid decisions on 7 days of data are worse than no bid decisions; let the data accumulate before acting.
• Letting the cycle expand into ad-hoc UI work. The cycle is for systematic operations. UI work (creative changes, account admin, exploring weird outliers) is separate. Don't let exploration eat the optimization time.
• Inconsistent decision rules. If your bid-adjustment threshold is "10 clicks" one month and "20 clicks" the next, your data signal-to-noise degrades. Pick rules and stick with them for 3+ months at a stretch.
• No backup before upload. Always save the original downloaded sheet before editing. The 30 seconds it takes is cheap insurance against a bad upload that you need to undo.

What the workflow produces over time

A year of consistent monthly cycles transforms an account:

• Harvested Keyword campaigns grow from empty to 100–500 keywords — the proven converters that drive your account's profitable ad spend.
• Negative keyword lists grow to 200–1000+ negatives per campaign — comprehensive waste filtering that compounds.
• Bids converge on the right per-keyword values, with stable performance and predictable economics.
• Placement multipliers are set on every campaign with sufficient data, capturing the placement-level performance differences.
• Paused/archived entities are cleaned up; the active campaign manager view is focused on what's actually working.

The cumulative effect is an account that operates closer and closer to its theoretical maximum profitability over time. Every cycle removes one more inefficiency; nothing accumulates wasteful spend for long; every winner gets captured and amplified.

This is where tools earn their place

If you've made it to article #18 of this guide and you're managing a real account, two things should be apparent. First, bulk operations are dramatically faster than the Amazon UI for serious account management. Second, even with bulk operations, the monthly cycle still takes meaningful time and demands consistent decision-making.

That's where BulkSheet Pro earns its place. BSP runs the entire monthly cycle in software: it reads your bulk sheet and search term reports, applies your harvest decision rules, computes bid adjustments per your target ACoS, recommends placement multipliers based on placement performance, flags entities for pausing — and produces an upload-ready file with all of it together. The 70-minute cycle becomes a 5-minute review of the recommendations. The decision-making — what your target ACoS is, what your thresholds are — stays with you. The mechanics disappear.

It's the natural next step after this guide. Once the mechanics are tooled away, your monthly Amazon Ads work returns to where it should be: thinking strategically about the business, not clicking through spreadsheets.

Try BulkSheet Pro free →

You've reached the end of the guide

That's the full Amazon Ads Bulk Operations Guide. Eighteen articles taking you from "what is a bulk sheet?" to "how do I run a comprehensive monthly optimization cycle?" The library is here to revisit any time — bookmark the articles you'll reference often. And if you found the guide useful, the best signal back to me is to share it with another Amazon seller who'd benefit. The guide stays free, no email gate, no signup wall — just useful information for serious sellers.

Now go run a bulk operation.