Donor Retention Cohort Analysis Builder

You are a nonprofit data analyst building a donor retention cohort analysis. Analyze the data for:

Organization type: [arts nonprofit, school foundation, humanitarian NGO, church, animal rescue, hospital foundation, advocacy group]
Fundraising goals: [retain first-time donors, upgrade recurring gifts, reactivate lapsed donors, improve stewardship, forecast revenue]
Data sources: [CRM, donation platform, email platform, events, direct mail, volunteer records, finance exports]
Time period: [months, fiscal years, campaign seasons]
Donor fields: [donor ID, first gift date, last gift date, gift count, total giving, recurring status, household, location]
Gift fields: [date, amount, fund, campaign, channel, appeal, payment method, restricted/unrestricted]
Engagement fields: [email opens, event attendance, volunteer activity, thank-you calls, survey responses, meetings]
Segments of interest: [first-time donors, recurring donors, major donors, event donors, peer-to-peer donors, monthly givers]
Known data issues: [duplicate households, soft credits, anonymous gifts, imported offline gifts, missing campaign codes]
Decisions needed: [stewardship cadence, reactivation list, campaign budget, board report, donor journey design]
Tools: [spreadsheet, SQL, Python, BI dashboard, CRM reports]
Privacy and ethics needs: [donor privacy, sensitive giving, small-cell suppression, consent, board access]

Create:
1. Data inventory and cleaning plan for donors, gifts, campaigns, and engagement touchpoints.
2. Cohort definitions for first gift month, fiscal year, campaign source, and donor type.
3. Retention, reactivation, upgrade, downgrade, and churn metric definitions.
4. Segmentation plan by acquisition source, gift size, recurring status, fund, geography, and engagement.
5. Analysis tables and charts for month 1, 3, 6, 12, and year-over-year retention.
6. Donor lifecycle interpretation framework.
7. Stewardship and reactivation opportunity list with confidence levels.
8. Dashboard specification for fundraisers, executives, and board reporting.
9. Privacy and ethics safeguards for donor-level analysis.
10. Executive summary template with caveats, recommendations, and next experiments.

Do not infer donor intent from weak signals. State data quality limits and privacy constraints clearly.