About the RealTime B2B Customers Data Product
Limited ReleaseRealTime 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 B2B Customers data product provides a consolidated view of businesses at the granularity of individual sites (headquarters versus satellite offices, for example).
This data product provides:
- An industry-standard schema for company data.
- A pre-trained matching configuration to identify duplicate company 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.
B2B Customers Schema, Match Logic, and Default Consolidation Rules
Single Attributes
| Attribute | Used In Matching | Default Record Consolidation Rule |
|---|---|---|
| Primary Key (required) | no | Not applicable |
| Company Name (required) | yes | Most common Company name Final value condition: Smallest value |
| Alternative Names | yes | List of distinct Alternative Names |
| Previous Names | yes | Most common Previous Name Final value condition: Smallest value |
| Revenue | no | Most common Revenue Final value condition: Smallest value |
| Company Type | no | Most common Company Type Final value condition: Smallest value |
| Industry Type | no | Most common Industry Type Final value condition: Smallest value |
| Founding Year | no | Most common Founding Year Final value condition: Smallest value |
| Registration Number | yes | Most common Registration Number Final value condition: Smallest value |
| Registration Number Type | no | Most common Registration Number Type Final value condition: Smallest value |
| Tax Ids | yes | Most common Tax Id Final value condition: Smallest value |
| Ticker Symbol | yes | Most common Ticker Symbol Final value condition: Smallest value |
| Stock Exchange | no | Most common Stock Exhange Final value condition: Smallest value |
| Email Domain | yes | Most common Email Domain Final value condition: Smallest value |
| Website | yes | Most common Website Final value condition: Smallest value |
| Associated Persons | no | Most common Associated Person 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 |
|---|---|
| Address (Map source fields with address line 1 or complete address to this field) | yes |
| Address Line 2 | yes |
| Address Line 3 | no |
| Address Line 4 | no |
| City | yes |
| State | yes |
| Country | yes |
| Latitude | no |
| Longitude | no |
Default consolidation rule for all addresses:
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
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 |
|---|---|
| Phone | yes |
| Alternative Phone | yes |
Default consolidation rule for all phones:
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
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 |
|---|---|---|
| yes | Most common Email Final value condition: Smallest value |
Updated about 16 hours ago