Donor Engagement Lifecycle Metrics
This dataset captures detailed nonprofit donor engagement metrics, including interaction types, event participation, donation history, and response times. It enables organizations to analyze donor patterns, optimize fundraising campaigns, and improve retention through targeted relationship management. The flat schema supports robust reporting and actionable insights for donor lifecycle analysis.
Sample rows
preview · 8 of 75 rows · all 27 columns| donor_idstring | engagement_typestring | response_time_minutesinteger | is_recurring_donorboolean | donor_statestring | donor_first_namestring | donor_last_namestring | donor_emailstring | donor_phonestring | donor_street_addressstring | donor_citystring | donor_postal_codestring | donor_countrystring | engagement_idstring | engagement_datetimedatetime | engagement_channelstring | engagement_outcomestring | event_idstring | event_namestring | event_datedate | donation_idstring | donation_datedate | donation_amountfloat | donation_frequencyinteger | donor_lifetime_valuefloat | last_engagement_datetimedatetime | donor_statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DNR001 | event | 65 | true | CA | Ava | Henderson | ava.henderson22@ | (415) 555-0148 | 1247 Pine St | San Francisco | 94109 | USA | ENG1001 | 2024-04-12T18:30:00 | Spring Gala | attended | EVT001 | Spring Gala | 2024-04-12 | blank | blank | blank | 3 | 950.5 | 2024-05-01T11:20:00 | active |
| DNR002 | 230 | false | IL | Isaac | Nguyen | isaac.nguyen@ | (312) 555-4302 | 4722 N Clark St | Chicago | 60640 | USA | ENG1002 | 2024-05-03T09:42:00 | Monthly Newsletter | responded | blank | blank | blank | blank | blank | blank | 1 | 120 | 2024-05-03T09:42:00 | prospect | |
| DNR003 | social_media | blank | false | MA | Priya | Singh | priya.singh@ | blank | 78 Elmwood Ave | Boston | 02124 | USA | ENG1003 | 2024-04-18T15:12:00 | no_response | blank | blank | blank | blank | blank | blank | 0 | 0 | 2024-04-18T15:12:00 | prospect | |
| DNR004 | phone_call | 12 | true | ON | James | Robertson | j.robertson@ | 647-555-7722 | 21 Maple Crescent | Toronto | M4E 1A7 | Canada | ENG1004 | 2024-03-28T11:34:00 | Volunteer Outreach | responded | blank | blank | blank | blank | blank | blank | 5 | 1750 | 2024-04-25T16:08:00 | active |
| DNR005 | direct_mail | 3280 | false | DC | Fatima | Ali | fatima.ali@ | 202-555-9923 | 3057 Connecticut Ave NW | Washington | 20008 | USA | ENG1005 | 2024-04-10T10:14:00 | Spring Appeal | donated | blank | blank | blank | DON1001 | 2024-04-14 | 250 | 2 | 480 | 2024-04-14T15:45:00 | active |
| DNR006 | event | 85 | true | CA | Liam | O'Connor | liam.oconnor@ | 925-555-1220 | 509 Walnut Dr | Oakland | 94607 | USA | ENG1006 | 2024-03-25T19:00:00 | Annual Banquet | attended | EVT002 | Annual Banquet | 2024-03-25 | blank | blank | blank | 7 | 2250 | 2024-03-25T19:00:00 | active |
| DNR007 | social_media | blank | false | CA | Daniel | Foster | daniel.foster@ | blank | 4402 York Blvd | Los Angeles | 90041 | USA | ENG1007 | 2024-04-19T20:10:00 | other | blank | blank | blank | blank | blank | blank | 2 | 190 | 2024-04-19T20:10:00 | active | |
| DNR008 | blank | false | NY | Mei | Chen | mei.chen@ | 212-555-1109 | 330 West 42nd St | New York | 10036 | USA | ENG1008 | 2024-04-29T08:45:00 | Impact Update | no_response | blank | blank | blank | blank | blank | blank | 0 | 0 | 2024-04-29T08:45:00 | prospect | |
| DNR009 | direct_mail | 1950 | false | MD | Sofia | Martinez | sofia.martinez@ | blank | 19 Calle de la Rosa | Madrid | 28012 | Spain | ENG1009 | 2024-05-07T13:37:00 | Donor Renewal | declined | blank | blank | blank | blank | blank | blank | 1 | 45 | 2024-05-07T13:37:00 | lapsed |
| DNR010 | event | 42 | true | LDN | Omar | El-Sayed | omar.elsayed@ | +44 20 7946 0021 | 15 Fleet St | London | EC4Y 1AA | UK | ENG1010 | 2024-05-02T17:00:00 | Donor Reception | attended | EVT003 | Donor Reception | 2024-05-02 | blank | blank | blank | 4 | 1250 | 2024-05-02T17:00:00 | active |
| DNR011 | 40 | false | CO | Emily | Griffin | emily.griffin@ | 303-555-9812 | 2304 Fox St | Denver | 80216 | USA | ENG1011 | 2024-03-20T14:28:00 | Welcome Email | responded | blank | blank | blank | blank | blank | blank | 2 | 260 | 2024-03-20T14:28:00 | active | |
| DNR012 | phone_call | 11 | true | ON | Lucas | Walker | lucas.walker@ | 416-555-7781 | 98 College St | Toronto | M5G 1L5 | Canada | ENG1012 | 2024-04-02T10:15:00 | Thank You Call | responded | blank | blank | blank | blank | blank | blank | 6 | 1380 | 2024-04-02T10:15:00 | active |
| DNR013 | social_media | blank | false | LDN | Zara | Khan | zara.khan@ | blank | 49 Kingsway | London | WC2B 6TP | UK | ENG1013 | 2024-03-29T15:07:00 | no_response | blank | blank | blank | blank | blank | blank | 0 | 0 | 2024-03-29T15:07:00 | prospect | |
| DNR014 | direct_mail | 1440 | false | MA | John | Miller | john.miller@ | 617-555-1104 | 333 Beacon St | Boston | 02116 | USA | ENG1014 | 2024-04-14T12:18:00 | Annual Report | donated | blank | blank | blank | DON1002 | 2024-04-15 | 100 | 1 | 100 | 2024-04-15T10:30:00 | active |
| DNR015 | event | 95 | false | TX | Chloe | Wright | chloe.wright@ | 214-555-2254 | 5709 Park Ln | Dallas | 75220 | USA | ENG1015 | 2024-05-05T18:00:00 | Volunteer Mixer | attended | EVT004 | Volunteer Mixer | 2024-05-05 | blank | blank | blank | 2 | 380 | 2024-05-05T18:00:00 | active |
| DNR016 | phone_call | 6 | false | BCN | Alejandro | Garcia | alejandro.garcia@ | blank | 14 Avenida de la Paz | Barcelona | 08002 | Spain | ENG1016 | 2024-04-16T16:25:00 | Event Reminder | declined | blank | blank | blank | blank | blank | blank | 0 | 0 | 2024-04-16T16:25:00 | inactive |
| DNR017 | social_media | 210 | false | AZ | Olivia | Davis | olivia.davis@ | 602-555-3412 | 3724 E Camelback Rd | Phoenix | 85018 | USA | ENG1017 | 2024-03-30T18:18:00 | responded | blank | blank | blank | blank | blank | blank | 1 | 75 | 2024-03-30T18:18:00 | prospect | |
| DNR018 | direct_mail | 4320 | true | CA | Victor | Kim | victor.kim@ | 415-555-2831 | 1845 Geary St | San Francisco | 94115 | USA | ENG1018 | 2024-05-08T14:30:00 | Major Donor Letter | donated | blank | blank | blank | DON1003 | 2024-05-11 | 500 | 8 | 3150 | 2024-05-11T17:10:00 | active |
| DNR019 | event | 60 | false | WA | Sara | Peterson | sara.peterson@ | 206-555-1041 | 1459 E Pine St | Seattle | 98122 | USA | ENG1019 | 2024-04-13T17:00:00 | Donor Brunch | attended | EVT005 | Donor Brunch | 2024-04-13 | blank | blank | blank | 3 | 230 | 2024-04-13T17:00:00 | active |
| DNR020 | direct_mail | 2210 | false | IDF | Amira | Hassan | amira.hassan@ | blank | 22 Rue de la République | Paris | 75003 | France | ENG1020 | 2024-05-09T10:45:00 | Spring Appeal | declined | blank | blank | blank | blank | blank | blank | 0 | 0 | 2024-05-09T10:45:00 | inactive |
What the 75 rows show
from the 75-row sampleDirect_
- 19%is_
recurring_ donor = true - 45median response_
time_ minutes - 4donor statuses
- 6donor countries
- 6engagement outcomes
- 90median donation_
amount
Median 45, from 2 to 4,320.
- string 18
- integer 2
- float 2
- date 2
- datetime 2
- boolean 1
Columns
27 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
donor_id | string | Unique identifier for each donorunique | DNR001 |
donor_first_name | string | Donor's first name | Ava |
donor_last_name | string | Donor's last name | Henderson |
donor_email | string | Donor's email addressunique | priya.singh@ |
donor_phone | string | Donor's phone numberoptional | (415) 555-0148 |
donor_street_address | string | Donor's street addressoptional | 1247 Pine St |
donor_city | string | Donor's cityoptional | San Francisco |
donor_state | string | Donor's state or provinceoptional | CA |
donor_postal_code | string | Donor's postal codeoptional | 94109 |
donor_country | string | Donor's country6 countries · optional | USA |
engagement_id | string | Unique identifier for each donor engagement eventunique | ENG1001 |
engagement_type | string | Type of engagement (e.g., email, phone call, event, social media, direct mail)6 values | event |
engagement_channel | string | Specific channel used for engagement (e.g., Facebook, newsletter, gala event)optional | Spring Gala |
engagement_outcome | string | Outcome of the engagement (e.g., responded, attended, donated, no response)6 values · optional | attended |
event_id | string | Unique identifier for events attended by donor (if applicable)optional | EVT001 |
event_name | string | Name of the event attended by donor (if applicable)optional | Spring Gala |
donation_id | string | Unique identifier for each donationoptional | DON1001 |
donor_status | string | Current status of donor (e.g., active, lapsed, prospect)active · lapsed · prospect · inactive · optional | active |
| Numbers 4 columns | |||
response_time_minutes | integer | Time in minutes between engagement and donor response (if applicable)0 or more · optional | 65 |
donation_amount | float | Amount donated in this transaction0 or more · optional | 250 |
donation_frequency | integer | Number of donations made by donor in the past 12 months0 or more · optional | 3 |
donor_lifetime_value | float | Total amount donated by donor to date0 or more · optional | 950.5 |
| Dates and times 4 columns | |||
engagement_datetime | datetime | Date and time of the engagement | 2024-04-12T18:30:00 |
event_date | date | Date of the event (if applicable)optional | 2024-04-12 |
donation_date | date | Date of donationoptional | 2024-04-14 |
last_engagement_datetime | datetime | Date and time of the donor's most recent engagementoptional | 2024-05-01T11:20:00 |
| True or false 1 column | |||
is_recurring_donor | boolean | Indicates if the donor is a recurring donoroptional | true |
Use it for
A marketing dashboard
The is_
recurring_ donor rate, response_ time_ minutes by engagement_ type and a breakdown of donor_ state. Excel, Power BI or Tableau. Why do the 12 direct_
mail rows have a mean response_ time_ minutes of 1,621? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Donors75DNR00165eventDNR002230emailDNR00412phone_ca…
A software demo
Believable donors with donor_
first_ name, donor_ last_ name and donor_ email to fill a screen in front of a buyer.
blueprint · donor-engagement-lifecycle-metrics
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 27 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each donor interaction is timestamped and categorized
- Donors are uniquely identified and mapped to engagement stages
- Engagement scores are recalculated after every interaction
- Donations must be linked to specific campaigns or events
- Retention risk assessment included for donors inactive over 180 days
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- donor-engagement-lifecycle-metrics