Data List

Data lists can contain any data. Usually this is additional information about the contact such as preferences, loyalty card info, order info, contest and survey answers, etc.  

They are 1-on-1 or 1-on-many linked to the Audience list.

  • With a 1-on-1 (1:1) linked list, the contact only has one record in the linked list.
  • With a 1-on-many (1:N) linked list, the contact can have many records in the linked list.

Only the ID of the record is predefined. All the other fields are custom. Below a small example of a profile extension (1:1) "Loyalty card" and a 1:N linked list "Orders"

Creating links between lists is defined in list 'relations'.

In this example, USERID is the foreign key on Customer ID and the relation is indicated by 'scope' name. For profile extensions (1:1),  you can use the scope name, which is LOYALTY_CARD in this case, to personalize your journey pages and emails. For instance: ~LOYALTY_CARD.POINTS~.

You cannot do this for 1:N linked lists, like "Orders" because the contact has multiple order records. You can use a "SQL container" to list the contacts orders on a journey page.

Back