how to create a report that show the contacts who meets the criteria of having the same First Name, Last name and mailing address - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Teenu TimyTeenu Timy 

how to create a report that show the contacts who meets the criteria of having the same First Name, Last name and mailing address

The idea is to find the duplicate records with the criteria the contact having same first name, last name and mailing address.
 
Is there a possibility to get this data as salesforce report.
 
Dnyaneshwar AghawDnyaneshwar Aghaw
Hi Tmiy,
Please find below Idea for Report Option for Distinct/Unique Records
https://success.salesforce.com/ideaview?id=08730000000BrYLAA0
 
Steve MolisSteve Molis
You could try this

Documentation Create Reports on Duplicate Records
https://help.salesforce.com/articleView?id=duplicate_management_custom_report_types.htm&type=5
Teenu TimyTeenu Timy
Hi Steve is the Duplicate Record Set exclusive to lightning? I cannot find any values popultaed in Duplicate Record Set
Steve MolisSteve Molis
No, it's available in Classic
Teenu TimyTeenu Timy
Hi Steve,
I have no values populated in any of the fields in the mentioned report using Duplicate Record Items is there any other way 
Duplicate Record Items
Steve MolisSteve Molis
Do you have any Duplicate Rules setup in your org?
Steve MolisSteve Molis
I can't help you much more than the information in the link I posted.  Otherwise you'd need to create a Contact and Leads report, export them to Excel, and try to match them in Excel (or buy a 3rd Party Data Hygiene App)
Teenu TimyTeenu Timy
@steve do you have any reccomondation on any Data Hygiene App We are currently using Cloudingo by symphonicsource which is not doing much of job;
the ability to export filters is overpriced and it leaves orphaned accounts in npsp environment when merging. 
So any better suggesition 

Ps:Duper catcher is also from symphonicsource so apart from cloudingo and dupecatcher any suggestion that would be affordable by nonprofit

 
Steve MolisSteve Molis
I dunno, I don;t have any experience with any of those Apps