6 Replies Latest reply on Feb 2, 2017 2:20 PM by Sanford Whiteman

    Smart list: <attribute> contains = whole word ?

      Hello!

      I'm trying to build a smart list that captures contacts where a field contains specific words.

      I want it to match whole words as opposed to just the characters.

      an example would be: contains = mod (as a whole word)

      so i wouldn't want it to return entries such as 'module'

       

      More specifically, i'm setting up the Company Web Activity report.

      i have a list of let's say our top 100 strategic accounts, and I want to monitor anonymous web activity.

      So I need to set up a smart list that looks at the 'inferred company'

      Lets say we want to track a company called Shire.

      Inferred Company is = Shire wont work as we cannot preempt all the possible ways a company might appear (i.e. Shire UK , Shire US etc.)

      The problem is that if there's inferred companies like Lancashire city council or Buckinghamshire etc. the smart list would pick these up too.

      So unless there is a 'match whole word' condition we would have to monitor manually and add exclusions. And that's only one of 100+ companies... so doing it manually is quite a task.

       

      Is there anyway to make this more intelligently?

       

      thanks