Prospect Activity Report Complete Reference

Summary

The Prospect Activity Report is a self-service report used to query interactions and contact reports to aid in managing development activity.

Key Takeaways

When to use the Prospect Activity Report
What is included in the Prospect Activity Report
How to generate the Prospect Activity Report
Such information is confidential and may only be used in accordance with WFAA’s polices, including its data disclosure and confidentiality policies.

When to Use

The Prospect Activity Report outputs interactions, including contact reports. This versatile report’s output can be based on the unit/department of an interaction, an interaction owner, or all interactions for prospects associated with a particular fundraiser/fundraiser role, as well as limited by date and a variety of other parameters.

This report has numerous potential applications: Managers can query all interactions for their team, or development officers can query all past/future interactions with their assigned prospects. Development staff can also use this report to gain insight on whether colleagues are contacting the same prospect.

The report can be exported into Excel for easy sorting and filtering, and it can be viewed in ABE CRM or as a PDF.

What Is Included in the Report

The Prospect Activity Report outputs completed and future interactions, including but not limited to the following fields:

Lookup ID	This is the unique ID used in the ABE CRM system. The report includes a hotlink that will redirect you to the constituent record in ABE CRM.
Athletic Patron ID	The patron ID used by the athletics department
Interaction Participant	The constituents listed as participants on the interaction or contact report, often a spouse or corporate contact
Constituent Degree(s)	The constituent’s earned degree(s)
Interaction Objective/Comments	The summary field of the interaction, or the objective field of the contact report. The report includes a hotlink that will redirect you to the full details of the interaction or contact report in ABE CRM.
Interaction Owner	The WFAA or campus staff member who is listed as the owner of the interaction or contact report
Additional Solicitor	The WFAA or campus staff member who participated in the interaction
Interaction Expected Date	The intended date of the future interaction
Interaction Actual Date	The date the interaction actually occurred
Interaction Status	The status of the interaction or contact report (planned, pending, canceled, or completed)
Interaction Site	The ABE site that is listed on the interaction or on the plan within which the contact report was recorded
Interaction Contact Method	The type of contact, e.g., email, phone call, personal meeting, letter, or virtual meeting
Step Stage	If the result is associated with a prospect plan, this is the development stage that was listed on the plan step/contact report. If the result is an interaction, this field will list “n/a.”
Plan Name	If the result is associated with a prospect plan, this is the name of that prospect plan. If the result is an interaction, this field will list “n/a.”
Plan Group	While uncommon, the plan group feature allows DoDs to view plans with specific attributes associated with a WFAA initiative, e.g., “Legacy Project” or “LET A-Rated Project.” Selecting “All Plans” allows you to see all activity on plans with the attributes you select.
Interaction Category/Subcategory	The category and subcategory associated with the interaction.

How to Generate the Prospect Activity Report

Log in to ABE CRM.
On the navigation bar, click WFAA Reports.
Click DEV — Prospect — Prospect Activity.
If necessary, select the applicable Plan Group. To see all plans, select All Plans. (Most plans do not have a plan group associated with them.)
Select Interaction Owner.
Select Interaction Status. (Select Completed if you only want to see interactions that took place in the past; choose Pending or Planned for future interactions.)
Select Constituent Type.
Select Interaction Category.
Select Interaction Subcategory.
Select Plan Type.
Select Unit.
Select Department. (This field only populates if a Department exists for the selected Unit.)
Select Fundraiser (limits results to interactions/contact reports for prospects for which the selected Fundraiser has a Role on a plan, even if the Fundraiser is not the interaction owner).
Select Fundraiser Role. (Select Any to see interactions/contact reports for prospects where the selected Fundraiser plays any role on a plan.)
Select Contact Reports. (Select Contact Reports Only to limit results to plan activity; however, you may wish to select All to see activity documented both by WFAA development staff and campus partners; the latter may be filing interactions only.)
Select Date Type. (Use Entered on Date to ensure all interactions are captured, including those that have been backdated, i.e., the date the interaction was entered is later than the date of the interaction itself.)
Select Date From. (Results are tied to the Actual Date when Contacted Date is selected for Date Type, but they tie back to the date the interaction was entered into ABE CRM when Date Type of Entered on Date is selected instead. For Pending/Planned interactions, results are based on the Expected Date when Contacted Date is selected as the Date Type.)
Select Date To (see “Date From”).
Select Region.
Select Excel-Ready Formatting.
Click View Report.