Skip to main content
  • EN

Boolean Explained

Taking deep dives into Operators and Channels to help you extract maximum value from your query.

  • 16 Posts
  • 73 Replies
16 Posts
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Basic Brand Query

Hi allJust wanted to share this little query string from ​@Alec Gillies in case you find it useful. Any suggested amendments are welcome to make it even more comprehensive. Please reply with them below and I can update this post. Anyone doing so will unlock the Query Builder badge! The RED TEXT is to be replaced with your Brand name, @handle, Channel ID etc. OR (“BRAND NAME” NEAR/5 RELEVANT BRAND TERM)OR @BRANDOR site:x.com/BRANDOR site:facebook.com/1234567891011 (CHANNEL ID)OR channelId:1234567891011(CHANNEL ID)OR (site:instagram.com AND author:BRAND)OR site:youtube.com/BRANDOR #BRANDHASHTAG OR site:BRAND.COMOR links:aBRANDOR url:BRANDOR title:(“BRAND” OR “ALTERNATE BRAND NAME”)

60
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Influencer ROI

This month I’m trying something a bit different with Boolean Explained. Getting great results still relies on a well-crafted query, of course, which is important here. But we’re going to look a bit more into the story telling, dashboards and widgets, to understand how a company might assess potential investment in influencers / brand ambassadors etc. through 2 use cases. Use Case 1: What contribution has X, Y, Z influencer had on our brand / brand campaign?Use Case 2: Using BW to conduct due diligence on influencers Academy Trainer ​​​​​@Ed Chapman will be hosting a one-off live training specifically on the topic of leveraging Consumer Research to demonstrate the ROI of influencers and how to execute due diligence as discussed below.Sign up here → Thursday May 29th, 3pm GMTUse Case 1:The first thing to do is introduce the context of my example. Presenting, Liam Gallagher “BIBLICAL/CELESTIAL/MAJESTICAL/APPROACHABLE/HUMBLE/SPIRITUAL” rock n’ roll star and frontman of Oasis. Back in Octob

1690
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: 10 Tips for a Comprehensive Query

An often overlooked step in creating a kick-ass query is arguably the most important one, and it’s about getting back to basics. When did you last Google search your own brand?If you are lucky enough to be searching for an unambiguous brand then you can often get away with quite a simple Query string that will not require too much syntax. IKEA is a favourite example of a unique brand term that captures 99% relevant mentions with just one term in the string (the other 1% is for the Scandinavian furniture enthusiasts that use IKEA in profile names, and a song about everyone’s favourite flat pack furniture company, by Jonathan Coulton on his Album Smoking Monkey).… Or maybe you have a more challenging brand name. SEAT, NEXT and MAC (cosmetics).Google the brand, note any similar names that aren't relevant for your exclusion list. Eg with Penfield (the outdoor clothing company) a Google search throws up: Wilder Penfield (a famous researcher), Penfield Marine (an oil tanker company), Penfiel

2862
S
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: TikTok

Simply reply with your question(s) for Forrest and he’ll come back to you before April 17th Hi everyone,Updated: Friday 21st March 2025TikTok in Consumer Research Handling multiple TikTok accounts Setting up Alerts for viral TikTok posts Useful operators for segmentation Location data Links to TikTok Comprehensive TikTok Query How does TikTok content propagate on the wider web? Query level TikTok links Influencer tracking via links Cleverly utilise #*Tok to identify trends. Hashtags TikTok Trend Identification (Reddit) Dashboard level Topic Clouds Top Subreddits  TikTok in Consumer ResearchFirstly, and perhaps most excitingly: TikTok date is available in Brandwatch Consumer Research, as of February 28th 2025.The API is constantly evolving - so expect more updates throughout this year.For now you can expect to receive:Top 1,000 brand mentions (based on number of likes received) from posts made within the past 90 days Top 1,000 comments mentioning the client’s brand, posted in

189129
J
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Identifying Bots & Spam

Hi everyone. A bit of a different one this month, looking at how to Identify Bots and Spam, as well as filtering this data if you would like to. Filtering these mentions out could make it easier to analyse and build a clearer picture of conversation around your organisation, products and competitors etc.Note: The figures proposed in this article are purely suggestions and highly recommend a period of experimentation in order to ensure you are satisfied with what the tags are filtering out.If you’re interested in this topic then will probably benefit from reading this:And while you’re here, if you have any query exclusion strings of your own which you might like to share with the community - I’ve just added a very useful bot related exclusion string! Adding Filters to TagsLet’s get started. Here are some typical attributes which we recognise in Bot and Spam accounts.Filter Why? Proposed Starting Value Low Follower Volume Bot / Spam Accounts typically have low followers 25 (Max)

2792
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Proximity Operators

