In Salesforce, you can create a report that lists duplicate records by setting the duplicate rule with SOC or the CI person ID as a key. However, records with SOC or CI person IDs prior to creating duplicate rules cannot be displayed in this report.
This section shows you how to efficiently find duplicate records that are not displayed in the duplicate report.
Complete the steps for setting matching rules and duplicate rules in the Salesforce duplicate record extraction procedures.
Report Creation Steps
- Click on "New Report".
- The Choose Report Type screen is displayed. Select the object for which you want to check duplicate records.
In the example image, "Account" is selected, but "Contact" and "Lead" can also be selected.
- The report definition screen is displayed. Under "Outline", add "SOC" in "Groups".
*In the example image, only "SOC" is added because Account is selected for the report type. If you select Contact or Lead in step 2, add "SOC" and "CI Person ID".
- In "Search conditions" set the following condition.
Display Settings Display Select "All accounts" or the relevant choice for Contacts or Leads. Date Date Select "Created Date", "Last Modified Date", or "Last Activity". Range Select "Always". SOC Operator Select "not equal to". Input field No input required
- Click "Save & Run" at the top right.
Duplicate Record Extraction
- Click ▼ in the “SOC” header of the report screen to sort the list in descending order, sort by "Record Count".
- Click the Account name to perform the merge so that duplicate records will be displayed first.
Refer to the Salesforce duplicate record extraction procedure for details on how to merge duplicate records.