Donor Engagement Metrics Nonprofits
This dataset provides a comprehensive view of donor engagement for educational nonprofits, including detailed donor profiles, communication histories, donation patterns, campaign responses, and lifecycle tracking. It is designed to help organizations optimize outreach, improve donor retention, and maximize fundraising effectiveness through actionable metrics and insights.
Sample rows
preview · 8 of 85 rows · all 25 columns| donor_idstring | donor_lifecycle_stagestring | engagement_scorefloat | donor_countrystring | donor_first_namestring | donor_last_namestring | donor_emailstring | donor_phonestring | donor_street_addressstring | donor_citystring | donor_statestring | donor_postal_codestring | communication_channelstring | last_communication_datedate | communication_frequency_30dinteger | total_donations_countinteger | total_donations_amountfloat | last_donation_datedate | average_donation_amountfloat | donation_frequency_12minteger | campaign_idstring | campaign_response_typestring | campaign_response_datedate | retention_statusstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DNR0001 | active | 88.7 | USA | Emily | Nguyen | emily.nguyen1@ | +1-212-555-0192 | 1024 Park Ave | New York | NY | 10028 | 2024-05-07 | 5 | 8 | 800 | 2024-05-01 | 100 | 7 | CMP202405A | donated | 2024-05-01 | retained | Responds well to email campaigns. | |
| DNR0002 | recurring | 92.6 | USA | Carlos | Gomez | carlos.gomez@ | +1-312-555-0178 | 200 W Lake St | Chicago | IL | 60601 | sms | 2024-06-03 | 3 | 19 | 1900 | 2024-06-01 | 100 | 12 | CMP202406B | shared | 2024-06-01 | retained | Frequent SMS responder. |
| DNR0003 | major | 77 | UK | Sophia | Martinez | s.martinez@ | +44 20 7946 0956 | 88 Queen St | London | London | SW1A 1AA | event | 2024-04-15 | 2 | 3 | 12000 | 2024-04-15 | 4000 | 2 | CMP202404C | attended_event | 2024-04-15 | retained | Major donor, prefers events. |
| DNR0004 | first-time | 41.5 | USA | Jamal | White | jamal.white@ | +1-617-555-0101 | 18 Beacon St | Boston | MA | 02108 | social_media | 2024-06-05 | 1 | 1 | 30 | 2024-06-01 | 30 | 1 | CMP202406D | clicked | 2024-06-01 | at-risk | Engaged via Instagram ad. |
| DNR0005 | active | 72.3 | India | Priya | Patel | priya.patel@ | +91-22-2345-6721 | 501 Residency Rd | Mumbai | MH | 400001 | 2024-05-28 | 4 | 5 | 250.5 | 2024-05-27 | 50.1 | 5 | CMP202405E | donated | 2024-05-27 | retained | Consistent supporter. | |
| DNR0006 | recurring | 90.2 | USA | Olivia | Lee | olivia.lee@ | +1-415-555-0154 | 912 Mission St | San Francisco | CA | 94103 | 2024-06-02 | 6 | 14 | 1120 | 2024-06-01 | 80 | 10 | CMP202406F | donated | 2024-06-01 | retained | Monthly recurring donor. | |
| DNR0007 | lapsed | 15.9 | USA | Benjamin | Carter | ben.carter@ | +1-202-555-0133 | 3300 M St NW | Washington | DC | 20007 | direct_mail | 2024-03-20 | 0 | 6 | 360 | 2023-11-25 | 60 | 0 | CMP202311A | ignored | 2023-11-25 | lost | No donation since last fall. |
| DNR0008 | active | 82.4 | South Korea | Anna | Kim | anna.kim@ | +82-2-3456-7890 | 55 Gangnam-daero | Seoul | Seoul | 06101 | phone | 2024-05-30 | 3 | 9 | 900 | 2024-05-28 | 100 | 8 | CMP202405G | clicked | 2024-05-28 | retained | High engagement via calls. |
| DNR0009 | recurring | 85.8 | USA | Ethan | Smith | ethan.smith@ | +1-305-555-0172 | 601 Ocean Dr | Miami | FL | 33139 | 2024-06-04 | 5 | 11 | 990 | 2024-06-02 | 90 | 9 | CMP202406H | donated | 2024-06-02 | retained | Regular monthly donor. | |
| DNR0010 | prospect | 29.2 | UAE | Fatima | Al-Farsi | fatima.alfarsi@ | +971-4-445-1234 | 210 Sheikh Zayed Rd | Dubai | Dubai | 00000 | social_media | 2024-05-31 | 1 | 0 | 0 | blank | 0 | 0 | CMP202405I | ignored | 2024-05-31 | at-risk | No donations yet. |
| DNR0011 | active | 75.6 | USA | Lucas | Johnson | lucas.johnson@ | +1-214-555-0183 | 3400 Main St | Dallas | TX | 75226 | phone | 2024-06-01 | 4 | 6 | 360 | 2024-05-29 | 60 | 5 | CMP202405J | shared | 2024-05-29 | retained | Shares campaign content. |
| DNR0012 | first-time | 46.8 | USA | Grace | Chen | grace.chen@ | +1-206-555-0152 | 400 Pine St | Seattle | WA | 98101 | 2024-06-05 | 2 | 1 | 25 | 2024-06-03 | 25 | 1 | CMP202406K | donated | 2024-06-03 | at-risk | First gift after newsletter. | |
| DNR0013 | recurring | 87.5 | USA | Mia | Rodriguez | mia.rodriguez@ | +1-602-555-0144 | 700 E Camelback Rd | Phoenix | AZ | 85014 | sms | 2024-05-29 | 3 | 15 | 1200 | 2024-05-29 | 80 | 11 | CMP202405L | donated | 2024-05-29 | retained | Prefers SMS reminders. |
| DNR0014 | major | 80.1 | USA | Thomas | Morales | thomas.morales@ | +1-303-555-0166 | 1234 Broadway | Denver | CO | 80203 | event | 2024-04-10 | 1 | 5 | 15000 | 2024-04-10 | 3000 | 3 | CMP202404M | attended_event | 2024-04-10 | retained | Major donor, attends galas. |
| DNR0015 | lapsed | 12.3 | USA | Liam | Turner | liam.turner@ | +1-404-555-0199 | 88 Peachtree St | Atlanta | GA | 30303 | direct_mail | 2024-01-15 | 0 | 4 | 280 | 2023-12-05 | 70 | 0 | CMP202312N | ignored | 2023-12-05 | lost | No activity in recent months. |
| DNR0016 | prospect | 33.8 | USA | Isabella | Williams | isabella.williams@ | +1-215-555-0168 | 910 Walnut St | Philadelphia | PA | 19107 | social_media | 2024-05-24 | 2 | 0 | 0 | blank | 0 | 0 | CMP202405O | clicked | 2024-05-24 | at-risk | Engaged through Facebook. |
| DNR0017 | active | 68.4 | USA | Oliver | Brown | oliver.brown@ | +1-512-555-0197 | 2200 Guadalupe St | Austin | TX | 78705 | phone | 2024-05-28 | 2 | 7 | 700 | 2024-05-27 | 100 | 6 | CMP202405P | shared | 2024-05-27 | retained | Active in phone campaigns. |
| DNR0018 | recurring | 84 | USA | Ava | Garcia | ava.garcia@ | +1-305-555-0187 | 1500 Biscayne Blvd | Miami | FL | 33132 | sms | 2024-06-03 | 3 | 10 | 800 | 2024-06-01 | 80 | 8 | CMP202406Q | donated | 2024-06-01 | retained | Prefers SMS reminders. |
| DNR0019 | active | 71.3 | USA | Noah | Thompson | noah.thompson@ | +1-703-555-0138 | 2101 Crystal Dr | Arlington | VA | 22202 | 2024-05-25 | 3 | 7 | 420 | 2024-05-23 | 60 | 5 | CMP202405R | donated | 2024-05-23 | retained | Long-term supporter. | |
| DNR0020 | first-time | 39.7 | India | Sanjay | Mehta | sanjay.mehta@ | +91-22-3345-1234 | 502 Linking Rd | Mumbai | MH | 400052 | 2024-05-19 | 1 | 1 | 45 | 2024-05-19 | 45 | 1 | CMP202405S | donated | 2024-05-19 | at-risk | First donation after email. |
What the 85 rows show
from the 85-row sampleLapsed (donor lifecycle stage) stands out: mean engagement_
- 73.1median engagement_
score - 3retention statuses
- 5campaign response types
- 6communication channels
- 2median communication_
frequency_ 30d - 6median total_
donations_ count
Median 73.1, from 8.4 to 94.2.
- string 16
- integer 3
- float 3
- date 3
Columns
25 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
donor_id | string | Unique identifier for each donorunique | DNR0001 |
donor_first_name | string | Donor's first name | Emily |
donor_last_name | string | Donor's last name | Nguyen |
donor_email | string | Donor's email addressunique | s.martinez@ |
donor_phone | string | Donor's phone numberoptional | +1-212-555-0192 |
donor_street_address | string | Donor's street addressoptional | 1024 Park Ave |
donor_city | string | Donor's cityoptional | New York |
donor_state | string | Donor's state or provinceoptional | NY |
donor_postal_code | string | Donor's postal codeoptional | 10028 |
donor_country | string | Donor's countryoptional | USA |
donor_lifecycle_stage | string | Current lifecycle stage of the donor (e.g., prospect, active, lapsed, recurring)6 values | active |
communication_channel | string | Primary communication channel used for donor outreach6 values | |
campaign_id | string | Identifier of the most recent campaign the donor interacted withoptional | CMP202405A |
campaign_response_type | string | Type of response to the most recent campaign (e.g., donated, shared, ignored)donated · shared · clicked · ignored · attended_event · optional | donated |
retention_status | string | Current retention status of the donor (e.g., retained, at-risk, lost)retained · at-risk · lost · optional | retained |
notes | string | Additional notes or comments about the donoroptional | Frequent SMS responder. |
| Numbers 6 columns | |||
communication_frequency_30d | integer | Number of communications sent to the donor in the last 30 days0 or more · optional | 5 |
total_donations_count | integer | Total number of donations made by the donor0 or more · optional | 8 |
total_donations_amount | float | Total monetary amount donated by the donor0 or more · optional | 800 |
average_donation_amount | float | Average amount donated per donation by the donor0 or more · optional | 100 |
donation_frequency_12m | integer | Number of donations made by the donor in the last 12 months0 or more · optional | 7 |
engagement_score | float | Calculated engagement score based on donor activity and interactions0 to 100 · optional | 88.7 |
| Dates and times 3 columns | |||
last_communication_date | date | Date of last communication with the donoroptional | 2024-05-07 |
last_donation_date | date | Date of the donor's most recent donationoptional | 2024-05-01 |
campaign_response_date | date | Date of the donor's response to the most recent campaignoptional | 2024-05-01 |
Use it for
An education dashboard
Engagement_
score by donor_ lifecycle_ stage and a breakdown of donor_ country. Excel, Power BI or Tableau. Why do the 10 lapsed rows have a mean engagement_
score of 17.5? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Donors85DNR000188.7activeDNR000292.6recurringDNR000377major
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-metrics-nonprofits
Behind this dataset
Same schema. As many rows as you need.
These 85 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 donor must have a unique identifier
- Campaign response is logged per communication instance
- Donation frequency is categorized (monthly, quarterly, annual)
- Lifecycle stage is updated based on latest engagement
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-metrics-nonprofits