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
-
What place does plural versions of keywords have in keyword research?
Working on doing a massive keyword research project for my sites, one of the things I am trying to figure out is if I should be including plural versions of keywords. For example, should you include yoga mat as well as yoga mats?
Keyword Research | | ShockoeCommerce0 -
Keyword Organising
Does anyone know of any tools to aid organising keywords? I'm currently using Excel extensively in an effort to bring some organisation, however it is very labour intensive.
Keyword Research | | seoman100 -
Domestic keyword searches
Hello I've spent some much information about how to get the best keywords for my SEO niche page. However, since the recent google changes, different opinions I fond it hard to use something accurate. Also the fact hat may keywords has so many variables, it makes it even tougher and more complex for a new beginner like me. Could anyone please guide me in the right way please? Lets say I would like rankings for Electronic Cigarettes in Norway. It can be written in so many different way, ecig. e-cig. elcig, e cigarette etc etc. (norwegian version ofc) I have for the most part used google keyword planner, but I am really unsure of what boxes to tick and not. I have deleted my wordpress installation and starting from scratch. But I want to make sure I get it 100% right this time before I start.
Keyword Research | | Kroeriks0 -
How many keywords is too many?
Hi there Moz'ers, I run a mens fashion brand called THE AFFAIR, where we craft premium T-shirts and Art Prints inspired by your favourite books. So my problem is that I have no idea what to try to rank for keyword wise because every product is inspired by a different book and author. Whilst I could go very wide and try for terms such as "graphic t-shirts" or "printed t-shirts" they are a) super competitive and b) bear no relation to the primary selling point being the literature inspired basis of what we do. But on the flip side, there's just not that many people searching for "Jules Verne t-shirts" or even "Adventure t-shirts" to go a little wider at the genre level. Basically I'm confused at a conceptual level about how to best select my keywords and desperately need some help before running down the wrong path! For what it's worth the site is built on WP (using WooCommerce) and I have installed Yoast and begin playing around with it... But anyway it's the larger strategy that has me stumped at the moment and I really don't know where to begin. Thanks for your time and all comments very much appreciated. FREE T-SHIRT to whoever has the best solution 🙂 cheers
Keyword Research | | theaffair
Zoltan0 -
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 -
Confirm my thoughts for this keyword
I'm working with a local kitchen remodeler. In reviewing the organic keyword searches for the last month I notice the word "kitchens" appearing in the top 10 keyword searches. Since I know we aren't ranking for the term "kitchens" I dug deeper. A handful of the searches are from the local area but most are one occurence of searches from cities across the US and the world. My surmise is that because there are 2.2 million searches for kitchens every month we just happen to be scraping enough of these searches, irrelevant as they are to our client, to make it look like an important keyword. Most of the visitors using this keyword are gone in seconds. Just wanted some folks to confirm what I'm thinking - that "kitchens" showing up in our top 10 keywords list is a bit of a red herring - and we should focus on more localized keyword searches.
Keyword Research | | DenverKelly0 -
Tools that show me what keywords my competitors are using
What tools can you teel me like keywordspy or SemRush that shows me what keywords my competitors are using to get traffic?
Keyword Research | | Montse0 -
How to choose Keywords
Am starting a company and in the process of developing the website. I would like to get a head start on content and want to know the best way to choose keywords and tips on how to write optimized content.
Keyword Research | | jclubb0