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
-
I'VE DONE EVERYTHING RIGHT BUT STILL GET LOW GOOGLE RANKING
Moz Pro Dashboard compared my site to three competitors' site. My site is better in every aspect. My DA is higher, I have four times more external links, I have more relevant content than my competition, my site also is the fastest, I have solved all redirect issues, there is no broken link internally or externally. We are custom home builders. So all our sites have numerous full screen images. I have optimized all of them. When I ran WebPageTest on my competition, they all fail. My site got A's in all categories. The three competitors' sites rank first, second and third. My site ranks bottom on the 2nd page. Since my site was online last January, I have spent thousands of dollars on SEO work. Its url is www.pokudesign.com I am hoping somebody can point me in the right direction. I am attaching a screen shot of my Moz Pro Dashboard. frEpZ
Moz Pro | | pokongku0 -
How can I limit the impact of Google's mobile friendly updates on keyword rankings?
Hi everyone, I have a client on a monthly SEO package that is taking a hard hit in the rankings as their website is not mobile friendly. We are currently building a new website for them that will be fully responsive, but face the predicament of how to keep the current site performing relatively well in the rankings in the meantime. The site is generally well optimised and we always follow SEO best practices, so we've hit a bit of a stumbling block as to how to limit any negative impact the mobile friendly updates have on the site. Does anyone have any suggestions for damage limitation? Any help will be greatly appreciated. Thanks.
Moz Pro | | keyzo0 -
Why has a .cleaning domain not been indexed on Google?
One of our clients domain names is http://companyname.cleaning I've done all of the on-page SEO, submitted a sitemap to Google and am currently monitoring the analytics and data on MozPro. The next scheduled update on domain authority is the 21st of July? We must have had this on since April, the website was most likely launched at the end of March. Is it normal to wait this long for a site to be indexed and the domain authority to rise?
Moz Pro | | birdmarketing0 -
On Page Reports for Long-Tail Keywords?
First Q&A here, so take it easy on me. Hopefully this is not a dumb question. 99% of the on page reports I look at are for local keywords. I'm finding that some of the page reports get and F where they should be receiving A's. I noticed if I manage a long-tail keyword like "books in houston tx" that I get a grade based on the exact phrase as opposed to a combination of the keywords. So when I have text in the body saying "books in the Houston area" or "Houston Books" for example, instead of using my exact managed keyword, it will tell me that the keyword is not mentioned in the body anywhere. When it is, it's just not in the exact order... I'm trying to write my pages for users and I don't think the users want to hear "books in houston tx" several times. If I do a report on the same page for the keyword "books" I get an A. So this is where it gets a little in the grey area for me. I need a solid on page report for local long-tail search terms. Anyone have any advice? Is there a way I could be using this tool to better suit my needs?
Moz Pro | | AmericomMarketing0 -
My tools have stopped working.
I just started my 30 day trial a week ago. Yesterday, the toolbar stopped showing PA or DA, and none of the tools will load for a page. I've tried logging back in several times and it hasn't helped.
Moz Pro | | HealingCrystal0 -
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 -
Keyword Canibalization!
I have a page and it's ranking for a keyword. I placed an internal text link with that keyword as an anchor from that page to that page. The pages is linking to itself. Why on-page report card sees that anchor text link as a cannibalization link? Another problem that i cannot resolve about keyword cannibalization is that the same tool sees cannibalizing link for different kw. Ex : I have a page/category about shoes. From that page i link with anchor text links (the name of the anchor is the name of subcategory ) to subcategories which are men shoes, women shoes, kids shoes, etc. Now, why those links are seen as a cannibalization links for the keyword shoes?
Moz Pro | | maldiniii0 -
Keyword Update More Frequent?
I think it's extremely important to be aware of any change in ranking ASAP is there any way to have SEOMOZ Pro update more often than once a week?
Moz Pro | | montage0