Review data unification

Review the summary of changes, create the unified profile, and review the results.

Review and create customer profiles

This last step in the unification process shows a summary of the steps in the process and provides a chance to make changes before you create the unified profile.

The following steps and images reflect the first time you go through the unification process. To edit existing unification settings, see Update the unification settings.

Screenshot of Review and create customer profiles.

  1. Select Edit on any of the data unification steps to review and make any changes.

  2. If you are satisfied with your selections, select Create customer profiles (or Create account profiles for B-to-B). The Unify page displays while the unified customer profile is being created.

    Screenshot of Unify page with tiles showing Queued or Refreshing.

    Tip

    There are statuses for tasks and processes. Most processes depend on other upstream processes, such as data sources and data profiling refreshes.

    Select the status to open the Progress details pane and view the progress of the tasks. To cancel the job, select Cancel job at the bottom of the pane.

    Under each task, you can select See details for more progress information, such as processing time, the last processing date, and any applicable errors and warnings associated with the task or process. Select the View system status at the bottom of the panel to see other processes in the system.

The unification algorithm takes some time to complete and you can't change the configuration until it completes.

View the results of data unification

After unification, the Data > Unify page shows the number of unified customer profiles (or account profiles for B-to-B). The results of each step in the unification process display on each tile. For example, Source fields shows the number of mapped attributes (fields) and Duplicate records shows the number of duplicate records found.

Screenshot of the Data Unify page after data is unified.

Tip

The Matching conditions tile displays only if multiple entities were selected.

We recommend you review the results, particularly the quality of your match rules and refine them if necessary.

When needed, make changes to the unification settings and rerun the unified profile.

Verify output entities from data unification

Go to Data > Entities to verify the output entities.

The unified customer profile entity, called Customer, displays in the Profiles section. The first successful unification run creates the unified Customer entity. All subsequent runs expand that entity.

Deduplication and conflation entities are created and display in the System section. A deduplicated entity for each of the source entities is created with the name Deduplication_DataSource_Entity. The ConflationMatchPairs entity contains information about cross-entity matches.

A deduplication output entity contains the following information:

  • IDs / Keys
    • Primary key and Alternate ID fields. Alternate ID field consists of all the alternate IDs identified for a record.
    • Deduplication_GroupId field shows the group or cluster identified within an entity that groups all the similar records based on the specified deduplication fields. It's used for system processing purposes. If there are no manual deduplication rules specified and system defined deduplication rules apply, you may not find this field in the deduplication output entity.
    • Deduplication_WinnerId: This field contains the winner ID from the identified groups or clusters. If the Deduplication_WinnerId is same as the Primary key value for a record, it means that the record is the winner record.
  • Fields used to define the deduplication rules.
  • Rule and Score fields to denote which of the deduplication rules got applied and the score returned by the matching algorithm.

Next Step