Sometimes your data is more complex and multiple records in each table can relate to multiple records in another table. This is where Many-to-Many relationships can help. Many-to-many relationships make use of a junction table to help relate your two objects together, which allows for more complex data relations.
A mapping table contains primary key columns from both related tables. This means it acts as an intermediary, creating a link between your two tables.
The resulting custom table allows flexible data connections. Instead of forcing a strict one-to-one or one-to-many structure, Many-to-Many tables enable more complex data relationships.
Examples of Many-to-Many tables: Parents may have multiple children, and those children share the same parents. Customers may purchase multiple products, and those products may be purchased by multiple customers.
Many-to-Many tables support segmentation, automation, and content merges. All data in Many-to-Many tables can be used to create more targeted and personalized campaigns.
Import data using CSV imports. This makes it easier to upload large datasets and ensure accurate data mapping.
Segment clauses ensure the correct data is used. When filtering contacts, it's essential to include a clause that correctly links Many-to-Many data.
Contact your Account Manager to get started. Many-to-Many tables cannot be created in the UI. Contacts success@delivra.com to get started with setup.
Availability depends on your license. Not all licenses have access to custom tables; it's important to verify license eligibility.