Getting relevant keywords from URL with Google KW Tool.
-
Hi,
When I first start researching a site, I like to see what Google "thinks" it is relevant to.
I use the Google KW Tool and enter the website URL only. I sort the results by relevance.
I can then show the prospective client what Google thinks his site is optimized for and use that info to show him what opportunities exist to rank for terms more relevant to his business. I show him keyword, volume and I also get current SERP rank for his site.
For larger sites, I do this for the top pages based Domain Authority.
I want to automate this process using excel and APIs but Google refused my API token request.
I told them I wanted to use the "Google AdWords API Extension for Excel" from http://seogadget.co.uk/google-adwords-plugin-excel.
The Google API token team replied:
Please note, after reviewing your application in detail, we are sorry to let you know that we won't be able to approve your token.
We understand that you are planning to use the AdWords API mainly for Targeting Idea Service (TIS) and Traffic Estimation Service (TES) such as 'keyword research'. Please note that as per the Required Minimum Functionality (RMF) outlined in the API Terms & Conditions, using the AdWords API exclusively for TIS and TES type of services is not allowed.
Q1: What does the KW Tool relevancy data mean, anyway?
Q2: is there another way to get it or is there another way to do this?
Q3: Is there a better approach I should take with the Google API team?
Q4: Are there other APIs and Excel plugins that can do this, including the SEOMoz APIs?
Thanks,
Phil -
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.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
How do I get back my archived campaigns??
Hi there, Can anyone help! I archived a campaign a month ago and now I want it back - can anyone help? How do I get back my archived campaign? Or do I need to start again?? Thanks Gareth
Moz Pro | | GAZ090 -
How does SEOMoz get ranking data? is it automated queries to Google?
Google's terms don't allow automated queries without Google's permission. https://support.google.com/webmasters/bin/answer.py?hl=en&answer=66357 How does SEOMoz get ranking data then? Is it sending automated queries with or without Google's permission? is it violating Google's guideline? Will it affect my site performance as far as rankings?
Moz Pro | | huangyouyou1170 -
Does Moz track SERP in Google Places?
Hi, how are you? I wanted to ask you if the rankings that Moz shows include the results from Google Places that sometimes appear in the SERPs. Thanks in advance1 Ariel
Moz Pro | | arielbortz0 -
Anyone know how/where to get keyword yield ratio?
I'm trying to incorporate keyword yield ratio (the ratio of keywords to pages yielding search traffic) in my seo report. I want to be able to compare on a monthly basis the percentage ratio of keywords to a landing page yielding search traffic. So for example, in July we might have 5 keywords that earned a click to landing page A. But in September, the number of keywords grew to 8 keywords that earned a click to landing A. I would like to be able to report monthly on the % ratio growth of number of keywords to landing pages that yield search traffic. Aim is to grow # of keywords per page... Is there a way I can get this data through seomoz tools or google analytics? Thanks, Gemma
Moz Pro | | RBA0 -
How do you get Mozbot to crawl your website
I trying to get the mozbot to crawl my site so I can get new crawl diagnostics info. Anyone know how this can be done?
Moz Pro | | Romancing0 -
How do I get my crawl report?
I received a message that my crawl report is complete with a link - went to the link however - when I click on the icon that has the report name and the complete check mark nothing happens looked around can't find the results. Need to bid on this job so it would be helpful to know where to get it. Thanks for all you do. Wickey
Moz Pro | | Wickey0 -
Keyword Rankings Question
Does the Keyword Rankings tool track all urls or just the main. Example: Say I put www.domain.com to have tracked. Will the Keyword Rankings tool also track www.domain.com/landing-page and any derivative of the main domain or would this be considered a separate campaign. Thanks
Moz Pro | | montage0 -
Home page not indexed by Google
Hello, Teacherprose.com 1. Sitemap was successfully submitted via Google webmaster tools 2. Site has been up for two years. 3. Site shows up in Google results for "Teacher Resume Service" 4. According to Google and SEOMoz, home page not indexed by Google or Bing. I'm a novice, am I missing something obvious? Thank You, Eric
Moz Pro | | monthelie10