Sample queries and common mistakes

In this article I would like to discuss the trickiest function in Awario, nevertheless the most effective — Boolean Search. It is a manual type of search that allows users to combine keywords with Boolean operators to create more specific search queries and get more relevant results.

In our knowledgebase we already have a training on Boolean Search operators (impt. I would highly recommend to look through it before proceeding).

I have prepared for your some case studies with step-by-step instructions, so let’s start with the first one.

Example 1:  Find conversations about a topic that DON'T mention your brand (great for sales opportunities)

This example contains the basics to demonstrate how to configure a search query in Boolean Search, which operators to use and the way to filter out mentions with the help of negative keywords.

Keywords: sneakers, jogging shoes, running shoes, training shoes
Negative keyword : Adidas
Sources: Facebook, Twitter


1. “Sneakers” - a simple one-word keyword, which we add as it is:


2. "jogging shoes", "running shoes", "training shoes"- keywords which consist of two (or more) keywords, so we should use them with the + and " " operators (" " are used to search for a specific word combination. But this operator allows digits and punctuation marks between words within a keyword. And if we add +, Awario won’t allow any characters between words and search for 100% exact match). As we're looking for either of these keywords, we also need to put OR between them:

sneakers OR +"jogging shoes" OR +"running shoes" OR +"training shoes"

3. Ok, now we should add our negative keyword to exclude documents that also contain "Adidas". For this purpose I will use the AND NOT operator:

sneakers OR +"jogging shoes" OR +"running shoes" OR +"training shoes" AND NOT Adidas

In addition, I would also put all our keywords in brackets to group them together, so that AND NOT can be applied to all the terms in the brackets:

(sneakers OR +"jogging shoes" OR +"running shoes" OR +"training shoes") AND NOT Adidas

4. We are on the final lap and only left to specify the sources. Here we will use the FROM operator and just specify the sources:

(sneakers OR +"jogging shoes" OR +"running shoes" OR +"training shoes") AND NOT Adidas FROM twitter,facebook

That’s been quite easy, hasn’t it? Let’s move forward and raise the bar.

Example 2: Get mentions from different sources for separate keyword groups

Now I will modify this query and try to get mentions for “sneakers’ from Twitter and for “jogging shoes, running shoes, training shoes” from Facebook.

Keyword: sneakers
Negative keyword: Adidas
Source: Twitter

Keywords: jogging shoes, running shoes, training shoes
Negative keywords: Adidas
Source: Facebook

If you’ve noticed, I made a tip in our conditions and divided keywords into groups with their own parameters.


1. I start from creating a query for the first group absolutely the same way as described in the previous example:

sneakers AND NOT Adidas FROM twitter

2. The first group is ready and I add the UNION operator which is used to include group of different keywords that should come from two different sources in one search:

sneakers AND NOT Adidas FROM twitter UNION

3. Now let’s add a group of keywords which should be found in Facebook, dividing them with the OR operator, as either of them can be applied:

sneakers AND NOT Adidas FROM twitter UNION (+"jogging shoes" OR +"running shoes" OR +"training shoes")

4. After that we complete the query by adding the negative keyword and the source for the second group:

sneakers AND NOT Adidas FROM twitter UNION (+"jogging shoes" OR +"running shoes" OR +"training shoes") AND NOT Adidas FROM facebook

Example 3: Add several negative keywords for a group of keywords

The third example describes a specific case which I face daily:
Users have several keywords and several negative keywords but want the tool to use combinations either of keywords with either of negative keywords.

Keywords: CAT, cat equipment, cat shoes
Negative keywords: animal, pur, fur, kitty

And it is pretty simple, so you should just specify a group of keywords.

(++"CAT" OR +"cat equipment" OR +"cat shoes")

*Pay attention to the keyword “CAT”. As you can see all the letters in this keyword are upper-case. And for the case-sensitive exact data search, we should use the ++" " operator.

Next, we should add AND NOT

(++"CAT" OR +"cat equipment" OR +"cat shoes") AND NOT

And finally, add a group of negative keywords

(++"CAT" OR +"cat equipment" OR +"cat shoes") AND NOT (animal OR pur OR fur OR kitty)