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.

  • last updated 6 Dec 2025
  • by GoMask
The brief that made it

Donor segmentation and targeted fundraising campaigns

Sample rows

preview · 8 of 75 rows · all 27 columns
donor_idstringengagement_typestringresponse_time_minutesintegeris_recurring_donorbooleandonor_statestringdonor_first_namestringdonor_last_namestringdonor_emailstringdonor_phonestringdonor_street_addressstringdonor_citystringdonor_postal_codestringdonor_countrystringengagement_idstringengagement_datetimedatetimeengagement_channelstringengagement_outcomestringevent_idstringevent_namestringevent_datedatedonation_idstringdonation_datedatedonation_amountfloatdonation_frequencyintegerdonor_lifetime_valuefloatlast_engagement_datetimedatetimedonor_statusstring
DNR001event65trueCAAvaHendersonava.henderson22@charitymail.org(415) 555-01481247 Pine StSan Francisco94109USAENG10012024-04-12T18:30:00Spring GalaattendedEVT001Spring Gala2024-04-12blankblankblank3950.52024-05-01T11:20:00active
DNR002email230falseILIsaacNguyenisaac.nguyen@donorplus.net(312) 555-43024722 N Clark StChicago60640USAENG10022024-05-03T09:42:00Monthly Newsletterrespondedblankblankblankblankblankblank11202024-05-03T09:42:00prospect
DNR003social_mediablankfalseMAPriyaSinghpriya.singh@kindact.orgblank78 Elmwood AveBoston02124USAENG10032024-04-18T15:12:00Facebookno_responseblankblankblankblankblankblank002024-04-18T15:12:00prospect
DNR004phone_call12trueONJamesRobertsonj.robertson@charitablelife.com647-555-772221 Maple CrescentTorontoM4E 1A7CanadaENG10042024-03-28T11:34:00Volunteer Outreachrespondedblankblankblankblankblankblank517502024-04-25T16:08:00active
DNR005direct_mail3280falseDCFatimaAlifatima.ali@helpinghands.org202-555-99233057 Connecticut Ave NWWashington20008USAENG10052024-04-10T10:14:00Spring AppealdonatedblankblankblankDON10012024-04-1425024802024-04-14T15:45:00active
DNR006event85trueCALiamO'Connorliam.oconnor@donorconnect.com925-555-1220509 Walnut DrOakland94607USAENG10062024-03-25T19:00:00Annual BanquetattendedEVT002Annual Banquet2024-03-25blankblankblank722502024-03-25T19:00:00active
DNR007social_mediablankfalseCADanielFosterdaniel.foster@donorlink.orgblank4402 York BlvdLos Angeles90041USAENG10072024-04-19T20:10:00Instagramotherblankblankblankblankblankblank21902024-04-19T20:10:00active
DNR008emailblankfalseNYMeiChenmei.chen@donorgift.net212-555-1109330 West 42nd StNew York10036USAENG10082024-04-29T08:45:00Impact Updateno_responseblankblankblankblankblankblank002024-04-29T08:45:00prospect

What the 75 rows show

from the 75-row sample

Direct_mail (engagement type) stands out: mean response_time_minutes is 1,621, against 45.5 for the rest.

  • 19%is_recurring_donor = true
  • 45median response_time_minutes
  • 4donor statuses
  • 6donor countries
  • 6engagement outcomes
  • 90median donation_amount
Mean response_time_minutes by engagement_type59 rows
01,0002,00068.4email8 rows33.1phone_…13 rows39.3event18 rows56.8social…8 rows1,621direct…12 rows
response_time_minutes59 rows, in bands of 500
03060510221110102,5004,500response_time_minutes →

Median 45, from 2 to 4,320.

donor_state75 rows · top 10 of 31 values
  1. CA10
  2. ON8
  3. NY8
  4. TX5
  5. IL4
  6. CO4
  7. MA3
  8. FL3
  9. LDN2
  10. AZ2
27 columns by typefrom the column list below
  • string 18
  • integer 2
  • float 2
  • date 2
  • datetime 2
  • boolean 1

Columns

27 columns in four groups
blueprint · 27 columns
columntypedescriptionexample
Text 18 columns
donor_idstringUnique identifier for each donoruniqueDNR001
donor_first_namestringDonor's first nameAva
donor_last_namestringDonor's last nameHenderson
donor_emailstringDonor's email addressuniquepriya.singh@kindact.org
donor_phonestringDonor's phone numberoptional(415) 555-0148
donor_street_addressstringDonor's street addressoptional1247 Pine St
donor_citystringDonor's cityoptionalSan Francisco
donor_statestringDonor's state or provinceoptionalCA
donor_postal_codestringDonor's postal codeoptional94109
donor_countrystringDonor's country6 countries · optionalUSA
engagement_idstringUnique identifier for each donor engagement eventuniqueENG1001
engagement_typestringType of engagement (e.g., email, phone call, event, social media, direct mail)6 valuesevent
engagement_channelstringSpecific channel used for engagement (e.g., Facebook, newsletter, gala event)optionalSpring Gala
engagement_outcomestringOutcome of the engagement (e.g., responded, attended, donated, no response)6 values · optionalattended
event_idstringUnique identifier for events attended by donor (if applicable)optionalEVT001
event_namestringName of the event attended by donor (if applicable)optionalSpring Gala
donation_idstringUnique identifier for each donationoptionalDON1001
donor_statusstringCurrent status of donor (e.g., active, lapsed, prospect)active · lapsed · prospect · inactive · optionalactive
Numbers 4 columns
response_time_minutesintegerTime in minutes between engagement and donor response (if applicable)0 or more · optional65
donation_amountfloatAmount donated in this transaction0 or more · optional250
donation_frequencyintegerNumber of donations made by donor in the past 12 months0 or more · optional3
donor_lifetime_valuefloatTotal amount donated by donor to date0 or more · optional950.5
Dates and times 4 columns
engagement_datetimedatetimeDate and time of the engagement2024-04-12T18:30:00
event_datedateDate of the event (if applicable)optional2024-04-12
donation_datedateDate of donationoptional2024-04-14
last_engagement_datetimedatetimeDate and time of the donor's most recent engagementoptional2024-05-01T11:20:00
True or false 1 column
is_recurring_donorbooleanIndicates if the donor is a recurring donoroptionaltrue

Use it for

  • is recurring d…19%14 of 75 rowsmean response time mi…68.4email33.1phon…39.3event56.8soci…

    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.

  • A software demo

    Believable donors with donor_first_name, donor_last_name and donor_email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset75 rows27 columns
Yours1,000 rows27 columnsdonor_street_address: UK only

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.

Rules it was built with
  • 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
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.