Upload bulk edits
About uploading bulk edits into Search Ads 360
To create or edit large numbers of items in Search Ads 360, such as campaigns, keywords, and labels, add the new or updated items to a specially formatted spreadsheet (called a bulksheet) and upload the bulksheet to Search Ads 360.
Search Ads 360 provides two ways to upload bulksheets:
- The Search Ads 360 UI: Uploading through the Search Ads 360 UI provides a single place to upload, review errors, and check the status. It isn't possible to schedule uploads through the UI, but you can specify a future date and time you want Search Ads 360 to start processing the upload.
- sFTP (secure File Transfer Protocol): If you upload bulksheets frequently, you may want to use third-party software (called an FTP client) to upload bulksheets to an sFTP endpoint instead of manually uploading through the Search Ads 360 UI. Your third-party FTP client may include the ability to schedule uploads. As soon as Search Ads 360 receives an sFTP upload it begins validating the file and places the file on the processing queue. You can't delay processing for files uploaded through sFTP.
Regardless of how you upload, the overall process of uploading a file, validating the file, and fixing any errors is the same.
The upload process
Here's the general process for uploading a bulksheet:
- You select a bulksheet from your computer and upload it to Search Ads 360, either through the Search Ads 360 UI or a third-party sFTP client.
- Search Ads 360 immediately validates the bulksheet and reports any validation errors.
If Search Ads 360 finds validation errors, you can fix the errors or continue with the invalid bulksheet. Search Ads 360 will ignore the invalid items and continue with the valid items in the bulksheet.
- Search Ads 360 places the bulksheet in its processing queue.
When processing begins, Search Ads 360 checks for any additional errors. Search Ads 360 will ignore any items that encounter processing errors and continue with the items that successfully processed.
- If you've uploaded new or updated campaigns, ad groups, or other items in a campaign, Search Ads 360 traffics your changes to the engine.
- If there are validation or processing errors, you'll see an error bulksheet in the upload history. The error bulksheet contains only the items that did not validate or process, along with an explanation of the error. You can download the error bulksheet, make corrections, and upload the corrected error bulksheet.
You can view the status and history of your uploads and upload errors at any time during or after this process.
You can upload files up to 600 MB in any of the following formats:
XLS/XLSX: You can upload files up to a million rows with XLSX (Excel 2007) files.
CSV: UTF-8 or UTF-16 (with BOM) file whose fields are comma separated.
Fields are optionally double quoted. For example, if your campaign names include commas, surround the Campaign field in double quotes:
Row Type,Action,Status,Campaign,Campaign start date
campaign,create,Active,"Campaign with, comma",12/30/2016
TSV: UTF-8 or UTF-16 (with BOM) file whose fields are delimited with a TAB character. Fields are optionally double quoted.
When you use a bulksheet to upload conversions, each upload should contain fewer than 100,000 rows. Search Ads 360 might not be able to process a conversions bulksheet with more than 100,000 rows.
Supported delimiters in CSV and TSV files
In CSV files, the only supported character for separating fields is a comma.
In TSV files, the only supported character for separating fields is a TAB.
Other characters, such as pipe or colon cannot be used to separate (delimit) fields.
If your bulksheet contains items that you want to upload to multiple engine accounts, make sure the bulksheet includes the Engine Account ID column. For example, if you're creating campaigns in multiple engine accounts, each campaign needs to specify the engine account that Search Ads 360 should upload it to.
If the bulksheet contains items to create or edit for multiple advertisers, make sure the bulksheet includes both the Engine Account ID column and the Advertiser ID column.