AquaHope Clean Water Initiative: Predicting Donations Custom Case Solution & Analysis

Case Evidence Brief

Financial Metrics

Operational Facts

• The database contains 100,000 potential donors with historical giving data and demographic indicators.
• Current outreach relies on a blanket mailing strategy to the entire list regardless of donor profile.
• Data variables include recency of last gift, frequency of giving, and total monetary value of past contributions.
• The mailing window for the year-end campaign is fixed at six weeks.

Stakeholder Positions

• Executive Director: Focused on maximizing total revenue for clean water projects but concerned about rising solicitation costs.
• Data Analyst: Advocates for the use of logistic regression to rank-order the list and improve efficiency.
• Board of Directors: Demands a higher return on marketing spend and reduction in donor fatigue.

Information Gaps

• Long-term donor retention rates following the first gift are not specified.
• The impact of digital outreach as a substitute or supplement to physical mail is unmeasured.
• Competitive benchmarks for other clean water non-profits in the same geography.

Strategic Analysis

Core Strategic Question

• How can AquaHope optimize its limited marketing budget to maximize net donation revenue while minimizing the costs associated with non-responsive prospects?

Structural Analysis

The current strategy of mailing 100,000 prospects at a 1.80 percent response rate results in a net loss per mailer because the response rate sits below the 3.38 percent break-even threshold. The unit economics of the current mass-mailing model are unsustainable. Applying a predictive lens reveals that a significant portion of the mailing budget is spent on prospects with a near-zero probability of contributing.

Strategic Options

• Option 1: Mass Mailing (Status Quo). Mail to all 100,000 prospects.
  • Rationale: Maintains maximum brand visibility and captures all potential gifts.
  • Trade-offs: High financial loss; ignores data insights; increases donor fatigue.
  • Requirements: $65,000 upfront budget.
• Option 2: Predictive Targeting (Top 40 Percent). Mail only to the top four deciles as ranked by the logistic regression model.
  • Rationale: Targets the segments that historically provide 80 percent of the revenue.
  • Trade-offs: Lower total gross revenue; potential for missing late-blooming donors.
  • Requirements: Data scoring capability and reduced budget of $26,000.
• Option 3: Hybrid Tiered Approach. Mail top deciles with premium content and bottom deciles with low-cost postcards or email.
  • Rationale: Balances efficiency with broad reach.
  • Trade-offs: Increased operational complexity and creative costs.
  • Requirements: Multi-channel marketing infrastructure.

Preliminary Recommendation

AquaHope should adopt Option 2. The predictive model shows that the bottom 60 percent of the list has a response rate so low that every letter sent to them destroys capital. By focusing on the top 40,000 prospects, the organization can shift from a net loss to a net surplus on the campaign, preserving capital for actual clean water implementation.

Implementation Roadmap

Critical Path

• Week 1: Data cleaning and validation of the 100,000-record database to ensure accuracy of recency and frequency variables.
• Week 2: Finalize the logistic regression model and score all prospects.
• Week 3: Segment the list into deciles and select the top 40,000 prospects for the physical mailing.
• Week 4: Transfer the optimized list to the mail house for production.
• Week 6: Launch the campaign and begin tracking real-time response rates.

Key Constraints

• Data Integrity: The model is only as effective as the historical records; missing gift data will lead to incorrect scoring.
• Technical Skill: The internal team must be able to execute the scoring without external consulting delays.

Risk-Adjusted Implementation Strategy

The strategy includes a 5,000-unit control group from the lower deciles. This allows the organization to test if the model is over-filtering and provides data to refine the model for the next cycle. This contingency ensures that if donor behavior shifts unexpectedly, the organization has a baseline for comparison.

Executive Review and BLUF

BLUF

AquaHope must immediately abandon its mass-mailing strategy. The current approach is financially dilutive, as the historical response rate of 1.80 percent fails to meet the 3.38 percent break-even requirement. By implementing a predictive model and targeting only the top 40 percent of prospects, AquaHope will convert a projected campaign loss into a net surplus. This shift preserves $39,000 in marketing capital while capturing the vast majority of expected donations. Speed in transitioning to data-driven selection is the primary driver of campaign profitability for the upcoming year-end cycle.

Dangerous Assumption

The analysis assumes that historical donor behavior is a stable predictor of future giving. If external economic conditions or organizational reputation have changed significantly since the last data collection, the model will miscalculate the response probabilities of the top deciles.

Unaddressed Risks

• Donor Attrition: By stopping communication with the bottom 60 percent, AquaHope may permanently lose the ability to reactivate these donors in future years when their financial situation changes.
• Model Overfitting: The model might be too closely calibrated to past specific campaigns, failing to account for the unique appeal of the current clean water initiative.

Unconsidered Alternative

The team failed to consider a full transition to digital-only outreach for the bottom 60 percent of the list. This would maintain engagement at near-zero marginal cost, mitigating the risk of donor attrition while still achieving the cost savings of the predictive model.

Verdict

APPROVED FOR LEADERSHIP REVIEW