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
-
Coworker and I see totally different keyword volumes on same paid keyword planner account
My coworker and I are both connected to the same company's paid keyword planner account but are using our own individual google accounts to log in. When I look up the keyword "joint bank account" I get a search volume of 9,900, while she gets a search volume of 2,900. Does anyone know why this might be? Do we know which might be more accurate? This doesn't seem to be connected to Google lumping semantic variations together. I've seen it happen way before that update. It's hindering our headline pitching since the volume she sees does not meet our minimum search threshold. Any insight would be greatly appreciated! Thanks, Laira
Keyword Research | | CTI1 -
Keyword Analysis
Is there any way I can find out a list of the top keywords for my site automatically without having to type in certain words myself and wait on the results?
Keyword Research | | meteorelectrical0 -
Any recommendations on how to find non-branded keyword phrases revealing searcher’s intent with high volume and CPC?
-Most of the organic keywords driving traffic to our website are branded. -I’ve used UberSuggest, but those keyword phrases tend to have low CPC and low volume -Thus, the UberSuggest keywords usually produce a low benefit & K.O.B score. -Andrew
Keyword Research | | Todd_Kendrick0 -
Question on keyword rankings
Hi everyone Within our campaign it says that we rank number 35 for a specific keyword in Google in the Unites States but when we google the specific keyword we come up as number two on the first page. Can you help me understand what the current rank is based on as well as how it's results can be different from our Google search? Thank you.
Keyword Research | | DRTBA0 -
Two for the price of one: Can I rank for multiple keywords when only targeting one keyword?
If I'm optimizing for a specific keyword, is it accurate to assume that by ranking for that specific keyword that I will also be able to rank for similar or root keywords merely by ranking for the original keyword? For example, if I'm targeting 'free online bucket list' is it safe to assume that I will also be able to inadvertently rank for 'online bucket list' or 'free bucket list'? Can I assure clients of this? Or if I'm targeting 'Colorado grocery store' should I also naturally rank for 'grocery store Colorado' and not need to make both of these my targeted keywords?
Keyword Research | | derrickkuhn0 -
Evaluating Competition of a Keyword
I'm curious about how others evaluate the competition of keywords when putting together an SEO program: Do you place any faith in the competition listing in the Google Keyword Tool? Do you find value in SEOmoz's Keyword Difficulty tool? What other tactics or processes do you perform?
Keyword Research | | EricVallee340 -
Is this keyword cannibalization?
Hi, Is using keywords in different orders considered keyword cannibalization? for example, if I my client has a catering business based in mississauga, Ontario, should I create separate 2nd tier pages on the following keywords? 1. mississauga catering 2. catering mississauga 3. catering in mississauga Is that keyword cannibalization? The reason I ask is because it's often hard to find a good # of diverse keywords for local businesses that are also used more than a few times each month in the search engines. thanks, Martin
Keyword Research | | RogersSEO0