Search lets you manage individual contacts matching certain criteria. You can search databases and relational tables.
- Locate an individual contact, view the contact's emails, and edit the contact's email address, type, and dates.
- Locate one or more contacts by certain criteria and opt-out or delete them.
- Search by email address, domain, message body type, and email date, and apply operators and criteria to the search.
Note: Use the Search button to search for record entries and assets within Acoustic Campaign, including databases, relational tables, emails, programs, and the asset library.
Search for contacts
- Click Data.
- Select the database to search.
- In the Database Summary Search tab, click Search for Contact.
- Add the search criteria.
- Check the part(s) of the database to search - Contacts, Opt-Outs, and/or Undeliverables. You can search multiple parts.
- Click Search. The resulting database contains the first 100 contacts in the database that match the entered criteria.
- You can view more information about the contact, edit contact details, or view contact insight.
For example, if you want to search for all contacts that use Gmail addresses, choose Domain in the upper drop-down list. Choose Contains in the lower drop-down list. Enter 'gmail' and click Search.
- Email: The full or partial email address of the contact.
- Domain: The full or partial domain, such as gmail.com.
- Message Body Type: HTML or TEXT. Note that the default is MIME, which is not entered in the field.
- Date: Date of the last email.
- equals: Exactly matches the search term. (Use lower case)
- begins with: The criteria begins with these contiguous letters. Example: bob.
- contains: The criteria contains these contiguous letters. Example: 'aho' in yahoo.
- is null: There is no information in the field.
- is not null: There is information in the field.
Type in the text to search for:
- If Email: Use the full address unless using the operators 'begins with' or 'contains.' Example:
mailto:email@example.com. To search for Bob, use the operator 'begins with.'
- If Domain: Use the full domain unless using the operators 'begins with' or 'contains.'. Example: gmail.com. Searching for gmail or com by themselves will not return any results.
- If Message body type: Valid types are HTML and TEXT. (The default is MIME, which is not entered in the field.)
- If Email Date: The format must be in the exact format used by Acoustic Campaign. The correct format is mm/dd/yyyy. Variations will not work.
EMAIL_LOCAL_PART and EMAIL_DOMAIN_PART
These parameters are used when you are trying to find a user name or the domain part of an email address.
- [EMAIL_LOCAL_PART] - used to find the user name.
- [EMAIL_DOMAIN_PART] - used to find the domain part of an email address. The email address has 3 parts: the user name, the @ sign, and the domain part. This parameter is used in queries when you are trying to find all email addresses in your database that contain a particular domain. It does not include the @ sign.
Quickly navigate to the edit contact page
You can quickly navigate to the Edit Contact pages for a list of recipient IDs without having to first back out into the Database Summary and manually search for the contact.
- Click a contact in the Search tab of a database. The Edit Contact page is displayed. This page provides valuable information such as custom field values and quick access to Contact Insight.
- To move to the Edit Contact page for another contact, replace the existing recipient ID in your URL with the Recipient ID of another contact and click Enter.
In the following example, you would replace the numerals shown in bold.
The Edit page for the contact is displayed.
Search contacts added between certain dates
Opted in contacts and date ranges
You would like to find the number of contacts in your database that have Opted In between two specific dates.
You could run a Query ini your database in which you specify to return contacts where Opt In Date is between a certain start date and end date. This will give you a listing of your contacts and the total number of contacts.