Wildcard Patterns for Segmenting in a Smart List | Community
Skip to main content
Level 2
October 29, 2021
Solved

Wildcard Patterns for Segmenting in a Smart List

  • October 29, 2021
  • 2 replies
  • 2521 views

Hello all - 

 

I am working on a smart list that is Job Title specific. Does Marketo have the capability to filter by using wildcard patterns? I know some programs use percent signs (%) or asterisks (*).

 

For example, I'd like to pull in CTOs but not Directors (which contains 'cto'). So it should look something like this - % CTO %. However, I've tried numerous iterations of wildcard patterns (and job titles) for testing purposes but it always returns zero contacts.

 

Does anyone have insight into this? Thanks 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jo_Pitts1

Kyle,

there aren't wild cards but you do have contains and not contains

 

You could create a filter that was along these lines

you may need to use advanced filters to create a combination of Ands and Ors that work for you.

 

Cheers

Jo

 

2 replies

SanfordWhiteman
Level 10
October 30, 2021
Neither SQL wildcards nor other wildcards (grep, regex) are supported.

You can pass people through a webhook for more precise pattern matching.
Jo_Pitts1
Community Advisor
Jo_Pitts1Community AdvisorAccepted solution
Community Advisor
October 31, 2021

Kyle,

there aren't wild cards but you do have contains and not contains

 

You could create a filter that was along these lines

you may need to use advanced filters to create a combination of Ands and Ors that work for you.

 

Cheers

Jo