The Social Media Monitoring Cheat Sheet

This blog post has it all: bargains, anger, jealousy, love, swearing and even some sexual language. Unfortunately for those of you who found your way here through the Googling of foul words, this post is tailored to both Boolean lovers and Brandwatch users, and is devoid of any explicit scenes. Sorry.

One way in which Brandwatch is head and shoulders above other social media monitoring tools is that it allows users to carefully customise their queries using Boolean operators, affording almost unlimited control over what can be searched for.

However, with great power comes great responsibility. And great patience.

It can mean typing out long passages of key terms to make sure the right words are being included or excluded. If you’re looking to isolate customer-service related tweets from other data you may have collected, it can require a bit of thought as to how best to separate them.

Our crack team of in-house analysts have put together some commonly-used strings of words that can be copied to find certain criteria, such as the aforementioned customer service. This can be great for categorising and segmenting your data.

As well as positive and negative lists, we’ve included a generic emotive one too, which lets you separate all social media mentions of your brand (or product, competitor et cetera) in which someone has an opinion, from less emotive reporting and neutral statements. It means you can see comments like ‘I love my new Sony Bravia screen’ and ignore things like ‘just moving my Sony Bravia into my bedroom’.

The copypasta is freshly prepared in Brandwatch syntax, so it’s all ready to be served into your existing queries.

To read a quick guide on how to build queries and get to grips with how Booleans work in Brandwatch, you can cast your eyes over this beauty.

In the meantime, here’s your cheat-sheet for helping you build your queries and searches.

[Note: you’ll need to replace :: with your search terms or original query string]

Voucher/Coupons

(coupon* OR voucher* OR code* OR discount OR deal OR deals OR offer OR offers OR (promo* NEAR/10 (sale OR buy)) OR sale OR (raw:(save OR Save OR SAVE OR off OR Off OR OFF) NEAR/4 raw:(“£” OR “$” OR “€” OR “%” OR pence OR Pence OR PENCE OR pennies OR Pennies OR PENNIES OR pounds OR Pounds OR POUNDS OR cent OR Cent OR CENT OR cents OR Cents OR CENTS OR dollars OR Dollars OR DOLLARS OR euros OR Euros OR EUROS)))

 

OR

 

title:(coupon* OR voucher* OR code* OR discount OR deal OR deals OR offer OR offers OR (promo* NEAR/10 (sale OR buy)) OR sale OR (raw:(save OR Save OR SAVE OR off OR Off OR OFF) NEAR/4 raw:(“£” OR “$” OR “€” OR “%” OR pence OR Pence OR PENCE OR pennies OR Pennies OR PENNIES OR pounds OR Pounds OR POUNDS OR cent OR Cent OR CENT OR cents OR Cents OR CENTS OR dollars OR Dollars OR DOLLARS OR euros OR Euros OR EUROS)))

Price

((pric* OR cost* OR money OR expensive OR cheap* OR value OR charge OR pay* OR paid OR ripoff OR “rip off” OR extortion* OR bargain OR tariff*) NEAR/20 ::)

 

OR

 

((worth NEAR/20 ::) -(worth NEAR/3 (hassle OR effort OR risk OR time OR wait OR salt OR candle OR while OR checking OR go* OR taking OR visit* OR look*)))

 

OR

 

(site:twitter AND raw:(“£” OR “€”) AND (::))

 

-giveaway -“give away” -“for your chance to” -“for ur chance to” -“for the chance to”

Ticket Price

(((reduc* OR lower OR decreas* OR cheaper OR less OR drop OR increas* OR inflate* OR rise OR cost OR expensive OR price) NEAR/2 ticket) NEAR/10 ::) -“Cheaper than” -“less than”

Recommendation

