What to do if you forgot to collect negative keywords?

Question

Google

Good afternoon!
Please do not ridicule - just learning (first experience).
In general, I did 2 collections of keywords through key-collector.
1st collection - collection from statistics services (wordstat, metrics, hands, spay, etc.)
2nd collection - by compiling a mind map and multiplying the received one with the other and running through KC on the frequency
The whole thing was filtered and weeded out and, by its stupidity, everything what filtered - deleted, and not entered into a separate group, and even more so into stop words.
At the output, I now have a good list of keywords, but no negative keywords. How to be? How to assemble?
The most convenient way comes to mind is to drive keywords and drive them as in the 1st collection - through all services. Thus, it is possible to get more keys + collect negative keywords. You will have to work with the handles, but nothing .... In general, the question is - am I right in my reasoning? Will I be able to cover most negative keywords this way?

Answer 1

Good afternoon! For you, the answer is most likely not relevant) But maybe it will help someone else.
Yes, the easiest way is to use the KeyCollector. Run a scraping on the high-frequency queries you have and manually review the scraping results. This way you will find negative keywords that will eliminate 95 percent of non-targeted queries. For those who do not have KeyCollector, you can use the free analogue of this program or collect negative keywords using Wordstat. To do this, enter wide-frequency queries and add non-target words with a minus sign after the keyword in the search bar of the wordstat. So you eliminate the repetition of already found words and cover more queries (screen in attachment).
Next, create an advertising campaign, set a minimum limit of 300 rubles and run it, and check the "Search queries" tab in the "Report Wizard" once a day. This way you will collect those negative words that you might have missed earlier due to their very low frequency. As soon as you see that there is practically no garbage in search queries, increase the limit to the one you need and carry out such a cleaning procedure once every 2 to 4 weeks. New queries appear in the search and you will find at least 5 - 10 additional negative words per month.
I can offer my services as a directologist, email me [email protected] with the address of your website, and I'll see what budget you can set up advertising within.