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
-
Duplicate URLs
A campaign that I ran said that my client's site had some 47,000+ duplicate pages and titles. I was wondering how I can possibly set that many 301 redirects, but a Moz help engineer said it has a lot to do with session IDs. See this set of duplicate URLs: http://www.lumberliquidators.com/ll/c/engineered-hardwood-flooring (clearly the main URL for the page)
Moz Pro | | AlanJacob
http://www.lumberliquidators.com/ll/c/engineered-hardwood-flooring?PIPELINE_SESSION_ID=0ac00a2e0ad53eb90cb0b0304d178fc1
http://www.lumberliquidators.com/ll/c/engineered-hardwood-flooring?PIPELINE_SESSION_ID=0ac3039d0ad4af2720b3ccd2238547ab
http://www.lumberliquidators.com/ll/c/engineered-hardwood-flooring?PIPELINE_SESSION_ID=0ac071ed0ad4af292684b0746931158f To a crawler, that looks like 4 different pages, when it's clear that they're actually all different URLs for the same page. I was wondering if some of you, maybe with experience in site architecture, would have insight into how to address this issue? Thanks Alan0 -
Google Webmaster Tools and Open Site explorer's links not matching up
My question is why do my GWT's links not match up to the ones on Open Site Explorer. I watched John Mueller's video, and he said that they had problems with the link counts recently. After checking my links today, I can see that the problem is fixed, but my link count differs from Open Site Explorer. On Web Master Tools I have 307 links, but on Open Site Explore I have 42. Has anyone dealt with this problem? thanks. Peter
Moz Pro | | PeterRota0 -
Integration of Google+, LinkedIn, YouTube?
I ran across a blog on Moz from last November that was introducing the social monitoring feature. It mentioned adding new social platforms that would eventually be included in SEOMoz. Any word on when/if that is happening? Excited to have SEO and Social under the same dashboard! Jake
Moz Pro | | AESEO2 -
Has MozTrust predicted fall in Google rankings???
The definition of MozTrust is:
Moz Pro | | driansmith
"MozTrust is SEOmoz's global link trust score. It is similar to MozRank but rather than measuring link popularity, it measures link trust. Receiving links from sources which have inherent trust, such as the homepages of major university websites or certain governmental web pages, is a strong trust endorsement." That being the case it is quite disturbing that a number of websites have been hit very badly by the latest Google algorithm changes that did indeed have very respectable MozTrust rankings. Can I ask whether anybody has carried out any sort of analysis of MozTrust versus negative impact in Google rankings? The prediction would of course be that websites suffering from a lower MozTrust would have been hit quite badly by these recent changes.0 -
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 -
Strange Ranking On 1st Page Of Google For Competitive Keyword
Hey all, So, I've noticed a site ranking on the first page in Google for a keyword that I have been targeting for years. The keyword is "mixtapes" and pretty competitive. The site, http://www.newyorkmixtapes.com is ranking around #4 in Google. It seemed odd to me so I looked into the site using some of the tools here. Open Explorer showed that they have minimal links. The actual site is pretty spammy also. Does anyone have any idea how this site ranked so high so fast? Is it ranking because I am located in New York? Does Google still put lots of weight on exact match domains? It's just been bothering me because it's a keyword that I put a lot of work into and then the site rolls around an ranks well for it with barely any backlinks. I just wanted to put it out there and see if I'm missing something obvious. Thanks everyone!
Moz Pro | | getrightmusic0 -
What is mT/mR good for In the keyword tool difficulty full report results?
So the ratio is MozTrust to MozRank, but what is this good for? What can I deduce from this and what can I use it for?
Moz Pro | | MarloSchneider2 -
SEOMOZ tools are not helping!
So, I have a website www.mobikwik.com which provides mobile phone topup in India. I signed up for SEOMOZ Pro membership a little less than a month ago. For all our competitors , which rank above us in google as of today , I checked out two things a) competitive link analysis and b) on-page optimization. On b) , our home page had the best optimization for targeted keywords and the best score amongst all competitors who ranked above us. On a) , linkscape tools showed our moztrust and mozrank to be the best. Except for 2 competitors, our domain authority was also better than the rest. Inspite of all this, our website is ranked no more than 6 on google for all targeted keywords. We have the best quality links amongst our competitors. I am at a loss to understand this and how to improve our ranking. I have to make a decision whether to renew my SEOMOZ membership in 2 days time. Please help me decide!
Moz Pro | | mobikwik0