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
-
Where is the link prospecting tool?
I feel like last year when Moz was still SEOMoz I used a beta tool that would help you build a bunch of queries for link prospecting. You would tell it what your sites about and a few other pieces of information, and it would give you a list of google queries to get you started (ie inurl:directory <industryname> +"add site"</industryname>). However, I'm having a hard time finding this tool, or any reference to it on the web. It's also possible that it wasn't a moz tool but I'm misremembering where I found it. Does anybody have any idea what I'm talking about?
Moz Pro | | brettgus1 -
Why My Keyword Rank Had a Huge Drop?
Hi guys.. i really need your help.. I have a problem, why after i optimization my keyword with one article each day, after 1 week later my keyword rankings had a huge drop from page 1 down to page 5? (the data from moz.com rankings) How the best way to increase my keyword rank in Google? Is there any other way than to use article? Really appreciated for your help..
Moz Pro | | newbie_SEO0 -
Finding Related Keywords and/or Phrases
I'm diving into unknown territory and looking for keywords and phrases related to a prospective new clients business. He knows some of the general terms, for example, water removal. What tool works best to find related search terms and the number of searches for those keywords/search terms. I usually use the Google Keyword Tool but going to give moz a try. Love to be able to get local search data as well. Thanks!
Moz Pro | | DFLsports1 -
Can you create in the Keyword Difficulty Tool several separate reports?
If I go now to the Keyword Difficulty Tool and submit keywords, I get one list with all keywords (let's say 300), but I have actually say 30 keywords per segment/niche I wan't to view. Is is possible to have 10 separate reports?
Moz Pro | | TrendDevelopment1 -
Does SEOmoz have a tool to find mirror sites?
I heard from a company that is trying to get my clients SEO business that they discovered multiple sites mirroring our site's content. Does SEOmoz have a tool to find these websites? Or does Google?
Moz Pro | | thomas.wittine0 -
No longer in top 100 for branded keyword - How!?
Got a weird one here... Won't give away actual URL but for this example let's say client's site is: www.purplebananas.com Many of the longtail keyword-targeted subpages/posts are still ranking pretty well. We recently went through and optimized the site based on poor scores we found from crawl reports from SEO Moz, which included renaming some sub-pages, eliminating duplicate content pages, archives, etc (it's a wordpress site, about 4 years old). This site used to rank at the top or near it for the search "purple bananas". However, after we optimized the site it's almost completely fallen off the radar of Google, turns up way over 100 for the search "purple bananas". Strangely, if we search "purplebananas" we're at the top still. Any idea what's going on here? Are we potentially over-optimized or something weird for our own brand!? Any troubleshooting tips? FWIW the changes were made about 6 weeks ago and while we're steadily building links, I don't think this is the standard "Google dance". Thanks!
Moz Pro | | alpen0 -
Technical Question about tools available in market
Hi, I am looking for a tool most probably web based tool like opensiteexplorer / majestic seo that gives me the list of URL For example, on google we can do site:seomoz.org , and it's saying About 115,000 results. I need to get list of those 115,000 URLS in any file whether it's csv or any other. anybody care to share ?
Moz Pro | | sumairr1230 -
Campaign Manager Keyword Rankings all messed up???
My campaign in SEO Moz Campaign Manager has just ran it's weekly crawl, and all my keyword rankings are messed up. 18 keywords have apparently dropped by massive amounts, but when I do a physical search, they haven't moved. Also Keyword Tracker agrees with the physical search, so why is the Campaign Manager showing the wrong rankings all of a sudden??
Moz Pro | | gdavies090319770