Excel Template - Explanation of Fields

Constituent ID -> The unique donor ID number or text that is assigned to your donor within your CRM

Fields in red are mandatory

Greatest Gift -> The largest dollar amount received from each donor

Fields in yellow are optional but will enhance the ask amounts 

Lifetime Giving -> Total gift amount donors made to your organization over their lifetime of giving

Number Of Lifetime Gifts -> Total number of gifts each donor made to your organization

Appeal Gifts Last Year -> Total dollar amount received or pledged that each donor made to your appeal last year

Fields in green are the minimum requested data to create ask amounts

Appeal Gifts Two Years Ago -> Total dollar amount received or pledged that each donor made to your appeal two years ago

Appeal Gifts Three Years Ago -> Total dollar amount received or pledged that each donor made to your appeal three years ago

Campaign Gifts -> Total dollar amount received (if the capital campaign is completed) or pledged dollar amount (if capital campaign collection is in progress) that each donor made to your capital campaign (we recommend only adding this giving data if you had a capital campaign in the last 3-8 years)

Fields in yellow are optional but will enhance the ask amounts

Special Event Gifts -> Total dollar amount donors gave during a recent special event (for example, think of gifts received at your latest golf event or gala)

Wealth Rating – Minimum Suggested Ask -> If you have conducted wealth research for your donors, this would generally be the minimum suggested ask amount (wealth research firms provide different types of data – the minimum ask amount might be located in an ask range or estimated capacity range)

Last Name

Fields in purple are optional -> this is additional information you might use for your direct mailing

First Name

Spouse -> first name of donor’s spouse

Address1

City

State

Zip

Preferred Email

Preferred Name

Additional Fields 1-10 -> Any other records can be placed in these fields. These will not impact the ask amounts. You can add up to 15 additional fields.