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
-
Why my site so poorly ranks on Google
Hi 🙂 I hope you can help me for my site http://www.majordroid.com/ I really do not understand why my site so poorly ranks on Google. What can I do about that? Are there any errors or something? What can be done about that? Also when I go to the Moz Tools - Open Site Explorer to check how many backlinks I have... It says: 12 Total Links but according to the Google Webmaster tools I have in total 334 links and 138 links to the homepage. see attachment Why Open Site Explorer does not see all the links to my site, which is a possible reason? And last question, what I need to do to remove pages from Google search like this: <cite class="_Rm">/page/2</cite>. <cite class="_Rm">/page/3 and so on...</cite> Thank you 🙂 aK0x345.jpg
Moz Pro | | ivek19870 -
Google+ Local Business Page not appearing
I have a local verified google + listing and recently just went to update it nicely. even though it has been around for months, however Google just can't seem to index it, does anybody know the reason why? I have tried " hard-searching" for it and it is not even indexed! However if i find hard enough, it will appear in google maps, and also my domain has been around for months, if not a year however under Moz Open Site explorer it indicates it is a super new domain and even alexa is not recognizing any data even though it has traffic. The only thing i have done is i have shifted servers two months ago. Does that translate to a new site? I hope not...
Moz Pro | | partyrocks0 -
Crawlers crawl weird long urls
I did a crawl start for the first time and i get many errors, but the weird fact is that the crawler tracks duplicate long, not existing urls. For example (to be clear): there is a page: www.website.com/dogs/dog.html but then it is continuing crawling:
Moz Pro | | r.nijkamp
www.website.com/dogs/dog.html
www.website.com/dogs/dogs/dog.html
www.website.com/dogs/dogs/dogs/dog.html
www.website.com/dogs/dogs/dogs/dogs/dog.html
www.website.com/dogs/dogs/dogs/dogs/dogs/dog.html what can I do about this? Screaming Frog gave me the same issue, so I know it's something with my website0 -
What is the Best Local Ranking Tool?
I'm trying to track down a tool that will provide localized rankings within Google Maps/Places, Yahoo Local, Bing Local as well as major local directories such as Yelp, Yellow Pages, etc. Additionally, I'm looking for the results to provide the address being displayed in the ranking. Any suggestions?
Moz Pro | | JonClark150 -
Find out what keywords a site is ranking for
I want to find out what keywords a site is ranking for. In other words, I want to find out how Google is currently seeing a site. I've used Google KW tool - not very accurate when you simply type in the URL. Is there anything in SEOMoz I can use? New to this. thanks
Moz Pro | | goodge0 -
Problems with google chrome
do anybody have a problem navigating Seomoz webpage and scrolling down. for example everytime that I came to ask a question and post, I write down later select my topic. and when I scroling down the web page just push up. and don't let me go to the button to "aks a question" from one moment I though was my computer but at the office and at home using chrome, I have the same issue. Anybody have the same issue?
Moz Pro | | lnietob0 -
What happened to the SEOmoz Term Extractor Tool?
I am looking for the SEOmoz Term Extractor Tool and it's nowhere to be found. Does it exist anymore? If not why and what would be a good alternative tool to use? Thank you.
Moz Pro | | brianhughes0