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
-
Has the keyword planner search volume metric gone crazy?
I use the search volume found in keyword planner to score and weight my keywords in a similar way as Rand showed us in this WBF. This week I've found that in many cases suddenly the singular and plural version of the keyword have the same search volume. This seems crazy to me as singular and plural is not the same, the intent is different but more importantly they behave very differently from each other when looking at their track record in Adwords (impressions, clicks, conversions, CTR, CVR etc...all different). For example, here's a screenshot of 4 keywords (singular and plural versions of 2 phrases) with search volume captured a couple of months ago. Now here's another screenshot of the same keywords taken from Keyword planner today. Any ideas why this would be happening? Does it makes sense to you? It just seems buggy to me. Thanks!
Keyword Research | | E_F0 -
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 -
Which keyword for title
I'm trying to figure out what to use for my title text. It's for a structural steel fabrication company. Adwords has the average monthly searches for "structural steel" and "steel fabrication" identical at 5,400. It has "structural steel fabrication" at 390 which I get that since its longer and a little more specific will have less searches. My question is if I make the title "structural steel fabrication" does google just see it as 1 big keyword or will it rank for "structural steel" and/or "steel fabrication"? What would any of you go with here? All 3 keyword strings make sense for the person seeing the title. Thanks for any advice you can give, Clay
Keyword Research | | clayknight0 -
Keyword tool suggestions??
Hello, What does everyone use as a good keyword tool for keyword research? I previously used Google's, but would like something better than what its become. Thanks!
Keyword Research | | CHECOM0 -
How do I make sure my homepage ranks better than my 2nd page when I need the same keywords for both? I don't want them competing against each other for keywords.
I seen here on SeoMoz something about more than one page having the same keywords so they don't compete against each other for the same keywords that makes sense to me. But I would like my main page (homepage) to be ranked better over time rather than the 2nd page or do I just not care about the second page ranking at all and don't SEO the page very well? ,Both pages have similar content so I need the keywords for both. So im very confused on what to do with the second page. Thanks in advance to any helpful answers, i am a newbie when it comes to SEO.
Keyword Research | | DreamKandy0 -
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 -
Invisible Long Tail Keywords
I've been doing some research on SEOmoz and have seen some posts relating to invisible long tail keywords. I have a couple of questions relating to this: Am I correct to understand that an invisible long tail keyword won't show any search in a tool like the Google Keyword Tool? If not, how do you define it? If an invisible long tail keyword has almost no search (or search that can be proven by an SEO researcher), how can you be confident that it will produce results?
Keyword Research | | EricVallee341 -
Keyword Difficulty: High or Low?
Looked in the FAQ in the Keyword Difficulty tool but it didn't mention whether or not a higher % or lower % is better. I'm assuming that a higher % means that the keyword is more competitive, is that correct?
Keyword Research | | kylesuss0