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

      In this article you will find examples of how-to build complex segments using one-to-many data tables. If you need help or have additional questions about building segments in your account you can email our Support team. Question: How do I get ...
    • 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 ...
    • Introduction to Custom Tables in Delivra

      Custom tables in Delivra provide a flexible way to store and manage structured data beyond the default contact record. This article introduces the concept of custom tables, their benefits, and when they should be used. What is a Custom Table? A ...
    • How to Create and Manage Custom Tables

      How to Create and Manage Custom Tables in Delivra Creating a custom table in Delivra allows users to extend their contact data and better manage structured information. This section provides a step-by-step guide to creating and managing custom tables ...
    • 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 ...