(((((recommend* OR propose* OR suggest* OR should) NEAR/3 (buy OR get OR purchase* OR getting OR bought)) NEAR/1 (I OR im OR you OR u OR your OR ur)) NEAR/10 (::))

Customer Service

Customer service is notoriously difficult to create rules for. It can be better to employ an emotive category instead (see below)

((customerservice* OR “customer service”~3 OR “customer services”~3 “customer assistance”~2 OR “customer support”~2 OR “customer relations”~2 OR “customer care”~2 OR “apology” OR “staff” OR “helpful” OR “polite” OR “approachable” OR “friendly” OR “rude” OR “unhelpful” OR help* OR complain* OR dispute* OR fault OR representative OR issue* OR ring* OR rang OR call* OR “on hold” OR “rude” OR “polite” OR “inpolite” OR impatient OR “interested” OR Uninterested OR arrogant OR friendly OR unfriendly OR pushy OR persistent OR attentive OR dishonest OR honest OR misleading OR sly OR unattentive OR “call back” OR “ring back” OR “ringing back” OR “calling back” OR “get back to me” OR “got back to me” OR complain* OR moaning OR disput* OR “hung up”) NEAR/10 ::)

 

-(“customer tags”~3 OR “customer rating”~3 OR “customer ratings”~3 OR “customer review”~3 OR “customer preview”~3 OR “customer reviews”~3 OR “customer previews”~3)

Emotive: Mild

(cool OR enjoy* OR like OR interesting) -(“looks like” OR “look like” OR “like there” OR “is like” OR “are like” OR “just like”)

Emotive: Intensifiers

((Speechless OR remarkable OR Wow* OR Jesus OR Christ OR Jesuschrist OR fuck* OR fuk* OR holy* OR bloody OR awfully OR deucedly OR emphatic* OR insanely OR madly OR truly OR horrendously OR tremendously OR terribly OR unquestionably OR very OR extremely OR incredibly OR exceedingly OR exceptionally OR extremely OR extraordinarily OR really OR utterly OR absolutely OR perfectly OR sublimely OR dramatically OR sheer OR avid OR flamboyant*) NEAR/10 ::)

 

(site:twitter AND raw:(“>:o” OR “>:O” OR “:-O” OR “:O” OR “°o°” OR “°O°” OR “o_O” OR “o_0” OR “o.O” OR “8-0”))

Emotive: Positive

((“fuck yes” OR love* OR brilliant OR amaz* OR excit* OR appealing OR exceptional OR absorbing OR incredible OR matchless OR impressive OR impressed OR ((a OR my OR his OR her OR your OR our OR their) NEAR/0f (favourite OR favorite)) OR outstanding OR superb OR passion OR passionate OR satisfied OR satisfaction OR adore OR exquisite OR genius OR pleasure OR reliable OR reward* OR stunning OR delight* OR excellent OR glorious OR goodness OR stylish OR supreme OR beautiful OR dazzling OR enthusiastic OR marvelous OR marvellous OR wonderful OR “the shit” OR “teh shit” OR magnificent OR magnanimous OR fantastic OR phenomenal OR wonderful OR extraordinary OR superb OR great* OR excellent OR spectacular OR prodigious OR brilliant OR grand OR glorious OR illustrious OR notable OR impressive OR splendid OR terrific OR tremendous OR wondrous OR wonderful OR sublime) NEAR/5 ::)

 

OR

 

(site:twitter AND raw:(“:-)” OR “:)” OR “:-D” OR “:^D” OR “<3”) AND ::)

 

-(amazon OR amazone OR cunts OR idiots OR troll OR trolling) -“great deal” -“great amount”

 

-((“don’t” OR dont OR not OR “isn’t” OR isnt OR “doesn’t” OR doesnt) NEAR/3f (love* OR brilliant OR amaz* OR excit* OR appealing OR exceptional OR absorbing OR incredible OR matchless OR impressive OR impressed OR ((a OR my OR his OR her OR your OR our OR their) NEAR/0f (favourite OR favorite)) OR outstanding OR superb OR passion OR passionate OR satisfied OR satisfaction OR adore OR exquisite OR genius OR pleasure OR reliable OR reward* OR stunning OR delight* OR excellent OR glorious OR goodness OR stylish OR supreme OR beautiful OR dazzling OR enthusiastic OR marvelous OR marvellous OR wonderful OR “the shit” OR “teh shit” OR magnificent OR magnanimous OR fantastic OR phenomenal OR wonderful OR extraordinary OR superb OR great* OR excellent OR spectacular OR prodigious OR brilliant OR grand OR glorious OR illustrious OR notable OR impressive OR splendid OR terrific OR tremendous OR wondrous OR wonderful OR sublime))

 

Emotive: Negative

((“Fuck no” OR hate OR hates OR fail* OR horrendous OR frustrated OR frustration OR shit* OR “is a joke” OR complicated OR terrible OR disaster OR sceptical OR upset OR disastrous OR dislike* OR disappoint* OR ridiculous OR unrealistic OR “not satisfied” OR dissatisfied OR awful OR absurd OR horrible OR unhappy OR sucks OR suck OR lousy OR unclear OR doubtful OR chaotic OR inadequate OR incomplete OR incompetent OR unimpressed OR “not impressed” OR confused OR disgusted OR crooked OR crap OR “fed up” OR annoy* OR pissedoff OR “pissed off” OR “no hope”) NEAR/5 ::)

 

