How to indentify list of unique email domains | Community
Skip to main content
A
Anonymous
January 29, 2015
Solved

How to indentify list of unique email domains

  • January 29, 2015
  • 12 replies
  • 8925 views
Here is my business case. I want to indentify list of unique email domains in my database. Is there a way it can be done?

Here are a couple of approaches I thought but ran in to roadblocks.

1> A lead preformance report would have been great fit here if I can group by a subset of email address field. i.e. domain name. But it is not supported to be grouped by a subset of a field value.

2> I thought there might be a way to use API to get this kind of data out. 
For example, by using getLead by EMAIL 
as explained here,
https://community.marketo.com/MarketoArticle?id=kA050000000L3FlCAK

The question is if this call returns the 'exact' match of the email address passed. Like Rajesh@BrightAspects.com
or
it returns all the records which 'contain' the string I pass. So I can pass just the domain name.such as @BrightAspects.com to get a list of all email addresses in the database from that domain.

There are a couple of other ways to solve this but I am not looking to use webhooks, create a new field and can not assime that all Marketo leads are also in SFDC. Any other ideas?

Thanks

Rajesh





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

    Rajesh, you could use a new beta feature called "Munchtions" that allows you do add functions to Change Data Values. One function is "regex replace", which allows you to extract the domain from the email address (and many other things). This would be the syntax:

    • Smart List
      • trigger: Lead is Created
      • trigger: data value changes, attribute is "email address"
      • filter: email address is not empty
    • Flow
      • Change Data Value, Attribute "email domain", new value: ##REGEX_REPLACE({{lead.Email Address}},"/.+(?<=@)/","")##
    • ​Schedule
      • ​Run every time

    You will have to ask Support to enable this feature.

    Once you have the domain in a separate field, it should be much easier to count the number of unique domains, for example a Lead Performance report grouped by "email domain" (time period: all time).

    MODERATOR EDIT: This feature is only available for internal use.  Support is not able to enable this for customer use at this time.

    12 replies

    Abaran
    Abaran
    New Participant
    August 12, 2015

    Hello Everyone

    I called Marketo support and they enabled it for me. I have yet to try it but it is certainly something i will be putting in place really soon.

    Does anyone know any other option with can use with Munchtions? Support is telling they seem to work the same as excel functions, for which there is a guide here: support.office.com/en-gb/article/Excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb#__toc309306717

    Please let me know

    Axel

    A
    Anonymous
    March 25, 2015
    I too tried this once by using the field "domain name". I just add domain names to a set of emails and used that domain field in smartlist to filter out the email address for the corresponding domains. But marketo does the filter only to email address not to domains... also please tell me if there is any way on this.
    Jep_Castelein2
    Jep_Castelein2
    New Participant
    March 25, 2015
    Angus, apparently I spoke too soon and this feature is not generally available yet. There is only a very limited-scale test right now. I believe there are plans for a larger scale test (like a beta test), but it may take a little while. 
    A
    Anonymous
    March 25, 2015
    Is there a list of functions available through this beta feature beyond REGEX_REPLACE? 
     
    A
    Anonymous
    January 30, 2015
    Jep - holy cow! That's amazing stuff. 
    A
    Anonymous
    January 30, 2015
    Thanks Jep.
    That's exactly I was looking for. It looked like a much needed and missing functionality gap to 'populate 'formula' fields based on other fields'. Glad that it is alredy thought of and created by smart brains at Marketo.

    Rajesh
     
    A
    Anonymous
    December 30, 2016

    Hi,

    Since Munchtions are getting discontinued, I had to work on alternative ways lately. In that process, built a set of webhooks. See if these can help you solve similar situations.

    DIY webhooks library for Marketo - Marketo LaunchPoint – Marketo LaunchPoint

    Particularly, this one Web Hook Library

    Hope this helps


    Rajesh

    Jep_Castelein2
    Jep_Castelein2Accepted solution
    New Participant
    January 30, 2015

    Rajesh, you could use a new beta feature called "Munchtions" that allows you do add functions to Change Data Values. One function is "regex replace", which allows you to extract the domain from the email address (and many other things). This would be the syntax:

    • Smart List
      • trigger: Lead is Created
      • trigger: data value changes, attribute is "email address"
      • filter: email address is not empty
    • Flow
      • Change Data Value, Attribute "email domain", new value: ##REGEX_REPLACE({{lead.Email Address}},"/.+(?<=@)/","")##
    • ​Schedule
      • ​Run every time

    You will have to ask Support to enable this feature.

    Once you have the domain in a separate field, it should be much easier to count the number of unique domains, for example a Lead Performance report grouped by "email domain" (time period: all time).

    MODERATOR EDIT: This feature is only available for internal use.  Support is not able to enable this for customer use at this time.

      Abaran
      Abaran
      New Participant
      November 5, 2015

      Hi Jep

      Great post. I got on ht trial list .

      Once we have email domains in separate fields, how can I create a list for just domains in Marketo (no in excel).

      I would like to be able then create a smart list of leads and check if any of the leads match the domain list described above.

      Any ideas?

      Thanks

      Axel

      A
      Anonymous
      January 30, 2015
      Hey Dory, just curious what method do you use to do this in SFDC? 

      @Rajesh, using the PowerPivot add-in (download for Excel 2010 or included with Excel 2013) you can manipulate even millions of data rows. 

      The example sheet in the second link has 161 million rows. 
        Dory_Viscoglio
        Dory_Viscoglio
        New Participant
        January 30, 2015
        HI Rajesh, does this have to be done in Marketo? We pull our domain lists from SFDC which ends up being a much cleaner and easier to pull list. 
        SanfordWhiteman
        SanfordWhiteman
        New Participant
        January 30, 2015
        @Rajesh I can understand working on millions at once may not be feasible, but you can straightforwardly divide them into 36 already-unique buckets -- where mail contains @a, @b, @c... @8, @9.  Then aggregate across all the buckets. Kind of a hack, of course, but don't know of another way.
        Show more replies
        Terms & ConditionsAccessibility statement

        Loading footer...