If you use one of the editors (AdWords or Bing Ads) to import keywords, mass create ads, etc – you always have a header row in Excel to remind you of the columns:
However, when you copy and paste your huge tables into the editors, most people hit ‘Cntl-A’ (select all) from Excel and then ‘Cntl-V’ (paste) into the editor.
When you upload those files, you get ads like this:
Another common mistake is in the AdWords interface itself. When you add more keywords, the default text is: Add Your Keywords Here
If you don’t remove that; your ads suddenly show up for a variety of search queries, and since its broad matched by default; some of the matches can be quite amusing.
Here’s the secret in the bulk import. Instead of copying and pasting all, in Excel do this:
Highlight the second row (past the header)
Then press & hold: Cntl – Shift – <down arrow or down>
Then hit Cntl-C for copy
Paste into the editor as usual
Of course, you can also just delete the header row and then copy and paste.
This is also why I’m a fan of filtering my keywords and ads by ‘keyword’ or ‘placeholder’(or whatever you use that needs to be replaced in your ads) on occasion just to make sure I’m not spending money on irrelevant keywords & ads.