AnsweredAssumed Answered

How to indentify list of unique email domains

Question asked by 15142a9527862a8049b3391154c47bd9d731620c on Jan 29, 2015
Latest reply on Dec 30, 2016 by Rajesh Talele
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,

The question is if this call returns the 'exact' match of the email address passed. Like
it returns all the records which 'contain' the string I pass. So I can pass just the domain name.such as 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?