<< Click to Display Table of Contents >> Navigation: Reports > Sample Donation Reports (Part 2) |
Report Menu Name
Donations - Grouped By Stimulus - Summary With Averages
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will show the donation total, count, and average amount for each Stimulus. The report will only include monetary donations.
Report Menu Name
Donations - Grouped By Stimulus And Donor - Summary
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation totals and counts for each donor within each stimulus.
Report Menu Name
Donations - Grouped By Stimulus And Donor - Summary (for file output only)
Description
Designed to be used with a Donation-based Selection Result, this report layout serves as an example of how to format a report which is intended to be written to a file. It has only column headings and data rows, but no page headings, footers, or margins.
Report Menu Name
Donations - Grouped By Stimulus With Monthly Totals In Columns
Description
Designed to be used with a Donation-based Selection Result, this report layout will show total amounts and counts for each Stimulus, and it will also show total giving by month for each stimulus.
Report Menu Name
Donations - Grouped By Stimulus, Subgrouped By Appeal
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with amounts and counts totaled by Stimulus, and subtotaled by Appeal.
Report Menu Name
Donations - Grouped By Stimulus, Subgrouped By Appeal - Code Descriptions
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with amounts and counts totaled by the Stimulus Code Description, and subtotaled by the Appeal Code Description.
Report Menu Name
Donations - Grouped By Stimulus, Subgrouped By Appeal - Code Descriptions - Summary
Description
Designed to be used with a Donation-based Selection Result, this report layout will show only totals and counts by the Stimulus Code Description, and subtotaled by the Appeal Code Description.
Report Menu Name
Donations - Grouped By Stimulus, Subgrouped By Appeal - Summary
Description
Designed to be used with a Donation-based Selection Result, this report layout will show only totals and counts by the Stimulus Code, and subtotaled by Appeal Code.
Report Menu Name
Donations - Grouped By Stimulus, Subgrouped By Donation Type
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with amounts and counts totaled by Donation Stimulus, and subtotaled by the Donation Type.
Report Menu Name
Donations - Grouped By Stimulus, Subgrouped By Donor Name
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with amounts and counts totaled by Donation Stimulus, and subtotaled by Donor Name.
Report Menu Name
Donations - Grouped By Stimulus, Subsorted By Amount
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with amounts and counts totaled by Donation Stimulus, and subsorted by Donation Amount.
Report Menu Name
Donations - Grouped By Stimulus, Subsorted By Donor Name
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with amounts and counts totaled by Donation Stimulus, and subsorted by Donor Name.
Report Menu Name
Donations - Grouped By TY Code
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with amounts and counts totaled by the donation TY code description.
Report Menu Name
Donations - Grouped By TY Code- Summary
Description
Designed to be used with a Donation-based Selection Result, this report layout will show just donation totals and counts for each donation TY code.
Report Menu Name
Donations - Grouped By Year + Stimulus, Subgrouped by TY code
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation totals by donation Year and Stimulus, and subtotals by donation TY code.
Report Menu Name
Donations - Grouped By Year + Stimulus, Subgrouped by TY code - Summary
Description
Just the totals from the, "Donations - Grouped By Year + Stimulus, Subgrouped by TY code" shown above.
Report Menu Name
Donations - Grouped By Year and Stimulus
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with total amounts and counts by year and donation stimulus description.
Report Menu Name
Donations - Grouped By Year With Donor Name, Amount, Stimulus
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donations amounts by donor, and it will subtotal by calendar year for each donor.
Report Menu Name
Donations - Grouped By Zip Code
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation detail with total amounts and counts for each zip code. All digits of the zip code are considered.
Report Menu Name
Donations - Grouped By Zip Code - Summary
Description
Designed to be used with a Donation-based Selection Result, this report layout will show just totals and counts by zip code. All digits of the zip code are considered.
Report Menu Name
Donations - Number of DONORS Giving To Each Campaign
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will count the number of donors giving to each campaign (stimulus) code.
Report Menu Name
Donations - Pledge Payments For Calendar Year, 1 Year Ago
Description
Designed to be run directly or used with a Donation-based Selection Result of donations applied as pledge payments, this report layout will show the pledge to which each donation has been applied as a payment.
Report Menu Name
Donations - Pledge Payments For Previous Month
Description
Designed to be run directly or used with a Donation-based Selection Result of donations applied as pledge payments, this report layout will show the pledge to which each donation has been applied as a payment.
Report Menu Name
Donations - Previous Month Only
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will show and subtotal all donations made available to the report by the donor to which they belong. If you run this report directly, it will automatically run a selection to find all the donations given in the previous month.
Report Menu Name
Donations - Previous Year Only
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will show and subtotal all donations made available to the report by the donor to which they belong. If you run this report directly, it will automatically run a selection to find all the donations given in the previous calendar year.
Report Menu Name
Donations - Quarterly Giving Totals By Calendar Year
Description
Designed to be used with a Donation-based Selection Result, this report layout will show quarterly totals by calendar year for all donations of the selection, and also show a total for each year.
Report Menu Name
Donations - Quarterly Giving Totals By Fiscal Year
Description
Designed to be used with a Donation-based Selection Result, this report layout will show quarterly totals by fiscal year for all donations of the selection, and also show a total for each year.
Report Menu Name
Donations - Recency / Frequency Report, 0-3 Month Donors
Description
This report should only be run directly (outside of a selection result) as it runs a special selection required for the special features of the report automatically. This report will break monetary donations of the past 90 days down into amount range categories in increments of $10 all the way up to the top $100+ category. For each range category, the number of donations given as single gifts by the respective donor are counted in the column, "Single Gifts." For a gift to be counted in this column, the donor giving the gift must have only given one gift in the 90-day period. If a a donation is one of multiple gifts in the period by the same donor, it will be counted in the, "Multiple Gifts" column. Likewise, donations will be summed in the corresponding "Income" column. The, "Total Count" and "Total Income" columns represent the combined count and income columns. This report is intended to give you a sense of the gift amount ranges providing your organization with the most revenue, so that you may focus on soliciting donations of those amounts. If reports such as this are of particular interest to your organization, you should be sure and try the DonorQuest, "Donor Metrics" series of reports found under the Reports menu.
Here is what the report looks like when run on a larger sample database:
Report Menu Name
Donations - Recency / Frequency Report, 4-6 Month Donors
Description
This is a variation on the Recency / Frequency report which looks at donations made in the past 91 to 180 days from the day you run the report.
Report Menu Name
Donations - Recency / Frequency Report, 7-12 Month Donors
Description
This is a variation on the Recency / Frequency report which looks at donations made in the past 181 to 365 days from the day you run the report.
Report Menu Name
Donations - Recency / Frequency Report, 13-18 Month Donors
Description
This is a variation on the Recency / Frequency report which looks at donations made in the past 366 to 546 days from the day you run the report.
Report Menu Name
Donations - Recency / Frequency Report, 19-24 Month Donors
Description
This is a variation on the Recency / Frequency report which looks at donations made in the past 547 to 727 days from the day you run the report.
Report Menu Name
Donations - Recency / Frequency Report, 25-36 Month Donors
Description
This is a variation on the Recency / Frequency report which looks at donations made in the past 728 to 907 days from the day you run the report.
Report Menu Name
Donations - Recency / Frequency Report, 36-plus Month Donors
Description
This is a variation on the Recency / Frequency report which looks at donations made in the past 908-plus days from the day you run the report.
Report Menu Name
Donations - Recency / Frequency Report, Overall Totals
Description
This is a variation on the Recency / Frequency report which looks at overall totals for all donations for all time.
Report Menu Name
Donations - Soft Credit Donations Only, Grouped By Giver
Description
Designed to be used with a Donation-based Selection Result, this report layout will further filter the selection so that only donations which have been soft-credited are shown. For each donation, this report will show the name of the actual giver, and the name of the soft credit recipient. Donations are grouped and totaled by the actual givers.
Report Menu Name
Donations - Soft Credit Donations Only, Grouped By Soft Credit Recipient
Description
Designed to be used with a Donation-based Selection Result, this report layout will further filter the selection so that only donations which have been soft-credited are shown. For each donation, this report will show the name of the soft credit recipient and the actual giver. Donations are grouped and totaled by the soft credit recipient. The donations are further subsorted by donation date, so they will appear in chronological order for each soft credit recipient.
Report Menu Name
Donations - Soft Credit Donations Only, Grouped By Soft Credit Recipient, Subsorted By Giver
Description
Designed to be used with a Donation-based Selection Result, this report layout will further filter the selection so that only donations which have been soft-credited are shown. For each donation, this report will show the name of the soft credit recipient and the actual giver. Donations are grouped and totaled by the soft credit recipient. The donations are further subsorted by the actual giver, so they will appear in alphabetical order by the giver's name for each soft credit recipient.
Report Menu Name
Donations - Soft Credit Donations Only, Grouped By Soft Credit Recipient, Totals Only
Description
Designed to be used with a Donation-based Selection Result, this report layout will further filter the selection so that only donations which have been soft-credited are considered. Soft credit donations are totaled and counted for each soft credit recipient. Also shown are the name and address for each sort credit recipient.
Report Menu Name
Donations - Total Of Gifts In Dollar Ranges By Calendar Year
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will show donation totals by calendar year in five amount ranges.
Report Menu Name
Donations - Total Of Gifts In Dollar Ranges By Calendar Year And Week
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will show donation totals by calendar year and week in five amount ranges.
Report Menu Name
Donations - Total Of Gifts In Dollar Ranges By Fiscal Year
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will show donation totals by fiscal year in five amount ranges.
Report Menu Name
Donations - Total Of Gifts In Dollar Ranges By Fiscal Year And Week
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will show donation totals by calendar year and week in five amount ranges.
Report Menu Name
Donations - Totals And Year Counts
Description
Designed to be run directly or used with a Donation-based Selection Result, this report layout will count the number of years for which each each donor shown had giving. The years don't have to be consecutive. The count simply represents the number of discrete years in which the donor gave. If you use this report with a selection of donations for the past ten years, only those years will be considered in the count. The Amount is simply a total of all giving for the donor for all donations processed by the report. The donations processed can either be all monetary donations (the default if the report is run directly outside of a selection result), or the donations of a specific selection result.
Report Menu Name
Donations - Totals And Year Counts, With Address, First, And Most Recent Years
Description
This is a variation on the, "Donations - Totals And Year Counts" report (shown above) which also includes the full mailing and email address for each donor, as well as the date of their first and most recent donation.
Report Menu Name
Donations - Totals, Counts, Averages By City And Year
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation totals, counts, and average amount by city, and subtotals within each city by calendar year.
Report Menu Name
Donations - Volunteer Hours For Soft Credit Recipient, Totals Only
Description
Designed to be used with a Donation-based Selection of volunteer hours (donations coded with a type of "HR"), this report layout will show total hours credited to each soft credit recipient of hours. This could be the employer or agency which encourages their employees to volunteer their time. The actual volunteers would still have the hard credits of the hours they donated in their donor accounts.
Report Menu Name
Donations - Yearly Donation Counts By $50 Increments
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation counts for the current and past four calendar years for donations of amounts in specific amount ranges.
Report Menu Name
Donations - Yearly Donation Counts By $50 Increments (Fiscal Years)
Description
Designed to be used with a Donation-based Selection Result, this report layout will show donation counts for the current and past four fiscal years for donations of amounts in specific amount ranges.
Report Menu Name
Donations - Yearly Donation Totals By $50 Increments
Description
Designed to be used with a Donation-based Selection Result, this report layout will show totals for the current and past four calendar years for donations of amounts in specific amount ranges.
Report Menu Name
Donations - Yearly Donation Totals By $50 Increments (Fiscal Years)
Description
Designed to be used with a Donation-based Selection Result, this report layout will show totals for the current and past four fiscal years for donations of amounts in specific amount ranges.