Welcome to the Q&A Forum

This article lists a bunch of Grease Monkey scripts that do this.

Hi Phillip, Let me try to address your questions one at a time. Q1: What does the KW Tool relevancy data mean, anyway? A. Google doesn't define relevance in regards to the keyword tool, but in a strict sense these are most "relevant" paid keywords queries Google suggests buying for a given domain, keyword-domain combo, or keyword query. A Google engineer briefly touched on the subject in an Adsense forum: http://www.google.com/support/forum/p/AdWords/thread?tid=7b621aceb8c81ceb&hl=en The problem with Google's Adwords tool is that it's designed to return paid search suggestions for ad buys, which is not necessarily how Google sees your site. One way to understand what terms Google sees your site as relevant to is by looking in the "Queries" report of the SEO section in Google Analytics, or the similar report in Webmaster Tools. Unfortunately these metrics aren't' available through the Analytics API. Q2: is there another way to get it or is there another way to do this? You might try SemRush, they have an API, although it's a paid service. Q3: Is there a better approach I should take with the Google API team? Last fall, Google started cracking down on use of the Adwords API for uses other than paid search. This effected many applications including the SEOmoz Keyword Difficulty tool. Unfortunately, the only way to show compliance with the Adwords API is to actually use it for paid search. Richard Baxter of SEO Gadget talked about this in a webinar for SEOmoz (PRO-only). But the short answer is no. Q4: Are there other APIs and Excel plugins that can do this, including the SEOMoz APIs? Not with the functionality you're looking for. SEOmoz APIs don't include keyword data. Again, you might try SemRush.

James and Joshua, Thank you. I read the pages James refered to. The information is useful but they don't refer to the CTR for Adwords for a given position. Phil