Create a relational table query in an original email

Relational table queries are used to add relational table markup in emails.

1. Create and name the query.
   1. Go to Relational Tables.
   2. Select the relational table that you want to use.
   3. Click Create Table Query.
   4. Enter the name of your query in the Save Query As field.
   5. Click Browse to choose where to save the query.
   6. Click OK.

      The Query dialog box displays for editing the new query.

2. Define your query data.
   1. (Optional) Select the fields that can be used for personalization. Either individual or all fields in the relational table can be selected for personalization. You can also add or remove fields later by editing the query.
   2. When you are done constructing your query, you can either click Save or Save & Calculate to run the query.
   3. To save and calculate the query, insert relational table markup into your mailing template.
3. (Optional) Select the fields that can be used for personalization. Either individual or all fields in the Relational Table can be selected for Personalization. You can also add or remove fields later by editing the Query.
   1. Click the Fields Available for Personalization tab.
   2. If you have Org Admin rights you may select the Permission check box to allow others to select or de-select Personalization fields when creating a query.
   3. Select the fields.

      To make all fields available, select the Include all fields check box (do not click the Add button).

      To select individual fields for Personalization use, remove the selection from the Permission check box.

   4. Select individual fields (use the Shift + Alt keys for multiple selections) and click the Add button.
   5. Click Save.
4. When you’re done constructing your query, you can click Save or click Save and Calculate to run the query. If you run the query, take the following steps.
   1. Review the query summary information.

      If you want to revise your query, click the Query Summary breadcrumb.

   2. (Optional) Check Upon completion of the data job, send an email notification to the address below and enter your email to be notified when the query calculation data job is complete.
   3. Click the Submit button.
   4. Click the Data Job ID link to view the data job’s progress.

      when the data job is complete, you find the number of contacts in your relational table.

5. Insert relational table markup into your mailing template.
   1. Create a new template or go to an existing one.
   2. Click Settings > Contacts to assign a contact source to the mailing template.

      The contact source must have an association with the relational table where you built your query.

   3. Click Insert Relational Table Data in the top toolbar.
   4. Check the box next to your relational table query and click Select.
   5. Click Insert Markup to add lookup code, a basic HTML table, and personalization fields from your relational table. Edit the relational table markup as needed.
      Note: If you use a relational table query to retrieve a URL value for use as a link a in a mailing, the entire anchor <a> element for your link must be created using a Dynamic Link Leader (DLL). You cannot reference the href value for your link, for example: href="%%MY_URL_VALUE%%". If you do, Acoustic Campaign will rebuild and redirect the link with tracking information, and the resulting link will be incorrect in the actual mailing that is sent. If you format the href value in your link as href="%%MY_URL_VALUE%%" and use the Personalization function to test, the correct URL value is pulled in from the relational table but you receive a false positive where it appears to work correctly. However, after the mailing is sent, the link is incorrect.
   6. Click Submit.