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
-
Setting Up a Keyword Matrix
Greetings MOZ community!! My real estate web site contains about 500 pages with perhaps 70 pages targeting low volume, somewhat valuable but not very competitive keywords. Three to four URLs target very competitive terms. The following terms are among the most valuable: New York City office space,
Keyword Research | | Kingalan1
New York office space,
Manhattan office space,
NYC office space Such variants as: Office space in New York City,
Office space in New York,
Office space in Manhattan,
Office space in NYC
ETCETERA convert really well How would I match different terms to different URLs? For example I have just re-written the following two critical URLs: www.nyc-officespace-leader.com (home page)
http://www.nyc-officespace-leader.com/commercial-space/office-space (product page) Would it make sense to use "Manhattan office space" and variants on the home page while excluding "New York City office space" variants? At the same time I would use "New York City office space" variants on the "office-space" product page while excluding all mention of "Manhattan office space". Is this logical and does it conform to SEO best practices? For the "NYC office space" terms I would add them to http://www.nyc-officespace-leader.com/listings. This URL has almost no text but a strong potential to rent because of a high number of incoming internal links. Is this approach sensible? In general what measures should I take to prevent URLs from competing for the same keywords? Also, is there a software package or tools that I can use to come up with keyword variants? As a non SEO professional, can I create my own keyword matrix or is this really in the realm of a professional SEO consultant? Thanks, Alan0 -
Is the Adwords keywords planner accurate ?
Hey guyz,
Keyword Research | | atakala
As you guyz do, I base all my seo effort into the keywords' traffic and quality which I can get from Adwords Keywords Planner.
But this post has confused my mind .
It' says the average searches doesn't exactly the average searches.
And everything is okay here now I can say that of course it's not %100 accurate.
But the shocking part is he gives an example of how a big gap there is between real searches number and adwords keywords planner tools give us . What do you think guyz?
Can it be true ?
(And also last time I asked a question, Randy has replied me, If possible please Randy do it again :D.)
Best wishes.0 -
Semantic Keywords Research
Where is the best place or tool to research semantic keywords - any help would be greatly appreciated
Keyword Research | | Bossandy0 -
Low Competition Keywords
My blog, which started in May, is doing really well except with Google. My traffic is growing and so are my subscribers etc but my keywords have very high competition. I don't really like google's new keyword research tool. Any advice for finding keywords I have a chance with? I am only ranking in the top 50 for one keyword (#1-2 spot) but it doesn't give me a lot of traffic. Thanks!
Keyword Research | | blogger20130 -
Title keyword and synonyms in content ?
what is the % relation in between a keyword in title and that given keyword's synonyms in a content of that page? if i use the keyword "apple pie" on a page title once, what should be % of reappearance of this keyword in the content ? and its synonyms in relation to the entire content on that page. thank you
Keyword Research | | orion680 -
How do I find what keywords competitors are ranking for?
I am just starting out doing come SEO research. I seem to remember a tool that would tell me which words my competitors are ranking for and what kind of traffic they are getting. Thanks, Lisa
Keyword Research | | lisarein0 -
Difference in Keywords and Anchor Text ?
Sorry i am noob here: I thought both are same but when i see GSA tutorials i found that both are different. If suppose my keywords is black german shoes than what is my anchor text will be. Also anchor text isdifferent like generice keywords click here, find more etc. Please give explanation.
Keyword Research | | chandubaba0 -
Google Keyword Tool: What is considered a unique keyword?
I'm trying to research keywords using Google's Keyword Tool. After looking at results, I have the following questions: 1. Does singular/plurals of a word count as two different keywords to Google (ie: photobooth and photobooths)? Would I need to have a unique page targeting each word or will one page on my site be sufficient for targeting both? 2. I've noticed that different variations of keywords have the same global monthly search results. This leads me to believe that Google see's all of them as one keyword. ie: "photo booth props" and "props for a photo booth" and "props with photo booth", all have 22,200 search global monthly search resluts. On the other hand "moustache prop" and "prop moustache" have different global monthly search results (480 and 590). Can anyone explain this?
Keyword Research | | Alchemist230