Portfolio project · CRM and fundraising analytics
This report shows how fictional HopeTrack campaign traffic moves from acquisition to first gift, repeat giving, and monthly membership. The purpose is not to showcase a decorative dashboard, but to show the decision logic a communications or fundraising team would use to improve conversion quality.
The objective of this view is to separate volume from donor quality. Traffic alone does not answer whether a channel is moving people into sustainable support.
The main leak is not at the donation completion step. It starts earlier, between donation page arrival and donation start, which suggests message-to-form continuity needs work.
This table is intentionally simple: it helps non-technical stakeholders compare efficiency, not just traffic contribution.
| Channel / audience | Sessions | First donations | First gift CVR | 90-day repeat rate | Membership rate | New donor revenue |
|---|---|---|---|---|---|---|
| Paid Social / Prospecting | 18,240 | 486 | 2.7% | 18.9% | 7.8% | $21,384 |
| Paid Social / Retargeting | 6,240 | 438 | 7.0% | 26.9% | 14.2% | $21,024 |
| Email / Existing supporters | 4,980 | 514 | 10.3% | 36.2% | 24.1% | $28,784 |
| Organic Search / High intent | 7,320 | 205 | 2.8% | 27.3% | 8.8% | $9,225 |
| Direct / Brand traffic | 3,680 | 224 | 6.1% | 32.1% | 15.2% | $11,760 |
| Referral / Partners | 2,940 | 126 | 4.3% | 31.0% | 16.7% | $6,552 |
Interpretation: owned audiences and warmer traffic segments create the strongest downstream donor quality. Prospecting remains useful for scale, but not as the main driver of monthly membership.
The value of this report is in what it tells the team to do next, not in how many metrics it can display.
Email drives the best first-gift conversion, the strongest repeat giving rate, and the highest membership activation rate. This suggests existing-supporter segments are the strongest base for sustainable revenue, not just short-term appeal response.
Paid social prospecting brings reach, but retargeting converts at a much higher rate and generates more membership-ready donors. This supports a tighter handoff between awareness campaigns and lower-funnel retargeting journeys.
More than half of users who reach the donation page do not begin the form. That points to message continuity, form framing, ask clarity, or page trust signals as the likely performance bottleneck.
These actions are intentionally specific enough to guide an actual campaign test plan.
Reduce drop-off by aligning headline, impact promise, and donation ask more tightly between ad or email creative and the donation landing experience.
Shift part of upper-funnel spend toward retargeting cohorts and reactivation journeys that already show stronger first-gift and membership outcomes.
Do not evaluate channels on sessions alone. Pair acquisition volume with repeat giving and membership rates so campaign decisions reflect long-term value.