Creating a database template for FCI

Use the following procedure to create a database template for an FCI Email.

About this task

Acoustic Campaign uses database templates to leverage the fastest possible contact upload and email sending in the Fast Campaign Integration with Unica Campaign. A database template is defined in Acoustic Campaign as a database created in Acoustic Campaign that contains no contacts, but contains the fields that are used for template personalization, dynamic content rule building, and more. This database must be flexible, keyed databases cannot be used as a database template.

You must have access to the Acoustic Campaign UI to create a database template.

Procedure

  1. On the Data tab of the Acoustic Campaign UI, navigate to Database > Create
  2. Ensure that Campaign Integration Database Template is selected as the type of database that you would like to create.
  3. In the Database or List Name field, designate the name of the database template. It is best practice to prefix the name with the acronym FCI so that it is distinguishable from other databases and so that it can be identified as belonging to the Fast Campaign Integration.
  4. Under Where would you like your database or list to be saved?, you must select Shared or a folder within Shared.
  5. Click Next.
  6. Add a field for any data attribute you wish to use.
    1. Type a name in the Field Name field.

      Field names are required and cannot be changed after the database is saved. If you make a mistake, you must delete the field and create a new one.

    2. Select a field type from the list.

      You can create up to 400 fields in any combination of field types. However, it is recommended that your create no more than 255 field types.

    3. Click Add Field.

      The new field appears in the list of fields. Edit or delete fields by clicking the Edit link next to the new field name. Add as many fields as you need.

    4. Add a text field called campaignAudienceId
  7. Click Save and then Create to continue.
  8. Designate the campaignAudienceId field as a Lookup Key field.
    1. Go to View Data.
    2. Select the database you want to use.
    3. Click Settings.
    4. Click LookUp Keys.
    5. In the Status column, check the box next to campaignAudienceId.

      After you select Save, the screen refreshes to the Database > Fields tab. A magnifying glass icon displays next to the lookup field.

    6. Click Save.

What to do next

Create a campaign specific to the Fast Campaign Integration. For more information about creating a campaign, see Creating a campaign in FCI