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
-
Google: Is There a Way to Find Your "Unknown Search Terms"
I believe Google stopped reporting search terms for privacy reasons. All my searches show as "unknown". I found a video that showed how to get around this but it's not current. Is there any way to get your Google terms search information? Thanks, Jo-Ann
Keyword Research | | VinJGirl0 -
Keyword Organising
Does anyone know of any tools to aid organising keywords? I'm currently using Excel extensively in an effort to bring some organisation, however it is very labour intensive.
Keyword Research | | seoman100 -
Homepage keyword changing strategy
Hi! We're a spanish construction company and we've been positioning our home with the keyword "wooden homes". We also have a specific landing page positioned with that same keyword. Right now we are getting out of a penguin and panda penalization and we're doing well. As part of a rebranding strategy we are thinking of changing our homepage keyword to "luxury homes". We are still going to hace the "wooden houses" landing page but this keyword is just going to be present in its own landing. The new keyword has much more volume of search than the one we have right now. Is there a strategy you can recomend us for this rebranding? Thanks
Keyword Research | | Canexel0 -
Local keywords still relevant?
Now with Google localizing search increasingly personalizing queriesquery results, is it still necessary to add geo-specific modifiers to keywords? [reworded for clarity]
Keyword Research | | SSFCU0 -
Keyword analysis tool
Is it not working? I have not been able to use it for the past 2 or so days.
Keyword Research | | JohnWalker0 -
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 -
Keywords for homepage and product categories
My homepage explains the different electrical equipment our company sells, our main product category page also does the same but in more detail. I'm stuck where I feel the homepage and product category page need to be optimised for the same keyword except the homepage needs to be optimised for our company name too. Was anyone else in the same situation as me and how did you choose the right keyword between two pages that have the same message?
Keyword Research | | Seaward-Group0 -
Run a batch of keywords 1 by 1 through Adwords Keyword tool
Hi, I'm looking for a tool that will be able to run a list of keywords 1 by 1 through the Google Adwords keyword tool and place them together in a list, in order to get as much long tail keywords as possible. Thanks for any suggestion!
Keyword Research | | DeptAgency0