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

Comments

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.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd><img>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
Are you alive?
t
z
V
g
Enter the code without spaces and pay attention to upper/lower case.
Syndicate content