You can run a custom query for advanced emails and text messaging with Constant Contact.

1. In the top-left corner, click your ministry hub then Realm. Then click Reporting > Custom Query.
2. Click the Select a main attribute drop-down menu, then select an attribute under the Constant Contact section. Primary attributes include:
   • Email Status
   • Email Subscription
   • SMS Number
3. Select an attribute in the second drop-down menu. For example, you can query on Email Status | is synced to run a report on all email addresses that are currently synced with Constant Contact.
4. If you use more than one Constant Contact account you can query on a specific account.
   1. Click the Select an optional sub-attribute drop-down list and select Constant Contact Account.
   2. Select from is equal to or is not equal to in the second drop-down menu.
   3. Choose the account name from the third drop-down menu.
5. Add another primary attribute to the report if needed:
   • If you want this attribute to work in conjunction with the previous one, click And.
   • If you don't want this attribute tied to the previous one, click Or.
6. Narrow your results using the drop-down list under Show.
7. Click Show Results.
   1. Simplify or expand your results. Click Edit Columns, and select the columns you want to see. To remove a column, point to it and click . This will not change your report results, just the amount of detail displayed for each record in the results. Edit Columns may be available, depending on the Show option you chose.
   2. Sort your results. Click a blue column name to sort the results based on that information.
8. You can click the Select an action drop-down menu to choose an action to take, or you can export the list of individuals as a report by clicking and selecting either the .pdf or .csv file type.