How Do You Rate?

For those of you with a fiscal year coming to a close this month, it’s time to start thinking about year-end reporting. Two of the simplest things you can measure are your Retention Rate and your Attrition Rate. Thanks to the Fiscal Summary table, this is a fairly easy task in ResultsPlus.

Let’s begin with a clarification. When ResultsPlus was first set up for your organization, you were prompted to specify the beginning and end dates of the current fiscal year. ResultsPlus uses that initial setting and the current date to always know what the current fiscal year is. It then stores data in fields going backward from the current year. So last years’ data is stored in fields called ‘Yr1’ fields – meaning one fiscal year back.

Retention Rate

Your retention rate is a measure of how many donors you were able to ‘keep’ from one year to the next. To find your retention rate, you need to perform two queries and do a little math.

  • Step A:  find people who gave in the last fiscal year (FiscalSummary.Yr1Amt > 0).
  • Step B:  find people who gave both last year and this year (FiscalSummary.Yr1Amt > 0 AND FiscalSummary.YrToDateAmt > 0)
  • Step C:  Divide the number of constituents from step B by the number from Step A and multiply by 100 to get your retention rate.

Attrition Rate

Your attrition rate is the opposite of your retention rate. It’s a measure of how many donors you ‘lost’ from one year to the next. To find your attrition rate, you again need to perform two queries and do a little math.

  • Step A:  find people who gave in the last fiscal year (FiscalSummary.Yr1Amt > 0).
  • Step B:  find people who gave last year but not this year (FiscalSummary.Yr1Amt > 0 AND (FiscalSummary.YrToDateAmt = 0 or isnull(FiscalSummary.YrToDateAmt)))
  • Step C:  Divide the number of constituents from step B by the number from Step A and multiply by 100 to get your attrition rate.

While you’re preparing to analyze your data, don’t forget to check out all the standard reports in the Reports menu on the Performance tab. With a few clicks, you can generate some pretty helpful and easy snapshots of your fiscal year performance.