Micro Project Overview

Colorado Gives Report Numbers

#00479

Requester: Jackie Poliseo

Department: Annual Giving

Project Type: Data Input/Output

Requested: 01/29/18

Due: 02/09/18

No assets were uploaded


Description

Hello - Community First Foundation requires that we answer a few questions about Colorado Gives Day for their yearly report. Could you help with gathering the numbers required to answer the following questions? Our responses are due to them by 2/12. Please let me know if you'd like to talk through any additional parameters that they don't address. Thank you! Jackie Question: How many Colorado Gives Day donors were first-time donors to your organization? How to answer: If the donor on your Colorado Gives Day 2017 donation report has donated to you before (i.e., the person is in your organization’s entire donor database prior to Colorado Gives Day 2017), then do not count him. If the donor has NOT given to you in any way before, then count him. Question: How many Colorado Gives Day donors were lapsed (donors who had not given to your organization for two or more years)? There are three steps to this: 1. Use this formula: (total # Colorado Gives Day 2017 donors) - (# first-time donors as calculated above) = # of existing donors 2. Check the donors identified as existing against your organization’s entire donor database to see when each of them last gave to you. 3. If the existing donor last gave to you two or more years ago, then count him. If the existing donor last gave to you more recently than two years ago, then do not count him Question: We have heard stories about the "halo" effect of Colorado Gives Day. What was the total dollar amount of donations given to your organization that were inspired by Colorado Gives Day, but were not made through the ColoradoGives.org website? How to answer: If your organization received any physical checks, cash, or donations through other online platforms related to Colorado Gives Day, calculate the total dollar amount of those donations.

Connected to existing project brief?

No information was provided