Most efficiënt way to retrieve search volume for thousands of keyword
-
Hi,
I'm trying to figure out how I can efficiently get search volumes for large quantities of keywords. Unfortunately Keyword Planner has reduced their limit of keywords:
"You entered too many keywords. Please limit the number of keywords to 1,000. You can also upload a file with up to 800 keywords."Weirdly, the file upload's limit is now even lower than the normal limit. A 1000 keywords a time will be a real chore when you want to retrieve search volume for 50.000 keywords. I tried SEMrush, but it does not suffice due to the fact that a lot of keywords in my language (Dutch) are not in the database. I also looked into the Adwords API, but this does not yet seem to have any implementation in Google sheets?
Ideas are welcome!
-
Thanks for you answers, I'll definitely be checking out Grepwords. I also want to look into the Adwords API in combination with excel, because these does seem to have an implementation, although I can hardly find any clear information on this. I just want to be able to paste a list of keywords and retrieve the search volumes for my country automatically.
-
Yup - agree that Grepwords is the way to go here. http://grepwords.com/
Keyword Explorer supports only up to 500 keywords uploaded in a single list (and the keyword data is only for the US right now). Going piece by piece through AdWords is probably the only other path to take.
-
Grepwords. Simple API, though poorly documented. Believe Moz products use it as a source too.
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
-
How is search volume measured (i.e., thousands)?
Some are in thousands, but it's not always noted and I'm sure there is more than 1 query for a term. Thanks!
Keyword Research | | rootmktg0 -
Keyword In Page Title
Broad Keyword Usage in Page Title Easyfix <dl> <dt>Page title</dt> <dd>"The Sea Trout Inn in South Devon, Near Totnes - Luxury Bed and Breakfast and Restaurant - Contact Us"</dd> <dt>Explanation</dt> <dd>Search engines consider the title element to be the most important place to identify keywords and associate the page with a topic and/or set of terms. SEOmoz's correlation research has also shown that rankings are heavily influenced by keyword usage in the title tag.</dd> <dt>Recommendation</dt> <dd>Employ the keyword in the page title, preferrably as the first words in the element.</dd> <dd>The keyword is Hotels Totnes, how can I put this in a page title without it looking stupid ?</dd> </dl>
Keyword Research | | Stoz0 -
Keyword stuffing
Just wondered whether you think the footer text here on tis page constitues 'keyword stuffing'. I think it does but wondering why they haven't been penalised for it. http://www . lippyliciouscakes . co.uk/ Thoughts? Many thanks.
Keyword Research | | littlesthobo1 -
SeoMoz Keyword Tool
Hello All, Ive been using the SeoMoz Keyword tool but have a quick question. Im working on a newer site with a DA according to OSE of 35. Im combing through keywords to rank. Although competition is very high I have found a few holes. According to the Keyword tool in SeoMoz a few keywords Im looking at are roughly 50%. Would it be to difficult to rank for this type of term? Ive been using a combination of Google Trends, Adwords keyword tool, and ubersuggest, to try and see whats available. Does anyone use different tools? Thank you
Keyword Research | | TP_Marketing0 -
Why are my keywords not being crawled
In my google web tools. the keywords that are about my site are not being crawled. I have them in my Meta descriptions and keyword meta, but still arne't showing in significant keyword list for google.
Keyword Research | | TheGroom0 -
Optimizing for two nearly identical keywords.
Hi Mozzers, So in one of my campaigns I'm trying to optimize for "Personal Trainer Minneapolis" and "Minneapolis Personal Trainer". Would the best tactic be: Develop and optimize two pages. One for each of these similar keywords. (Clearly not the best UX). or Try to optimize a single page for both. Thanks for your thoughts!
Keyword Research | | JesseCWalker0 -
Do you use broad match or exact match on Adwords Keyword Tool when doing keyword research?
I wasn't sure whether to classify this as a discussion or a question. I'd love "the right answer" but I'm not sure if we're going to get one... Let's try. When you use the Adwords Keyword Tool for doing keyword research, do you use the numbers from "broad match" or "exact match" when comparing relative search volume of keywords? (And yes, I know the numbers need to be taken with a grain of salt, but when it comes down to it, you're using the numbers to compare and come to conclusions regarding the best keyword to use - so which match type gives you the data you're looking for?) To be a little more specific - when you select "exact match" for, let's say the keyword "baking supplies", is that telling you how many people searched for that phrase within quotes <"baking supplies">, or how many people searched for only <baking supplies="">, as opposed to that word within a phrase <baking supplies="" stores="">or with the words reversed <supplies baking="">?</supplies></baking></baking> Based on some keyword research we had done a year ago where any phrase reversals like <water bottles="">and <bottles water="">were coming out with the exact same numbers, even when it wasn't so intuitive that there would be the same search volume, we came to the conclusion - with the tentative suggestion of the SEOMoz staff on the old Q & A - that broad match would include all instances of the keywords in reverse order, so if you wanted to know how many people were searching for <water bottles="">only, you needed to use exact match. </water></bottles></water> That's what we did for about a year (I also think I saw Rand mention that somewhere in a presentation slide recently, although I could be mistaken and I don't recall exactly where it was to check it up) and then based on a recent forum discussion I had where someone was questioning that premise, I did another check with two KW reversals and while <water bottles="">and <bottles water="">still give the same number, <baking supplies="">and <supplies baking="">do not. </supplies></baking></bottles></water> So I'm left with a big question here as to what the best policy is. Google Adwords Help is very vague on what the match type means in the tool (it seems to be talking about only your settings for your campaigns). So - any input after this long saga? Thanks!
Keyword Research | | debi_zyx0 -
A good rule of thumb for competition and local searches when selecting keywords
I'm doing keyword research in the Google Keyword Tool and was looking and spending a lot of time looking at keyword competition and local searches. I'm trying to determine what is a good rule of thumb for what level of competition and local searches people have used when selecting the keywords they will optimize for. I've currently been trying to find ones that have less than 50% (moderate) competition and less than 1,000 monthly searches. Also, which do you put more weight on the competition or the number of searches.
Keyword Research | | EricVallee341