This article provides details on what bulk operations is, how it operates and how to execute it.
Showcase your product to millions of shoppers directly in their search results. This guide covers key topics for using our self-serve platform.
This article provides details on what bulk operations is, how it operates and how to execute it.
Bulk operations provides streamlined campaign management, simplified bulk updates and the ability to make offline edits for complex tasks for your Sponsored Products campaigns.
Bulk operations enable you to:
Bulk operations is an advertiser’s power tool for managing large-scale campaigns and optimizing advertising performance.
Bulk operations empowers advertisers to create and manage campaigns efficiently and effectively by building a template with all your updates in it. This helps save you time and effort by handling complex tasks with ease.
Bulk operations assists in creating, updating and enabling or disabling campaigns, ad groups, items and keywords. This includes setting and updating budgets and bids, changing match types, setting and changing flight dates and adding ad groups using an Excel spreadsheet.
Easily download current or past campaign information into an editable Excel spreadsheet or start from a blank Excel template, then use up to 25,000 rows to create and update. Upload back into the Walmart Connect Ad Center and get detailed error feedback on any upload issues it encounters (if any). Utilize Walmart’s upload template with actionable step to prepare your bulk update sheet and address any errors identified in the feedback.
Note: Bulk operations can only be used on Sponsored Products campaigns within a single account.
To access the bulk operations tool, select Bulk Operations from the navigation menu.
Clicking Bulk Operations takes you to the Create files tab. Bulk operations gives you the option to download an Excel spreadsheet with existing campaign and ad group information or to start with a blank template.
We recommend downloading campaign information if you want to update existing campaign and ad group content. This will allow you to quickly focus on what needs to be updated.
Note: For complex campaign structures with multiple ad groups, we recommend using separate files for each campaign. This ensures accurate targeting, avoids potential conflicts, and keeps uploaded files manageable.
Select your date range. You can use the predefined ranges from the right or select a custom range from the calendar. Optionally, choose which campaigns you want to exclude from the list. You can exclude currently ended campaigns and/or campaign items with zero impressions.
Date ranges are limited to a one month duration.
Click Create file then select between CSV or Excel (.xlsx) format. The Walmart Connect Ad Center will start to generate the file for download. The file will include all campaigns that meet your date range and exclusion preferences.
Download the file from the Created files list using the download icon. It may take several minutes for the list to generate, depending on the amount and size of the campaigns meeting your date range and exclusion preferences.
Open the downloaded Excel/CSV file. The file will have up to 25,000 populated rows. You can use this file to perform bulk operations on multiple Sponsored Products campaigns, so let’s examine the template’s columns.
If your Excel file is particularly long, we recommend applying filters to the columns to quickly filter and sort for the rows you want to update. Since you need to delete the rows you don’t want to change, we also recommend removing the default entry under Operation (default is update from download) to help track which rows you are changing.
Note: If you want to update budgets, filter by Campaign record type.
Apply the updates to the rows you want to manage. Make sure you update the columns that match the record type you are updating.
Note: Special characters like quotes (") and commas (,) can cause parsing issues. Ensure these characters are properly escaped within your file to avoid errors. The Bulk Update Resource provides guidance on proper escape methods. Wildcard characters like asterisks (*) are technically accepted, but have the potential to cause errors, so their use is discouraged.
For example, if you want to update the bid multiplier amount on a placement, try this:
Note: For manual campaigns, options for placement bid multipliers are Search Ingrid and Item Buybox. For automatic campaigns, options for placement bid multipliers are Search Ingrid, Item Buybox, Homepage and Stock Up.
In addition to updating existing record types, you can create new campaigns and ad groups and add items, keywords, placement inclusion and bid multipliers. Creating and adding can be done in the same Excel spreadsheet as updates or in a blank bulk operations template.
Your record type options are:
Ad group | Campaign placement inclusion
|
3. Enter create under Operation.
4. Leave Campaign ID blank if you are creating a new campaign. If you are creating a new ad group, leave Ad Group Id blank. Fill them in if you are adding to an existing campaign and/or ad group.
5. Enter the campaign name and/or ad group name. Both are required if you are adding items and/or keywords.
6. Enter the start date for your new campaign. The end date is optional. If you choose to leave the end date blank, the campaign will default to run indefinitely.
7. Enter your Campaign Targeting Type: automatic or manual, and your Total Budget and/or Daily Budget. These columns are only required for new campaigns.
8. Set status to enabled.
9. Columns L, N, O, P Q, R, T, U, V, W and X are dependent on record type and should be completed the following ways:
For new items
For new keywords
Note: If you want different match types for the same keyword (i.e., broad and phrase), you’ll need a separate entry/row for each match type. Keyword IDs are generated by the Walmart Connect Ad Center. You do not need to include one for new keywords.
For adding placement inclusion (manual campaigns only)
For adding bid multipliers
10. Save your bulk operations file. You’re now ready to upload it into the Walmart Connect Ad Center.
You can create an entirely new campaign without having a campaign ID or ad group ID by entering these record types in this exact order:
When you’re ready to upload your bulk operations file, select the Upload files tab. Drag and drop or use the browse to select files button to start your upload. Uploading is automatic after selection. Scheduling bulk operations is not an option at this time. File size is limited to 25 MB or less. If your file is larger than that, consider splitting it into two or more files.
Uploads can take up to four hours to complete, depending on the length and complexity of your requests. Status of your upload can be tracked under Your uploads.
Note: You can’t make changes to your bulk operations file once upload has started. Additional changes will need a new uploaded file.
Status options under Your uploads:
For uploads that are partially successful or errored out, you can download a feedback file to get a detailed report on why the requested operations failed. Rows without changes or rows deleted from the Excel spreadsheet prior to upload remain unchanged.
Note: You cannot cancel changes you made, so if you made a change you want to undo, create a new version of the bulk operations file with the update reverted.
Use the Bulk Update Resource for guidance on preparing your bulk operations sheet and decoding error codes identified in the feedback file.
Note: The feedback sheet currently doesn't include feedback on normalized keywords. You can get around this by downloading a bulk operations file for your newly added keywords.
To ensure smooth upload and processing, follow these best practices:
Several advanced techniques can further enhance the effectiveness of your bulk operations, such as:
Optimize your workflows for efficiency by: