Fix issues with your spreadsheet for bulk uploads

When you make changes with bulk uploads, you might encounter errors. Some of these errors might be due to how your spreadsheet is formatted, or errors in the spreadsheet contents.

This article describes how to find your changes that Google Ads couldn’t apply and their corresponding error messages. You’ll also see solutions for fixing the errors.

How to identify errors with your upload

 

  1. Click the tool icon  in the top-right corner of your account.
  2. Under “Bulk actions,” click Uploads.
  3. Find your spreadsheet in the table. If there were errors in uploading the spreadsheet, you’ll see the number of errors in the “Results” column.
  4. Click the link for the errors in the “Results” column. This takes you to a page that has more details about your file upload.
  5. Click the tile that has the number of errors, then review the reason for each error in the “Status” column.

Refer to the table below for a list of common upload errors and the steps you can take to address them.

 

                     Error
 

                                                      Solution
 

There are conflicting changes.
 

Make sure no one else is trying to edit your account and try again.
 

Items in your file do not meet editorial guidelines.
 

Make sure all the items in your file follow Google Ads Editorial guidelines.
 

Your file is missing a header row.
 

The first row of an uploaded file must be used for headers.
Note: When you download the file from Google Ads, headers are already present.
 

Column contains the wrong type of information.
 

Please make sure the information you entered meets the requirements.
 

This row is missing a value.
 

Please make sure to enter a value for all required column.
 

Your keywords have characters that are not allowed.
 

Remove any non-standard characters ( ! @ % , *) from your keywords.


One of the IDs does not exists.
 
If you’re adding an element, remove the value from the ID column. If you’re making changes to an element, make sure that the ID is correct and that the entity has not been removed.
If you’re adding an element to an ad group or campaign, please make sure the campaign or ad group has a valid ID.
 

Upgraded URL is not the same as previous destination URL.
 

The final URL and tracking template should be the same as the destination URL. If you don't want them to be the same, follow the steps outlined in How to upgrade your URLs.
 
Cannot use both final URL and destination URL. You can not use both a final URL and a destination URL (/SitelinkURL for Sitelinks). Note: Final URL is recommended

To update your data set or feed, you'll need to include an "Action" column.
 

A column with the header ‘ACTION’ is required for sitelinks and other feeds changes via bulk uploads (possible values are “SET”, “ADD” or “REMOVE”).
 


 

 

Related links

Was this article helpful?
How can we improve it?