Workaround for “Ends With” - Suppressing Top-Level Email Domains | Community
Skip to main content
A
Anonymous
October 16, 2015

Workaround for “Ends With” - Suppressing Top-Level Email Domains

  • October 16, 2015
  • 7 replies
  • 5565 views

Sometimes you want to be able to suppress certain top-level email domains from your communications. If you aren’t suppressing the entire domain (@marketo.com) and you just want to suppress something like .it (all Italian domains), it’s challenging to do this since Marketo does not have an ‘ends with’ filter.

One of my customers needed to blacklist all military email addresses, ending in .mil. However, I wanted to make sure we didn’t also blacklist people who just happened to have .mil in their email address, like jon.miller@marketo.com. My solution was to suppress people whose email domains contained .mil but did not contain .mil with any letter or character after it:

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

    7 replies

    J
    Adobe Champion
    JennyRo4Adobe Champion
    Adobe Champion
    October 23, 2015

    I find this useful when you need to identify Canada emails (.ca) 

    Heleen_Abegg1
    Heleen_Abegg1
    Level 2
    October 26, 2015

    Thank you Kristen! I've been bothering Marketo for over a year to add the 'ends with' option, this seems a good way to work around the issue. Regards Heleen

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    November 2, 2015

    The list is missing .MILL.  That was probably a typo, but more important, there aren't enough exclusions. 

    Needs to at least cover a-z0-9+=@,

    Consider:

    john.mil@example.com

    john.mil+retail@example.com

    john.doe@example.mil.news

    enfa.mil=joe@example.com

    All perf'ly valid addresses w/common formats.

    And there are plenty of other valid chars as well. Ultimately, there's no faking our way around the need for an 'ends with'.

    A
    Anonymous
    November 3, 2015

    Completely agree. It's on my personal list of requests and I'm sure someone out there has a community idea for it too.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    November 30, 2016

    Relevant: http://blog.teknkl.com/flowboost-fbemail-for-domains/

    A
    Anonymous
    October 19, 2018

    As well, this method unfortunately also includes some .mil addresses.

    For example, johnny.miles@usmc.mil would be included because his email includes .mil AND .mile.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    October 19, 2018

    A more, let's say, modern way of doing this is to maintain a custom field whose value is

      {{Lead.Email Address}}..

    Note two periods at the end. Using New Lead and Data Value Changes triggers, you always keep this value up to date.

    Then you can do

      contains .mil..

    or

      contains @example.com..

    Note: Two successive periods are chosen to eliminate confusion, because that sequence can never be part of a valid email address.

    Terms & ConditionsAccessibility statement

    Loading footer...