Micro-Charity Donation Flow Analytics
This dataset provides granular, workflow-level analytics for micro-charity donations, capturing donor details, transaction data, workflow steps, bottlenecks, and impact reporting. It enables nonprofit program analysts to identify conversion bottlenecks, optimize fundraising processes, and improve donor engagement and impact transparency.
Sample rows
preview · 8 of 64 rows · all 24 columns| donation_idstring | workflow_stepstring | donation_amountfloat | bottleneck_flagboolean | donor_countrystring | donor_idstring | donor_namestring | donor_emailstring | donor_phonestring | organization_idstring | organization_namestring | campaign_idstring | campaign_namestring | donation_currencystring | donation_datedatetime | donation_statusstring | payment_methodstring | conversion_stagestring | processing_time_secondsfloat | is_recurringboolean | recurring_frequencystring | impact_reportedboolean | impact_report_datedate | bottleneck_reasonstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DN0001 | confirmation_sent | 35.5 | false | United States | DR001 | Anna Martinez | anna.martinez@ | +1-202-555-0175 | ORG001 | Hope for All | CP001 | Clean Water Initiative | USD | 2024-05-03T14:18:23 | completed | credit_card | completed | 18.5 | true | monthly | true | 2024-05-10 | blank |
| DN0002 | confirmation_sent | 60 | false | United Kingdom | DR002 | John K. Lee | johnlee23@ | +44-20-7946-0957 | ORG002 | Green Planet | CP002 | Tree Planting Drive | GBP | 2024-04-18T09:41:12 | completed | paypal | completed | 12.7 | false | none | false | blank | blank |
| DN0003 | form_filled | 15 | true | Canada | DR003 | Emily Wang | emily.wang@ | blank | ORG001 | Hope for All | CP001 | Clean Water Initiative | CAD | 2024-05-07T11:14:54 | pending | credit_card | initiated | 0 | false | none | false | blank | Payment gateway delay |
| DN0004 | confirmation_sent | 21.75 | false | Brazil | DR004 | Luis Nascimento | luis.nascimento@ | +55-11-3124-8256 | ORG003 | Children First | CP003 | School Supplies Drive | BRL | 2024-05-10T17:29:08 | completed | bank_transfer | completed | 40.2 | false | none | true | 2024-05-18 | blank |
| DN0005 | confirmation_sent | 150 | false | United Kingdom | DR002 | John K. Lee | johnlee23@ | +44-20-7946-0957 | ORG002 | Green Planet | CP004 | Ocean Cleanup Fund | GBP | 2024-05-15T21:05:47 | completed | paypal | completed | 14.3 | true | quarterly | true | 2024-05-22 | blank |
| DN0006 | payment_submitted | 50 | true | India | DR005 | Priya Singh | priya.singh@ | +91-22-2234-8765 | ORG004 | Food Relief Network | CP005 | Hunger Free Week | INR | 2024-04-22T13:47:19 | failed | credit_card | abandoned | 3.2 | false | none | false | blank | Card declined |
| DN0007 | confirmation_sent | 25 | false | Spain | DR006 | Samantha Rivera | samantha.rivera@ | +34-91-555-1234 | ORG005 | Animal Aid | CP006 | Pet Shelter Expansion | EUR | 2024-05-13T10:25:36 | completed | credit_card | completed | 9.8 | false | none | true | 2024-05-21 | blank |
| DN0008 | form_filled | 10 | true | Egypt | DR007 | Mohamed Hassan | mohamed.hassan@ | +20-2-2794-5632 | ORG006 | Medical Mission | CP007 | Vaccination Drive | EGP | 2024-05-09T16:38:04 | pending | bank_transfer | initiated | 0 | false | none | false | blank | Incomplete bank details |
| DN0009 | confirmation_sent | 55.8 | false | Russia | DR008 | Olga Petrov | olga.petrov@ | +7-495-555-1234 | ORG007 | Winter Warmth | CP008 | Coat for Kids | RUB | 2024-05-12T18:11:55 | completed | paypal | completed | 20.6 | true | yearly | true | 2024-05-19 | blank |
| DN0010 | confirmation_sent | 12 | false | South Korea | DR009 | Sarah Kim | sarahkim12@ | blank | ORG008 | Bright Future | blank | blank | KRW | 2024-05-14T07:53:17 | completed | credit_card | completed | 8.3 | false | none | true | 2024-05-22 | blank |
| DN0011 | payment_submitted | 70 | true | Australia | DR010 | David Brown | david.brown@ | +61-2-5550-1234 | ORG009 | Youth Empower | CP009 | Tech for Teens | AUD | 2024-05-01T19:22:44 | refunded | credit_card | abandoned | 5.6 | false | none | false | blank | Duplicate transaction |
| DN0012 | confirmation_sent | 29.99 | false | Oman | DR011 | Fatima Al-Farsi | fatima.alfarsi@ | blank | ORG010 | Women Rise | CP010 | Education Empowerment | OMR | 2024-05-11T12:02:38 | completed | bank_transfer | completed | 33.1 | false | none | true | 2024-05-19 | blank |
| DN0013 | confirmation_sent | 120 | false | Germany | DR012 | Peter Schmidt | peter.schmidt@ | +49-30-5550-1234 | ORG005 | Animal Aid | CP006 | Pet Shelter Expansion | EUR | 2024-05-05T22:15:30 | completed | bank_transfer | completed | 28.4 | false | none | true | 2024-05-13 | blank |
| DN0014 | form_filled | 30 | true | France | DR013 | Lisa Dupont | lisa.dupont@ | +33-1-5550-1234 | ORG011 | Health Bridge | CP011 | Medical Outreach | EUR | 2024-05-04T15:18:43 | pending | credit_card | initiated | 0 | false | none | false | blank | Form validation error |
| DN0015 | confirmation_sent | 5 | false | United States | DR014 | Jacob Smith | jacob.smith@ | +1-415-555-1234 | ORG001 | Hope for All | blank | blank | USD | 2024-05-06T20:10:17 | completed | cash | completed | 1.7 | false | none | false | blank | blank |
| DN0016 | confirmation_sent | 8 | false | Vietnam | DR015 | Mai Nguyen | mai.nguyen@ | blank | ORG012 | Green Start | CP012 | Youth Sports Fund | VND | 2024-04-30T08:39:02 | completed | other | completed | 4.5 | false | none | true | 2024-05-07 | blank |
| DN0017 | confirmation_sent | 70 | false | Spain | DR016 | Isabel Garcia | isabel.garcia@ | +34-91-555-6789 | ORG005 | Animal Aid | CP006 | Pet Shelter Expansion | EUR | 2024-05-02T12:20:54 | completed | credit_card | completed | 9.2 | false | none | false | blank | blank |
| DN0018 | confirmation_sent | 90 | false | Egypt | DR017 | Ahmed El-Sayed | ahmed.elsayed@ | blank | ORG006 | Medical Mission | CP013 | Mobile Clinic | EGP | 2024-05-08T14:37:22 | completed | paypal | completed | 15.6 | true | monthly | true | 2024-05-16 | blank |
| DN0019 | form_filled | 20 | true | Italy | DR018 | Maria Rossi | maria.rossi@ | +39-06-5550-1234 | ORG013 | Family Help | CP014 | Meal for Families | EUR | 2024-05-03T10:08:59 | pending | credit_card | initiated | 0 | false | none | false | blank | Payment authentication failed |
| DN0020 | confirmation_sent | 80 | false | United States | DR019 | James Miller | james.miller@ | +1-646-555-1234 | ORG002 | Green Planet | CP002 | Tree Planting Drive | USD | 2024-05-13T15:33:48 | completed | bank_transfer | completed | 19.2 | true | monthly | false | blank | blank |
What the 64 rows show
from the 64-row sampleForm_
- 20%bottleneck_
flag = true - 36.5median donation_
amount - 3conversion stages
- 4donation statuses
- 4recurring frequencies
- 5payment methods
Median 36.5, from 5.0 to 1,200.
- string 17
- float 2
- date 1
- datetime 1
- boolean 3
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
donation_id | string | Unique identifier for each donation transactionunique | DN0001 |
donor_id | string | Unique identifier for each donor | DR001 |
donor_name | string | Full name of the donor | Anna Martinez |
donor_email | string | Email address of the donor | anna.martinez@ |
donor_phone | string | Phone number of the donoroptional | +1-202-555-0175 |
donor_country | string | Country of residence of the donoroptional | United States |
organization_id | string | Unique identifier for the nonprofit organization receiving the donation | ORG001 |
organization_name | string | Name of the nonprofit organization | Hope for All |
campaign_id | string | Unique identifier for the fundraising campaignoptional | CP001 |
campaign_name | string | Name of the fundraising campaignoptional | Clean Water Initiative |
donation_currency | string | Currency code of the donation (e.g., USD, EUR) | USD |
donation_status | string | Current status of the donation (e.g., pending, completed, failed, refunded)pending · completed · failed · refunded | completed |
payment_method | string | Method used for the donation payment (e.g., credit_card, paypal, bank_transfer)credit_card · paypal · bank_transfer · cash · other | credit_card |
conversion_stage | string | Stage in the donation workflow where the donor is (e.g., visited, initiated, completed, abandoned)visited · initiated · completed · abandoned | completed |
workflow_step | string | Specific step in the donation workflow (e.g., landing_page, form_filled, payment_submitted, confirmation_sent)5 values | confirmation_sent |
recurring_frequency | string | Frequency of recurring donation (e.g., monthly, yearly); null if not recurringmonthly · quarterly · yearly · none · optional | monthly |
bottleneck_reason | string | Reason for the bottleneck, if any10 reasons · optional | Payment gateway delay |
| Numbers 2 columns | |||
donation_amount | float | Amount donated in the transaction0.01 or more | 35.5 |
processing_time_seconds | float | Time taken to process the donation (in seconds)0 or more · optional | 18.5 |
| Dates and times 2 columns | |||
donation_date | datetime | Date and time the donation was made | 2024-05-03T14:18:23 |
impact_report_date | date | Date when the impact report was sent to the donoroptional | 2024-05-10 |
| True or false 3 columns | |||
is_recurring | boolean | Indicates if the donation is part of a recurring schedule | true |
impact_reported | boolean | Indicates if the impact of the donation has been reported to the donoroptional | true |
bottleneck_flag | boolean | Indicates if this donation encountered a workflow bottleneckoptional | false |
Use it for
A dashboard
The bottleneck_
flag rate, donation_ amount by workflow_ step and a breakdown of donor_ country. Excel, Power BI or Tableau. Why do 13 of 64 rows have bottleneck_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Donations64DN000135.5confirma…DN000315form_fil…DN000650payment_…
A software demo
Believable donations with donor_
id, donor_ name and donor_ email to fill a screen in front of a buyer.
blueprint · micro-charity-donation-flow-analytics
Behind this dataset
Same schema. As many rows as you need.
These 64 rows came out of a blueprint — 24 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 donation record includes donor type (individual, corporate, recurring)
- Workflow steps tracked: awareness, engagement, donation, thank you, follow-up
- Status fields must reflect completion or pending
- Donation amounts range from $1 to $5,000
- Time-to-donation tracked from initial contact to completion
- Flag donations tied to specific campaigns or unrestricted
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
- micro-charity-donation-flow-analytics