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
-
Where else can I get search volumes from?
We use Keyword Planner to get a rough idea if a keyword has search volumes and worth tracking. But recently, it's showing zeroes (all locations) for very broad search terms such as "corn seed" "sorghum seed" "canola seed" and all variations of these three with "seed" in the phrase. We checked trends and there are searches for it. Has keyword planner gone bonkers? There were search volumes for corn, canola and sorghum variations, just not words with "seed", which is very odd. "corn grain" has 9,900 searches and "canola plant" has 5,400 searches, for example. "canola seed" has 201-500 searches on Moz, so keyword planner, I think really filtered out seed words. Is there another tool where we could just copy/paste or import a list and it'll show us the search volumes? I uploaded words on Moz, but we can only get search vol ranges and mostly don't have data yet for Australian searches. Does SEMRush have this capability too? I couldn't seem to find where to upload a list. If Google just filtered out these words, is there a way to get around it?
Keyword Research | | nhhernandez1 -
What place does plural versions of keywords have in keyword research?
Working on doing a massive keyword research project for my sites, one of the things I am trying to figure out is if I should be including plural versions of keywords. For example, should you include yoga mat as well as yoga mats?
Keyword Research | | ShockoeCommerce0 -
Setting Up a Keyword Matrix
Greetings MOZ community!! My real estate web site contains about 500 pages with perhaps 70 pages targeting low volume, somewhat valuable but not very competitive keywords. Three to four URLs target very competitive terms. The following terms are among the most valuable: New York City office space,
Keyword Research | | Kingalan1
New York office space,
Manhattan office space,
NYC office space Such variants as: Office space in New York City,
Office space in New York,
Office space in Manhattan,
Office space in NYC
ETCETERA convert really well How would I match different terms to different URLs? For example I have just re-written the following two critical URLs: www.nyc-officespace-leader.com (home page)
http://www.nyc-officespace-leader.com/commercial-space/office-space (product page) Would it make sense to use "Manhattan office space" and variants on the home page while excluding "New York City office space" variants? At the same time I would use "New York City office space" variants on the "office-space" product page while excluding all mention of "Manhattan office space". Is this logical and does it conform to SEO best practices? For the "NYC office space" terms I would add them to http://www.nyc-officespace-leader.com/listings. This URL has almost no text but a strong potential to rent because of a high number of incoming internal links. Is this approach sensible? In general what measures should I take to prevent URLs from competing for the same keywords? Also, is there a software package or tools that I can use to come up with keyword variants? As a non SEO professional, can I create my own keyword matrix or is this really in the realm of a professional SEO consultant? Thanks, Alan0 -
Long tail keyword research
Is there any way for me to figure out long tail key words related to keyword such as "IT solutions"? This is a competitive term. How do I figure out related keywords with high search volume and less competition?
Keyword Research | | zsyed0 -
Broad Match Search Volume
Hi All, In Google keyword planner, "broad match" option has been removed. I want to know that is there any other method in Google keyword planner or any other tool or any technique through which we can find out the "Broad Match" search volume??
Keyword Research | | RuchiPardal1 -
Does SEOmoz account for keyword variations?
If I want to know my rank for bank account, do I need to list bank accounts as well or will my ranking include variations? Also, if I use the word bank as a keyword, will any search that contains the word bank (even when other words are included) count towards the ranking for that word? Or would I need to add additional keywords like dallas bank, local bank, etc?
Keyword Research | | Mpulliam0 -
Page keywords
How many keywords should the home page of a Real Estate site be optimized for?
Keyword Research | | bronxpad0 -
How to interpret the keyword tool?
I've played with the keyword tool a bit. Some keywords have 43% difficulty and some have 55%. What do these difficulty levels mean? I don't really know how to go about it.
Keyword Research | | sleepmaster0