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

[Manish_Khemani1]

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.

[Gerard_Donnell4]

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

[Manish_Khemani1]

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]

You seem to have missed A hackity-hack for “Ends With” and email domains.

[Steven_Vanderb3]

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]

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]

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]

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]

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