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."

Google AdWords_ Edit Keywords and Bids.jpg

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.

Advanced Find - Smultron-1.jpg

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.

No votes yet

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

The content of this field is kept private and will not be shown publicly.
CAPTCHA
Are you alive?
k
W
i
n
Enter the code without spaces and pay attention to upper/lower case.
Syndicate content