You are here:
Data Relationships
A data relationship in Email Studio specifies that a column in one data extension contains the same kind of information as a column in another data extension or in a subscriber attribute. Use a data relationship to relate two data extensions based on a common column contained in both data extensions. You can then apply a filter to the two data extensions and create a new segment of data.
Usually, the column is the primary key of one of the data extensions. For example, if you store an airport code as a subscriber attribute and create a data extension that contains airport names related to the airport codes, you would create a data relationship to declare that the airport code on the subscriber contains the same kind of information as the airport code in the data extension. This process allows the relationship to find the airport name by looking up the row in the data extension that contains the same airport code as the subscriber attribute.
You can relate multiple columns from each table to use multiple values to identify the correct row in the related table.
Before you create a data relationship, you must create the data extensions that are involved in the relationship. After you create a data relationship, you can include information from the data extension in messages to subscribers via a data filter.
- Create a Data Relationship in Marketing Cloud Engagement
Create a data relationship between data extensions in Email Studio. - Troubleshoot Marketing Cloud Engagement Data Relationships
Review this information to troubleshoot your data relationships for data extensions in Email Studio.
