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
-
New Limits to Adwords Search Volume Data..Oh my!
Has anyone experienced the recent limiting of data in the Google Adwords keyword tools -- Monthly average search volume? The average monthly search volume data used to be nuanced and precise. When searching for the average monthly volume for a keyword like "Chicago Heating and Colling Companies"now results in the vague 1K-10K . Does anyone know what it will take to get more specific ranges? I am new to AdWords and creating my first campaign. Thanks!
Keyword Research | | HectorCortes1 -
Is this keyword cannibalization?
I have a product page and our home page ranked for the same keyword. On August 6th the product page was ranked #14 then plummeted to #60. On August 13th our home page was in the #2 spot (line just appears out of nowhere) and it is now in the #1 spot. I also see the same pages appearing for some keywords ranked in multiple positions then plummeting and one coming back up. I'm having a hard time understanding how the Keyword tool in Moz is reporting exactly. Thanks! To add to this: From Oct 8th to the 15th we jumped up from #60 to #16 for one keyword and then by Oct. 22nd are back down to #60. I have a huge spike on the 15th. Wondering if that had anything to do with any algorithm updates?
Keyword Research | | Sika220 -
Excluding my domain from search statistics
I would like to exclude my own domain from seach statisics- so when I search the numbers are not reflected in the various search engines. Do I need to register the domain in each search engine to do that? Thanks!
Keyword Research | | Kenaiguide0 -
Keyword tool
Does anyone know of any good keyword tools that will help me find and then maintain a list of keywords? I currently use Google adwords and now the keyword tool from Moz but I am looking for something that will help me find and generate keywords not just get statistics about them. Thank you.
Keyword Research | | shiftins1 -
Keyword selection and search counts
I am a new pro member and have noticed that a lot of my keywords are very similar. i.e. "piano movers Atlanta" vs. "Atlanta piano movers" vs. "piano movers in Atlanta" Is there an accurate way to see search counts for each of these terms do determine which one I should target? Does anyone have any recommended tools or strategies?
Keyword Research | | bcarp880 -
Meta Keywords Dilution?
In general, does having a large number of meta keywords listed in a page's meta keywords line dilute effort? On other words, should I focus on optimizing for 1 or 2 keywords per page to keep my efforts focused and increase the probability of ranking better for those 1 or 2.....or should I put down all the keywords I would "like" to rank for? Thank You
Keyword Research | | NiallTom0 -
Duplicated string in the google keyword tool
Is it possible that the google keyword tool is wrong? It's the first time I realize that for many keywords the google keyword tool reports a big volume of searchs for a keyword as if it were tiped two times. In some cases, as the attached image, it's the same volume, in other cases is even bigger the one with the duplicated string What should I think of that, that, "champagne champagne" has really 4 million searchs? if champagnechampagne.com were an available domain name, should it be a good idea for a microsite? Thank you! t9Jwn.png
Keyword Research | | gvnns0 -
Does keyword arrangement matter?
If I choose: Blue Wide Widgets vs. Wide Blue Widgets vs. Widgets Wide Blue Are these considered 3 different keywords that show up on 3 different SERPs?
Keyword Research | | 13375auc30