Option 1: Use a system report
- Campaign Dashboard: Summaries showing giving by payment type and by program to the campaign. Includes donations made towards a campaign program that were not credited to any pledge.
- Campaign Donation List: Lists all donations made to the campaign by pledge. Provides a summary of donations to the campaign.
- Campaign Donation to Pledge Matching: Lists donations that may need to be credited to a pledge. Allows a user to quickly credit those donations to the pledge.
- Campaign Pledge Dashboard: Summaries based upon whether pledges are ahead, completed, or behind.
- Campaign Pledge List: Lists the pledges associated with a specific campaign. Pledge Due refers to how much a Pledger "should" have given up to this point based on their Installment details.
- Campaign Projection: Review projected pledges and actual giving for the duration of the campaign (Note: unbatched donations do not appear in this report.)
- Selected Campaign Donor Summary: Provides a list of each donor and their participation in the campaign. Sum totals are provided where appropriate. (Note: unbatched donations do not appear in this report.)
- Selected Campaign Summary: Provides an overview of the campaign goal totals and pledge totals.
- Selected Pledge Donation List: Shows the specific donations credited to selected pledge records. (Pledges Page).
Note: Not seeing the Campaign you expected? The
SSRS,CurrentCampaignFilters impacts whether the Pledge Campaign/ Mission Trip report parameters list ALL Campaigns or just current/ future Campaigns. If set to "yes," the only Events associated with current Mission Trips in the Events drop down will be available on several Mission Trip-related reports. Option 2: Export data with the Selected Campaign Donor Summary Export report
Select your Pledge Campaign on the Pledge Campaigns page then run the report titled Selected Campaign Donor Summary Export. This report provides one row per donor participating in the campaign. It includes mail merge data. Donors can be included even if they do not have a pledge but have been giving towards programs that are associated with the Pledge Campaign. Donors whose donations were credited to another person's pledge will also be included. You may export the results of this report to Excel for further analysis or mail merging.
Option 3: Export data with a view created on the Donation Distributions page
This option provides raw data. Be sure to include any fields you wish and to use as your criteria the fact that the Pledge on the Donation Distribution record was assigned to the Pledge Campaign for which you wish to report. This extracts all donation distributions that went to a pledge in your campaign. Please note that any unpledged donations are not exported. To get a more comprehensive list you may need to export any distribution to one of your pledge campaign programs.
