AutoMerge Management Application User Guide

The AutoMerge Management Application is an xRM model-driven application built on the same Dynamics platform as your CRM. The Management App is where you define your duplicate matching rules. Using those rules, you can submit requests to analyze for and tag duplicates in your CRM.

Table of Contents

Getting Access

Access to the Management Application is for paid AutoMerge subscribers only. Contact us if you are interested in starting a trial.

Once you receive an invitation to connect to the AutoMerge Management Application, go to https://automerge.crm4.dynamics.com. Enter your usual Office 365 username and your password on the subsequent domain specific page.

AMA Log In
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

Viewing Your Customer Profile

Once you log in to the AutoMerge Management Application, you will see your customer record.

Contoso on Active Customers view
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

Click your customer record to open your organization’s main profile. Your organization’s main profile should include your organization name, contact email address, mobile number for notifications, and a default CRM connection to use for new requests.

Contoso Profile
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

Connecting to Your CRM

The CRM connection form is where you give the AutoMerge Service access to your CRM system. Here, you can define multiple connections to your Sandbox organizations and one connection to your Production organization.

On the CRM connection form, only the “Name” and “Purpose” fields are editable. Most fields are automatically edited via the “VERIFY URL,” a feature which gathers credentials securely and verifies that they work.

To edit an already-verified connection or to remove credentials, check the “Clear Credentials” checkbox and then click “Save.” Click the “VERIFY URL” to edit the connection.

Connection Info
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

With the exception of the password, all connection information is stored directly on the record. The password itself is encrypted and stored securely elsewhere. 

To create a new CRM Connection, simply go back to your Customer profile record and click the “+ New CRM Connections” button.

If you have trouble connecting your CRM, it might be due to Multi-Factor Authentication.

Connection Verified URL
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

Editing Matching, Ranking, Precision Configurations

When AutoMerge service does the analysis for duplicates, it follows a set of rules that are kept together in a single configuration record.

The five parts of a configuration are:

  1. The Entity under analysis. (i.e. Contact)
  2. Custom FetchXML statement that determines which records should be analyzed. This can be generated from CRM’s Advanced Find tool. If this is left blank, all active records of the Entity are used.
  3. A set of Matching Rules. These are used in a specific order to find duplicates in your CRM.
  4. A set of Ranking Rules. These are used to sort the members of the duplicate sets found in #3.
  5. A set of Precision Rules that feed an algorithm that gives the resulting duplicate sets a number from 0-100 based on how closely matched the members of each duplicate set are.

With the exception of the Custom FetchXML statement, all of the above is required for a successful analysis. These configurations are also fully customizable. 

Detailed View of the Five Configurations

To better understand the five configurations from above, we will take you through the “Contact-XXXXXXXX” record.

In this record, the GENERAL tab includes:

  • The Entity Definition (stored in a separate object). Within the entity definition is a list of all fields needed for the matching/ranking/precision rules.
  • An optional FetchXML Filter. Open “Advanced Find” in your CRM, add some filters, export the FetchXML text, and paste it in here.
    • In this example, we list all contacts whose parent account is in the Consumer Services industry. If submitting a request using this configuration, only those contacts would be analyzed.

NOTE: In addition to the FetchXML Filter above, the CRM user that is configured in the CRM connection may be limited by its security roles and hence may further filter which records are analyzed during requests.

Image showing General Tab
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

The MATCHING tab has a list of rules used to find duplicates during analysis. Any number of rules can be defined, but ultimately each duplicate record can only belong to a single match set. The rules are applied in order according to the precedence number in the second column. The “Match Type Name” in the third column is how the duplicate sets are categorized in your CRM after tagging.

Image showing Matching Tab
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

The RANKING tab has a list of rules used to sort the resulting members of a duplicate set. This is important because the record that “wins” (where Rank is #1) the AutoMerge operation in your CRM will remain. All the other records of the set (where Rank is >1) will be deactivated. 

Automatic Field-Preservation: During an AutoMerge of a duplicate set, any un-populated fields in the winner record will be filled in by values found in the losing records. This is simple “Non-NULL replaces a NULL” logic. More complex decision-based field preservation logic is possible using workflow rules.

In the Customer-XXXXXXXX record, we created a Ranking Rule in the “customertypecode” field to ensure contacts of particular type (i.e. “Customer”) are ranked better than other types (i.e. “Vendor.”) In other words, a customer contact will always win an AutoMerge over a vendor contact. If the first rule doesn’t differentiate all duplicates in every set, the second rule will apply and give preference to the most recently modified contact.

TIP: Matching, Ranking, and Precision rules can also be based on fields from N:1 related records such as a contact’s parent account. Consider ranking duplicate contacts based on their parent account’s owner.

Image showing Ranking Tab
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

The PRECISION tab shows the matching rules (“schemanames”) that are weighted together to give the duplicate sets a number from 0-100 based on how closely matched the members of each duplicate set are.

Image showing Contact Precision Tab
AutoMerge Contacts Dashboard View in Microsoft Dynamics 365 CRM

Come back soon! We are constantly updating our AutoMerge Management Application User Guide!

Check out our other resources!

Still Have Questions?

Contact us at (503) 914-6304 or email us at sales@genbil.com.

Copyright © 2020 AutoMerge