Donor Engagement Impact Tracker
This dataset provides a comprehensive view of how individual donor interactions and engagement strategies translate into recurring donations and measurable nonprofit program outcomes. It enables fundraising and impact teams to analyze donor behavior, optimize engagement tactics, and directly link fundraising efforts to program success for improved resource allocation and reporting.
Sample rows
preview · 8 of 110 rows · all 29 columns| donor_idstring | interaction_typestring | donation_amountfloat | is_recurring_donorboolean | donation_typestring | donor_first_namestring | donor_last_namestring | donor_emailstring | donor_phonestring | donor_street_addressstring | donor_citystring | donor_statestring | donor_postal_codestring | donor_countrystring | interaction_idstring | interaction_datedatetime | interaction_channelstring | interaction_notesstring | engagement_strategystring | donation_idstring | donation_datedate | program_idstring | program_namestring | program_outcome_idstring | program_outcome_typestring | program_outcome_valuefloat | program_outcome_datedate | donor_lifetime_valuefloat | donor_engagement_scorefloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DN0001 | 150 | false | one_time | Emily | Harrison | emily.harrison1@ | +1-312-555-0190 | 1732 Oak Grove Ave | Chicago | IL | 60614 | USA | INT1001 | 2024-04-15T10:45:00 | online | Sent thank-you email for last donation. | Spring Donor Appreciation | DON2001 | 2024-04-10 | PRG001 | Food Security Initiative | OUT3001 | beneficiaries served | 67 | 2024-04-13 | 490 | 68.2 | |
| DN0002 | event | 500 | false | one_time | Rajiv | Patel | rajiv.patel2@ | +1-415-555-3482 | 2154 Elm Street | San Francisco | CA | 94105 | USA | INT1002 | 2024-05-02T14:30:00 | in_person | Attended annual fundraising gala. | Major Donor Event | DON2002 | 2024-05-03 | PRG002 | Youth Empowerment | OUT3002 | events held | 3 | 2024-05-05 | 1500 | 81.5 |
| DN0003 | phone_call | 50 | true | recurring | Linda | Nguyen | linda.nguyen3@ | +1-213-555-7623 | 3902 Pine View Rd | Los Angeles | CA | 90032 | USA | INT1003 | 2024-04-18T09:20:00 | phone | Discussed recurring donation options. | Recurring Donor Outreach | DON2003 | 2024-04-19 | PRG003 | Literacy Program | OUT3003 | resources distributed | 120 | 2024-04-20 | 600 | 74.9 |
| DN0004 | social_media | blank | false | blank | Ava | Taylor | ava.taylor4@ | +1-646-555-0054 | 105 West 47th St | New York | NY | 10036 | USA | INT1004 | 2024-06-04T16:05:00 | online | Liked and shared campaign post. | Social Media Advocacy | blank | blank | PRG004 | Community Health | OUT3004 | beneficiaries served | 45 | 2024-06-06 | 0 | 41.2 |
| DN0005 | mailing | 75 | false | one_time | Carlos | Ramirez | c.ramirez5@ | +1-512-555-8088 | 712 South Congress Ave | Austin | TX | 78704 | USA | INT1005 | 2024-03-28T11:40:00 | Received program impact newsletter. | Quarterly Impact Mailing | DON2005 | 2024-03-29 | PRG001 | Food Security Initiative | OUT3005 | resources distributed | 89 | 2024-03-30 | 75 | 52.3 | |
| DN0006 | meeting | 1000 | false | one_time | Fatima | Salah | fatima.salah6@ | +44 20 7946 0228 | 29 Bedford Square | London | London | WC1B 3JD | UK | INT1006 | 2024-05-14T13:25:00 | in_person | Met to discuss major gift. | Major Gift Meetings | DON2006 | 2024-05-15 | PRG002 | Youth Empowerment | OUT3006 | events held | 2 | 2024-05-16 | 3500 | 92 |
| DN0007 | event | 200 | false | one_time | Sophie | Martin | sophie.martin7@ | +33 1 42 78 23 11 | 14 Rue des Martyrs | Paris | Île-de-France | 75009 | France | INT1007 | 2024-04-22T17:00:00 | in_person | Attended donor recognition dinner. | Donor Recognition Events | DON2007 | 2024-04-23 | PRG003 | Literacy Program | OUT3007 | beneficiaries served | 32 | 2024-04-24 | 650 | 65.6 |
| DN0008 | phone_call | blank | false | blank | James | Miller | james.miller8@ | +1-617-555-1084 | 89 Beacon St | Boston | MA | 02108 | USA | INT1008 | 2024-06-01T09:55:00 | phone | Provided update on program progress. | Impact Follow-Up Calls | blank | blank | PRG004 | Community Health | OUT3008 | events held | 1 | 2024-06-02 | 0 | 36.8 |
| DN0009 | mailing | 120 | false | pledge | Hannah | O'Connor | h.oconnor9@ | +353 1 555 2311 | 57 Dame Street | Dublin | Leinster | D02 HD26 | Ireland | INT1009 | 2024-05-18T15:10:00 | Received pledge form by mail. | Pledge Drive | DON2009 | 2024-05-19 | PRG001 | Food Security Initiative | OUT3009 | resources distributed | 54 | 2024-05-20 | 265 | 48.9 | |
| DN0010 | 30 | true | recurring | Yasmin | El-Gamal | y.elgamal10@ | +1-972-555-4456 | 4012 Maple Ave | Dallas | TX | 75219 | USA | INT1010 | 2024-03-14T12:25:00 | online | Sent information on recurring giving. | Recurring Donor Outreach | DON2010 | 2024-03-15 | PRG003 | Literacy Program | OUT3010 | beneficiaries served | 16 | 2024-03-16 | 330 | 54 | |
| DN0011 | meeting | blank | false | blank | Nathan | Chen | nathan.chen11@ | +1-718-555-7182 | 788 Grand Ave | Brooklyn | NY | 11238 | USA | INT1011 | 2024-05-11T11:10:00 | in_person | Met at volunteer appreciation breakfast. | Volunteer Engagement | blank | blank | PRG004 | Community Health | OUT3011 | events held | 1 | 2024-05-12 | 0 | 32.6 |
| DN0012 | social_media | blank | false | blank | Isabelle | Dubois | isabelle.dubois12@ | +33 1 45 32 22 44 | 48 Rue de Lyon | Paris | Île-de-France | 75012 | France | INT1012 | 2024-04-10T16:45:00 | online | Commented on program update post. | Spring Donor Appreciation | blank | blank | PRG002 | Youth Empowerment | OUT3012 | beneficiaries served | 23 | 2024-04-11 | 0 | 29.9 |
| DN0013 | event | 100 | false | pledge | Michael | Smith | michael.smith13@ | +1-305-555-2219 | 623 Ocean Drive | Miami | FL | 33139 | USA | INT1013 | 2024-05-28T18:20:00 | in_person | Participated in program launch event. | Program Launch Events | DON2013 | 2024-05-29 | PRG003 | Literacy Program | OUT3013 | resources distributed | 38 | 2024-05-30 | 100 | 51.1 |
| DN0014 | blank | false | blank | Grace | Lee | grace.lee14@ | +1-206-555-0922 | 1127 Pike St | Seattle | WA | 98101 | USA | INT1014 | 2024-03-21T08:40:00 | online | Sent update on program outcome. | Program Update Email | blank | blank | PRG001 | Food Security Initiative | OUT3014 | beneficiaries served | 11 | 2024-03-22 | 0 | 22.7 | |
| DN0015 | phone_call | 200 | false | pledge | Oliver | Williams | oliver.williams15@ | +1-212-555-0877 | 37 East 60th St | New York | NY | 10022 | USA | INT1015 | 2024-06-10T10:30:00 | phone | Followed up on pledge fulfillment. | Pledge Drive | DON2015 | 2024-06-12 | PRG002 | Youth Empowerment | OUT3015 | events held | 1 | 2024-06-13 | 200 | 57.3 |
| DN0016 | meeting | 0 | false | in_kind | Lucas | Gonzalez | lucas.gonzalez16@ | +34 91 555 2218 | Calle Gran Via 44 | Madrid | Madrid | 28013 | Spain | INT1016 | 2024-04-29T15:35:00 | in_person | Met with staff to discuss in-kind donation. | In-Kind Donor Outreach | DON2016 | 2024-04-30 | PRG001 | Food Security Initiative | OUT3016 | resources distributed | 75 | 2024-05-01 | 0 | 44.8 |
| DN0017 | event | blank | false | blank | Anna | Kowalska | anna.kowalska17@ | +48 22 555 4432 | Ul. Marszalkowska 99 | Warsaw | Mazowieckie | 00-693 | Poland | INT1017 | 2024-03-16T14:20:00 | in_person | Attended donor forum. | Donor Forum | blank | blank | PRG002 | Youth Empowerment | OUT3017 | events held | 1 | 2024-03-17 | 0 | 33.4 |
| DN0018 | phone_call | 75 | false | one_time | Tariq | Al-Mansouri | t.al-mansouri18@ | +971 4 555 1123 | 102 Sheikh Zayed Rd | Dubai | Dubai | 00000 | UAE | INT1018 | 2024-05-09T09:05:00 | phone | Discussed program outcomes. | Impact Follow-Up Calls | DON2018 | 2024-05-10 | PRG003 | Literacy Program | OUT3018 | resources distributed | 41 | 2024-05-11 | 75 | 48 |
| DN0019 | mailing | blank | false | blank | Sarah | Peterson | sarah.peterson19@ | +1-504-555-5123 | 21 Royal St | New Orleans | LA | 70130 | USA | INT1019 | 2024-06-15T13:50:00 | Received program update flyer. | Quarterly Impact Mailing | blank | blank | PRG002 | Youth Empowerment | OUT3019 | beneficiaries served | 17 | 2024-06-16 | 0 | 25.3 | |
| DN0020 | 75 | false | one_time | David | Kim | david.kim20@ | +1-714-555-0033 | 440 S Lemon St | Fullerton | CA | 92832 | USA | INT1020 | 2024-04-09T17:30:00 | online | Sent invitation to donor event. | Donor Recognition Events | DON2020 | 2024-04-10 | PRG001 | Food Security Initiative | OUT3020 | beneficiaries served | 24 | 2024-04-11 | 210 | 46.2 |
What the 110 rows show
from the 110-row sampleMeeting (interaction type) stands out: mean donation_
- 10%is_
recurring_ donor = true - 120median donation_
amount - 3program outcome types
- 4interaction channels
- 15donor countries
- 16program names
Median 120, from 0 to 2,000.
- string 21
- float 4
- date 2
- datetime 1
- boolean 1
Columns
29 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 21 columns | |||
donor_id | string | Unique identifier for each donorunique | DN0001 |
donor_first_name | string | Donor's first name | Emily |
donor_last_name | string | Donor's last name | Harrison |
donor_email | string | Donor's email addressunique | rajiv.patel2@ |
donor_phone | string | Donor's phone numberoptional | +1-312-555-0190 |
donor_street_address | string | Donor's street addressoptional | 1732 Oak Grove Ave |
donor_city | string | Donor's cityoptional | Chicago |
donor_state | string | Donor's state or provinceoptional | IL |
donor_postal_code | string | Donor's postal codeoptional | 60614 |
donor_country | string | Donor's countryoptional | USA |
interaction_id | string | Unique identifier for each donor engagement interactionunique | INT1001 |
interaction_type | string | Type of engagement (e.g., email, phone call, event, meeting, social media)7 values | |
interaction_channel | string | Channel used for engagement (e.g., in-person, online, phone, mail)in_person · online · phone · mail · other · optional | online |
interaction_notes | string | Additional notes or description about the interactionoptional | Attended donor forum. |
engagement_strategy | string | Strategy or campaign associated with the interactionoptional | Major Donor Event |
donation_id | string | Unique identifier for each donationunique · optional | DON2001 |
donation_type | string | Type of donation (e.g., one-time, recurring, pledge, in-kind)one_time · recurring · pledge · in_kind · optional | one_time |
program_id | string | Unique identifier for the nonprofit program or initiative impactedoptional | PRG001 |
program_name | string | Name of the nonprofit program or initiativeoptional | Food Security Initiative |
program_outcome_id | string | Unique identifier for the outcome or impact metricunique · optional | OUT3001 |
program_outcome_type | string | Type of outcome (e.g., beneficiaries served, events held, resources distributed)3 types · optional | beneficiaries served |
| Numbers 4 columns | |||
donation_amount | float | Amount donated in the transaction0 or more · optional | 150 |
program_outcome_value | float | Quantitative value of the outcome (e.g., number of beneficiaries, amount of resources)0 or more · optional | 67 |
donor_lifetime_value | float | Total lifetime donation amount from the donor0 or more · optional | 490 |
donor_engagement_score | float | Calculated score representing donor engagement level0 to 100 · optional | 68.2 |
| Dates and times 3 columns | |||
interaction_date | datetime | Date and time of the donor interaction | 2024-04-15T10:45:00 |
donation_date | date | Date the donation was madeoptional | 2024-04-10 |
program_outcome_date | date | Date the program outcome was achieved or measuredoptional | 2024-04-13 |
| True or false 1 column | |||
is_recurring_donor | boolean | Indicates if the donor is a recurring donoroptional | false |
Use it for
A marketing dashboard
The is_
recurring_ donor rate, donation_ amount by interaction_ type and a breakdown of donation_ type. Excel, Power BI or Tableau. Why do the 11 meeting rows have a mean donation_
amount of 720.5? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Donors110DN0001150emailDN000350phone_ca…DN001030email
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-impact-tracker
Behind this dataset
Same schema. As many rows as you need.
These 110 rows came out of a blueprint — 29 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 row records a unique donor engagement event (e.g., email, call, event attendance)
- Include donor segment, engagement channel, date, and type
- Log subsequent donation amount and project supported (if any)
- Track time between engagement and donation
- Flag recurring donors for retention analysis
- Capture engagement effectiveness score based on conversion rate
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- donor-engagement-impact-tracker