Target mapping target-mapping

Create a new data schema which integrates the fields of the custom table that you want to use.

For further information, refer to Schema reference (xtk:srcSchema).

In our example, we will create a customer schema, a very simple table containing the following fields: ID, first name, last name, email address, mobile phone number. The aim is to be able to send email or SMS alerts to the individuals stored in this table.

Example schema (cus:individual)

<srcSchema name="individual" namespace="cus" label="Individuals">
  <element name="individual">
    <key name="id" internal="true">
      <keyfield xpath="@id"/>
    </key>
    <attribute name="id" type="long" length="32"/>
    <attribute name="lastName" type="string" length="100"/>
    <attribute name="firstName" type="string" length="100"/>
    <attribute name="email" type="string" length="100"/>
    <attribute name="mobile" type="string" length="100"/>
  </element>
</srcSchema>

Declare your schema as an external view using the =“true” attribute. Refer to The view attribute.

 <srcSchema desc="External recipient table" namespace="cus" view="true"....>
   ...
 </srcSchema>

If you need to add a direct mail address, please use the following type of structure:

<element advanced="true" name="postalAddress" template="nms:common:postalAddress">
     <attribute expr="SubString(JuxtWords(Smart([../infos/@firstname]), Upper([../infos/@name])), 1, 80)"
                name="line1"/>
     <attribute expr="Upper([../address/@line2])" name="line2"/>
     <attribute expr="Upper([../address/@line])" name="line3"/>
     <attribute expr="Upper([../address/@line])" name="line4"/>
     <attribute expr="Upper([../address/@line])" name="line5"/>
     <attribute expr="Upper([../address/@line])" name="line6"/>
     <attribute _operation="delete" name="line7"/>
     <attribute _operation="delete" name="addrErrorCount"/>
     <attribute _operation="delete" name="addrQuality"/>
     <attribute _operation="delete" name="addrLastCheck"/>
     <element expr="@line1+'n'+@line2+'n'+@line3+'n'+@line4+'n'+@line5+'n'+@line6"
              name="serialized"/>
     <attribute expr="AllNonNull2([../address/@line], [../infos/@name])" name="addrDefined"/>
   </element>

Click the Administration > Campaign management > Target mappings node.

Click the New button to open the target mapping creation wizard.

Enter the Label field and select the schema which you have just created in the Targeting dimension field.

In the Edit address forms window, select the fields of the schema which match the various delivery addresses. Here, we are able to map the @email and @mobile fields.

In the following Storage window, enter the Suffix of the extension schemas field to differentiate the new schemas from the out-of-the-box schemas provided by Adobe Campaign.

Click Define new additional fields to select the dimension you want to target in your delivery.

By default, exclusion management is stored in the same table as messages.

Check the Generate a storage schema for tracking box if you want to configure storage for the tracking linked to your target mapping.

In the Extensions window, select the optional schemas that you want to generate (the list of available schemas depends on the modules installed on the Adobe Campaign platform).

Click the Save button to close the wizard.

The wizard uses the start schema to create all the other schemas required to make the new target mapping work.