Report Example: Last Year's Donors for Summary Letters

Create Group for Last Year's Donors

1. From the Manage menu, select Configuration.
2. Select the Groups node on the left.
   
3. Click Add to add a new Group. The new Group does not need to be a Smart Group or synchronized with Salsa Engage.
4. Name the Group.
5. Click OK to save.

Create Report on Last year's donors

1. From the Reports menu, click Gifts > Donor Detail.
2. For the data range of the report, enter the date range that you want to use (for example,  01/01/2017 - 12/31/2017) in the From and To dates.
3. Exclude Deceased and Do Not Contact by selecting the appropriate checkboxes.
4. Exclude Co-Donors and Soft Credit by deselecting the appropriate checkboxes.
5. Do Not Consolidate Spouses; leave this box unchecked. The Summary Letter functionality does not generate a consolidated letter for spouses, just individuals.
6. Do not exclude any funds/campaigns/appeals via Additional Filters as they will not be reflected in the summary letter. If you don't want certain donations counted, apply the Summary Letter to the Donation record instead.
7. Run Report as Advanced Query. This is only to get people into the group. Other report values won't translate into the letter.

Add Last Year’s Donors to Group

Run the Advanced Query Wizard. You will see the Donor Detail report results display as Step 3 of the Query Wizard. Select the Next button in the bottom right corner.

In Step 4 of the Query Wizard, after you see the results of the report, add last year's donors to Group:

1. Click the Global Update button.
2. Click the Assign to Group button.
3. Select the last year’s donors Group.
4. Click OK. The constituents in the report results will be added to the Group.
5. Run the Summary Letter report for those in the Group.