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
-
Special Characters in URL & Google Search Engine (Index & Crawl)
G'd everyone, I need help with understanding how special characters impact SEO. Eg. é , ë ô in words Does anyone have good insights or reference material regarding the treatment of Special Characters by Google Search Engine? how Page Title / Meta Desc with Special Chars are being index & Crawl Best Practices when it comes to URLs - uses of Unicode, HTML entity references - when are where? any disadvantage using special characters Does special characters in URL have any impact on SEO performance & User search, experience. Thanks heaps, Amy
Moz Pro | | LabeliumUSA0 -
What are the factors that have an impact on the google search results?
When I compare the ranking of my keywords with the Moz Rankings and my own search results I get different results even I use the google chrome incognito browser (not logged in, no cookies, no cache) and it's definitely the same country-setting (google.de) where the search is run. I double checked it with several browsers and computers, and I still get a different result as the Moz Ranking Tracker. The keyword is "schafkopf" and the site is www.sauspiel.de. The relevant country is Germany (www.google.de). Does anyone know the reason why the results differ? Could it be the search query was made from different countries/IPs? Any ideas, hints?
Moz Pro | | sauspiel0 -
Keyword difficulty always high
HI there, I'm new here and am just getting used to the keyword difficulty tool. I've noticed that just about every keyword phrase I type in, including ridiculous ones such as "perspex underpants" or "guy debord's shoes" all have a difficulty well over 50% and many over 60%. It makes little difference what my phrase is. Am I doing something wrong perhaps? How am I to interpret this result? It would seem to suggest that It is always very hard to rank, even for a rare and ridiculous phrase.
Moz Pro | | WeGoBang0 -
How do i target keywords locally
I am working for a cosmetic surgeon with clinics in three geographic places. I would like to give him specific keywords that he can go after successfully. When I use the keyword tool with terms like botox cosmetic staten island or breast augmentation tarrytown, I get competitive rankings like 36% or 37%, but it doesnt tell me if there are only a few searchers doing this per month. In Google's Adwords tool, it thinks that the number fo searchers with these same terms is too small to measure, literally giving me back a dash (= insignificant traffic). However, it I use Google Adwords with more general terms, say breast augmentation surgeon, and get a medium/110 global monthly searches, when I come back to SEOmoz tool and assess the same keyword, I find that the traffic picks up doctor sites in Arizona and elsewhere, where clearly no one who wants cosmetic surgery in new York is going to fly to Arizona for it. So, how do I ensure a balance between targeting too little traffic but including the names of specific towns, and targetting more general terms but not having local prospects. Has anyone tackled this in a specific medical niche?
Moz Pro | | DianeDP0 -
Choosing the right keywords
With the Pro tools at SEOMoz, how do you know if your going after the right keywords on your website and do any of the tools suggest keywords you should be going after?
Moz Pro | | TheVolkinator0 -
Why am I getting duplicate content errors on same page?
In the SEOmoz tools I am getting multiple errors for duplicate page content and duplicate page titles for one section on my site. When I check to see which page has the duplicate title/content the url listed is exactly the same. All sections are set up the same, so any ideas on why I would be getting duplication errors in just this one section and why they would say the errors are on the same page (when I only have one copy uploaded on the server)?
Moz Pro | | CIEEwebTeam0 -
On-Page Keyword Optimization Question
First let me say I want to improve the text of the site I am working on focusing on the site visitor in the first instance. I run the "On-Page Keyword Optimization" The page fails on "Avoid Keyword Stuffing in Document... ...Occurrences of Keyword 48" well over the limit of 15. The occurrence include those in the site navigation and strapline, but it was my understanding that Google was aware of nav areas/areas common to most other pages on the site and that keywords in these areas weren't viewed as being part of the page content. The keyword is the main keyword for the company, and the page is the home page i.e. "acme widgets" the others are "acme widgets for the home"... well you get the idea: The page breaks down as follows: 5 instances in primary nav 1 instance strapline 3 instances secondary nav Remainder in page body I am told by the tool to reduce to 15 instances, so should I? Have 9 instances in the nav and other areas and 6 or so on the page Have 9 instances in the nav and other areas and 15 or so on the page
Moz Pro | | GrouchyKids0 -
Keyword tracking
I'm tracking keywords. In the past past i used Rank checker. I have compared Rank checker and Rank tracker of SEOmoz and they give different results. Which one is more accurate?
Moz Pro | | PlusPort0