Join ID in the customer data. For example, if the primary key, such as Product ID, is of string type, it can only be mapped to a Join ID of either string type or a list of strings. Note that if there is more than one attribute of a customer that needs to be enriched with this NCE data source, then you can include them by editing the enricher of the relevant NCE data source. To know more about how to configure this enricher, refer to Configuring the Join Key Enricher.
How to Identify the Join ID and Primary Key
You can select a user attribute from categories such as ID, User Traits, Product, Event, or Campaign as the Join Key (Join ID). To understand how to identify the Join ID in customer data and the Primary Key in non-customer data, consider the following example datasets:Customer Dataset (CE)
| CRM ID (Join ID) | Name | Phone Number | |
|---|---|---|---|
| 12345 | Jane Doe | jane.doe@email.com | 555-1234 |
| 67890 | John Smith | john.smith@email.com | 555-5678 |
Non-Customer Entity Dataset (NCE)
| CRM ID (Primary Key) | Order ID | Order Date | Total Amount |
|---|---|---|---|
| 12345 | ORD001 | 2024-01-01 | $250 |
| 67890 | ORD002 | 2024-01-15 | $400 |
| CRM ID | Name | Phone Number | Order ID | Order Date | Total Amount | |
|---|---|---|---|---|---|---|
| 12345 | Jane Doe | jane.doe@email.com | 555-1234 | ORD001 | 2024-01-01 | $250 |
| 67890 | John Smith | john.smith@email.com | 555-5678 | ORD002 | 2024-01-15 | $400 |