I'm creating a Smart List for scoring purposes and I want to include titles with IT. Examples: Director of IT, IT Manager, IT Security, etc. Since there are many title variations that will include "IT", I do not want to use an exact match. Is there a way to locate titles that include "IT" but also exclude words with "it" in them? Examples of words with "it" in them that we would want to exclude are architect, unit, critical, etc. There is a way to build a filter formula in SFDC that will include spaces - example: CONTAINS( LOWER( Title ) , " it") -- Notice the space before the " it". Is there a way to do something similar in Marketo?
Solved! Go to Solution.
Hi Tammy,
To add spaces around a filter value, adapt my approach from Creating a line break token for history fields
The changes from the history field method are:
The deal is otherwise the same: Marketo doesn't actually have a problem with special characters on the back end, it's that the front end filters them out unless you get creative.
Then you can get just what you want:
Instead of the overly broad [contains] results:
Spaces aren't recognized in most situations.
I wrote about this in my guide, but you need to make several smart lists:
(1 or 2 or 3) and 4
it might work better to have 2 or 3 and then cross them.
It is possible to create a filter that includes leading and trailing spaces, but you can't do it using the UI directly. Same reason you can't directly enter a line break in a flow textbox: the Marketo back end does fully support these characters, but the front end "helpfully" strips them out.
To store this filter on the back end, you can use the same hack I developed to create a line break token. You can contact me if you're interested.
Hi Sanford,
I'm running into the same issue here, would you be able to tell me how you addressed this? I basically want to bucket all "IT" contained titles into a segment but i'm getting things like "digital" etc.
Thanks!
Hi Tammy,
To add spaces around a filter value, adapt my approach from Creating a line break token for history fields
The changes from the history field method are:
The deal is otherwise the same: Marketo doesn't actually have a problem with special characters on the back end, it's that the front end filters them out unless you get creative.
Then you can get just what you want:
Instead of the overly broad [contains] results:
This is AWESOME! Thank you SO MUCH!
It is really useful, right?
I'm going to do a little updated blog post on it -- ran it on one of my instances and real " IT " had 10 leads (granted, not a technology company) while "IT" had 72 pages of leads! People may have no idea how off they are...
Hey Sanford
This seemed to have worked for the IT titles, but now I'm trying to run a segmentation for c-suite, vp, directors, managers etc. I used this method again for the c-suite titles like "CIO" and CFO etc. created a c-suite smart list, and created a VP smart list. I excluded the members of 'c-suite smart list' from the 'vp smart list' but when I did a check my VP list included some "CIO" and "CFO" but not in the c-suite list. Not sure what is going on - do you have any insight? I'm not sure what I'm doing wrong....
For c-suite- I created rules to include a space before and after "cio" and another one for just a space after "cio"
Looks like your C - Suite list doesn't include a rule for entries that end with a space followed by CxO.
Thanks! I think I ended up figuring it out- I guess I needed to have:
Thanks again!