Tamr Recommended Record Consolidation Rules

For each attribute in the predefined data product schema, you can choose to use the Tamr recommended record consolidation rule, as described in the tables below, or set a custom rule.

Note: In the event of a tie, the value with the least lexicographic value is selected. This means the value that comes first alphabetically is chosen. Upper case letters are of lower lexicographic value than lower case letters, so MAIN ST is of lower lexicographic value than Main St.

B2B Customers Tamr Recommended Rules

The following table describes the Tamr recommended record consolidation rules for the attributes in the B2B Customers data product.

Attribute Tamr Recommended Rule
Company Name Most common value
Alternative Names Pipe-delimited array of distinct values from the Company Name and Alternative Names attributes, excluding the value selected for the Company Name attribute
Previous Names Most common value
Revenue Most common value
Company Type Most common value
Industry Type Most common value
Founding Year Most common value
Phone Most common value
Registration Number Most common value
Tax IDs Most common value
Ticker Symbol Most common value
Stock Exchange Most common value
Email Domain Most common value
Website Most common value
Associated Person Most common value

<AddressGroup>: Address

<AddressGroup>: Address Line 2

<AddressGroup>: City

<AddressGroup>: State

<AddressGroup>: Postal Code

<AddressGroup>: Country

<AddressGroup>: Latitude

<AddressGroup>: Longitude

For all address attributes in the address group, Tamr selects the golden record values from the single source record with:

  1. The most common non-null Address. If the most common value is null, THEN
  2. The most common non-null City. If the most common value is null, THEN
  3. The most common non-null State. If the most common value is null, THEN
  4. The most common non-null Postal Code. If the most common value is null, THEN
  5. The most common Country.
Custom attributes Most common value

B2C Customers Tamr Recommended Rules

The following table describes the Tamr recommended record consolidation rules for the attributes in the B2C Customers data product.

Attribute Tamr Recommended Rule
Name Prefix Most common value associated with the most common full name
First Name Most common value associated with the most common full name
Middle Name Most common value associated with the most common full name
Family Name Most common value associated with the most common full name
Full Name Most common value
Name Suffix Most common value associated with the most common full name
Data of Birth Most common value
Gender Most common value
Email Most common value
Phone Most common value that was successfully enriched by the Phone Number data quality service
National ID Most common value

<AddressGroup>: Address

<AddressGroup>: Address Line 2

<AddressGroup>: City

<AddressGroup>: State

<AddressGroup>: Postal Code

<AddressGroup>: Country

<AddressGroup>: Latitude

<AddressGroup>: Longitude

For all address attributes in the address group, Tamr selects the golden record values from the single source record with:

  1. The most common non-null Address. If the most common value is null, THEN
  2. The most common non-null City. If the most common value is null, THEN
  3. The most common non-null State. If the most common value is null, THEN
  4. The most common non-null Postal Code. If the most common value is null, THEN
  5. The most common Country.
Custom attributes Most common value

Contacts Tamr Recommended Rules

The following table describes the Tamr recommended record consolidation rules for the attributes in the Contacts data product.

Attribute Tamr Recommended Rule
Name Prefix Most common value associated with the most common full name
First Name Most common value associated with the most common full name
Middle Name Most common value associated with the most common full name
Family Name Most common value associated with the most common full name
Full Name Most common value
Name Suffix Most common value associated with the most common full name

Address

Address Line 2

City

State

Postal Code

Country

Latitude

Longitude

Address Type

For all address attributes, Tamr selects the golden record values from the single source record with:

  1. The most common non-null Address.
    If the most common value is null, THEN
  2. The most common non-null City.
    If the most common value is null, THEN
  3. The most common non-null State.
    If the most common value is null, THEN
  4. The most common non-null Postal Code.
    If the most common value is null, THEN
  5. The most common Country.
Professional Title Most common value
Email Most common value
Phone Most common value that was successfully enriched
Alternative Phone Most common value that was successfully enriched
Organization Name Most common value
Organization Alternative Names Pipe-delimited array of distinct values from the Organization Name and Organization Alternative Names attributes, excluding the value selected for the Organization Name attribute
Organization Website Most common value
Custom attributes Most common value

Healthcare Providers Tamr Recommended Rules

The following table describes the Tamr recommended record consolidation rules for the attributes in the Healthcare Providers data product.

Attribute Tamr Recommended Rule
NPI Most common value
Full Name Most common value
First Name Most common value associated with the most common full name
Middle Name Most common value associated with the most common full name
Family Name Most common value associated with the most common full name
Name Prefix Most common value associated with the most common full name
Name Suffix Most common value associated with the most common full name
Gender Most common value
Phone Most common value
Email Most common value
Date of Birth Most common value
Organization Name Pipe-delimited array of distinct values from the Organization Name attribute
Credentials Pipe-delimited array of distinct values from the Credentials attribute
Degree Most common value
Graduation Year Most common value
License Number Pipe-delimited array of distinct values from the License Number attribute
License State Pipe-delimited array of distinct values from the License State attribute
License Status Most common value
Provider Speciality Pipe-delimited array of distinct values from the Provider Speciality attribute

<AddressGroup>: Address

<AddressGroup>: Address Line 2

<AddressGroup>: City

<AddressGroup>: State

<AddressGroup>: Postal Code

<AddressGroup>: Country

<AddressGroup>: Latitude

<AddressGroup>: Longitude

For all address attributes in the address group, Tamr selects the golden record values from the single source record with:

  1. The most common non-null Address. If the most common value is null, THEN
  2. The most common non-null City. If the most common value is null, THEN
  3. The most common non-null State. If the most common value is null, THEN
  4. The most common non-null Postal Code. If the most common value is null, THEN
  5. The most common Country.
Custom attributes Most common value