Get started with Campaign data model gs-ac-datamodel
۶Ƶ Campaign comes with a pre-defined data model. This section gives some details on the built-in tables of the ۶Ƶ Campaign data model and their interaction. ۶Ƶ Campaign relies on a Cloud database containing tables that are linked together.
The basic structure of the ۶Ƶ 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 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 nmsBroadlog table is the largest table in the system. It stores one record per message sent, and these records are inserted, updated to track the delivery status, and deleted when the history is purged.
- 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 ۶Ƶ 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.
When starting with ۶Ƶ 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:
- Extend an existing table with new fields. For example, you can add a new “Loyalty” field to the Recipient table.
- Create a new table, for example a “Purchase” table listing all the purchases made by each profile of the database, and link it to the Recipient table.
Discover best practices when working with Campaign data model in this section.
Built-in profile table ootb-profiles
The built-in recipient table (nmsrecipient) in ۶Ƶ 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:
- Working out-of-the-box with key functionalities such as subscriptions, seed lists, and more
- Providing a marketing database with a recipient-centric data model
- Faster implementation
- Easy maintainance by support and partners
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.
Campaign tables and Cloud database
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.
Related topics
Discover how to import profiles in this section
Learn more about Campaign audiences in this section