In this article:

• What is a Communication Planner - Donors to Unit/Dept/Fund Report
• How to access the report
• How to interpret the report
• Downloadable PDF

What is a Communication Planner - Donors to Unit/Dept/FundReport?

The Communication Planner – Donors to Unit/Dept/Fund Report is a tool WFAA staff may use to communicate to a specific set of donors at the unit, department or fund level. Typically, this is used for impact reporting, stewardship communications, or solicitations to donors. The report includes contact information, so it may be used to produce lists for mailings, emails, or phone calls with the proper solicit codes applied. This report is not intended to replace the Stewardship “Prep” report that may be requested from BI.

If you choose to use this list to communicate to a group of constituents, you must also submit the final list via the List & Report Request Form. This will allow BI to tag the constituent records in ABE to show they received the communication. This step is crucial for tracking which communications a constituent receives, and helps us continue to refine our marketing and communications strategy.

If you use this to create a solicitation mailing, please work with Gift Processing in advance to create an appeal.  This will streamline gift processing and allow you to track the results of your appeal

How to access the report

1. Log in to ABE CRM
2. On the navigation bar, click WFAA Reports
3. Click CST – Constituent – Communication Planner - Donors to Unit/Dept/Fund
4. Select a value in the Donors to field. The Unit/Department/Fund choice allows you to select funds at the unit/department/or fund level. The Fund Groups choice allows you to select some or all funds in a fund group.
5. Select a Donors to Unit or Fund Group (dependent upon the choice you've made in the Donors to field).
6. If desired, enter a word or number into the Fund Filter field. This will limit the choices in the Fund field to funds that contain your entry in their name.
7. Select a Fund. You can only select one unit and one department OR one fund group, but you can select multiple funds.
8. If desired, use Start Date and End Date to limit the report results based on the transaction dates of the gifts. Use the format MM/DD/YYYY.
9. Select a Giving Total Type. Cash is for cash-in-the-door (outright gifts, plus payments on pledges, planned gifts, recurring gifts and matching gift claims). Commitments is for new gifts and pledges (outright gifts, pledge initiations, planned gifts, matching gift claims).
10. In the Exclude Organizations field, select Yes if you only want individual donors in your output.
11. In the Exclude Tributes field, select Yes if you do not want tribute gifts in your output.
12. In the Exclude Matching Gift Payments field, select Yes if you do not want Matching Gift Payments in your output.
13. Use the Who is Communication from? field to apply appropriate solicit codes based on the “brand” on the communication. For cross-branded communications, you may select multiple options.
14. Use the Intent of Communication field to apply additional solicit codes based on special types of communications (invitations, solicitations, magazine/newsletter).
15. Use the Other Solicit codes field to provide additional solicit codes to select if applicable. For example, some schools and colleges have multiple magazines/newsletters.
16. In the SpouseLink field, select Yes if you want spouses merged together on one row. If No is selected, the spouses will be listed individually on the list.
17. Use the List this School/College Alum first when Spouse-linked feature to indicate your preference if you want the alumnus from your unit listed as Constituent.
18. In the Include Spouse even if they do not qualify? field, Yes indicates that the spouse of the main constituent will be included even if s/he is not a donor to the unit/department/fund selected. Select Yes to get an exact count of total number of people who would be invited to an event, for example.
19. Excel Ready Formatting: If you intend to refine the file in Excel, select Yes. Once the list is exported, you can refine the list by region, county, city, state, giving history, etc.  
20. Click View Report.

When exported to Excel, the report returns two tabs – one for domestic addresses and one for international addresses.

This report allows you to apply ABE Solicit Codes based on the source of the communication.  This feature ensures that there will be no contact information surfaced if the constituent does not wish to receive a certain type of communication or communications from specific areas on campus or WFAA.  This feature will not exclude anyone who meets the criteria selected in the parameters, but it will suppress the relevant contact information.

How to interpret the report

What is included in the Communication Planner - Donors to Unit/Dept/Fund Report?

Downloadable PDF