Using Many-to-Many Relational Tables in Delivra

Using Many-to-Many Relational Tables in Delivra

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.

How Many-to-Many Tables Work

  • 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.

Managing Many-to-Many Tables

  1. 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.

  2. Import data using CSV imports. This makes it easier to upload large datasets and ensure accurate data mapping.

  3. 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.

  4. 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.

  5. Availability depends on your license. Not all licenses have access to custom tables; it's important to verify license eligibility.

    • Related Articles

    • Examples of Using One-to-Many Tables in Segments

      This feature is currently only available in Legacy, but will be coming to Air soon! Creating precise audience segments is essential for relevant, data-driven messaging. With Delivra’s one-to-many data tables (often used for purchase history, product ...

    • Understanding & Creating Custom Tables

      Custom tables in Delivra are a flexible way to store and manage additional data beyond what’s available in standard contact records. Whether you're tracking multiple transactions per contact, managing complex relationships between data sets, or ...

    • Using Custom Tables in Delivra

      Custom tables solve various data challenges, allowing businesses to store and organize information effectively. By leveraging custom tables, companies can improve data management, enhance segmentation, and personalize marketing efforts. Key Use Cases ...

    • Populating your Custom Tables with data

      Importing data into custom tables is essential for keeping records up to date and integrating data from external sources. This section covers different import methods and best practices. Import Methods CSV Imports: This manual method allows users to ...

    • Frequently Asked Questions About Custom Tables

      Many users have common questions about custom tables in Delivra. This section addresses some of the most frequently asked questions and provides best-practice recommendations. Common Issues and Solutions Can I delete all data from a custom table? ...