Sample queries and common mistakes

  Hello friends!

Yegor here from Awario ;)

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 knowledge base we already have a training section about Boolean Search and search operators which you can find here (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

Solution:

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:

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:

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:

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:

If you would like to copy & paste the text, please click on "Show details".

 
Show details

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.

Solution:

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

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:

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:

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


 

 
Show details

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.

*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

And finally, add a group of negative keywords


 

 
Show details