Source Dataset Requirements for the Contacts Data Product

The Contacts data product includes a predefined, standardized schema for contact data. When you add data to your data product, you identify how columns in your source datasets correspond to the attributes in the unified schema.

To prepare, review the general Requirements for Source Datasets.

The table below describes these attributes and explains which are:

  • Required: You cannot refresh your data until you map source columns to these attributes.
  • Suggested: For optimal enrichment and clustering results, map source columns to these attributes.
  • Optional: These attributes have minimal impact on your clustering and enrichment results. If your source data includes columns that match these attributes, map them to include that source data in your completed data product.

Attributes Other than Addresses

Note that the matching model can use either the combination of first and family name values or full name values, whichever is mapped from the source data.

Unified Attribute Description Type
Primary Key The primary key used in the source dataset to uniquely identify each record. See About Primary Keys for more information. Required
Name Prefix The contact's prefix, such as Ms. or Mr. Optional
First Name The contact's first name. Optional
Middle Name The contact's middle name. Optional
Family Name The contact's last name. Optional
Full Name The contact's full name. Optional
Name suffix The contacts's suffix, such as Jr. or Senior. Optional
Professional Title The contact's professional title. Suggested
Email The contact's email address. Suggested
Phone The contact's phone number. Suggested
Alternative Phone The contact's alternate phone number. Optional
Organization Name The name of the contact's organization or business. Suggested
Organization Alternative Names The alternate name of the contact's organization or business. Optional
Organization Website The website or url of the contact's organization or business. Optional

Address Attributes

You can configure multiple address types in the Contacts data product. Address attributes are organized into different groups, representing different types of addresses associated with the contactss.

The data product schema includes Primary address attributes by default. You can choose to include attributes for additional address types, including: office, corporate, previous, mailing, shipping, registered, billing, and other addresses.

Within an attribute group, the attribute name is prefixed with the address type. For example: Primary: Address, Billing: City, and Mailing: Country.

Each attribute group includes the following address attributes:

Unified Address Attribute Description Type
Address Either line 1 of the address, or the complete address. Suggested for primary address. Optional for other address types.
Address Line 2 Line 2 of the address. Optional
City City of the address. Optional
State The state or region of the address. Optional
Postal Code Postal (zip) code of the address. Optional
Country Country of the address. Suggested for primary address. Optional for other address types.
Latitude The latitude of the address. Optional
Longitude The longitude of the address. Optional