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
-
Keywords and content query
Hi we are in the process of redesigning a web site and I’m looking to ensure each of the pages are correctly optimized. I’m concerned that some of the pages do not allow for text or content . From an optimization perspective is there a general rule around the amount of text a page should have and the amount/ration of keywords they should contain? Any advice would be much appreciated.
Keyword Research | | aplnzjune180 -
Can you ever compete with product keywords?
I am doing keyword research for a dental blog and wanted to get the forum's opinion about these SERP results: https://moz.com/explorer/keyword/serp-analysis?q=electric+toothbrushWondering if the Google algorithm will always favor something like Amazon since someone searching "electric toothbrush" probably doesn't want info -- they probably want to buy...right?
Keyword Research | | catbur2 -
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 -
Google algo mistake in persian search?
I recently wanted to work on a high important persian keyword (شارژ ایرانسل) and analysis it on moz.com Difficulty SERP. But the result was very Surprised me. because the second top site in SERP used more than 15 time the keyword in home page and Google doesn't mark it as spam. why Google doesn't apply the spam algo in some language? akg2NqH.png kcHgx0D.png gUSez3B.png
Keyword Research | | vahidafshari450 -
Best keyword research tool
Okay, what is the BEST keyword research tool? I've heard all across the board, but I'm looking for preferrably a free tool, but just want to use one that can do competitive research, as well as find me a ton of long tail.
Keyword Research | | azguy0 -
Google Webmaster Keyword Significance.
In my google webmaster tools the most significant keyword google attaches to my site is word 'VAT' as in, Value Added Tax. Followed by Basket. I can see why this is, as the word VAT and Basket is on every product page, but it really is not a keyword I want to target. Does this have any negative effect on other keywords I am targeting? What should I do about this? Here is the site: https://www.loveelectronics.co.uk
Keyword Research | | jcarter0 -
Keyword Updates
I have a list of keywords in a campaign that I need to update. I use the keyword report card to review those keyword performance by page. I dont currently see a way to update those keywords, I only see the option to add or delete. I don't want to delete and re-enter because then I will lose that "mapping". Is there a way to simply update a keyword?
Keyword Research | | webdecorators0