About the RealTime B2C Customers Data Product

👋
Limited Release
RealTime data products are in limited release. Some functionality is still in development and is subject to change. If you are interested in using these data products, contact Tamr Support ([email protected]).

The RealTime B2C Customers data product provides a 360-degree view of your individual customers, and ensures that you have the most complete and up-to-date information for use in marketing campaigns and other communications targeting individuals.

This data product provides:

An industry-standard schema for B2C customer data.
A pre-trained matching configuration to identify duplicate customer records.
Default rules to determine the best values for your golden records. These rules also include a final value condition as a tiebreaker if rules resolve to multiple values.

B2C Customers Schema, Match Logic, and Default Consolidation Rules

Single Attributes

Attribute	Used in Matching	Default Record Consolidation Rule
Primary Key (required)	no	Not applicable
Full Name (required if First and Family Names are not provided)	yes	Most common Full Name Final value condition: Smallest value
First Name	yes	Most common First Name associated with the most common Full Name Final value condition: Smallest value
Middle Name	no	Most common Middle Name associated with the most common Full Name Final value condition: Smallest value
Family Name	yes	Most common Family Name associated with the most common Full Name Final value condition: Smallest value
Name Suffix	no	Most common Name Suffix value associated with the most common Full Name Final value condition: Smallest value
Date of Birth	yes	Most common Date of Birth Final value condition: Smallest value
Gender	yes	Most common Gender Final value condition: Smallest value
National Id	yes	Most common National Id Final value condition: Smallest value

Address Attributes

The data product schema includes Primary address attributes by default. You can choose to include attributes for additional address types, including:

Secondary
Office
Corporate
Previous
Mailing
Shipping
Registered
Billing
Other

Each address type includes the following attributes:

Address Attribute	Used in Matching	Default Record Consolidation Rule
Address (Map source fields with address line 1 or complete address to this field)	yes	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 non-null Country. If the most common value is null, THEN The most common Address Line 2. Final value condition: Smallest value
Address Line 2	yes
Address Line 3	no
Address Line 4	no
City	yes
State	yes
Country	yes
Latitude	no
Longitude	no

Phone Attributes

The data product schema includes Primary phone number attributes by default. You can choose to include attributes for additional phone number types, including:

Secondary
Office
Corporate
Previous
Other
Primary Fax
Secondary Fax

Each phone type includes the following attributes:

Phone Attribute	Used in Matching	Default Record Consolidation Rule
Phone	yes	For all phone attributes in the phone group, Tamr selects the golden record values from the single source record with the most common value for Phone Final value condition: Smallest value
Alternative Phone	yes

Phone Attribute

Used in Matching

Default Record Consolidation Rule

Phone

yes

For all phone attributes in the phone group, Tamr selects the golden record values from the single source record with the most common value for Phone

Final value condition: Smallest value

Alternative Phone

yes

Email Attributes

The data product schema includes Primary email address attributes by default. You can choose to include attributes for additional email address types, including:

Secondary
Office
Corporate
Previous
Other

Each email type includes the following attributes:

Email Attribute	Used in Matching	Default Record Consolidation Rule
Email	yes	Most common Email Final value condition: Smallest value

Email Attribute

Used in Matching

Default Record Consolidation Rule

yes

Most common Email

Final value condition: Smallest value