After the relational table is added to Acoustic Campaign, you can create queries to send emails that target your customers.

1. Create a query based on the relational table data.
2. Include Acoustic Digital Analytics or Adobe™ Analytics relational table data in an Campaign email.
3. After the query is created, it's time to insert the relational table data into Campaign email.

Complete the following steps to create a query using the relational table data.

1. From the Edit Mailing Template page, go to the Mailing Body tab to edit your email.
2. Create a relational table query within the email. This query will define what content will go in the email. Click the Relational Table icon.
3. Select Create Relational Table Query.
4. Select the CM Relational Table that is associated with our database.
5. Click Select.
6. Enter a Name for your query.
7. Click OK.
8. Enter a query criteria. In this example, we'll show what was in the customer's shopping cart. Select the Activity Date item as our first criterion and leave the operator as Equals.
9. Click Value and select Current Date. This time, let's query for the current date - 3 days. This will target customers who abandoned their cart 3 days ago.
10. Click Add.
11. Select Activity Type and leave the operator as Equals.
12. Enter a Value of ABAN to target customers who abandoned their carts.
13. Click Add.
14. Click Save & Calculate, then Submit.
15. Now, in the email body, select the Relational Tables icon again and click Insert Relational Table Data to select the query we just created.
16. Select a Relational Table Query to use with your email template. Let's select the CM Mailing Query we just created within the email.
17. Click Select.

What to do next

The next step is to select Insert Markup to define the layout of the Relational Table Data to be displayed. This creates a generic outline containing fields from your Relational Table. You can insert the fields you want to include in the email from the relational table.