Automate the Pulling of Keyword Suggestions from the Google Adwords Keyword Suggestion Tool

[developer7]

I need to write code written code to pull information from the Google
Adwords Tool insert the data into a spreadsheet, and I am not sure if
this is possible with the google API tool.

Basic example of what I want to do:

the code will need to be able to query "Keyword Combo 1" into the
google adwords keyword tool, and get the top 10 alternatives for that
term or combination of terms.

and plug this data into a simple spreadsheet that has columns, ID,
Original Keyword Combo, Alternative Keyword Combos.

So the final product would look like this in Excel.

ID1 - Original Keyword1 - "Alternative Keyword Combo 1"
ID1 - Original Keyword1 - "Alternative Keyword Combo 2"
ID1 - Original Keyword1 - "Alternative Keyword Combo 3"
ID1 - Original Keyword1 - "Alternative Keyword Combo 4"
ID1 - Original Keyword1 - "Alternative Keyword Combo 5"
ID1 - Original Keyword1 - "Alternative Keyword Combo 6"
ID1 - Original Keyword1 - "Alternative Keyword Combo 7"
ID1 - Original Keyword1 - "Alternative Keyword Combo 8"
ID1 - Original Keyword1 - "Alternative Keyword Combo 9"
ID1 - Original Keyword1 - "Alternative Keyword Combo 10"
ID2 - Original Keyword2 - "Alternative Keyword Combo 1" etc and so on
until there are not more original keywords in the spreadsheet.


Is this something that is do-able with the google API tool. Thanks.

[AdWords API Advisor]

It sounds like the getKeywordVariations() API call can serve as the
source of your keyword variations:

http://www.google.com/apis/adwords/developer/KeywordToolService.html#getKeywordVariations

Actually parsing that data and writing it to a spreadsheet is specific
to whatever underlying language you are using. At the most basic you
should be able to output the data as comma- or tab-separated values
and import that into Excel.

Cheers,
-Jeff Posnick, AdWords API Team