As an open solution, Adobe Campaign is ready for customization and advanced applications development.
The conceptual data model of the Adobe Campaign database consists in a set of built-in tables and their interaction. The physical and logical structure of the data carried in the application is described in XML. It obeys a grammar specific to Adobe Campaign, called a schema. For more on Adobe Campaign schemas, refer to this section.
Best practices are listed in this article.
In Adobe Campaign, data schemas are used to:
Read out the Tables and schemas getting started to understand how to work with data schema, extend and customize Campaign to address your needs.
You can create and implement a non-built-in recipient table in Campaign to send your messages.
Adobe Campaign query editor is a powerful tool to explore data and build segments.
The Adobe Campaign query tool can be found on multiple levels of the software: to create a target population, segment customers, extract and filter tracking logs, build filters, etc.
You can query Campaign database using the generic query editor. It is accessed via the Tools > Generic query editor… menu. It lets you extract information stored in a database and organize, group, sort, etc. For instance, the user can recover recipients who clicked more than ‘n’ times on the link of a newsletter over a given period. This tool lets you collect, sort and display results based on your needs. This tool combines all Adobe Campaign querying possibilities. For instance, it lets you create and save restriction filters. This means that a user filter created in the Generic query editor can be used in the Query box of a targeting workflow, etc.
Queries are created using fields of the selected table or using a formula. Main principles to create a query on Campaign database are described in this page.
Click here to discover Campaign query editor.
Adobe Campaign allows you to export or import the platform configuration and data through a package system. Data packages let entities of the Adobe Campaign database be displayed via files in XML format. Each entity contained in a package is represented with all of its data.
The principle of data packages is to export a data configuration and integrate it into another Adobe Campaign system.
Click here to learn how to work with data packages to import and export Campaign configurations.
All Campaign APIs including their full description is available in this dedicated documentation.