Overview

This article will teach you how to build queries by different E-Mail criteria.  This assumes you have email address data in your Trail Blazer Database and some of the queries can’t be run until after you have sent an Eblast.

Steps to Query by Email

Under Application Menu follow Voter/Donor > Voters/Donors

Select the General tab & Email sub tab.

Click the [Plug] button to “Plug In” and activate the tab.

Now you can click [Search] and (Load All) to pull up a list of everyone in your database who has a who has subscribed.  To target people who have subscribed and either have an email present or missing you will also need to select the appropriate radio button.

NOTE: You can target records in Trail Blazer by email using the options shown in the picture and listed below.

List of Email Search/Query Options

Primary Address

Alternate Address

Present Addresses

Missing Addresses

Subscribed

Not Subscribed

Unsubscribed

Bounced

Exclude Bounced

Abuse Complaints

Exclude Complaints

Awaiting Opt-In

Exclude Awaiting

Unopened Messages Threshold

Resources

Trail Blazer Campaign Services YouTube Channel

“Getting Started Queries” Link

“Advanced Queries with SQL Wildcards”: Link