help with method for generating negative keyword list

Hi,

I'm a massage therapist, working part-time alongside looking after my kids. I have a google ads account that I would like to use to encourage prospective clients to contact me via my website. (http://bendaviesmassage.co.uk) I have followed some of the GrowMyAds YouTube videos over the past three weeks. These were very helpful, easy to understand and put into practice. I set up a couple of campaigns and four adgroups. Now I need to create a comprehensive negative keyword list.

I've tried the following method;

Using the keyword planner to generate keyword ideas using all the keywords in my main adgroup as seed terms, 10 at a time.
Download the generated keywords in .csv format
Repeat steps 1-2 for 10 keywords at a time until I have used all the keywords in the adgroup as seed terms.
Copy and paste all the generated keywords to a single spreadsheet.
Removed duplicates.

I tried using the refine dialogue in keyword planner to remove positive keywords, but this removed negative keywords as well. The result was a list of over 4000 negative keywords. I estimate this will take several hours for me to go through and remove positive keywords. Is there a more efficient way to generate negative keywords?

3 comments