14 Replies Latest reply on Dec 30, 2016 3:18 PM by Rajesh Talele

    How to indentify list of unique email domains

      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