web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

The best way to perform duplicate detection with a large number of leads?

(0) ShareShare
ReportReport
Posted on by 985

I have about 10,000 leads in the CRM leads section already. I have 1,500 leads that are in a spreadsheet that I want to import in to the CRM.

The 1,500 leads in the spreadsheet are companies that were part of the 10,000 original import but this group of 1,500 have different bits of data on the company. Thus i want to import the 1,500 in to the CRM run a duplicate detection and merge the records, keeping the correct data from both records.

When I run a duplicate detection in the CRM it presents an error saying the following:   'Bulk Detect Duplicate Limit Exceeded. The Bulk Duplicate Detection job cannot detect more than 5000 duplicates. Please review your duplicate rules or resolve existing duplicates and rerun the job.'

Can I change this in order to scan for over 5000 duplicates? Because after the first 5000 scanned I have to do the others through filtering the 10,000 leads then merging them manually.

 Or is there a more efficient way to perform a duplicate detection of this nature altogether?

*This post is locked for comments

I have the same question (0)
  • Inogic Profile Picture
    651 on at
    The best way to perform duplicate detection with a large number of leads?
    Hi,
     
    Hi,
    I understand the challenge you're facing with duplicate detection in your CRM when dealing with a large number of leads. You can easily overcome the Bulk Duplicate Detection job limit of 5000 duplicates with deduplication solutions.

    One such solution that can simplify this task is DeDupeD App by Inogic.  DeDupeD can help you detect, prevent, and merge Duplicate records for any and all entities within the Dynamics 365 CRM. With the apps Clean Up History Duplicate Records in Bulk feature, users can detect and merge “N” numbers of duplicate records within Dynamics 365 CRM based on set criteria with just a click of a button.
    Here are some key benefits of using this feature:
    • Bulk Duplicate Merge: The Clean Up History Duplicate Records in Bulk feature allows you to run a comprehensive duplicate merge process, identifying and merging multiple duplicate records at once. This is particularly useful when dealing with a large number of leads.
    • Efficient Criteria-based Merging: You can set criteria for duplicate detection, ensuring that the correct data from both records is retained during the merge process. This helps maintain accuracy in your CRM data.
    • Convenience: The bulk merge process saves you from the hassle of manually going through each record and identifying duplicates. It's a more efficient way to clean up historical duplicate records.
    Be it 5,000 or 10,000 leads, DeDupeD can help you manage any number of duplicate leads within CRM.
    Download your free 15-day trial from the Inogic website or Microsoft AppSource to get started!
     
    Thanks!
  • Gus Gonzalez Profile Picture
    27,113 on at
    Re: The best way to perform duplicate detection with a large number of leads?

    Jonathan,

    Is it possible to export all these Leads to Excel, deduplicate in Excel and re-import the clean list?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans