Bulk Operations allow me to make thousands of changes to my PPC campaigns with a single upload. I can add new campaigns, adjust bids, update budgets, and much more, saving me a lot of time and effort. Let's talk about it.

⤵️ How Do I Download and Upload Bulk Sheets?

I log into Seller Central, go to Campaign Manager, and click “Bulk Operations.” I select “Create spreadsheet for download” to get the bulk file. The file preparation can take from a minute to an hour, depending on the size of my account. After making changes, I go back to Bulk Operations, choose the file, and upload it. It’s crucial not to change the “Record ID.”

🦡 How Do I Create New Campaigns?

I use the Bulk Operations template, which can be downloaded from the Bulk Ops page. I fill in the campaign information:

1. Record type: “Campaign”
2. Campaign: Campaign name
3. Campaign Daily Budget: Daily budget
4. Campaign Start Date: Start date
5. Campaign Targeting Type: Targeting type
6. Campaign Status: “enabled”

➕ How Do I Create New Ad Groups?

In my spreadsheet, I set the record type to “AdGroup.” I fill in:

1. Campaign: Campaign name
2. Ad Group: Ad group name
3. Max Bid: Maximum bid
4. Ad Group Status: “enabled”

👍 How Do I Add SKUs?

I set the record type to “Ad.” I fill in:

- Campaign: Campaign name
- Ad Group: Ad group name
- SKU: The product SKU
- Status: “enabled”

🗝️ How Do I Add Keywords?

I set the record type to “Keyword.” I enter:

- Campaign: Campaign name
-Ad Group: Ad group name
-Max Bid: Maximum bid
- Keyword or Product Targeting: Keyword or product ASIN
- Status: “enabled”

What Advanced Tactics Do I Use?

1) What is the RPSB Strategy?

I run an auto-campaign, extract converting search terms, add them to a manual campaign, and block those terms in the auto-campaign with negative keywords. To do this, I transfer the search terms to the sponsored products template, setting them as “NegativeExact” for auto-campaigns and “Exact” for manual campaigns.

2) How Do I Optimize Negative Keywords?

I identify high-spend, no-conversion search terms and add them as “NegativeExact” to block them. This helps avoid spending on inefficient search queries.

3) How Do I Copy and Paste for International Markets?

I copy optimized campaigns from one market and paste them into another with the same language (e.g., from the US to the UK). This significantly speeds up the process of launching new campaigns in international markets.

4) What Advanced Bid Strategies Do I Use?

I use a formula to calculate the perfect bid: Total Sales / Total Clicks * Target ACOS %. I apply this formula to my bulk file for quick optimization of bids across thousands of keywords.

By using Bulk Operations, I can efficiently and conveniently manage my Amazon PPC campaigns. Happy advertising!