Email Address Filter 'Contains' filter issue without using '@'

Manish_Khemani1
Level 3

Email Address Filter 'Contains' filter issue without using '@'

Hello Marketo Experts,

I tried using the 'Emaill Address' field as a filter in one of my smart lists with a condition as:

Email address --> Contains --> .ibm.

But it did no show up results;

Later when I tried with

Email address --> Contains --> @dk.ibm. --> Only then it showed up the leads from IBM.

Any work around to get all leads without putting '@' in the condition. Require this since there are a lot of companies with varied email domains

and I need to get all of them together in one list.

Using Company Name is not the right option for us since users fill in companies with junk text too.

Regards,

Manish.

8 REPLIES 8
Gerard_Donnell4
Level 10

Re: Email Address Filter 'Contains' filter issue without using '@'

Have you tried it without the dot. Just "IBM"?

Manish_Khemani1
Level 3

Re: Email Address Filter 'Contains' filter issue without using '@'

Yes but that will get some undesired records too.

Best Regards,

Manish Khemani

Gerard Donnelly --- Re: - Re: Email Address Filter 'Contains' filter issue without using '@' ---

From:"Gerard Donnelly" <marketingnation@marketo.com>To:"Manish Khemani" <manish.khemani@tcs.com>Date:Mon, 12-Nov-2018 3:23 PMSubject:Re: - Re: Email Address Filter 'Contains' filter issue without using '@'

"External email. Open with Caution"

The Marketo Marketing Nation Community Re: Email Address Filter 'Contains' filter issue without using '@' reply from Gerard Donnelly in Products - View the full discussion

Have you tried it without the dot. Just "IBM"?

Reply to this message by replying to this email, or go to the message on Marketo Marketing Nation Community Start a new discussion in Products by email or at Marketo Marketing Nation Community Following Re: Email Address Filter 'Contains' filter issue without using '@' in these streams: Inbox This email was sent by Marketo Marketing Nation Community because you are a registered user.

You may unsubscribe instantly from Marketo Marketing Nation Community, or adjust email frequency in your email preferences Community Help & Feedback

=====

SanfordWhiteman
Level 10 - Community Moderator

Re: Email Address Filter 'Contains' filter issue without using '@'

Steven_Vanderb3
Marketo Employee

Re: Email Address Filter 'Contains' filter issue without using '@'

If you're searching for multiple domains, you need to include the @ symbol.

10. Include the @ symbol before the domain name when using the Email Address filter - This makes it use a faster query. Example: Instead of using email contains 'somedomain.com', use email contains '@somedomain.com.' If you're using multiple email address with "contains," ALL of them must start with "@."

Best Practices for Smart Lists - Marketo Docs - Product Documentation

Manish_Khemani1
Level 3

Re: Email Address Filter 'Contains' filter issue without using '@'

But in the case I specified, IBM has ids like @dk.ibm.com, @in.ibm.com,

etc. so in this case (unfortunately) the hack won't work!

Also if I include '@' I need to know all the email domains -

Is there a way I an use wild cards like @??.ibm.com?

With Best Regards

Manish Khemani

SanfordWhiteman
Level 10 - Community Moderator

Re: Email Address Filter 'Contains' filter issue without using '@'

Please read my blog post more thoroughly.

Is there a way I an use wild cards like @??.ibm.com?

You can't use wildcards, but why would you want a trailing wildcard in this case? The number of public .com second-level domains is too small to matter.

Manish_Khemani1
Level 3

Re: Email Address Filter 'Contains' filter issue without using '@'

Got it!

Probably I should have given a better example where email domains are like

@its.jnj.in or @itj.jnj.au

With Best Regards

Manish Khemani

Tata Consultancy Services

Mailto: manish.khemani@tcs.com

Website: http://www.tcs.com

SanfordWhiteman
Level 10 - Community Moderator

Re: Email Address Filter 'Contains' filter issue without using '@'

If you really need that depth of pattern matching you must use a webhook.