filter ".ca" email domain contacts in a smart list

Anonymous
Not applicable

filter ".ca" email domain contacts in a smart list

Hello everyone,

I have to pull out a list of all the contacts with Canadian email address i.e of ".ca" domain. I particularly need help since if I create a smart list with filter "Email Address contains .ca" it is pulling out other contacts too such as "honglei.calvin@xyz.com". Is there any way I can only filter out only those emails which ends with ".ca" domain?

Thank you in advance.

Harshit

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: filter ".ca" email domain contacts in a smart list

Very similar to a recent Community question, so be sure to search first.

You can't do this kind of pattern matching.  I recommend maintaining a separate custom field for the public domain suffix.  You can populate this field using a webhook or import/export, or if you use SFDC you can compute it there. The more fields you split it into, the easier it is to use Marketo's rather limited string matching rules.

Anonymous
Not applicable

Re: filter ".ca" email domain contacts in a smart list

Apologies, I should have searched through the community questions first. I am a new user so I don't know the guidelines/navigation.

Also thank you so much for your response, I will make sure to implement your suggestion.