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
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: The most common non-null Address. If the most common value is null, THEN The most common non-null City. If the most common value is null, THEN The most common non-null State. If the most common value is null, THEN The most common non-null Postal Code. If the most common value is null, THEN The most common Country.
<PhoneGroup>: Phone	Most common value
<EmailGroup>: Email	Most common value
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
Date of Birth	Most common value
Gender	Most common value
National ID	Most common value
<AddressGroup>: Address <AddressGroup>: Address Line 2 <AddressGroup>: City <AddressGroup>: State <AddressGroup>: Postal Code <AddressGroup>: Country <AddressGroup>: Latitude <AddressGroup>: Longitude <AddressGroup>: Mail Consent Status <AddressGroup>: Mail Consent Date	For all address attributes in the address group, Tamr selects the golden record values from the single source record by first filtering to the records with the most recent mail consent date and then selecting the record with: The most common non-null Address. If the most common value is null, THEN The most common non-null City. If the most common value is null, THEN The most common non-null State. If the most common value is null, THEN The most common non-null Postal Code. If the most common value is null, THEN The most common Country.
<PhoneGroup>: Phone <PhoneGroup>: SMS Consent Status <PhoneGroup>: SMS Consent Date <PhoneGroup>: Voice Consent Status <PhoneGroup>: Voice Consent Date	For all phone attributes in the phone group, Tamr selects the golden record values from the single source record by first filtering to the most recent overall consent date considering both SMS and voice consent (ignoring nulls), and then selecting the most common phone value (ignoring nulls).
<EmailGroup>: Email <EmailGroup>: Consent Status <EmailGroup>: Consent Date <EmailGroup>: Delivery Status	For all email attributes in the email group, Tamr selects the golden record values from the single source record by first filtering to the most recent overall consent date considering (ignoring nulls), and then selecting the most common email value (ignoring nulls).
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
<AddressGroup>: Address <AddressGroup>: Address Line 2 <AddressGroup>: City <AddressGroup>: State <AddressGroup>: Postal Code <AddressGroup>: Country <AddressGroup>: Latitude <AddressGroup>: Longitude <AddressGroup>: Mail Consent Status <AddressGroup>: Mail Consent Date	For all address attributes in the address group, Tamr selects the golden record values from the single source record by first filtering to the records with the most recent mail consent date and then selecting the record with: The most common non-null Address. If the most common value is null, THEN The most common non-null City. If the most common value is null, THEN The most common non-null State. If the most common value is null, THEN The most common non-null Postal Code. If the most common value is null, THEN The most common Country.
<PhoneGroup>: Phone	Most common value
<EmailGroup>: Email	Most common value
Professional Title	Most common value
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
LinkedIn URL	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
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_1-20>: Number <License_1-20>: State <License_1-20>: Country <License_1-20>: Status	For each attribute, pipe-delimited array of distinct values.
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: The most common non-null Address. If the most common value is null, THEN The most common non-null City. If the most common value is null, THEN The most common non-null State. If the most common value is null, THEN The most common non-null Postal Code. If the most common value is null, THEN The most common Country.
<PhoneGroup>: Phone	Most common value
<EmailGroup>: Email	Most common value
Custom attributes	Most common value