Email Marketing
How to Query a Database

How to Create a Query in Acoustic (formerly IBM Watson Campaign Automation)

You followed the last tutorial on importing and updating a database in Acousitc. Utilizing those contacts, email marketers can create a query. A query is a way to filter contacts based on criteria you, the email marketer, outline. Criteria can be established based on behavior, profile data and locked criteria. For example, a query can be set up to identify a list of contacts with in the email domain. This query can then be used to send a mailing only applicable to employees at LSC Digital. In this tutorial, we will show you how to create a query using profile data, and then how to query a query for an even more specific list of contacts. For example, using the query, we can query another list of people in the marketing department of the company.

Subscribe to our YouTube channel

Procedure: Creating a query

  • First scroll to the menu on the left side of the screen and select the data menu.
  • Select Manage and then Data from that drop down menu.
  • Select the Query tab from the top menu. Once the Query page opens, choose to Create Query.
  • The dialogue box will pop up and prompt you to choose a database. Select the database you would like to query.
  • Give the query a unique name and take note of where you will be saving the newly created query.
  • The type should be query if that is not already the default.
  • Now you will select the criteria to run.
    • Profile data is data found in the field types of each contact. This can be name, email, birthday, etc.
    • Behavioral data is data collected by Watson based on previous mailings. For example, you can create a query based on people who opened your last mailing.
  • We will select profile data and use the EMAIL_DOMAIN_PART data field. This will only collect contacts based on email domain. We want the operator to be “is equal to” and we’re going to type in our value:
  • At this time, you can save and calculate the query, or save and close the dialogue box to calculate the query later.
  • Once save and calculate is selected, the data job page (the same one as in the previous tutorial) will open. You can check the box and enter your email address to be notified when the job is complete. This is useful for especially large databases and queries.
  • Click the data job link to check on the status of the data job. Once it is complete, information about the newly formed query will appear including the number of contacts in the query and information about where it is located.

Procedure: Creating a query from a query

  • Now with this query created, we will query it to find employees at LSC Digital who work in the marketing department.
  • Return to the manage data page, and follow the steps to create a query again.
  • For this query, select the same database, give it a unique name, and save it in the same folder as the same type of query.
  • For this query, select profile data again but this time select ‘query.’
  • Select parameters that say the contact ‘is in query’ and then find the previously created query.
  • Then go back to profile data and make sure that the field type is ‘department’ and operator is ‘is equal to’ and we’re going to type in our value: marketing.
  • Select save and calculate and follow the steps after the data job page appears.
  • Once the data job is complete, compare the size of your first query to this query. You will notice that there are fewer contacts in this query than the previous. This is because this query contains only LSC Digital employees that work in the marketing department.

Bring more email marketing insights to your company. Subscribe to LSC Digital’s YouTube channel for new videos and tutorials every Tuesday and Thursday.

2 thoughts on “How to Create a Query in Acoustic (formerly IBM Watson Campaign Automation)

Leave a Reply

Your email address will not be published. Required fields are marked *