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
-
Supplementing Moz's Keyword Explorer When Volume Has "No Data?"
Many of the keywords for which I'm trying to find volume information in Moz's Keyword Explorer have "no data." This makes it difficult to determine the value of the keyword compared to other options. What tools / techniques do you use as a stand-in for this data?
Keyword Research | | Kevin_P0 -
Targeted keywords for landing pages but keyword has a lot of synonyms, how is the best way to approach this?
I'm trying to target one page for one broad 2 word keyword, however, because our niche revolves around this keyword and it's synonyms, the keyword is used on every other page, thus creating the issue of non-targeted pages taking the rank instead of targeted page. I've thought of using synonyms on each page, so that no one page uses the same keyword, but felt this could be seen as spammy or could just hurt overall relevancy towards the main keyword, thus a loss of rank. I understand page authority also plays a part, but also seems that every page other than the page I want get's targeted.
Keyword Research | | Deacyde0 -
Long tail keyword
Hi, What the the most useful long tail keyword tools you use for your adwords? Thanks for any insight.
Keyword Research | | LauraHT0 -
Keyword difficulty %age
I am using the Seomoz keyword tool to do some research. Some of the keywords I am researching are returning with a difficulty of 20 - 30% , are these good percentage keywords to target. I will obviously be following Seomoz tips / methods etc
Keyword Research | | wtfi0 -
Is there a good way to get the list of keywords that bring the most traffic to a competing website?
Listing your most "popular" keywords is easy when you have an "old" website, but when you start out, it's not always easy. We obviously have a list of keywords, as well as various versions for each of them, but we have a hard time assessing which ones are the most popular. Also, we may be missing some. It would be handy to know which keywords are bringing the most traffic to our competitors. Is that even possible?
Keyword Research | | jgenesto0 -
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 -
Site Wide Keyword Extractor
I need a tool or a method that will let me know what a search engine thinks the overall theme of the site is about. Sort of like the keyword extractor, but on a site-wide basis. Does anyone have any sugestions?
Keyword Research | | waynekolenchuk0 -
How to do geo research for keyword phrases?
I'm working on a landing page for a client (music instrument rentals) and want to optimize for terms related to: music instrument rentals in San Francisco music instrument rentals in Seattle music instrument rentals in St. Louis music instrument rentals in Minneapolis/St. Paul How can I find the most popular terms based on a variation of the main term (music instrument rentals) and geo area? In other words, maybe 'Where to get Instrument rentals in San Francisco' is best? Thanks for your input! Mike Corso
Keyword Research | | mikecorso0