Skip to main content
M
manishk56775265
Level 4
November 12, 2018
Question

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

  • November 12, 2018
  • 2 replies
  • 6242 views

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.

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

2 replies

Gerard_Donnell4
Gerard_Donnell4
Level 9
November 12, 2018

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

M
manishk56775265Author
Level 4
November 12, 2018

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
SanfordWhiteman
Level 10
November 12, 2018

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

    Steven_Vanderb3
    Adobe Employee
    Steven_Vanderb3Adobe Employee
    Adobe Employee
    November 12, 2018

    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

      M
      manishk56775265Author
      Level 4
      November 13, 2018

      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
      SanfordWhiteman
      Level 10
      November 13, 2018

      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.

      Terms & ConditionsAccessibility statement

      Loading footer...