Nonprofit Donor Engagement Metrics
This dataset provides a unified view of nonprofit donor engagement, capturing key metrics across donations, email campaigns, event attendance, and social media advocacy. It enables organizations to identify high-value donors, optimize outreach strategies, and measure the impact of campaigns on donor retention and conversion. The flat structure supports advanced analytics and segmentation for fundraising and engagement optimization.
Sample rows
preview · 8 of 120 rows · all 25 columns| donor_idstring | donor_retention_statusstring | social_media_advocacy_scorefloat | high_value_donor_flagboolean | donor_countrystring | donor_first_namestring | donor_last_namestring | donor_emailstring | donor_phonestring | donor_street_addressstring | donor_citystring | donor_statestring | donor_postal_codestring | donor_since_datedate | total_donations_amountfloat | total_donations_countinteger | last_donation_datedate | email_engagement_scorefloat | email_open_countinteger | email_click_countinteger | event_attendance_countinteger | last_event_attended_datedate | social_media_share_countinteger | social_media_mention_countinteger | donor_conversion_statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| donor0001 | active | 87.3 | true | USA | Ava | Clark | ava.clark@ | +1-415-555-2871 | 2128 Lincoln Blvd | San Francisco | CA | 94109 | 2016-03-14 | 13450.75 | 37 | 2024-05-08 | 92.7 | 678 | 57 | 14 | 2024-03-11 | 63 | 18 | repeat |
| donor0002 | new | 2.6 | false | India | Nina | Patel | nina.patel@ | +91 98205 44321 | 57 MG Road | Mumbai | MH | 400001 | 2022-04-21 | 46 | 1 | 2023-10-17 | 12.3 | 4 | 1 | 0 | blank | 0 | 0 | converted |
| donor0003 | prospect | 5.9 | false | Denmark | Lars | Hansen | lars.hansen@ | +45 22 33 44 55 | Bredgade 12 | Copenhagen | blank | 1260 | 2019-07-13 | 0 | 0 | blank | 91.2 | 612 | 8 | 0 | blank | 2 | 1 | prospect |
| donor0004 | active | 93.1 | true | Spain | Mateo | Santos | mateo.santos@ | +34 661 123 456 | Calle Mayor 45 | Madrid | MD | 28013 | 2012-10-06 | 22564.2 | 43 | 2024-04-12 | 85.6 | 412 | 68 | 19 | 2024-02-25 | 54 | 23 | repeat |
| donor0005 | prospect | 3.2 | false | USA | Sophia | Martinez | sophia.martinez@ | +1-305-222-1098 | 1121 SW 8th Ave | Miami | FL | 33130 | 2018-08-22 | 0 | 0 | blank | 88.4 | 341 | 5 | 1 | 2024-05-06 | 1 | 0 | prospect |
| donor0006 | new | 0 | false | South Korea | Hannah | Lee | hannah.lee@ | blank | 23 Insa-dong | Seoul | blank | 03164 | 2021-07-11 | 82 | 2 | 2023-09-04 | 17.4 | 2 | 0 | 0 | blank | 0 | 0 | converted |
| donor0007 | lapsed | 9.3 | false | UK | Owen | Foster | owen.foster@ | +44 7700 900123 | 19 Abbey Road | London | ENG | NW8 9AY | 2015-02-05 | 3287.15 | 8 | 2023-07-12 | 29.1 | 8 | 2 | 1 | 2023-07-07 | 2 | 1 | repeat |
| donor0008 | active | 94.4 | true | USA | Jasmine | Nguyen | jasmine.nguyen@ | +1-832-555-4398 | 7832 Memorial Dr | Houston | TX | 77024 | 2011-05-18 | 32768.75 | 89 | 2024-04-25 | 98.9 | 987 | 94 | 13 | 2024-02-08 | 65 | 24 | repeat |
| donor0009 | prospect | 7.1 | false | Russia | Ivan | Petrov | ivan.petrov@ | +7 903 123 4567 | Ulitsa Tverskaya 22 | Moscow | MOW | 125009 | 2020-09-03 | 0 | 0 | blank | 84.2 | 425 | 7 | 0 | blank | 1 | 0 | prospect |
| donor0010 | lapsed | 6.8 | false | India | Maya | Singh | maya.singh@ | +91 98765 43210 | 5A Rajendra Place | New Delhi | DL | 110008 | 2018-04-15 | 298 | 4 | 2022-07-11 | 19.2 | 7 | 1 | 1 | 2022-05-22 | 2 | 0 | converted |
| donor0011 | new | 1.6 | false | Canada | Connor | Wright | connor.wright@ | blank | 62 Elm Street | Toronto | ON | M5G 2K5 | 2017-09-23 | 158 | 2 | 2023-11-21 | 13 | 5 | 0 | 0 | blank | 0 | 0 | converted |
| donor0012 | recovered | 13.4 | false | France | Isabelle | Dubois | isabelle.dubois@ | +33 6 12 34 56 78 | 14 Rue du Bac | Paris | blank | 75007 | 2013-02-27 | 6848.6 | 14 | 2023-12-03 | 52.3 | 18 | 4 | 2 | 2022-10-17 | 2 | 1 | repeat |
| donor0013 | prospect | 5.4 | false | China | Emily | Zhao | emily.zhao@ | blank | 6 Huixin East Street | Beijing | blank | 100029 | 2015-11-05 | 0 | 0 | blank | 86.1 | 412 | 7 | 2 | 2024-04-15 | 2 | 1 | prospect |
| donor0014 | active | 97.2 | true | Germany | Lucas | Berg | lucas.berg@ | +49 151 12345678 | Hauptstrasse 83 | Berlin | BE | 10117 | 2012-04-18 | 41798 | 56 | 2024-03-02 | 94.5 | 934 | 86 | 18 | 2024-02-23 | 59 | 22 | repeat |
| donor0015 | lapsed | 8.7 | false | Russia | Elena | Ivanova | elena.ivanova@ | +7 921 555 2233 | Ligovsky Prospekt 75 | Saint Petersburg | blank | 191040 | 2011-09-10 | 1297.4 | 10 | 2023-06-17 | 24.3 | 14 | 2 | 2 | 2022-09-09 | 2 | 1 | repeat |
| donor0016 | lapsed | 8.3 | false | South Korea | Grace | Kim | grace.kim@ | +82 10-1234-5678 | 123 Gangnam-daero | Seoul | blank | 06130 | 2017-10-04 | 598 | 7 | 2022-12-15 | 28.2 | 11 | 1 | 0 | blank | 1 | 0 | repeat |
| donor0017 | recovered | 11.9 | false | USA | Ethan | Brown | ethan.brown@ | +1-206-555-7901 | 1401 Pike St | Seattle | WA | 98101 | 2016-06-12 | 1096.3 | 6 | 2023-08-22 | 41.2 | 17 | 3 | 2 | 2022-07-18 | 2 | 1 | repeat |
| donor0018 | prospect | 4.6 | false | USA | Amelia | Smith | amelia.smith@ | +1-404-555-4321 | 215 Peachtree St | Atlanta | GA | 30303 | 2019-01-12 | 0 | 0 | blank | 97.8 | 845 | 6 | 0 | blank | 2 | 1 | prospect |
| donor0019 | lapsed | 2.8 | false | Spain | Diego | Garcia | diego.garcia@ | +34 622 555 789 | Avenida de la Paz 32 | Valencia | VC | 46021 | 2017-11-14 | 212 | 3 | 2022-06-08 | 15.9 | 4 | 0 | 0 | blank | 1 | 0 | converted |
| donor0020 | active | 75.4 | true | USA | Olivia | Miller | olivia.miller@ | +1-617-555-1234 | 11 Beacon St | Boston | MA | 02108 | 2013-10-23 | 17890 | 34 | 2024-02-28 | 88.1 | 634 | 61 | 10 | 2023-11-18 | 42 | 15 | repeat |
What the 120 rows show
from the 120-row sampleActive (donor retention status) stands out: mean social_
- 30%high_
value_ donor_ flag = true - 8.8median social_
media_ advocacy_ score - 3donor conversion statuses
- 505.0median total_
donations_ amount - 5median total_
donations_ count - 81.0median email_
engagement_ score
Every row with social_
- string 12
- integer 6
- float 3
- date 3
- boolean 1
Columns
25 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
donor_id | string | Unique identifier for each donorunique | donor0001 |
donor_first_name | string | Donor's first name | Ava |
donor_last_name | string | Donor's last name | Clark |
donor_email | string | Donor's email addressunique | ava.clark@ |
donor_phone | string | Donor's phone numberoptional | +1-415-555-2871 |
donor_street_address | string | Donor's street addressoptional | 2128 Lincoln Blvd |
donor_city | string | Donor's cityoptional | San Francisco |
donor_state | string | Donor's state or provinceoptional | CA |
donor_postal_code | string | Donor's postal or ZIP codeoptional | 94109 |
donor_country | string | Donor's countryoptional | USA |
donor_retention_status | string | Current retention status of the donoractive · lapsed · new · recovered | active |
donor_conversion_status | string | Conversion status indicating if donor has converted from prospect to active donorprospect · converted · repeat | repeat |
| Numbers 9 columns | |||
total_donations_amount | float | Cumulative amount donated by the donor0 or more | 13450.75 |
total_donations_count | integer | Total number of donations made by the donor0 or more | 37 |
email_engagement_score | float | Aggregate score representing donor's engagement with email campaigns (e.g., opens, clicks)0 to 100 · optional | 92.7 |
email_open_count | integer | Total number of emails opened by the donor0 or more · optional | 678 |
email_click_count | integer | Total number of email links clicked by the donor0 or more · optional | 57 |
event_attendance_count | integer | Number of nonprofit events attended by the donor0 or more · optional | 14 |
social_media_advocacy_score | float | Aggregate score representing donor's advocacy on social media (e.g., shares, mentions)0 to 100 · optional | 87.3 |
social_media_share_count | integer | Number of times donor shared nonprofit content on social media0 or more · optional | 63 |
social_media_mention_count | integer | Number of times donor mentioned the nonprofit on social media0 or more · optional | 18 |
| Dates and times 3 columns | |||
donor_since_date | date | Date donor first engaged with the nonprofit | 2016-03-14 |
last_donation_date | date | Date of the donor's most recent donationoptional | 2024-05-08 |
last_event_attended_date | date | Date of the most recent event attended by the donoroptional | 2024-03-11 |
| True or false 1 column | |||
high_value_donor_flag | boolean | Flag indicating if donor is considered high-value based on donations or engagementoptional | true |
Use it for
A marketing dashboard
The high_
value_ donor_ flag rate, social_ media_ advocacy_ score by donor_ retention_ status and a breakdown of donor_ country. Excel, Power BI or Tableau. Why do the 36 active rows have a mean social_
media_ advocacy_ score of 81.9? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Donors120donor000187.3activedonor00022.6newdonor000493.1active
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 · nonprofit-donor-engagement-metrics
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 25 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 represents a unique donor engagement event.
- Include donor ID, engagement channel, event type, timestamp, and outcome.
- Events must be mapped to active fundraising campaigns.
- Donor engagement scores are calculated based on frequency and event type.
- Exclude anonymous donors and inactive campaigns.
- Outcomes must be one of: donation, pledge, advocacy action, no response.
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
- nonprofit-donor-engagement-metrics