Export Adwords Keyword List
Frustratingly, Adwords does not allow you to export your keywords as a raw list for import into other programs. Here is a quick workaround that will save you form having to sit around re-typing your keyword lists.
You will need access to your adwords account and a text editor that supports find & replace with regular expressions. I recommend Smultron because it's super awesome.
1. Navigate to your Ad Group in the Adwords interface and click on "edit keywords."

2. Copy your list of keywords and paste it into your text editor.
3. Using the find & replace feature of your text editor, use the following regular expression to scrub the list of cost data.
\*\* ([0-9]*).([0-9]+)
So in "find" you should have \*\* ([0-9]*).([0-9]+) and in replace you should have nothing.

You can also use find and replace to remove quotes or brackets, depending on how you want your list formatted.
You should now have a scrubbed keyword list ready to use with your other applications.



1 comment so far:
John (not verified) says: Very useful post. I'm
Very useful post. I'm trying to figure out how to bulk change negative keywords to all adgroups at once rather than selecting the adgroup drop-down each time. Thanks for the post.
Post new comment