{"id":11409,"date":"2021-01-26T09:27:32","date_gmt":"2021-01-26T09:27:32","guid":{"rendered":"https:\/\/staging.sellerapp.com\/blog\/?p=11409"},"modified":"2026-01-07T18:11:11","modified_gmt":"2026-01-07T12:41:11","slug":"amazon-ppc-bulk-operations","status":"publish","type":"post","link":"https:\/\/www.sellerapp.com\/blog\/amazon-ppc-bulk-operations\/","title":{"rendered":"The Ultimate guide to Amazon PPC bulk operations"},"content":{"rendered":"\n<p>If you haven\u2019t used bulk sheets to optimize your <a href=\"https:\/\/www.sellerapp.com\/blog\/amazon-ppc-basics\/\">Amazon PPC campaigns<\/a> already, it is time to start. You can use them to streamline all your PPC campaigns with just a few clicks! The time you can save by using bulk operations is priceless.&nbsp;<\/p>\n\n\n\n<p>So, what are these bulk sheets? How can you leverage them to optimize your Amazon PPC campaigns, and how do you even find them in the first place? We\u2019ll be covering this, and a lot more in this deep dive into the world of bulk operations.<\/p>\n\n\n\n<p> <strong>Quick Guide:<\/strong> <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li> <a href=\"#what-are-amazon-ppc-bulk-operations\">What are Amazon PPC bulk operations<\/a>?  <\/li>\n\n\n\n<li> <a href=\"#2\">How to download Amazon PPC bulk sheets<\/a> <\/li>\n\n\n\n<li> <a href=\"#3\">How to create new campaigns <\/a><\/li>\n\n\n\n<li> <a href=\"#4\">How to leverage Amazon PPC bulk operations&nbsp; <\/a><\/li>\n\n\n\n<li> <a href=\"#5\">How can you save time with SellerApp\u2019s Bulk Actions<\/a>? <\/li>\n\n\n\n<li> <a href=\"#6\">Final thoughts&nbsp; <\/a><\/li>\n<\/ol>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1628253093348\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What are Amazon PPC bulk operations? <\/h3>\n<div class=\"rank-math-answer \">\n\n<p> It is a method by which you can make changes to your ad campaigns en masse. You can do this by <a href=\"https:\/\/sellercentral.amazon.com\/bulksheet\/HomePage\" target=\"_blank\" rel=\"noopener\">downloading spreadsheets<\/a> and templates directly from seller central. Just change the values where ever necessary and upload the document.\u00a0 <\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n<p>That\u2019s all you need to do. So, what are some of the changes that you can make?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add or create new campaigns, ad groups, keywords, or SKUs&nbsp;<\/li>\n\n\n\n<li>Pause active campaigns, ad groups, or keywords<\/li>\n\n\n\n<li>Enable inactive campaigns, ad groups, or keywords<\/li>\n\n\n\n<li>Optimize bids and placement&nbsp;<\/li>\n\n\n\n<li>Negative product and keyword targeting&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>All of this, and we are still barely scratching the surface.&nbsp;<\/p>\n\n\n\n<p>In a nutshell, it is a great way to save time by making changes en masse.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2\">How to download Amazon PPC bulk sheets<\/h3>\n\n\n\n<p>To get started, you need to know where to find the spreadsheets. Fortunately, it is not difficult to find or use.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1100\" height=\"333\" src=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/how-to-download-amazon-ppc-bulk-sheets-1100x333.jpg\" alt=\"how to download amazon ppc bulk sheets\" class=\"wp-image-11411\" title=\"\" srcset=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/how-to-download-amazon-ppc-bulk-sheets-1100x333.jpg 1100w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/how-to-download-amazon-ppc-bulk-sheets-300x91.jpg 300w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/how-to-download-amazon-ppc-bulk-sheets-768x233.jpg 768w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/how-to-download-amazon-ppc-bulk-sheets-1536x466.jpg 1536w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/how-to-download-amazon-ppc-bulk-sheets.jpg 1547w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Log in to your seller central account&nbsp;<\/li>\n\n\n\n<li>Navigate to the <strong>Advertising<\/strong> console<\/li>\n\n\n\n<li>Select the <strong>Bulk operations <\/strong>option&nbsp;<\/li>\n\n\n\n<li>Click on <strong>Create spreadsheet for download<\/strong><\/li>\n<\/ul>\n\n\n\n<p>That is all it takes to download your bulk sheets.&nbsp;<\/p>\n\n\n\n<p>Before you download the bulk sheets, you can choose the following \u2018exclude\u2019 options and select a date range. The maximum time frame for which you can download the bulk spreadsheet is 60 days.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"469\" height=\"362\" src=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-download-custom-spreadsheet.jpg\" alt=\"how to download custom spreadsheet\" class=\"wp-image-11412\" title=\"\" srcset=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-download-custom-spreadsheet.jpg 469w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-download-custom-spreadsheet-300x232.jpg 300w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Terminated campaigns<\/strong>: All inactive campaigns will be excluded from the downloaded bulk sheet if this option is selected.&nbsp;<\/li>\n\n\n\n<li><strong>Campaign items with zero impressions<\/strong>: Campaigns with zero impressions will not be included in the downloaded bulk sheet. There is an exception for entities that will never have impressions like Sponsored Brands drafts.<\/li>\n\n\n\n<li><strong>Placement data for campaigns<\/strong>: Spreadsheets downloaded with this option active will not have placement type attributes such as <strong>all, top of shopping results, product detail page<\/strong>, etc.<\/li>\n\n\n\n<li><strong>Brand assets data<\/strong>: It is a read-only directory featuring all rich media that has been uploaded to your asset library. This includes the brand logo, images, and videos.<\/li>\n<\/ul>\n\n\n\n<p>Check out this guide to improve <a href=\"https:\/\/www.sellerapp.com\/blog\/amazon-advertising-impressions\/\">Amazon Advertising Impressions<\/a>.<\/p>\n\n\n\n<p>Pro-tip<strong>:<\/strong> If you only want to manage <a href=\"https:\/\/www.sellerapp.com\/blog\/amazon-sponsored-products-vs-sponsored-display-ads\/\">Sponsored Product ads<\/a>, exclude brand asset data. The data is not relevant to sponsored product ads and excluding it will reduce the time you take to download and upload the sheets.<\/p>\n\n\n\n<p>Bulk sheet changes and adjustments are supported for every type of sponsored ad, and the data is also categorized by campaign type. This enables you to make changes easily.&nbsp;<\/p>\n\n\n\n<p>Note: Do not make any changes to the <strong>Record ID <\/strong>tab. This ID is how Amazon tracks and identifies each record internally. If you change it, Amazon will not be able to track that entry.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"3\">How to create new campaigns<\/h2>\n\n\n\n<p>To create multiple campaigns at the same time, you can use the Bulk operations template. It is essentially the bulk operation&#8217;s spreadsheet without any data. Additionally, the file contains various hints and other helpful information to help you get started.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"477\" height=\"486\" src=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-new-campaign.jpg\" alt=\"amazon ppc bulk operation template\" class=\"wp-image-11413\" title=\"\" srcset=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-new-campaign.jpg 477w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-new-campaign-300x306.jpg 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/figure>\n<\/div>\n\n\n<p>Once you download the template (you can follow the link we\u2019ve added above), you will need to enter the following information to create a campaign:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Record type: <\/strong>You need to set this as<strong> <\/strong>\u201cCampaign\u201d<\/li>\n\n\n\n<li><strong>Campaign<\/strong>: The same as your campaign<\/li>\n\n\n\n<li><strong>Campaign Daily Budget: <\/strong>Self-explanatory. How much money you want to spend on the campaign every day<\/li>\n\n\n\n<li><strong>Campaign Start Date: <\/strong>If you don\u2019t set a date, it will default to the date you upload the file&nbsp;<\/li>\n\n\n\n<li><strong>Campaign End Date<\/strong>: If you plan to end the campaign at a given date, go for it. Otherwise, leave it blank<\/li>\n\n\n\n<li><strong>Campaign Targeting Type: <\/strong>Auto or manual (for sponsored product campaigns).<\/li>\n\n\n\n<li><strong>Campaign Status: <\/strong>Make sure it is \u2018enabled\u2019&nbsp;<\/li>\n\n\n\n<li><strong>Bidding Strategy: <\/strong>Pick between fixed bids or dynamic bidding. If you\u2019re picking dynamic bids, you can either type in <em>Dynamic Bidding (Down Only)<\/em> or <em>Dynamic Bidding (Up and Down)<\/em>. Learn more about about amazon bidding strategy <a href=\"https:\/\/www.sellerapp.com\/blog\/amazon-bidding-strategies\/\">here<\/a>.<\/li>\n\n\n\n<li><strong>Placement: <\/strong>This decides where you want your ads to appear. Your choices are <em>All<\/em>, <em>Top of search (page 1)<\/em>, <em>Product pages<\/em>, or <em>Rest of Search<\/em>&nbsp;<\/li>\n\n\n\n<li><strong>Increase bids by placement: <\/strong>Pick a number between 0 and 900. If your <strong>Placement <\/strong>option is <em>All<\/em> or <em>Rest of Search<\/em>, you should leave this blank. Otherwise, Amazon will adjust your bids depending on the range you provide for page 1 or product page placements&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>Additional reading: <a href=\"https:\/\/www.sellerapp.com\/blog\/advanced-amazon-ppc-strategy-revealed\/\">Powerful Amazon PPC strategies, including dynamic bidding.<\/a>&nbsp;&nbsp;<\/p>\n\n\n\n<p>Once you fill in all the necessary details, you just need to upload the spreadsheet to start your campaigns. You\u2019ll find the upload option on the same page where you download the spreadsheets.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"357\" height=\"230\" src=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-new-campaign-1.jpg\" alt=\"how to upload your file to update ppc campaign\" class=\"wp-image-11416\" title=\"\" srcset=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-new-campaign-1.jpg 357w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/01\/create-new-campaign-1-300x193.jpg 300w\" sizes=\"(max-width: 357px) 100vw, 357px\" \/><\/figure>\n<\/div>\n\n\n<p>The changes won\u2019t be reflected instantly. The amount of time Amazon takes to process your changes depends on the number of rows in your sheet. You can check the status of the upload by looking at the \u201cStatus\u201d column.<\/p>\n\n\n\n<p>If you encounter any errors, make sure you download the error report and check it carefully. It should tell you where the problem occurred. Just make the necessary changes to your Amazon PPC bulk sheet and you are good to go!&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.sellerapp.com\/schedule-demo.html?referrer=blog-mid\"><img decoding=\"async\" src=\"https:\/\/cdn.sellerapp.com\/Blog_images\/amazon-success-steps.jpg\" alt=\"\" title=\"\"><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"4\">How to Take Advantage of Amazon PPC Bulk Operations\u00a0<\/h2>\n\n\n\n<p>There are multiple ways in which you can use the bulk upload feature to your advantage. This is especially true for a seller with many campaigns. Managing all of them one at a time is next to impossible. That\u2019s where the bulk operations feature comes in handy.&nbsp;<\/p>\n\n\n\n<p>You won\u2019t need to separately optimize your bids and keywords with the bulk upload feature. Just make all the necessary changes in the spreadsheet and upload it to Amazon.&nbsp;<\/p>\n\n\n\n<p>The bulk operations file has multiple filter options which will help you find exactly what you are looking for.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"reliable-data\">Reliable data<\/h3>\n\n\n\n<p>The Bulk files can help you optimize your campaigns en masse, but there is one overlooked aspect of that massive spreadsheet. It is a treasure trove of data!&nbsp;<\/p>\n\n\n\n<p>This file will have everything there is to know about your sponsored ad campaigns. Data on clicks, spend, orders, sales, ACoS &#8211; you name it, the file has it. Unfortunately, you can only get data for up to 60 days. You won\u2019t find anything before that magic number.&nbsp;We know how important all your data is. Historical sales trends can be vital when planning for the holiday season. That\u2019s why <a href=\"https:\/\/www.sellerapp.com\/\">SellerApp<\/a> will let you access your data in perpetuity. From the day you sign up, we safeguard all your vital Amazon PPC data and let you access it whenever you want.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.sellerapp.com\/amazon-ppc-management.html?referrer=amazonppcbulkoperations\"><img decoding=\"async\" src=\"https:\/\/cdn.sellerapp.com\/Blog_images\/amazon-ppc-automation-software.jpg \" alt=\"amazon ppc management\" title=\"\"><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"5\">How can you save time with SellerApp\u2019s Bulk Actions?<\/h2>\n\n\n\n<p>SellerApp&#8217;s Bulk Actions is a smart solution to help you create, edit, and optimize your campaigns. This feature is exactly what you need to save time and increase your operational efficiency.&nbsp;<\/p>\n\n\n\n<p>To access this feature, you can go login to <a href=\"https:\/\/dashboard.sellerapp.com\/register\" target=\"_blank\" rel=\"noopener\">SellerApp dashboard<\/a> &gt; Advertising &gt; Campaign Manager<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"512\" height=\"176\" src=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/08\/sellerapp-bulk-actions.jpg\" alt=\"sellerapp bulk actions\" class=\"wp-image-13590\" style=\"width:576px;height:198px\" title=\"\" srcset=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/08\/sellerapp-bulk-actions.jpg 512w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/08\/sellerapp-bulk-actions-300x103.jpg 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n<\/div>\n\n\n<p>If you are a seller with multiple ad campaigns and a large product portfolio, our Bulk Actions feature will help you edit your campaigns locally. All you need to do is download the bulk sheet, make the changes, and upload it to our feature. With the help of this feature:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can create multiple campaigns, ad groups, and keywords<\/li>\n\n\n\n<li>Add SKUs at the ad group level<\/li>\n\n\n\n<li>Pause keywords, ad groups, and campaigns<\/li>\n\n\n\n<li>Adjust bids across the campaigns, ad groups, and keywords<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"512\" height=\"242\" src=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/08\/bulk-actions-of-sellerapp.jpg\" alt=\"how to use sellerapp&#039;s bulk actions\" class=\"wp-image-13591\" style=\"width:585px;height:277px\" title=\"\" srcset=\"https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/08\/bulk-actions-of-sellerapp.jpg 512w, https:\/\/www.sellerapp.com\/blog\/wp-content\/uploads\/2021\/08\/bulk-actions-of-sellerapp-300x142.jpg 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n<\/div>\n\n\n<p>If you want to learn more about this feature, we suggest you check out <a href=\"https:\/\/www.sellerapp.com\/help\/article\/bulk-actions-to-manage-amazon-ad-campaigns\/\">this article<\/a>. It helps you understand how SellerApp\u2019s Bulk Actions work and how you can effortlessly manage your campaigns.<\/p>\n\n\n\n<p>In this video, we\u2019ll be discussing the SellerApp PPC Bulk Operation.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Presenting SellerApp Advertising Bulk Operations | Amazon PPC Bulk Operations Made Easy!\" width=\"750\" height=\"422\" src=\"https:\/\/www.youtube.com\/embed\/xcs_MtEaPhM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6\">Final thoughts&nbsp;<\/h4>\n\n\n\n<p>The Amazon bulk sheet is a life-saver for many sellers. It saves them valuable time by allowing them to optimize their campaign on the go and in bulk. It is a great source of reliable data and gives you an overview of the health of your campaigns.&nbsp;<\/p>\n\n\n\n<p>The filter options make it incredibly easy to make adjustments exactly where you want to. If you are managing your campaigns on your own, without using any third-party service, there isn\u2019t a better way to do it. You won\u2019t get suggested bids or any other advanced analytics, but if you are an Amazon marketing whiz, you can make informed choices based on the data.&nbsp;<\/p>\n\n\n\n<p>However, there is another way to make sure your campaigns are super optimized. You can leave it to our experts. We combine the best of machine learning technology and decades of experience to deliver tangible results &#8211; all while you sit back and relax. Interested? Try our Amazon <a href=\"https:\/\/www.sellerapp.com\/amazon-ppc-agency.html\">PPC management services<\/a>!<\/p>\n\n\n\n<p><strong>Additional Read:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.sellerapp.com\/blog\/amazon-action-plan-2017\/\">Sell More with Amazon Action Plan<\/a> <\/p>\n\n\n\n<p><a href=\"https:\/\/www.sellerapp.com\/blog\/amazon-sponsored-display-product-targeting\/\">Amazon Sponsored Display Product Targeting&nbsp;<\/a> <\/p>\n\n\n\n<p><a href=\"https:\/\/www.sellerapp.com\/blog\/amazon-ppc-outsourcing\/\">Why You Should Outsource Your Amazon PPC Services<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you haven\u2019t used bulk sheets to optimize your Amazon PPC campaigns already, it is time to start. You can use them to streamline all your PPC campaigns with just a few clicks! The time you can save by using bulk operations is priceless.&nbsp; So, what are these bulk sheets? How can you leverage them&hellip;<\/p>\n","protected":false},"author":15,"featured_media":11414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[254,288,361],"tags":[],"class_list":["post-11409","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ppc","category-product-marketing","category-seller-central"],"_links":{"self":[{"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/posts\/11409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/comments?post=11409"}],"version-history":[{"count":2,"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/posts\/11409\/revisions"}],"predecessor-version":[{"id":32928,"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/posts\/11409\/revisions\/32928"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/media\/11414"}],"wp:attachment":[{"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/media?parent=11409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/categories?post=11409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sellerapp.com\/blog\/wp-json\/wp\/v2\/tags?post=11409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}