What is a Bulksheet?

Bulksheet is a spreadsheet-based tool that allows sponsored ads advertisers to create and optimize multiple campaigns in batches, reducing time and manual effort. Bulksheets can be a good option if you’ve already been using the advertising console, but want more robust functionality and the ability to scale without calling the API.

Downloading a Bulksheet

1. Log in to your client’s Seller Central account.
2. Go to Campaign Manager > Sponsored ads > Bulk Operations (See Campaign Manager for additional information)

1. Choose ‘Use the new spreadsheet format….’ option”

   

2. Click on Date Range to choose the desired date range.

   • As a rule of thumb, skip the last 3 days as the data for these days may not be finalized yet due to several factors thus avoiding any possible data discrepancy.

     • For example, if today is October 10th, start on October 7th then go two weeks back.

     

3. Under Include, take note of the following points/recommendations:

   1. Terminated campaigns - make sure this remains unchecked
   2. Campaign items with zero impressions - For keyword optimization, it might be helpful to check this box to include items with zero impressions. This can help you see which keywords you might want to update or negate.
   3. Placement data for campaigns - untick this box as this is available in a separate (placement) report
   4. Brand assets data - tick this box if you have a brand
   5. Sponsored Products data - only tick if you’ll be working on this campaign type
   6. Sponsored Brands data - only tick if you’ll be working on this campaign type
   7. Sponsored Display data - only tick if you’ll be working on this campaign type

4. Click Create spreadsheet for download.

5. Your download will appear at the bottom under Downloads. Once the file is ready to be downloaded, you can click Download.

   

6. Open the downloaded report.

7. Click Enable Editing.

8. There are at least three tabs on the report:

   1. Portfolios - has a list of your portfolios but we won’t be using this data

      

   2. Sponsored Products Campaigns - this is the tab that we’ll be working on

      

   3. Sponsored Brands Campaigns - this will be discussed on a different video.

      

Want a Quick Chat for you Brand ? Connect me here 👉

Q&A Session or Consultation

Sponsored Products Campaigns Bulk Sheet