Welcome to the Q&A Forum

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.

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!

Hi Nitin,

We found that using Fruition (actually a penalty checker) was pretty useful as well. It overlays all Google updates and SERP changes on your Analytics data. And of course: use annotations in Analytics.

If you figure out a great way to do this, please let me know!

Kind regards,

Linda Hogenes

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!