Data tables help you link your contacts' information to external data without having to add too much information directly into the contact database. This way, you can keep the database well organized and easy to manage.
Consider, for example, a contact's purchases:
- The database hosts the contact's basic information, such as first name, last name, country;
- The data table contains information for each order placed by the contact, such as order number, total value, purchase date.
Solution without a data table
One possible data organization, without a data table, involves storing purchase information directly on the customer’s contact record. It's a simple yet limiting solution: contact records can efficiently manage summary data, such as the date of the last purchase, but not detailed information.
Solution with a data table
In a more structured approach, a table containing order details is associated with contacts, and a link between contacts and orders is created. This solution allows maintaining the depth of information and enables the creation of audiences even on the data of the linked table.