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
-
Keyword Ranking History Chart
The attached image shows the Keyword Ranking History with big downward spirals on Aug 27 and Sep 24th. Yet it's also showing up within the #10-#20 row. What is the official technical reason for why it's in both places? My boss is asking and I'm blanking. 🙂 Just that the URL was found in both spots? B69toK9
Moz Pro | | WineCellarInnovations0 -
How To Ques. Getting ranked on page one for a keyword when you compete with bigger websites/companies/stores
Can David Beat Goliath. I work with small businesses with top products that are up against big brands and their online presence. If I am working with them to create content that meets the needs of all their stakeholders/customers/prospects to generate revenue I wonder if keyword targeting with content can really pay off to get them page one, #1 position ranking. So I ask you this question? How do you create a story for a small online store that can get ranked on page one for a keyword when you compete with bigger websites (or sites with higher domain authority)? I don't need all the basics, I'm just looking for a key insight or tip that you have found or heard is working for a David to beat a Goliath (and hold their position rank once they get highly ranked). We are up against sites - for viable keywords -who have higher domain authority and in some cases more content or link backs. Also, I've notice in situations when I do get to page one and I'm in position 7 MOZ analytics show low to no traffic coming from it? Yikes, what do I do to improve that? These are top keywords.
Moz Pro | | brandawakening0 -
Google Local results ranking
Are Google Local position results included in Moz ranking reports? If not, how can these be tracked and monitored? Is a Google Local result likely to achieve a similar CTR as previous organic results? Some of our previous good organic search rankings seem to have been replaced by Google Local results for our restaurant and hotel clients. Is this likely to achieve the same traffic and if not, is there a way to get back to organic results? Thanks!
Moz Pro | | ignitehospitality0 -
My Keyword Stats are Lagging?
In several of my PRO campaigns, I'm noticing that my keyword traffic stats are several weeks behind. Any idea what is causing this? Here's today's report from a campaign: Any help or explanation is great. Thanks!
Moz Pro | | jeffpic0 -
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 -
Canonical URLs for Search Parameters
Hi Guys Our seomoz campaign report is returning a lot or Rel Canonical issues similar to this for each page. The non / version redirects to the / version but how do I get the ones with search parameters ie '?datefrom&nights' to redirect. http://www.lamangaclubresort.co.uk/accommodations/las-brisas-78
Moz Pro | | JohnTulley
http://www.lamangaclubresort.co.uk/accommodations/las-brisas-78/
http://www.lamangaclubresort.co.uk/accommodations/las-brisas-78/?datefrom&nights
http://www.lamangaclubresort.co.uk/accommodations/las-brisas-78/?datefrom=&nights= Any help would be welcome, thanks0 -
Looking for a tool that can pull OSE stats for a bulk amount of URLs
I know that people have developed inhouse tools with the OSE API that can analyze thousands of URLs and pull metrics like PA, inbound links, etc. I need to analyze about 80k URLs and sort them by authority and I was hoping that someone could point me to a tool that can do this or let me use their tool. I'm willing to pay for access to it. We could build it inhouse, I imagine that it would be pretty easy, but our IT resources are stretched too thin right now.
Moz Pro | | Business.com0 -
Idea for the Best Method of getting REAL Keyword Search Data
I've been using googles keyword tools to get keyword search data, but I'm pretty sceptical of some of the results it throws out on number of searches. On a number of keywords - particularly when you get to longtail, I've seen results which cannot possibly be right. So - I am trying to find out a way of getting REAL data I can trust. Here are my thoughts on a possible method of getting this key data:
Moz Pro | | James77
1/. Firstly I am taking on the assumption that the adwords campaign monitoring statistics are more reliable and accurate than the keyword research tools - correct me if I am wrong! 2/. Then take a load of keywords you wish to monitor and create didfferent ads for them based of EXACT match. 3/. Make sure non of your adverts conflict with each other, so you may have to turn off any other campaigns you have running. 4/. Put you bids and available spend as high as possible, so that ideally you will your ads will always be shown for every search match, and ideally always come in No1 spot on the ads. IE your aim is to create a neutral environment where your ads are shown for every search match and appear in the exact same position for each search match. Run the campaign for a period of time long enough to be confident that you have enough search data. From this you should have the vital data on keyword searches done on your exact match keywords. 5/. Repeat the test, but this time use phrase matches and again make sure there are no conflicts. 6/. Repeat again with broad match - this would require very careful implimentation not to have any conflicts and you would likely need to make heavy use of the "Not Include" keywords. What are your thoughts on the above process? - Any flaws, or other better solutions? Obviously one key thing with doing this is you need to have to be prepared to have a decent budget to get this data - but it won't be wasted as you will also be getting the adwords traffic. Thanks0