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
-
Finding less competitive keywords
Hello, How Moz can help me in finding less competitive keywords for a site based on omega masticating juicer. I had tried other tools but i am not satisfied with it. Kindly tell me the process to find it. Thanks.
Keyword Research | | romanjames0 -
Keyword inside keyword
Hi, I'm a newb and I'm trying to wrap my head around how this keyword thing works. Let's say I find these KWs as part of my research: Acupuncture Acupuncture Clinics Acupuncture Clinics in Gainesville Acupuncture Clinics in Gainesville Florida Does optimizing for Acupuncture Clinics in Gainesville Florida optimize me for all the other terms as well? And furthermore, might I appear for searches like these too: Acupuncture Florida Acupuncture Gainesviile Acupuncture clinics Fl Thanks a bunch!
Keyword Research | | Graphbyte0 -
Best way to find the best keywords to write Q&A
Hi All, Best way to find the best keywords to write Q&A I have a celebrity website where people ask questions about Movies and celebrities. Now how can i create some content based on keywords so i can get some better traffic? Or is this method a waste of time?
Keyword Research | | jomin740 -
Way of including Keyword into content
Hi all! My website is that of a large 7 bedroom luxury villa in Barbados (www.bruadair.com). Now, I am having problems understanding how i can include my targeted keywords in to my content without it looking unnatural and disrupting the quality of the content. I wish to use the keyword phrase 'Large luxury villa in Barbados' however including this directly into on-page elements seems to look unnatural. My current content on my home page is as follows 'Bruadair is a large luxurious villa situated on the prestigious Platinum West Coast of Barbados, located in a beautiful tropical setting with gorgeous beaches just minutes walk away' I want to rank for this keyword however changing to 'Bruadair is a large luxurious villa in Barbados, located in a beautiful tropical setting with gorgeous beaches just minutes walk away' degrades the quality of the content... is there anyway i can get round this issue? I greatly appreciate any help/advice given to my problem! Thanks once again, T
Keyword Research | | Tmgale0 -
Do "search keywords" matter?
I've been getting conflicting accounts about this. We aways fill out the Title Tag, Meta Description and Product Tags(<- for internal purposes) but we are concerned about how important the "search keywords" are. We use bigcommerce and they describe their value as this: "the search keywords are optional, but if entered will be used for two things. First, they will be used along with the product name to create meta tags for search engine (I know meta keywords are not important, so is this what they mean?). Second, they will be used to assist people when searching your products. (Also internal, right?)." For all intents and purposes I think it is NOT super important but I wanted to make sure before I let them take a back burner. Thank you for your help in advance!
Keyword Research | | WNL0 -
What is the ideal keyword difficulty percentage?
I am trying to establish my best keywords using the keyword difficulty tool. So if I want to come up with the best keywords, should I use the ones that come in at 50%??
Keyword Research | | mmookie0 -
Ranking Reports for New Keywords
I added new keywords to my campaign. They do appear in my ranking report. But I am not getting any ranking data on the new keywords. It looks like they are yet to be crawled. For my initial set of keywords, i see the specific rankings in each search engine and for some it says "not in the top 50." For the new ones all I see are zeros. Will the ranking data eventually appear?
Keyword Research | | dseevers0 -
Stop List and Keywords
I've came across a suggested list of words that google will ignore in your content, if this is correct and one of our main keywords is one of those words, will it lose effectiveness? We are trying to get #1 SERP for "Self Tan" and it seems "Self" is one of the words ignored - so should we just be focusing on Tan? Any tips / advice would be great!
Keyword Research | | ChrisMciIlroy0