The OrgGiving
report is a SQL script for which we have a recipe in our documentation. It is designed to give your finance leadership (it is locked down to only Finance users) an overall view of what percent of members in specific groups of organizations, such as adult Life Groups, are givers to the church. This is also a nice report to use for a Division containing orgs that teach financial planning, such as Financial Peace University.
You determine which Division(s) to include and you determine the criteria for a Status Flag to use in the script to denote givers. For example: Those who have given more than $1000.00 in the past 365 days.
Here's a sample:
This is very simple to create in your database - just follow the recipe!
Read more...