Open Forum

Is it possible to get a report showing contacts with duplicate first and last name? 

Hello Karen,

On the Event Level you could do the following

Create a Custom Report (Reporting > Custom Report > Create Custom Report (green button)) then choose Category Attendees, Type All Attendees. Step 2: Select the fields that you want, Step 3: Any sorting criteria, Step 4, Date rage and then in Advanced Filters, select Last Name, Operator Equals, Value (last name in question). Add another Filter, and leave the And button checked and this time do First Name, Operator Equals, Value (first name in question)


If you want to know if there are any duplicates (perhaps just same name??) on the Account Level, you can do the following

The Account Level reports can be found by clicking Solution: Events > Cross Events > Cross Event Reports > Create Custom Report (green button)

The Account Level is similar, but instead of selecting Attendees as the Category, go ahead and select Contacts. 

I hope this helps.

Thanks! I'm definitely working at the account level. I'm still not quite sure how to get what I want, though. I've created a custom report, and it looks like it basically a list of my account's contacts. How do I return a list of ONLY contacts that have an identical first and last name as another contact?

Hi Karen - there isn't currently a report for this. The best we have is searching for duplicates by either Source ID or by Last Name and Email Address. Cvent is exploring other ways to locate duplicates, however. Stay tuned!

That's exactly what I'm doing! The huge Excel file nearly crashed my computer and cleaning up dozens of manual merges is turning into a full-time job! 

As someone who works for a large organization, we are struggling with keeping our records clean as only 2 criteria for finding duplicates is not enough.  When I run the last name and company, it returns 8500 potential duplicate records.  If first name and company even more.  It would be lovely to have first name, last name and company.