consistency: Calculate the consistency rate for constituents (the...
In crazybilly/fundRaising: Functions for Fundraising Analytics

calculates consistency a rate of how often gifts have been made during a defined time period

1	consistency(data, id_col, fy_col, threshold = 1, alt_year = NA, max_year = 0)

`data`	a data frame
`id_col`	a column from the data frame containing constituent IDs - column name should be unquoted
`fy_col`	a column from the data frame containing fiscal years for gifts - column name should be unquoted (use the fy() function if fiscal years are not already in the data)
`threshold`	a numeric value for the minimum active years to consider - for example, if someone is a first time donor they will have 100 percent consistency to only include those that could have given at least 3 fiscal years, change threshold to 3
`alt_year`	a numeric value or a quoted column name from the data frame containing which fiscal years should be used for the lower bound of the active years range. By default, the minimum fiscal year for gifts will be used however graduation year could also be used or just any given fiscal year
`max_year`	a numeric value for the upper bound of the active years. By default, the maximum fiscal year for gifts will be used however any fiscal year can be used to override this such as the current fiscal year

a summary data frame with the unique ID, first and last year of the active range, the defined active giving years, the number of fiscal years during the active giving years when a gift was a received, the consistency rate of fiscal years with a gift over active giving range

crazybilly/fundRaising documentation built on July 30, 2021, 12:51 a.m.