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
-
Focus Keyword
Hi everyone! I am pretty new to SEO so all the help would be great. Does every webpage on our website need a focus keyword for example like the about us page. We have webpages for every location in the UK - Would it be helpful if the location webpages had a focus keyword also? Just to note that I am using Yoast on Wordpress. Many thanks,
Keyword Research | | SMCCoachHire
Aqib0 -
National keyword results v local keyword results
If the keyword contains the location term like "SEO company London" is it better to use the wider results over local? Additionally, some best practice examples of national v local result tracking would be great 🙂 Darren
Keyword Research | | SEODarren0 -
Best Tools for Keyword Research?
Hi guys, Please share your best and recommended tools for keyword research. Thanks in advance.
Keyword Research | | KLLC0 -
Google search not grouping keywords properly
When is a 'Repair' not a 'Repair'...? When it's a "Service" (... cue rapturous applause and laughter!) We run an air conditioning website and we have recently noticed that Google is assuming the keyword "Repair" also means "Service". For example if you type in (in the UK) "Air Conditioner Repair" the first page of Google it puts the word "Service" in bold. E.g: 1. Check this before calling for air conditioner service - YouTube 2. Halfords Autocentres| Air Conditioning Service for all car makes and 3. Service Your Air Conditioner for Summer Comfort « Sustainable Now... why do I find this annoying. I had a amicable dispute with a colleague last year before all of this happened. I noticed that our Google Adwords campaign was showing a high bounce rate for our /air_conditioning_service page. He explained to me that if someone wanted and 'air conditioning service' it was because they wanted their air conditioning fixed / cleaned etc. My argument was that a fair few of the people bouncing off were actually looking for a company to provide a service (of air conditioning) that they were looking for. We split the page in half (half linking through to a repair page and the other half to a page about the service that we offer) and ran a test against the original. I was only expecting a small percentage of people to click on the new option we had added to the page, however, the difference was far greater than ever expected. It was a 60/40% split in favour of the new option not people wanting their aircon repaired/serviced! So in conclusion... very annoyingly, Google is recognising my service page rather than my far more relevant repair page, and there seems to be nothing I can do about it (other than make my service page more relevant) Rant over... but has anyone else experienced anything similar? Is there anything you can do about it?
Keyword Research | | trickshotric0 -
Best way to find Long Tail Keywords?
Hello, I'm looking for some help trying to discover some long tail keywords i can use. Is there a site or a program out there that lets you type in a keyword and then shows you the long tail versions that are actually searched? (anything other than google keyword tool). Thanks,
Keyword Research | | Prime850 -
Spammy Industry Keyword Research
Hi everyone, First question posted on here. I have spent a lot time this week going through videos and discussions since I signed up here earlier this week. We're just starting in a particular niche that is powerful (home-based businesses), but EXTREMELY spammy with all the at-home opportunities from stuffing envelopes, to MLM, etc. Then there's the other side which is not as spammy, but just not an overall good business model with the in-home Tupperware, candle, and makeup party sales companies. The people that we help and serve are just people who want to start up a part-time or full-time home-based business doing what they love. Maybe it's a dad who loves golf and would like to start a golf store on Ebay or a lady who is great at making stuff and wants to open an Etsy shop or start selling her goods at craft fairs. Our program is more about teaching them how to start a real home-based business that can either earn them a profit either part-time or fulltime while also doing what they love and spending time with their family. My biggest question right now as we begin the Keyword Research and SEO process part of this, is how do we go about doing the keyword research for this while also dealing with a spammy niche? All the research I've been doing for home-based businesses comes back to all the ugly examples I gave above and that isn't the type of people that we're a good fit for. I appreciate all your help and guidance in advance. Been doing web development for 10+ years but finally taking the tiger by the throat and actually learning the SEO/SEM piece myself.
Keyword Research | | buzzmediallc0 -
How to find easy keywords to rank for?
We've got fantastic results from a keyword here. After we signed up for SeoMoz, we found that, for luck, this was a very easy keyword (1%) to rank for. How can I find more easy keywords?
Keyword Research | | BrunoReis0 -
Keyword and Keyphrases
I'm looking to optimise my website for some keywords and keyphrases I'm getting a bit confused on how different pages might compete (or help) each other. As we are an automotive dealer I was thinking about building the hompage around 4 keywords (one for each franchise we represent e.g 'Ford'). These show high local monthly searches and medium competition for just the manufacturer name on its own. Then if someone drills down into a franchise homepage (linked from our homepage e.g. www.ourwebsite.com/ford) I was thinking to optimise the page around e.g. 'Ford Dealer' (which has medium local monthly searches and high competition). Then if someone drills down into a particular model I optimise around that and so on. Question is will I be playing the franchise homepage vs the group homepage (Ford vs Ford Dealer) as I have read here on Keyword Cannibalization? Or will it work together? Alternative I guess is not to focus around a franchise on the group homepage and then only focus on the franchise from the franchise homepage onwards but I feel I would be missing a trick? As a new kid on the block help will be most appreciated.
Keyword Research | | design_man0