1. Vainu Help Center
  2. Sales Prospecting
  3. Get Familiar With Category-Specific Filters

Make AND, OR and NOT searches & keyword search logic

A deep-dive into the logic behind the search function in Vainu 🧙‍♀️

You may have noticed that simply by clicking on the filter you have selected, you can change its colour to red, blue or green. The colours represent different search conditions, OR being the default state.

ORsearches

You can recognise "OR" search from it's blue colour. 

“OR” search is the basic search.  If you look at the filters selected on the picture below, the search would find me companies that either use Giosg OR Zendesk OR Userlike Chat. So the company needs to have any one of the three technologies, but not all of them 😊

Näyttökuva 2019-11-26 kello 9.57.04

“AND” and "ALL" searches

You can recognise "AND" search from it's green colour.

“AND” search is the second most common search option in Vainu. With "AND", any filters you give in your search, they will ALL need to match for the company to show up in your search. 

If you look at the picture below, it would mean that the companies need to have a revenue of over 900 000 euros AND the companies need to have 8 or over 8 employees. If both of them are true for the company then you will see it in your results 👍

7z6ki-9Ro2YJjDpZMHBmbavVprzucVR4DytQV2dASMZv8NeH5auljCJ1NmzBHat4k6Yt0QXCNCzL_6FmRT4XLgubO7yJzoT6lXxogqUNuIlkDp5m692ZaPjEzNxcPVMUHujZjUgh

. The picture below would mean that I want to find companies that have Giosg OR Userlike on their website AND Zendesk. Green colour tells you if the filter is using the AND search option. 

Näyttökuva 2019-11-26 kello 9.58.08

 

“NOT” - the negative search

You can recognise the NOT-search from its red colour.  

By using the NOT-search, you can for example remove companies that are in a static list from your search results, like in the picture below. That means that any company that is on the "DOMAIN IMPORT"-list would not be shown in your search 🔎

a5qNgnLA-KCkJCufgGIz3_xmFju2BoWZwWg45LYdmzfx7cshMBJh1-hNfyJQaD75ERGTsvgsVLVMOL-QG4XxhGHOiMyysNY4E79GSNafz-KP_cuEayIjAcVIligiQM62O4Chmu8p

 

You can also companies without specific website technology. The picture below would make a search that finds companies that DON’T have a website on their company profile.

jo4tqAXbNFAi-ioi7jrmj04Z8WDPJaH7ix5OSJ5BEcuRVnqbJBp699tiL4PDLcuoDqRl87-X0nd44431bAo5t5YQ0OlgmmaSdlQvZpLoecbx2kCwIqTd2CSup-XYWag1f9n-874g

Keyword search and company name search

All the AND, OR, NOT filter options apply to keyword searches also.

 

“OR” Example: Website needs to have either word “tech” OR “computer”

Näyttökuva 2019-11-26 kello 9.28.27

“AND” Example: Website needs to have word “tech” AND “computer”

Näyttökuva 2019-11-26 kello 9.28.36

“NOT” Example: Website needs to have word “tech” BUT NO word “computer”

Näyttökuva 2019-11-26 kello 9.28.51

 

Vainu automatically searches any words that include your search word. Meaning if you type in “tech”, Vainu searches also for words TECHnology, TECHnologies, TECHnological etc.

 

💬 If you have any questions, you can reach out to us through the chat in the bottom right corner or by sending an email to support@vainu.io 😊