upload negative keywords failed

Question

Created Oct ’17

Replies 1

Boosts 0

Views 1.1k

Participants 2

I just downloaded all the keywords from search ads in csv format and tried to upload it into the negative ad group, but it says that Your file contains invalid columns headers.

Boost

Answer 1

robglassey OP

Nov ’17

Two possible things.

The negative CSV file format uses different column headers. It uses:

Action,Keyword ID,Negative Keyword,Match Type,Campaign ID,Ad Group ID

As compared to when creating normal keywords:

Action,Keyword ID,Keyword,Match Type,Status,Bid,Campaign ID,Ad Group ID

So you can't just send positive keywords straight across, without first editing the structure of the file. So use Negative Keyword instead of Keyword, and columns like Status and Bid don't make sense for negative keywords so are dropped in this file.

Also make sure you save the file in a UTF-8 encoding. I get this every time I download and edit keywords - so I guess either the file sent down isn't in the right format, or it's something in the act of downloading, or maybe it's the editor I'm using. Once you have a file saved in UTF-8 it's fine, but I seem to have to do this every time you freshly download a CSV file from Search Ads before uploading again.

0