My list of negative words for SEO and Yandex.Direct

When working with the semantic core for commercial projects, the question often arises of how to massively filter information keywords that are not suitable for a given SL. If services such as OverLead can be used to automatically clean up search queries, it is difficult to do without human intervention to check new semantics.

In this article, I'll share how I approach this process, and at the end I'll provide a link to my search blacklists and share best practices for using them.

Cleaning the semantic core:

- Minus words

- Parameters (completeness, frequency, geo, etc.)

I will not disclose my criteria by parameters, but I am ready to share lists of negative keywords, since these phrases are available to everyone and are, in fact, a collective product.

Global blacklist of phrases

This list mainly contains information requests that are generally not relevant for typical commercial projects. Before using this list, it is important to study it carefully, as thoughtless use can be harmful. For example, the list contains queries such as “install”, which may be useful in the context of software, but for a business related to the installation of plastic windows, such phrases would be inappropriate.

List of cities in the Russian Federation with a population of over 100 thousand people:

This list was compiled according to data from Wikipedia (at the time of its creation - cities with a population of more than 100 thousand). When collecting semantics for business, for example, in Yaroslavl, queries often contain keywords mentioning large cities, such as Moscow. In order not to add such keys to the emergency situation, I use this list and exclude unnecessary cities.

Cities of Ukraine and Belarus with a population of more than 100 thousand people:

The principle of working with this list is similar to the previous one. If you are collecting semantics for Ukraine or Belarus, be sure to exclude those cities that do not suit you.

Female (1072 pcs.) and male (2196 pcs.) names:

Lists of female and male names are useful if people's names appear frequently in queries, especially in cases where the brand has a name. This may be relevant, for example, when working in the service industry for photographers.

Where to download?

All of the above and other lists of negative keywords can be downloaded through my Yandex.Disk, the link to which is provided below.

Lifehack for working with a blacklist

UPD1:

In Yandex.Direct, you can add no more than 2048 characters to negative keywords. However, my lists are only 3 - 5682 characters long, which is over the limit. To solve this problem, I use the following method: I put the entire list into the collector, select my region and parse the frequency according to the base frequency. Thus, you can cut off unimportant requests and reduce the list to the desired limit.

UPD2:

To create a list of negative keywords for a specific advertising campaign, you can use the following technique:

  • We take the left column from Wordstat for the target request (the most convenient way is through the key collector).
  • Copy it into notepad.
  • We delete the key query and its derivatives, as well as pluses.
  • We carefully examine the remaining tails.
  • We remove the conversion keys, and the remaining list can be safely used in the negative keywords of the advertising campaign.

If you have questions about SEO promotion, you can contact the SEO COMPUTER studio with any questions by email: info@seo.computer.

ID 7205

Send a request and we will provide a consultation on SEO promotion of your website