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
-
Paid vs Organic Keyword Optimisation
Hi Im wondering whether I should optimise my site with Organic search terms that drive traffic to the site or the paid terms i use in Google search ads?
Keyword Research | | aplnzmarch180 -
Coworker and I see totally different keyword volumes on same paid keyword planner account
My coworker and I are both connected to the same company's paid keyword planner account but are using our own individual google accounts to log in. When I look up the keyword "joint bank account" I get a search volume of 9,900, while she gets a search volume of 2,900. Does anyone know why this might be? Do we know which might be more accurate? This doesn't seem to be connected to Google lumping semantic variations together. I've seen it happen way before that update. It's hindering our headline pitching since the volume she sees does not meet our minimum search threshold. Any insight would be greatly appreciated! Thanks, Laira
Keyword Research | | CTI1 -
How to finalize the keywords for SEO?
Hi, I use the following method for keyword research: Create a long raw list of keywords. Use Google AdWords Keyword tool to find monthly searches. Find raw competition. Find direct competition (via allinanchor: search operator) Calculate KEI (Keyword Effectiveness Index) Calculate KOI (Keyword Opportunity Index) Is there any other (better) way to execute the keyword research? Or is finalizing/selecting the keywords only on the basis of monthly searches sufficient? In short, how to select the best keywords from a long list? Thanks & Regards
Keyword Research | | IM_Learner0 -
Keywords for fabrication (welding) company??
I've been tasked with finding the keywords for our website. The difficulty I'm finding is receiving help from the fabrication personal to suggest keywords. I'm not sure if its peoples imagination or if there's a general unwillingness. Can anyone make any suggestions here? Is there a fabrication or welding keyword database I can put to them and hopefully get their brains working? Or even a way to see what keywords our competitors use?
Keyword Research | | Resolver1010 -
Local search data
Is there a good reliable tool for getting search volume for local keywords. The adwords keyword tool is nice but I am wanting to know which cities get which portion of the local traffic they present.
Keyword Research | | webfeatseo0 -
How to find keywords getting significant traffic
How can we check with the Google Keyword Tool to figure out which keywords are getting significant traffic. Needs explanation for the bolded part. I am referring to the Q and A at - http://www.seomoz.org/q/is-there-a-report-in-seomoz-that-will-show-me-what-keywords-each-page-ranks-for-on-my-site The best way to see the information you're looking for is to take all keywords that sent you an organic search visit for a given time period in your analytics and run them through a rank checker. You can then cross-check this data with the Google Keyword Tool to figure out which keywords are getting significant traffic.
Keyword Research | | seoug_20050 -
Keyword Optimization for 2 Brands
We carry two brands, Buick & GMC. All of the most trafficked keywords that I'm finding in my research are structured like this: buick denver buick service gmc denver gmc service How should I approach this situation so that I'm optimizing for both brands?
Keyword Research | | kylesuss0