After importing the data into the data table, the next step is to create the database field to which the table itself will be linked.
Navigate to the database where you intend to create the field following the path:
Profile Studio >> Database Name >> Settings >> Contact Fields
- Click the Create Field button
- Define the category and label
- Navigate to the Data Type tab and select 1 to 1 Association or 1 to Many Association according to your needs; in the case of orders, we select 1 to many as a contact can place multiple orders.
- Select the relevant data table
- Check the option Use an association data table and select the corresponding table
- If your table includes Contact ID, enter the name of the column (in the created example it is contactemail)
- Enable the option "The contact ID field contains the contact key instead of the ID" if the data table field you have indicated for the contact ID contains the contact key (for example, the email) instead of the ID.
- The association table you have selected must include a field that contains the ID reference to the table you have chosen in "Associate 1 contact with multiple items of".
Indicate here the name of this field.
After creating the field, proceed to import the contacts into the database, populating the Orders field with the ID corresponding to the order linked to each contact.
Once the import is complete, you can create filters or dynamic audiences by crossing the information in your database with those contained in the table linked to it.
For example: to filter for everyone who has made at least one order, we can apply the following filter Orders >> Want >> is Populated
Next article