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
-
I understand it's been asked before, however moz staff is telling me keyword's capitalization is treated as a separate keyword.
So there I was looking through my rankings like every other day, when I see a lowercase and uppercase version of a keyword. Most times I see this, I see them with the same rankings, and even researched this about 5 months ago, when I came to the conclusion that google treats them the same way. However, this day I saw them as different ranks, same keyword, only capitalized 1st letter of the 2 word keyword. I asked moz staff about this, as I felt it was an error. But was met with the answer that google does indeed treat these keywords differently. My line of thought was that the rank checker didn't check both the lowercase and uppercase keyword at the same time, and SERPs happened to change when the second word was checked for rank, returning a different rank. So now, I am in doubt again, as to uppercase and lowercase keywords being different or the same in google's eyes? I honestly don't know why a uppercase keyword would have different motive from searcher than a lowercase when many time not, searchers can't even spell the keyword correctly.
Keyword Research | | Deacyde0 -
Finding Long Tail Searches
Hi Does anyone have any useful tools or ways of looking for long tail phrases apart from Google Keyword Planner? Thank you
Keyword Research | | BeckyKey0 -
Singular and Plural Noun Keywords
Hi everyone Extremely love this community, learning a lot day by day! I am currently in the process of writing a blog post and say for example I am targetting the keyword 'apple' and 'apples'. My current word count of the article is 850 words and I have used 'Apple' 15 times and 'Apples' 26 times. 1 .Is my Keyword density too high and will Google look at this as keyword stuffing? 2. Do I have to target each Singular and Plural keyword individually? Or will targetting 'Apple' will also automatically target 'Apples' for me and vice versa? Thanks in advance!
Keyword Research | | u_rauf922 -
Keyword Research Help
Hi all, My website is www.bruadair.com which is a luxury 7 bedroom villa in Barbados primary suited for large groups and weddings , using googles adword keyword tool i have been trying to establish some long tail keywords that i could include in my website. However i am finding it extremely difficult to find any long tail keywords (such as: Luxury 7 bedroom Villa Barbados ) that are receiving any local or global searches, it seems that there are only extremely competitive keywords receiving traffic. Does anyone have any suggestions as to how i can find effective keywords? With this type of website is it really as likely to be able to rank high due to the pure amount of keyword competition? I would really appreciate any help given as i am really struggling with my keyword research 😞 Thank you very much!!
Keyword Research | | Tmgale0 -
Keyword categories.
Hello everyone, After watching keyword research for motivated marketers (pro webinar), I've put together a master framework. This works like a charm, however, I'm having trouble with a few categories. They are picking up keywords that are not in the marker that are assigned to the category. For example, I have one category with 10 simple markers like red, green, blue, but when I apply the filter, the results include words that are outside these markers like Career One. . Baffled! Anyone help? Thank you in advance. J
Keyword Research | | jasonlewisdiiigy0 -
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 -
Keyword domain names
My two best key words are "gps tracking" and "vehicle tracking". For the Irish market I have got the two domain names: www.vehicletracking.ie www.gpstracking.ie Have a very poor landing page on www.vehicletracking.ie and just redirecting www.gpstracking.ie to our site. I am wondering what I should do thie these two assets? Should I be running them as micro sites? re directing them? Or something else? Let me know what you think. Andrew
Keyword Research | | fleurya0 -
Should I be optimizing for Keywords that we already rank for?
When selecting which Keywords to optimize for, should I choose all words that I want us to move up for? Like that my company appears ranked for 5, 10, 42, 44, etc.? Or should I select a mix of some that rank well (top 1-2 pgs in Google) /rank near pg 5/ and some that aren't showing up in the top 50 yet? I don't want to waste my time optimizing for words I don't need to. Thanks!
Keyword Research | | aircyclemegan0