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 stores all the marketing profiles. Learn more about the recipient table in this section.
Delivery table: This table stores one record per delivery action. Usually it is the Delivery table (NmsDelivery). 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. Each record is updated several times to reflect delivery progress
Logs tables: These tables store all the logs associated with the execution of the campaigns.
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), user sessions (xtkSessionInfo), folders in the explorer tree (XtkFolder), workflows (xtkWorkflow), and more.
To access the description of each table, browse to Administration > 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 pre-defined 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, in the context of an Enterprise (FFDA) deployment, tables are replicated between Campaign and its Snowflake Cloud database.
Learn more about replication strategy and mechanisms in this section.