Adobe Campaign comes with a pre-defined data model. This section gives some details on the built-in tables of the Adobe Campaign data model and their interaction. Adobe Campaign relies on a Cloud database containing tables that are linked together.
The basic structure of the Adobe Campaign data model can be described as follows:
Recipient table: The data model relies on a main table which is by default the Recipient table (nmsRecipient). This table enables to store all the marketing profiles.
💡 For more on the Recipient table, see this section.
Delivery table: The data model also includes a part dedicated to store all the marketing activities. Usually it is the Delivery table (NmsDelivery). Each record in this table represents a delivery action or a delivery template. It contains all the necessary parameters for performing deliveries such as target, content, etc.
Logs tables: These tables store all the logs associated with the execution of the campaigns.
Delivery logs are all messages sent to recipients or devices across all channels. The main Delivery logs table (NmsBroadLogRcp) contains the delivery logs for all recipients.
The main Tracking logs table (NmsTrackingLogRcp) stores the tracking logs for all recipients. The tracking logs refer to reactions of recipients, such as email openings and clicks. Each reaction corresponds to a tracking log.
Delivery logs and tracking logs are deleted after a certain period, which is specified in Adobe Campaign and can be modified. Therefore, it is highly recommended to export the logs on a regular basis.
Technical tables: Gather technical data used for the applicative process, including operators and user rights (xtkGroup), folders (XtkFolder).
To access the description of each table, go to Admin > Configuration > Data schemas, select a resource from the list and click the Documentation tab.
When starting with Adobe Campaign, you need to assess the default data model to check which table is the best suited to store your marketing data.
You can use the default Recipient table with the out-of-the-box fields, such as described in this section. If needed, you can extend it with two mechanisms:
💡 Discover best practices when working with Campaign datamodel in this section.
The built-in recipient table (nmsrecipient) in Adobe Campaign provides a good starting point for building your data model. It has a number of predefined fields and table links that can be easily extended. This is particularly useful when you are mainly targeting recipients, because it fits a simple recipient-centric data model.
The benefits of using the standard recipient table are:
It is possible to extend the recipient table, but not to reduce the number of fields or links in the table.
💡 Learn how to extend an existing schema in this section.
↗️ Discover examples of built-in recipient table extensions in Campaign Classic v7 documentation
You can also use a different recipient table to better fit with your business or functional requirements. This method comes with limitations and is described in this section.
For a better understanding of table management in Campaign v8, note that tables are replicated between Campaign and its Snowflake Cloud database.
💡 Learn more about replication strategy and mechanisms in this section.