List Deduplication and Incomplete Address Removal

General Information

This function enables you to "scrub" the current list of duplicate and/or incomplete addresses. In addition, in enables you to update the results of the list scrubbing back to your M.O.M. customer file. For example, if during the deduplication process, five John H. Smiths at 11 Willow Drive in Easton, PA are identified by M.O.M., you can update your customer file and have M.O.M. combine all five customer records into one single John H. Smith.

How it works

Finding Duplicates

Using a database parsing process, M.O.M. studies customer last name, street address, and ZIP code in combination to identify duplicates.

Finding Incomplete Addresses

M.O.M. searches for a combination of missing components.  For example, no last name or company name, no street address, or no city, state or ZIP code.

How to Use the Screens

Using the List De-Duplication Selection Screen

M.O.M. works with both address and customer name to determine duplicates and incomplete addresses.

Select the SELECT CRITERIA button to open the Select Fields to Include in LMM Dedupe screen.  After making these criteria selections, you will return to this screen, press the YES button to dedupe the list.

Hint: When performing a list deduplication using the COMPANY field as a criteria, M.O.M. will only combine customers having  both matching customer names AND company names.  Any matching customer names having no company name will not be included.

Using the De-Duplication Results Screen

This screen provides the counts on duplicates and incomplete addresses found during the deduplication process. The VIEW LIST buttons enable you to see and/or print the names/addresses identified as either incomplete and/or duplicate. The VIEW NAMES button enables you to select which duplicate names are master and duplicate by checking the M for master and the D for duplicate or to remove the names from the dedupe process by unchecking the name.  The ORIGINAL LIST SIZE field provides a count on the list prior to the deduplication process. The RESULT LIST SIZE provides the total count after the duplicate and incomplete addresses are removed from the original list.

UPDATE CUSTOMER FILE WITH RESULTS - check this box to have M.O.M. update your customer file with the results of the deduplication process. Duplicate customer records will be combined in the customer file. Incomplete addresses are marked as expired.

Note: To permanently remove incomplete addresses after they are marked as expired, the Database Purge Module must be used.

Press OK to accept the results and correct the query and/or list counts accordingly. If you elected to update your customer file with the results, OK also processes the update.

Press CANCEL to exit without accepting, updating counts or processing the optional update.

Other Information

"Scrubbing" Your Entire Customer File

If you want to eliminate duplicates and incomplete addresses from your entire customer file, use an Include function to create a list of all customers and prospects in your database. (Use the All Names option under Include, Names by...) Then, de-duplicate the list using the De-duplicate List function.

Finally, use the UPDATE CUSTOMER FILE WITH RESULTS option to automatically combine duplicates and mark incomplete addresses as expired for your entire customer file.

Note: To permanently remove incomplete addresses after they are marked as expired, the Database Purge Module must be used.