The Campaign, Appeal, and Event's rollup fields allows you to track these specific gift giving activities success in real time. While some fields are automatically updated by Causeview based on the constituent's transactions, others are manually specified by a Causeview user.
| Field Names | Automatic Updates | Descriptions |
| Average Gift Amount | Yes | Average Gift - Rollup Amount |
| Cost Per Response | No | Actual Cost / Donations Received - Rollup Amount |
| Cost Per Solicitation | Yes | Actual Cost / Number Sent - Rollup Amount |
| Current Fiscal Goal | Yes | Fiscal Goal This Year - Rollup from goal |
| Current Fiscal Q1 Goal | Yes | Q1 Goal This Year - Rollup from goal |
| Current Fiscal Q2 Goal | Yes | Q2 Goal This Year - Rollup from goal |
| Current Fiscal Q3 Goal | Yes | Q3 Goal This Year - Rollup from goal |
| Current Fiscal Q4 Goal | Yes | Q4 Goal This Year - Rollup from goal |
| Fiscal Goal Achieved to Date (%) | Yes | The percentage of the current fiscal goal that has been reached so far - Rollup Amount |
| Gift Amount | Yes | Total value of Gifts received NOT including child records - Rollup Amount |
| Gift Count | Yes | Total number of Gifts received NOT including child records - Rollup Amount |
| Gifts for Current Fiscal | Yes | Total amount of gifts received during current fiscal NOT including child records - Rollup Amount |
| Gifts for Current Quarter | Yes | Total amount of Gifts received during current quarter NOT including child records - Rollup Amount |
| Lifetime Goal | Yes | Goal over the lifetime of the campaign or appeal - Rollup from Goal |
| Lifetime Goal Achieved to Date (%) | Yes | Percentage of Goal Achieved to Date - Rollup from Goal |
| Number Attended | Yes | The number of registered registrations marked "Attended" - Rollup Amount |
| Number of Tickets Available | Yes | Number of tickets available for purchase (Number of Tickets Planned - Number Registered) - Rollup Amount |
| Number of No Shows | Yes | Number of registrations marked as "No Show" - Rollup Amount |
| Number of Tickets Planned | Yes | Planned number of attendees (Sum of all Quantity Available values for all Event Levels) - Rollup Amount |
| Number Registered | Yes | The number of individuals that have registered for the event - Rollup Amount |
| One-Time Gift Count | Yes | Total number of One-Time Gifts received NOT including child records - Rollup Amount |
| Overall Gifts for Current Fiscal | Yes | Total amount of Gifts received during current fiscal including all child records - Rollup Amount |
| Overall Gifts for Current Quarter | Yes | Total amount of Gifts received during current quarter including all child records - Rollup Amount |
| Overall Lifetime Gift Amount | Yes | Total amount of Gifts received including all child records - Rollup Amount |
| Overall Lifetime Gift Count | Yes | Total number of Gifts received including all child records - Rollup Amount |
| Overall One-Time Gift Count | Yes | Total number of One-Time Gifts received including all child records - Rollup Amount |
| Overall Reccuing Gift Count | Yes | Total number of Recurring Gifts received including all child records - Rollup Amount |
| Total Individuals | Yes | Total number of Campaign Members - Rollup Amount |
Note: for Campaign, Appeal, and Event Rollups to be run, they must fit in the Hieararchy.
Comments
0 comments
Please sign in to leave a comment.