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
-
Organic search
To get the best organic search results and rankings; should I use as many keywords from analyasis tools. Load all into the keywords tag section of my home page. Or, run Google keyword analysis for ytd 2013 and select only the keywords that had any activity. I understand that for PPC I need to be more selective.
Keyword Research | | STDGreg1 -
Long tail keyword research tool
What long tail keyword research tool do you use besides Moz keyword research tool. Thanks
Keyword Research | | zsyed0 -
Where are the Google Search Volumes in Keyword Analysis
I just joined and started by doing some keyword analysis, For some reason although I select "On Google", the tool only reports Bing Search Volume (Exact match). I am not that interested in Bing - not sure how to display the Google search stats
Keyword Research | | jbendiner0 -
Keyword difficulty report - am I stupid??
Hi, Im a programmer but SEO newbie and I am trying out Moz Pro. To be honest I feel really disheartened right now, I find the world of SEO very difficult and full of conflicting information. Anyway, I am trying to get my head around the Keyword difficulty tool in order to determine what keyword I want to go after and what I would need to do in order to outrank the competitors. The website with the highest PA, most external links to the domain (4000 versus around 80-90), the most linking root domain and the best on page optimasations ranks nr 5. The website that ranks 1 is the only one with good social signals. All of the websites has the keyword in the page title. What am I missing? This makes no sense to me. Is this Keyword tool reliable? VERY grateful for any help from you guys.. /Emma
Keyword Research | | EmmaGrey0 -
What do broad match keywords represent?
Exact match is perfectly easy for me to get my head around - broad match, not so much! Take the phrase, "removing blueberry stains." Is the broad match data for this that I'm seeing in the Google keyword tool for searches that involve any of these particular words, in any phrase, in any order - just so long as they're all there? Any help with this concept would be much appreciated.
Keyword Research | | ZakGottlieb710 -
Keyword Research tips at State level
Google Adwords Keyword tool Local Monthly searches covers all US and it is misleading for local/regional companies. is there any tool and method you could recommend to find out State Level (for example Virginia) local monthly search volume for Keyword research. I think the methods of Keyword Research for National and Local (state level) level should be different. what do you think?
Keyword Research | | CertifiedSEO0 -
How can i track keywords history
i need to keep a record for all keywords history , is there any way that we can track keywords history so we can compare each week with the previous weeks ?
Keyword Research | | omarfk0 -
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