AFP’s Growth-in-Giving (GiG) Measurement Tools
All the GiGi Fundraising Fitness Test reports and GiG Reports are growth-oriented fundraising tools for tracking growth in giving by various performance indicators, gift ranges and gain(loss) categories. GiG reports can show performance for the fundraising program overall, as well as for each fundraising activity, such as direct mail and major gifts. Based on these reports, fundraising managers can recommend detail-level strategies by gain/loss category for each fundraising activity.
1. GiGi Fundraising Fitness Test (Excel)
2. FEP’s Growth-in-Giving Reports (Excel)
3. "A Better Measure of Success: How to Use AFP’s Growth-in-Giving Reports to Improve Fundraising Performance" article (PDF)
4. Instructions for Fundraising Fitness Test and GiG Reports templates (Word or PDF)
You can use the same simple set of instructions (#4) for extracting data from your donor records system for inserting into both the new GiGi Fundraising Fitness Test (#1) and the earlier Growth-in-Giving Reports template (#2).
1. GiGi Fundraising Fitness Test
In collaboration with PSI/Adventist, the FEP has developed the downloadable Excel-based GiGi Fundraising Fitness Test that allows nonprofits to measure and evaluate their fundraising programs against a set of over 100 performance indicators by five donor giving levels. The fundraising performance reports are generated by inserting gift transaction data into the Fundraising Fitness Test Excel template. Follow the instructions (#4) for retrieving gift transaction data from donor databases and inserting the data into the Fitness Test template. The performance reports can be generated for each year as far back as the gift transactions history goes.
Performance indicators include: donor retention rates (new donor retention, repeat donor retention and overall donor retention); donor gains, losses and net; dollar gains, losses and net; growth in giving ($); growth in number of donors; and donor attrition. Gift range categories are $5,000 & up, $1,000 to $4,999, $250 to $999, $100 to 249 and Under $100.
Click here to download the GiGi Fundraising Fitness Test.
2. AFP’s Growth-in-Giving (GiG) Reports
The core Growth-in-Giving (GiG) Report provides a concise, yet informative picture of fundraising gains and losses-growth in giving and attrition-in simple, reader-friendly format that the executive staff and board members can understand. The GiG Reports are generated by inserting gift transaction data into the downloadable Excel-based GiG Report template. Follow the instructions (#4) for retrieving gift transaction data from donor databases and inserting the data into the GiG Reports template.
The GiG Report template automatically produces the "Core GiG Report" - the centerpiece of the FEP gain(loss) reporting package -- along with 6 other GiG Reports that are also useful. The GiG Reports are cross-referenced to the figures and tables in the "A Better Measure of Success" article.
Click here to download the Growth-in-Giving (GiG) Reports template
3. The article "A Better Measure of Success: How to Use AFP’s Growth-in-Giving Reports to Improve Fundraising Performance" in the March-April, 2011, issue of Advancing Philanthropy introduces the GiG Reports, describes them and explains how to use them with CEOs and boards to help justify growth-oriented fundraising budgets. A copy of the article in PDF is available here.
4. Instructions for Fundraising Fitness Test and GiG Reports templates
The data extract procedure is quite simple. You extract from your donor records system a gift transaction file with three fields – donorID, date and amount – for each gift in your database. Go back as far as you can, at least 6 years if possible – minimum 3 years for the reports to function. This gift transaction data is inserted into the GiGi measurement tools and all of the reports are generated “with the click of a mouse.” Note that retrieving gift transaction data from donor databases and entering it into the Fitness Test and GiG Report templates is usually an assignment for donor records and reports managers.
If you have questions or suggestions regarding the Fitness test or GiG reports, please contact Randy Fox, GiGi Fundraising Fitness Test Manager or Bill Levis, FEP Project Manager, by email at firstname.lastname@example.org.