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
-
How to find long tail keywords?
I need ideas for finding long tail keywords, I do have a few tools that I make use of but I guess I'm just getting the same results as everyone else will be getting. Ideas please? (And thank you!)
Keyword Research | | seoman100 -
Ranking a homepage for keywords
We recently found a handful of keywords we would like our homepage to rank for (for example - customer experience). On our homepage we have articles (4-5 posted daily) that feature the keywords we are targeting (one being customer experience). How do the keywords we are using in our daily articles that are posted to the homepage affect the overall keyword ranking for the homepage? In other words do the keywords used in the articles (title, first 2-3 paragraphs, meta description, etc.) all roll up/build up to the homepage's keywords or how does that work?
Keyword Research | | carlystemmer0 -
Why will my site not rank for this keyword?
My site http://www.electric-heatingcompany.co.uk/ performs quite well for most of my keywords and gets ok traffic. But for "electric radiators" it just isn't ranking? I was thinking about redoing the landing page for it? Can anyone offer some insight as to what else I could do? Here is the current electric radiators page http://www.electric-heatingcompany.co.uk/index.php/electric-radiators-2/ Thanks, Laura
Keyword Research | | lauratagdigital0 -
How to stay organized for keyword research?
As most of you know keyword research can be quite taxing. I have been trying to get organized and do extensive keyword research. But trying to stay organized is proving to be more and more difficult. Can I get some expert views from experts in the community as to how you all go about organizing your research and how you track things over time. Thanks
Keyword Research | | EricMoore0 -
Website no.1 on Google for keyword but why?
Hi Guys, I'm trying to figure out why a site is ranking for a keyword. Keyword is "guitar strings" They have only implemented the following techniques: -Chosen keyword is within Meta title -Chosen keyword is used 8 times within content What else would make them rank so highly? Thanks, Dan
Keyword Research | | Sparkstone0 -
Help finding some decent keywords
Anyone care to help a SEO Newbie find a couple of key words that would be easier to rank for for my website that provides kayak fishing information? mysite: yakangler.com The key words that I've identified are as follows: best kayak
Keyword Research | | mr_w
fishing from a kayak
fishing kayak review
fishing kayaks
kayak and fishing
kayak fishing
kayak for fishing
kayak reviews
kayak rigging
kayak weight limit
kayaks fishing
kayaks for fishing But I'm worried I'm missing the point, I don't see hardly any traffic from most of these. I've really tried to rank for "kayak fishing" but seem to be totally lost in the Google Panda abyss. Any advice on a different word or strategy would be greatly appreciated!0 -
How trustworthy is Google's Keyword Tool for organic search research?
Can anyone (not Google affliated) explain to me where Google's data really comes from in their Keyword Tool? Is it at all based on organic search? Or only on Google Ads related data? I know there was some controversy back in June '10 and the Google remedied the return of suggested keywords but I can't seem to get a clear answer (other than from the Google blog itself) whether the search volumes returned are truly indicative of organic search. Am I relying on the wrong tool? Do those more savvy than I only rely on the keyword tool for PPC research. Please help! I'm obsessing over my numbers here. 🙂
Keyword Research | | lhutt0 -
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