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.
A custom table is a data structure composed of rows and columns used to store and organize data efficiently. Each row represents a record, and each record has a unique identifier, called a key, which links records across different tables. This allows for the expansion of contact information without modifying the standard database structure.
Standard tables store basic contact information within Delivra. These include default fields like name, email, and phone number, which are predefined and limited in number.
Custom tables extend the storage capacity, allowing for additional fields and relational data. Businesses can add specific data points that are not available in standard tables, making it easier to personalize campaigns and track custom metrics.
They enable the storage of multiple records per email address. Unlike standard tables, which typically store only one record per contact, custom tables allow for multiple records per email, which is useful for tracking repeated actions like purchases or event registrations.
Storing additional contact details when the default fields are insufficient. Custom tables can accommodate extra details such as multiple addresses, preferences, or behavioral data.
Tracking multiple transactions, orders, or event registrations per contact. Businesses that need to track repeat purchases, appointment history, or event attendance can store multiple records per contact.
Creating relational data connections to merge external data into campaigns. Custom tables make it possible to connect and use data from external sources, such as CRM systems, within marketing campaigns.
Custom tables are available based on your Delivra license. To determine if your license includes this feature, visit Delivra Pricing or contact the Client Success team for more information.