How do I create a query?

How to create a query.

Procedure

  1. In Data, go to Queries > Create or New > Query.
  2. Complete the Save Query As dialog box.
    1. Choose Database to Query - Select the database you want to query.
    2. Save Query As - Name the query
    3. Location - Save the query in a Shared or a Private folder.
    4. Type - Select Query or Classic Query.
  3. Click OK to open the query builder.
  4. Click an option to add your criteria:
    1. Profile (from Data Fields, Contact List)
    2. Behavior (based on behaviors performed in email, web form, program, universal behaviors, web site)
    3. Relational Table
    4. Criteria (from Data Fields, Contact List)
    5. Behavior Criteria (based on a contact who opened an email, clicked a link in an email or bounced on an email)
    6. Fields Available for Personalization (allows you to include all or some fields available for personalization within emails to this query)

    Capitalization matters in classic queries.

    For example, if there is a city field in your database that contains atlanta for one entry and Atlanta for another entry and you want to capture ALL recipients who reside in Atlanta, then you have to construct your query in the following manner:

    Criteria: City equals atlanta OR City equals Atlanta

    This ensures that ALL recipients who reside in Atlanta/atlanta are returned by the query.

    Another option is to use the 'case sensitive' box.

    Clearing this box allows you to search for 'Atlanta' and return results with both 'Atlanta' and 'atlanta' in the field.

    The new query type isNOT case-sensitive.

  5. Create query based on an option selected in Step 4.
  6. Click one of the Save options (Save, Save & Close, Save & Calculate).