Creatio base
This documentation is valid for Creatio version 7.12.0. We recommend using the newest version of Creatio documentation.

How to search for duplicates

Before comparing the records, bpm'online converts their data to a single format (data standardization), and afterwards compares the converted values in the fields according to the active duplicate rules.

As part of the data standardization:

All text messages are made lower case.

All spaces are deleted.

All special symbols are deleted: brackets, quotation marks, hyphens, "#", "%", etc.

Standard text is deleted from website addresses, such as: "http(s):\\", "www", and the items of the domain name, such as .com, .org, etc., except top-level domains.

When comparing email addresses, symbols “@”, “_”, “.”, integers and Latin characters are taken into account.

When comparing full names, both integers and Latin characters are taken into account. When comparing values in the [Full name] field, the system will identify duplicates regardless of the order in which first and last names are entered.

When comparing phone numbers, only the last 10 digits are taken into account.

Note

The records from the [Contacts] and [Accounts] section remain unchanged in the process of data standardization.

When conducting a duplicate search, bpm'online compares standardized field values for leads, contacts and accounts.

All types of phone numbers are compared when conducting a duplicate search: [Business phone], [Mobile phone], [Home phone]. For example a phone number of a contact can be registered as a business phone number in bpm'online, but while adding it to the database it can be registered as a home phone number.

If there are enough matches between several records, the records are marked as potential duplicates when the duplicate search results are displayed.

See also

How to search for duplicates when saving records

How to set up rules and schedule for a general duplicate search

Preconfigured duplicate search rules for contacts and accounts

Lead duplicate search

Manual merging of duplicate records

Did you find this information useful?

How can we improve it?