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
-
When I use the Google search console to discover keyword phrases being used to drive visitors to my site I see some keywords that have the city name repeated (ex: web design sarasota sarasota, fl). Why?
When I use the Google search console to discover keyword phrases being used to drive visitors to my site I see some keywords that have the city name repeated (ex: web design sarasota sarasota, fl). Why does this happen?
Keyword Research | | Noblemoz1 -
Keywords moving up, except...
The keywords on my page are moving up, except for one. I have routinely ranked between 13-15 for one particular keyword. I am aware that it is a broad term, however, at one point, I showed up on page one at #6, and then dropped right back down to where I was. The website it "sexaddict.com" and, don't worry, it's for addicts so you won't find anything but help and resources there. The keyword is "sex addiction." Thanks, Ryan
Keyword Research | | drdougweiss0 -
On-page optimization for closely related keywords or acronyms of keywords
We are in the process of on-page optimization for a site that sells one kind of software. We are trying to optimize each page for a target keyword and variations of the keyword, however we have more pages than keyword variation types, so I'm looking for feedback on whether the below plan would be keyword cannibalization. Examples: URL: www.domain.com/product
Keyword Research | | seo_1234b
Tarket Keyword: device imaging software
Title Tag: Device Imaging Software | Company Name URL: www.domain.com/solutions
Target Keyword: device imaging solutions
Title Tag: Device Imaging Solutions | Company Name URL: www.domain.com/products/product-name
Target Keyword: dis (acronym)
Title Tag: DIS Software | Product Name | Company Name My question is are these keyword too closely related for each of the pages? Will they be considered duplicate title tags? Keyword cannibalization? etc. Thanks!0 -
Brand Name Keyword Stuffing
I'm targeting Roho Cushions and the category page has many products starting with Roho underneath it. I know the keyword "Roho" shows up at least 70 times. I'm not targeting the keyword Roho, but could this negatively effect the rest of my keywords that start with Roho, such as "Roho Wheelchair Cushions"?
Keyword Research | | Mike.Bean0 -
Keyword research
i am trying to figure out what would be good keywords to optimize for an orthodontist. i looked up the keywords "his city + orthodontist" or " his city + braces" and the google adword tool tells me there are no monthly searches for those terms. i am not sure what i can optimize for if no one is searching for the most obvious keywords.
Keyword Research | | dad7more0 -
Am I Doomed with Low Volume Keywords?
I've been pursuing an internet startup for over a year now. We've figured a lot of things out along the way and even managed to start making some modest revenue ~$3,000/month. We're just now starting to dig into SEO and I'm realizing that most of our keywords aren't very high volume. The best have 1,000 local searches per month (exact match) with most being a couple hundred local searches. I'm worried that I've picked a market that's too small, but I don't have the SEO experience to know if this is normal or not. Most of my keywords are rated 'highly competitive' and also are stacked with CPC ads upon Google search. I'd love to know what others' experience with keyword volume is and if I'm just overreacting on limited knowledge. Thanks!
Keyword Research | | TBiz0 -
Keywords for multi service business?
New to this so bear with, I am a TV aerial, satellite, CCTV, Door entry, Access Control, Telephone repair engineer. I have one seperate page for each of the installations I carry out as well as the basic home, about, areas, faqs and so on. My question is do i have one key phrase for each of the services i cover or do i just relate all the keywords from that service into the keywords tag ie, META name=keywords content="Digial aerials Stockport,digital aerials Manchester,aerials Stockport,aerials Manchester,aerial repairs Stockport,aerial repairs Manchester,digital,aerial,tv,tv aerials Manchester,tv aerials Stockport,arials,arial,aerial installer,aerial installations,aeril installation,Stockport,Manchester ,"> That is what i have fro Tv aerial installation, Should i make landing pages for each phrase for each service or stick to one page? www.redvalecommunications.co.uk is the site if you want to take a look thanks in advance
Keyword Research | | redvalecomms0