OR

 

(site:twitter AND raw:(“:-(” OR “:(” OR “:-c” OR “:c” OR “:<” OR “:-<” OR “:-||” OR “;-(“) AND ::)

 

-(“holy shit” OR “holy shite” OR “the shit” OR “teh shit” OR “that shit” OR “and shit” OR “buy shit” OR “my shit” OR “crap at” OR raw:”crap @” OR “suck on” OR lol OR “suck at” OR “i’m crap” OR “i suck” OR “im crap” OR shitting)

 

-((“don’t” OR dont OR not OR “isn’t” OR isnt OR “doesn’t” OR doesnt) NEAR/3f (hate OR hates OR fail* OR horrendous OR frustrated OR frustration OR shit* OR complicated OR terrible OR disaster OR sceptical OR upset OR disastrous OR dislike* OR disappoint* OR ridiculous OR unrealistic OR dissatisfied OR awful OR absurd OR horrible OR unhappy OR sucks OR suck OR lousy OR unclear OR doubtful OR chaotic OR inadequate OR incomplete OR incompetent OR unimpressed OR confused OR disgusted OR crooked OR crap OR “fed up” OR annoy* OR pissedoff OR “pissed off” OR “no hope”))

Generic Emotive Language

(((“fuck yes” OR love* OR brilliant OR amaz* OR excit* OR appealing OR exceptional OR absorbing OR incredible OR matchless OR impressive OR impressed OR ((a OR my OR his OR her OR your OR our OR their) NEAR/0f (favourite OR favorite)) OR outstanding OR superb OR passion OR passionate OR satisfied OR satisfaction OR adore OR exquisite OR genius OR pleasure OR reliable OR reward* OR stunning OR delight* OR excellent OR glorious OR goodness OR stylish OR supreme OR beautiful OR dazzling OR enthusiastic OR marvelous OR marvellous OR wonderful OR “the shit” OR “teh shit” OR magnificent OR magnanimous OR fantastic OR phenomenal OR wonderful OR extraordinary OR superb OR great* OR excellent OR spectacular OR prodigious OR brilliant OR grand OR glorious OR illustrious OR notable OR impressive OR splendid OR terrific OR tremendous OR wondrous OR wonderful OR sublime) OR (“Fuck no” OR hate OR hates OR fail* OR horrendous OR frustrated OR frustration OR shit* OR “is a joke” OR complicated OR terrible OR disaster OR sceptical OR upset OR disastrous OR dislike* OR disappoint* OR ridiculous OR unrealistic OR “not satisfied” OR dissatisfied OR awful OR absurd OR horrible OR unhappy OR sucks OR suck OR lousy OR unclear OR doubtful OR chaotic OR inadequate OR incomplete OR incompetent OR unimpressed OR “not impressed” OR confused OR disgusted OR crooked OR crap OR “fed up” OR annoy* OR pissedoff OR “pissed off” OR “no hope”)) NEAR/5 ::)

 

OR

 

((Speechless OR remarkable OR Wow* OR Jesus OR Christ OR Jesuschrist OR fuck* OR fuk* OR holy* OR bloody OR awfully OR deucedly OR emphatic* OR insanely OR madly OR truly OR horrendously OR tremendously OR terribly OR unquestionably OR very OR extremely OR incredibly OR exceedingly OR exceptionally OR extremely OR extraordinarily OR really OR utterly OR absolutely OR perfectly OR sublimely OR dramatically OR sheer OR avid OR flamboyant*) NEAR/10 ::)

 

OR

 

(site:twitter AND raw:(“:-)” OR “:)” OR “:-D” OR “:^D” OR “<3” OR “:-(” OR “:(” OR “:-c” OR “:c” OR “:<” OR “:-<” OR “:-||” OR “;-(” OR “>:o” OR “>:O” OR “:-O” OR “:O” OR “°o°” OR “°O°” OR “o_O” OR “o_0” OR “o.O” OR “8-0”) AND ::)

 

-(“holy shit” OR “holy shite” OR “the shit” OR “teh shit” OR “that shit” OR “and shit” OR “buy shit” OR “my shit” OR “crap at” OR raw:”crap @” OR “suck on” OR lol OR “suck at” OR “i’m crap” OR “i suck” OR “im crap” OR shitting)

 

-(amazon OR amazone OR cunts OR idiots OR troll OR trolling)

 

-“great deal” -“great amount”

I hope you agreed that this post made for a jolly good read, and if not, you at least managed to enjoy some delicious copypasta for your social media monitoring queries.