Overview
The B2C Link Database is made up of consumers throughout the US and Canada. Each record has a first name, last name, home, and family.
Consumers are matched to the Places Database and linked to their workplace whenever possible. When linked, the workplace_id is attached to the record along with workplace details such as contact info, address, and primary line of business.
The workplace_id is blank on records that are not linked to a workplace. Records that are not linked can have workplace attributes, these are workplaces that did not match to the Places Database.
| first_name | last_name | home_id | home.city | workplace_id | workplace.name | emails.address | |
| Linked | Joe | Johnson | 987654321098 | Boise | 123456789 | Red Rock Cafe | joe@redrock.com |
| Not linked | Sara | Johnson | 654321098765 | Boise | (blank) | saraJ@email.com |
See also:
- Work Details
- Places Database - Data Guide
Home ID
Home ID is the primary key of the linked Home, and a persistent key for the person at a specific location. It can be used to find the associated Person in the People database.
See also:
Mapped Contact ID
Mapped Contact ID is a persistent ID assigned by legacy systems. It can be used to join Place contacts on contacts.mapped_contact_id.
See also
Contact ID
Contact ID is a persistent ID assigned by the Platform. Use it to join Place contacts on contacts.id.
See also
contact_id- The unique ID for the contact.
Name
A consumer's name is represented by the following attributes:
first_name- The first name of the individual.last_name- The last name of the individual.
Gender
Gender is predicted based on a consumer's first name.
gender- The gender of the individual.