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 content.
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
- In your Google Ads account, click the Tools icon
- Click the Bulk actions drop-down in the section menu.
- Click Uploads.
- 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.
- Click the link for the errors in the 'Results' column. This takes you to a page that has more details about your file upload.
- 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 that you can take to address them.
Error |
Solution |
---|---|
There are conflicting changes. |
Make sure that no one else is trying to edit your account and try again. |
Items in your file do not meet editorial guidelines. |
Make sure that 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 that the information that you entered meets the requirements. |
This row is missing a value. |
Please make sure that you enter a value for all required columns. |
Your keywords have characters that are not allowed. |
Remove any non-standard characters ( ! @ % , *) from your keywords. |
One of the IDs does not exist. |
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 hasn't been removed. If you’re adding an element to an ad group or campaign, please make sure that 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't use either a final URL or 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 feed changes via bulk uploads (possible values are 'SET', 'ADD' or 'REMOVE'). |