Are you bringing in irrelevant mentions? Sometimes key terms need some additional context. The NEAR/ operator will help with that. Let’s take a deep dive…What is the NEAR/ operator?By utilising the NEAR/ operator we can find mentions within a certain number of words from each other. How many words? Your choice, just place a number after the operator to choose the distance between the words its working with. This gives the flexibility to target different word types and sentence structures.Using NEAR/ Using NEAR to understand opinions  NEAR with Japanese language (and other similar languages) Using NEAR/ to understand if there is media contained within posts Finding keywords mentioned multiple times Using NEAR/(((Christmas OR Xmas) NEAR/2 (Gift OR Present))Using Multiple NEAR/ OperatorsNEAR/ is great for adding context, but maybe it's not enough. Try using multiple NEAR/’s. By continuing your search string with another set of NEAR criteria you can continue to refine the search and releva

3736
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Reddit

It’s a been a little while since we took a deep dive into a channel. This time, let’s try Reddit! In case you didn’t know, as of July 2024 Brandwatch has a direct “firehose” into Reddit, offering richer metadata and direct Reddit access. Note: Reddit does not provide Location Data to us. When filtering in your dashboard to certain Locations, Reddit data will not appear. Setting Location as Worldwide is the only way to ensure Reddit data is returned in your Query.  Operators, what you need to know: Operator  Example  Description  subreddit  subreddit: cars AND tesla  Returns all posts and replies belonging to the named subreddits  subredditTopics  AND / OR subredditTitle  subredditTopics: cars   Returns all posts and replies belonging to any subreddit whose title has the keyword “cars” within it. You can use extra boolean here to get more specific.  weblogTitle  weblogTitle:AlexTheGreat  Returns a

3450
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Review Data

Hello Community!We’re taking a look at Review data and some tips and tricks you can use to get the most out of your query. This article will help you find Reviews of your products, services or organisation – on indeed all of the above for competitors and there is a lot to cover so please bear with me. As always, any questions please fire away in the comments and someone from Brandwatch or the Community will hopefully come back to you. We collect Mentions from a range of Review sites including Google Play, Apple App Store, OpenTable, Flipkart, Steam Community, Best Buy, Glassdoor, Review Centre, Reviews.io, eBay, CNET, Amazon, TrustPilot and more, using our third-party data providers. We can also add coverage for particular product reviews upon request. To do this, please contact support@brandwatch.com Full list of included sources:AgodaAvvoExpedia  (Only hotel reviews)Facebook (Only publicly available)GoogleGoogle PlaystoreGoogle ShoppingZomatoAirbnb AliExpress  (.com, .us, .ca. co.uk)

2913
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Query Exclusions

Let’s talk query exclusions and how to filter out data you don’t want. Firstly, we have a dedicated topic for sharing query strings. Have a search in here and please add your own to help the Community. On to the tips and tricks;  Filtering images using Object IDs Explicit content often comes in the form of images on X (Twitter), and cannot always be filtered by Boolean or AI because the text is similar to relevant data you might want to track. As such, we need a solution leveraging metadata instead. To do this we use Object IDs, take a look at this exclusion example for pornographic content: (objects: (3093 <<<active undergarment>>>OR 3388 <<<art model>>>OR 4081 <<<barechestedness>>>OR 4097 <<<banana family>>>OR 3873 <<<bed>>>OR 3930 <<<bedroom>>>OR 4160 <<<bedtime>>>OR 3411 <<<bikini>>>OR 3316 <<<bodybuilding>>>OR 3283 <&l

1701
W
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: 6 Tips to use Brackets more effectively!

Hello Community!It’s been a while since we’ve taken a look under the hood at query writing. Well, we’re back with a look at Brackets/Parentheses in our Boolean Explained Series.  Case Sensitive Data The raw operator has been retired in favour of pointed brackets { }. To return case sensitive results, just place the phrase you’re looking for inside the brackets.  Not case-sensitive: British Telecom OR BT Will likely find mentions of both “British Telecom” and “BT:, but might also include misspellings of the word “but” or the acronym for “Bad Trip”, because we haven’t specified that BT must be case-sensitive (which is how references to the brand BT are typically written).Case-sensitive:  British Telecom OR {BT} This query specifies that BT should only be included if it is written in the same case-sensitive format as the word inside the pointed brackets.  Note: Will only retrieve Mentions where upper case letters are used in the exact way specified inside the brackets. Upper case matching

3050
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Using ChatGPT for query writing

Hi all! The continuing rise in popularity of Generative AI tools like ChatGPT provides an opportunity to augment human creativity and paves the way for optimising strategic planning and decision making. With that in mind, we had to do a deep dive into it...All of the below is connected with using tools outside Brandwatch to help you write killer queries. However, we have AI tools of our own too, which you might already be using. If you are and could do with a refresh or if you’d like to learn how to use them, then head to the bottom of this post for details of an exclusive webinar hosted by @Ed Chapman from our Academy team. Using ChatGPT to help write queriesAsking for help to identify a boolean error  List out different variations of a topicThis is particularly useful when creating categories, e.g different flavours and garnishes of daiquiri to help create categories for a pie chart answering the Q on which flavour/garnish is most spoken about. Quickly understand a topic with concise

6730
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Youtube

Hi allAnother channel special this month, following our popular Tiktok one last month. As always, if you have any tips yourself to share - please do so! And if you’ve found this post useful, show it some love 👍🏼 Note: YouTube Shorts Data is not pulled via our crawlers.Find out more about Youtube mentions and metadata in this Help Center article Find YouTube channels that post about your brandWe’ve got a whole topic dedicated to this one thanks to @Jennifer Wilder If you are interested in tracking comments for a particular video or wish to track all videos and comments posted by a particular YouTube channel, please contact our Support team with the channel IDs. The team will check if we already cover the channel or video in question and if we do not, we will add it to our coverage.Note: We cannot guarantee historical data coverage when indexing new channelsNote: You should also add these channels or videos into your query Search the whole of Youtubesite:youtube.com AND “John Mayer”Not

2890
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Location Data

Let’s take a deep dive in to the location specific operators. If you have anything to add, please let a comment below to share it with the community! When we have location data, either geotagged or inferred, we classify mentions by location.Location data is not available across all content sources, often based on platforms/pages terms & conditions. We do not infer location for the following sites, among others:Instagram & Facebook Reddit YouTube QQ  Data CollectionIf your query needs to be restricted to one location use the country operator within your Boolean instead of using the location filter. And make sure to include FB & IG with the site operator.(( “Taylor Swift” OR TaylorSwift OR @taylorswift OR @taylorswift13 )AND (country:”GBR” OR site:(facebook.com OR instagram.com))) Additionally, you can use context keywords to target a specific location.(( “Taylor Swift” OR TaylorSwift)NEAR/20 (“united kingdom” OR unitedkingdom OR UK OR british OR britain OR england OR scotlan

6195
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Wildcard* + Question Mark ?

Hello all! Thought we could take a deep dive into one of our Operators, in this case…. The * Wildcard OperatorThe purpose of the Wildcard operator is to find mentions that include the root of a word. It’s really useful for finding lots of variations on a word, without having to include them all in your query.For example, I could write a query that looks like this:Kiss OR Kisses OR Kissing OR Kissed OR KisserBut using the Wildcard operator, I can shorten that query down to:Kiss*The use of the * here instructs Brandwatch to find any word that contains the root Kiss.  Placement is everything with the Wildcard!Where you place the Wildcard operator in a word has a big impact on the output. For example, if I were to move the * towards the beginning of the word Kiss like this:Ki*Then this instruction tells Brandwatch to find any word that starts with “Ki”. Kids, Kin, Kim, Kissing, Kilogram, Kindling and many more would be captured by this query.Similarly, I can restrict the number of words fo

39611
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: Site Vs URL Vs Links

Let’s take a deep dive in to the Site, URL and Link operators. If you have anything to add, please let a comment below to share it with the community! site: site:bbc.comOnly brings in mentions from specific sitesThis command can be helpful when looking for a particular piece of content on a given website.  site:bbc.Matches all documents from a site and its affiliated subdomain sites eg https://www.bbc.com/, https://www.bbc.co.uk, etc.  site:bbc.com/search-glossaryIf a site has a search glossary, you can add /search-glossary to narrow your search even more. The same goes for blogs and other website-specific features.  URL: URL:bbc.comURL captures any part of the url so if you do url:bbc you will get bbc.com but also bbc.com/reddit-announces-xxx-yyy. URL:(bbc.com AND (politics OR election))Use the above for when you want to look more broadly at mentions.  links: links:"bbc.com”Gives you shortened links from Twitter that direct you to the site eg. ‘omg check this out t.co/abcdef’ and that

9036
Ian Ferguson
Ian Ferguson
Ian FergusonCommunity Manager
posted in Boolean Explained
Boolean Explained: engagingWith:

Let’s take a dive into the engagingWith: operator… Firstly, let’s get some context: author: captures posts by a person engagingWith: captures replies and shares of posts by a personYou can use engagingWith:rihanna to measure engagement as people respond to (or retweet) a post from the account, even if they don’t mention the word rihanna in the post. Mentions will be indexed when people have replied or Retweeted a post from the specified account. For Twitter, engagingWith: only looks at the immediate parent, so it will not pull all replies where there is a large tree of replies and sub-replies. For Reddit we have engagingWithUrl: which is always the root post of the comment chain, e.g. all comments and nested comments within comments will be found with the engagingWithUrl: operator querying the url of the original post.engagementType: is a refinement which you can add on, for example if you only wanted comments and quotes, not retweets, you could do engagingWith:rihanna NOT engagementTy

7718
Ian Ferguson
Community GuidelinesCookie settings