In Virtuous, each Contact has a set of Contact Statistics that can be quickly referenced to see different milestones in their history, qualify certain selections of records for actions, and much more! When working with a Contact Query, you'll see several fields that capture giving statistics for Contacts. These are also available as query parameters and as exportable fields.
Some of these fields, like "Life to Date Giving," are generally straightforward. There are other fields like "Second Last Year Plus Passthrough Gift Count" that aren't as straightforward. This article will outline the specific definition for each Contact Statistic available.
The selection of available Statistics are separated into "Statistics" and "Passthrough Statistics," just as in the export field selection screen. Unless otherwise specified in the definition, anything in the "Statistics" group does not include Passthrough Gifts, only direct giving from a Contact.
Click Here to Review the Full List of Contact Statistics
Click Here to Review the Full List of Passthrough Contact Statistics
In addition, there is a second set of Contact Statistics that are focused on Passthrough Statistics.
Statistics
Average Gift Amount - The average of the amounts of all Gifts from a particular Contact.
Gifts Per Year - The average number of Gifts a Contact gives in a 12-month period, based on their entire lifetime giving history. For example, a donor with a monthly recurring Gift who has not missed a payment would show 12.
Year to Date Gift Count - The total number of gifts received in the current calendar year. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions.
Year to Date Giving - The total dollar amount (or other currency, we're not judging) of all gifts received in the current calendar year.
Year to Date Gifts - This is an export-only field that lists all of the gifts received by a Contact for the current year. Each Gift is listed in a single, comma-delimited export field, with the date, amount, and Project designation for each gift.
First Gift Amount - The dollar amount of the first gift received from a Contact, based on their giving history. This will be the gift with the earliest gift date in their history.
First Gift Date - The gift date of the first gift received from a Contact, based on their giving history. This will be the gift with the earliest gift date in their history.
First Gift Segment Code - The Segment Code associated with the first gift received from a Contact, based on their giving history. This will be the gift with the earliest gift date in their history. This value can be used to evaluate acquisition efforts.
First Gift Segment Name - The Segment Name associated with the first gift received from a Contact, based on their giving history. This will be the gift with the earliest gift date in their history. This value can be used to evaluate acquisition efforts.
Fiscal Year to Date Gift Count - The total number of gifts received in the current fiscal year. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Fiscal Year to Date Giving - The total dollar amount of all gifts received in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Last Fiscal Year to Date Gift Count - The combined total number of gifts received in the previous fiscal year and the current fiscal year. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Last Fiscal Year to Date Giving - The combined total dollar amount of all gifts received in the previous fiscal year and the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Last Fiscal Year Gift Count - The total number of gifts received in the previous fiscal year. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Last Fiscal Year Giving - The total dollar amount of all gifts received in the previous fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Second Last Fiscal Year Gift Count - The total number of gifts received in the fiscal year beginning two years ago. For example, in 2021, this will return data for all gifts received in 2019. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Second Last Fiscal Year Giving - The total dollar amount of all gifts received in the fiscal year beginning two years ago. For example, in 2021, this will return data for all gifts received in 2019. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Third Last Fiscal Year Gift Count - The total number of gifts received in the fiscal year beginning three years ago. For example, in 2021, this will return data for all gifts received in 2018. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Third Last Fiscal Year Giving - The total dollar amount of all gifts received in the fiscal year beginning three years ago. For example, in 2021, this will return data for all gifts received in 2018. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Largest Gift Amount - The total dollar amount of the single gift with the highest value a Contact has given in their lifetime.
Largest Gift Date - The gift date of the single gift with the highest value a Contact has given in their lifetime.
Largest Gift Segment Code - The Segment Code associated with the single gift with the highest value a Contact has given in their lifetime.
Largest Gift Segment Name - The Segment Name associated with the single gift with the highest value a Contact has given in their lifetime.
Last Calendar Year Gift Count - The total number of gifts received in the previous calendar year. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions.
Last Calendar Year Giving - The total dollar amount of all gifts received in the previous calendar year.
Last Year to Date Gift Count - The combined total number of gifts received in the previous calendar year and the current year. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions.
Last Year to Date Giving - The combined total dollar amount of all gifts received in the previous calendar year and the current year.
Second Last Year Gift Count - The total number of gifts received in the entire calendar year for the year beginning two years ago. For example, in 2019, this will return data for all gifts received in 2017. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions.
Second Last Year Giving - The total dollar amount of all gifts received in the entire calendar year for the year beginning two years ago. For example, in 2019, this will return data for all gifts received in 2017.
Second Last Year to Date Gift Count - The combined total number of gifts received in the entire calendar year for the year beginning two years ago, the previous calendar year, and the current year. For example, in 2019, this will return data for all gifts received in 2017, 2018, and 2019. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions.
Second Last Year to Date Giving - The combined total dollar amount of all gifts received in the entire calendar year for the year beginning two years ago, the previous calendar year, and the current year. For example, in 2019, this will return data for all gifts received in 2017, 2018, and 2019.
Third Last Year Gift Count - The total number of gifts received in the entire calendar year for the year beginning three years ago. For example, in 2019, this will return data for all gifts received in 2016. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions.
Third Last Year Giving - The total dollar amount of all gifts received in the entire calendar year for the year beginning three years ago. For example, in 2019, this will return data for all gifts received in 2016.
Third Last Year to Date Gift Count - The combined total number of gifts received in the entire calendar year for the year beginning three years ago, the entire calendar year for the year beginning two years ago, the previous calendar year, and the current year. For example, in 2019, this will return data for all gifts received in 2016, 2017, 2018, and 2019. This total will include any and all gifts, including $0 gifts, noncash gifts, and reversing transactions.
Third Last Year to Date Giving - The combined total dollar amount of all gifts received in the entire calendar year for the year beginning three years ago, the entire calendar year for the year beginning two years ago, the previous calendar year, and the current year. For example, in 2019, this will return data for all gifts received in 2016, 2017, 2018, and 2019.
Last Gift Amount - The dollar amount of the most recent gift received from a Contact, based on their giving history. This will be the gift with the latest gift date in their history.
Last Gift Date - The gift date of the most recent gift received from a Contact, based on their giving history. This will be the gift with the latest gift date in their history.
Last Gift Segment Code - The Segment Code associated with the most recent gift received from a Contact, based on their giving history. This will be the gift with the latest gift date in their history.
Last Gift Segment Name - The Segment Name associated with the most recent gift received from a Contact, based on their giving history. This will be the gift with the latest gift date in their history.
Life to Date Gift Count - The total number of gifts received from a Contact, over their entire giving history with your organization.
Life to Date Giving - The total dollar amount of gifts received from a Contact, over their entire giving history with your organization.
Rolling Year Gift Count - The total number of gifts received from a Contact within the last 365 days.
Rolling Year Giving - The total dollar amount of gifts received from a Contact within the last 365 days.
Previous Rolling Year Gift Count - The total number of gifts received from a Contact between 730 days ago and 365 days ago.
Previous Rolling Year Giving - The total dollar amount of gifts received from a Contact between 730 days ago and 365 days ago.
Median Gift Amount - The dollar amount of the gift that falls in the exact middle of a Contacts's entire giving history. For example, if a Contact has given gifts of $25, $50, and $275, the Median would be $50.
Zero Dollar Gift Count - The total number of gifts received from a Contact over their entire giving history with your organization where the gift amount is $0. These may include noncash gifts as well.
First Recurring Gift Date - The recurring gift date of the first recurring gift received from a Contact, based on their giving history. This will be the recurring gift with the earliest recurring gift date in their history. This will only include new recurring gifts, and not payments applied to those gifts.
First Recurring Gift Amount - The recurring gift amount of the first recurring gift received from a Contact, based on their giving history. This will be the recurring gift with the earliest recurring gift date in their history. This will only include new recurring gifts, and not payments applied to those gifts.
Last Recurring Gift Date - The recurring gift date of the most recent recurring gift received from a Contact, based on their giving history. This will be the recurring gift with the latest recurring gift date in their history. This will only include new recurring gifts, and not payments applied to those gifts.
Last Recurring Gift Amount - The recurring gift amount of the most recent recurring gift received from a Contact, based on their giving history. This will be the recurring gift with the latest recurring gift date in their history. This will only include new recurring gifts, and not payments applied to those gifts.
Calendar Year to Date Recurring Gift Count - The total number of recurring gifts a Contact has made in the current calendar year. This will only include new recurring gifts, and not payments applied to those gifts.
Calendar Year to Date Recurring Gift Amount - The total dollar amount of recurring gifts a Contact has made in the current calendar year. This will only include new recurring gifts, and not payments applied to those gifts.
Fiscal Year to Date Recurring Gift Count - The total number of recurring gifts a Contact has made in the current fiscal year. This will only include new recurring gifts, and not payments applied to those gifts.
Fiscal Year to Date Recurring Gift Amount - The total dollar amount of recurring gifts a Contact has made in the current fiscal year. This will only include new recurring gifts, and not payments applied to those gifts.
Raised Life To Date Gift Count - The total number of gifts raised by a Contact, over their entire giving history with your organization. The Contact must be listed as the fundraiser on a peer-to-peer segment to be associated with “raised” gifts.
Raised Life To Date Giving - The total dollar amount of all gifts raised by a Contact, over their entire giving history with your organization. The Contact must be listed as the fundraiser on a peer-to-peer segment to be associated with “raised” gifts.
Raised Year To Date Gift Count - The total number of gifts raised by a Contact, for the current calendar year. The Contact must be listed as the fundraiser on a peer-to-peer segment to be associated with “raised” gifts.
Raised Year To Date Giving - The total dollar amount of all gifts raised by a Contact, for the current calendar year. The Contact must be listed as the fundraiser on a peer-to-peer segment to be associated with “raised” gifts.
Raised Fiscal Year To Date Gift Count - The total number of gifts raised by a contact in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value and the Contact must be listed as the fundraiser on a peer-to-peer segment to be associated with “raised” gifts.
Raised Fiscal Year To Date Giving - The total dollar amount of all gifts raised by a contact in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value and the Contact must be listed as the fundraiser on a peer-to-peer segment to be associated with “raised” gifts.
Last Note Date - The note date of the most recent Contact note logged on a Contact record. Use this value to determine how long it's been since you communicated with your supporters.
Passthrough Statistics
First Passthrough Gift Amount - The dollar amount of the first passthrough gift received from a Contact, based on their giving history. This will be the passthrough gift with the earliest gift date in their history.
First Passthrough Gift Date - The gift date of the first passthrough gift received from a Contact, based on their giving history. This will be the passthrough gift with the earliest gift date in their history.
Last Passthrough Gift Amount - The dollar amount of the most recent passthrough gift received from a Contact, based on their giving history. This will be the passthrough gift with the latest gift date in their history.
Last Passthrough Gift Date - The gift date of the most recent passthrough gift received from a Contact, based on their giving history. This will be the passthrough gift with the latest gift date in their history.
Largest Passthrough Gift Amount - The total dollar amount of the single passthrough gift with the highest value a Contact has given in their lifetime.
Largest Passthrough Gift Date - The gift date of the single passthrough gift with the highest value a Contact has given in their lifetime.
First Gift Amount Overall - The dollar amount of the first gift received from a Contact, based on their giving history. This will be the gift with the earliest gift date in their history, whether it’s Direct Giving or Passthrough Giving.
First Gift Date Overall - The gift date of the first gift received from a Contact, based on their giving history. This will be the gift with the earliest gift date in their history, whether it’s Direct Giving or Passthrough Giving.
Last Gift Amount Overall - The dollar amount of the most recent gift received from a Contact, based on their giving history. This will be the gift with the latest gift date in their history, whether it’s Direct Giving or Passthrough Giving.
Last Gift Date Overall - The gift date of the most recent gift received from a Contact, based on their giving history. This will be the gift with the latest gift date in their history, whether it’s Direct Giving or Passthrough Giving.
Largest Gift Amount Overall - The total dollar amount of the single gift with the highest value a Contact has given in their lifetime, whether it’s Direct Giving or Passthrough Giving.
Largest Gift Date Overall - The gift date of the single gift with the highest value a Contact has given in their lifetime, whether it’s Direct Giving or Passthrough Giving.
Year to Date Passthrough Gift Count - The total number of passthrough gifts received in the current calendar year.
Year to Date Passthrough Giving - The total dollar amount of passthrough gifts received in the current calendar year.
Year to Date Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received in the current calendar year.
Year to Date Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received in the current calendar year.
Last Calendar Year Passthrough Gift Count - The total number of passthrough gifts received in the previous calendar year.
Last Calendar Year Passthrough Giving - The total dollar amount of passthrough gifts received in the previous calendar year.
Last Calendar Year Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received in the previous calendar year.
Last Calendar Year Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received in the previous calendar year.
Life to Date Passthrough Gift Count - The total number of all passthrough gifts received from a Contact, over their entire giving history with your organization.
Life to Date Passthrough Giving - The total dollar amount of all passthrough gifts received from a Contact, over their entire giving history with your organization.
Life to Date Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received from a Contact, over their entire giving history with your organization.
Life to Date Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received from a Contact, over their entire giving history with your organization.
Second Last Year Passthrough Giving - The total dollar amount of all passthrough gifts received in the entire calendar year for the year beginning two years ago. For example, in 2019, this will return data for all gifts received in 2017.
Second Last Year Passthrough Gift Count - The total number of all passthrough gifts received in the entire calendar year for the year beginning two years ago. For example, in 2019, this will return data for all gifts received in 2017.
Second Last Year Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received in the entire calendar year for the year beginning two years ago. For example, in 2019, this will return data for all gifts received in 2017.
Second Last Year Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received in the entire calendar year for the year beginning two years ago. For example, in 2019, this will return data for all gifts received in 2017.
Third Last Year Passthrough Giving - The total dollar amount of all passthrough gifts received in the entire calendar year for the year beginning three years ago. For example, in 2019, this will return data for all gifts received in 2016.
Third Last Year Passthrough Gift Count - The total number of all passthrough gifts received in the entire calendar year for the year beginning three years ago. For example, in 2019, this will return data for all gifts received in 2016.
Third Last Year Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received in the entire calendar year for the year beginning three years ago. For example, in 2019, this will return data for all gifts received in 2016.
Third Last Year Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received in the entire calendar year for the year beginning three years ago. For example, in 2019, this will return data for all gifts received in 2016.
Fiscal Year to Date Passthrough Giving - The total dollar amount of all passthrough gifts received in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Fiscal Year to Date Passthrough Gift Count - The total number of all passthrough gifts received in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Fiscal Year to Date Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Fiscal Year to Date Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Fiscal Year Plus Passthrough Giving - The total dollar amount of all gifts and passthrough gifts received in the current fiscal year. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Last Fiscal Year Plus Passthrough Giving - The combined total amount of all gifts and passthrough gifts received in the previous fiscal year
Second Last Fiscal Year Plus Passthrough Giving - The total amount of all gifts and passthrough gifts received in the fiscal year beginning two years ago. For example, in 2021, this will return data for all gifts received in 2019. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Third Last Fiscal Year Plus Passthrough Giving - The total amount of all gifts and passthrough gifts received in the fiscal year beginning three years ago. For example, in 2021, this will return data for all gifts received in 2018. The fiscal year start date must be set correctly in your organization settings in order to use this value.
Rolling Year Passthrough Giving - The total dollar amount of all passthrough gifts received from a Contact within the last 365 days.
Rolling Year Passthrough Gift Count - The total number of all passthrough gifts received from a Contact within the last 365 days.
Rolling Year Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received from a Contact within the last 365 days.
Rolling Year Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received from a Contact within the last 365 days.
Previous Rolling Year Passthrough Giving - The total dollar amount of all passthrough gifts received from a Contact between 730 days ago and 365 days ago.
Previous Rolling Year Passthrough Gift Count - The total number of all passthrough gifts received from a Contact between 730 days ago and 365 days ago.
Previous Rolling Year Plus Passthrough Giving - The combined total dollar amount of all gifts and passthrough gifts received from a Contact between 730 days ago and 365 days ago.
Previous Rolling Year Plus Passthrough Gift Count - The combined total number of all gifts and passthrough gifts received from a Contact between 730 days ago and 365 days ago.