When working with a Contact query, you'll see several fields that capture giving statistics for Contacts, available as query parameters and and as export fields. 

Not to mention, a whole separate group of Passthrough statistics.

Some of these fields, like "Life to Date Giving," are fairly straightforward, but at first glance, you might wonder what the heck "Second Last Year Plus Passthrough Gift Count" actually means.

Well, this guide is here to help with that.

Below, you'll find definitions of all the Contact statistics, 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.

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.

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.

Last Note Date - The note date of the 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.

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.

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.

Did this answer your question?