Data cleaning

Modified on Tue, 30 May, 2023 at 12:10 PM

Overview



The data cleaning section enables you to find and merge duplicate entries within your contacts and pools lists.

Finding duplicates
Step 1: Select all options in the "Filter" section. This will show any records that match on all this criteria


 Step 2: Gradually switch off different combinations of filters and check your results.


Merging duplicates
Once you have found duplicates, you can start to merge them together

Set as primary: The first record in the list will be chosen as the primary, however you can assign which record you would like to be the master using this function.

Ignore: This will remove the contact from the list, so it will not be deduplicated.

Edit data: You can edit the primary record data to dictate what the final deduplicated record looks like.

Merge: Once you are ready, you can click "Merge" which will combine all the chosen records, into a single record. All the associated records, such as quotes and invoices, will be moved to the primary record.

Automatic de-duplication

IMPORTANT:

We recommend using the manual deduplication tool, and identifying the best rule before using this function. You cannot undo this action, so you need to make sure that anything that will be merged, should be merged.

Clicking the Automatic de-duplication button will show you the same filters you can see in the manual de-duplication section. Once you have chosen the filters, you can proceed. You will not be given the choice as to which data to retain per record group, it will default to the first record in the group.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article