fundraising-analyzer

What this skill does

# Fundraising Analyzer

Frameworks for analyzing nonprofit fundraising performance, segmenting donors, evaluating campaign effectiveness, and building data-driven fundraising strategies.

## Donor Analysis

### Donor Segmentation Framework

```
DONOR SEGMENTATION MATRIX:

BY GIVING LEVEL:
  Tier              | Annual Giving      | % of Donors | % of Revenue
  ------------------|--------------------| ------------|-------------
  Major donors      | $10,000+           | [%]         | [%]
  Mid-level donors  | $1,000 - $9,999    | [%]         | [%]
  Grassroots donors | $100 - $999        | [%]         | [%]
  Small donors      | Under $100         | [%]         | [%]

BY ENGAGEMENT:
  Segment           | Definition                    | Strategy
  ------------------|-------------------------------|------------------
  Champions         | Top 10% by giving + volunteer | Steward, recognize
  Loyal             | 3+ consecutive years giving   | Retain, upgrade
  Growing           | Increased gift this year      | Encourage, cultivate
  Lapsed risk       | Decreased gift or late renewal| Re-engage campaign
  Lapsed            | No gift in 13+ months         | Win-back campaign
  New               | First gift in last 12 months  | Welcome series

BY RECENCY-FREQUENCY-MONETARY (RFM):
  Score each 1-5:
  Recency:   How recently did they give? (5 = this month)
  Frequency: How often do they give?     (5 = monthly)
  Monetary:  How much do they give?      (5 = top tier)

  RFM Score  | Segment    | Priority
  555        | Best       | Highest — personal stewardship
  5XX        | Active     | High — upgrade opportunities
  X5X        | Frequent   | Medium — increase gift size
  XX5        | High value | High — increase frequency
  1XX        | At risk    | High — re-engagement needed
  111        | Lost       | Low — win-back or remove
```

### Donor Lifetime Value

```
DONOR LIFETIME VALUE (LTV) CALCULATOR:

INPUTS:
  Average annual gift:           $______
  Average giving years:          ______ years
  Donor retention rate:          ______%
  Discount rate:                 ______% (typically 5-8%)

SIMPLE LTV:
  LTV = Average annual gift × Average giving years
  LTV = $______ × ______ = $______

ADJUSTED LTV (with retention):
  LTV = Average gift × (Retention rate / (1 - Retention rate))
  LTV = $______ × (____% / (1 - ____%)) = $______

COST-ADJUSTED LTV:
  Acquisition cost:              $______
  Annual stewardship cost:       $______
  Net LTV = Adjusted LTV - Acquisition cost - (Stewardship × Years)
  Net LTV = $______

BY SEGMENT:
  Segment          | Avg Gift | Retention | LTV     | Acq Cost | Net LTV
  -----------------|----------|-----------|---------|----------|--------
  Major donors     | $______  | ____%     | $______ | $______  | $______
  Mid-level        | $______  | ____%     | $______ | $______  | $______
  Grassroots       | $______  | ____%     | $______ | $______  | $______
  Small            | $______  | ____%     | $______ | $______  | $______
```

## Campaign Analysis

### Campaign Performance Dashboard

```
CAMPAIGN REPORT: [Campaign Name]
Period: [Start Date] — [End Date]
Goal: $______

RESULTS:
  Revenue raised:       $______  (___% of goal)
  Number of gifts:      ______
  Average gift:         $______
  Median gift:          $______
  New donors acquired:  ______
  Returning donors:     ______

COST ANALYSIS:
  Total campaign cost:  $______
  Cost per dollar raised: $______
  Cost per acquisition:   $______
  ROI: (Revenue - Cost) / Cost = ______%

CHANNEL PERFORMANCE:
  Channel          | Revenue  | Gifts | Avg Gift | Cost    | ROI
  -----------------|----------|-------|----------|---------|-----
  Email            | $______  | _____ | $______  | $______ | ___%
  Direct mail      | $______  | _____ | $______  | $______ | ___%
  Social media     | $______  | _____ | $______  | $______ | ___%
  Website          | $______  | _____ | $______  | $______ | ___%
  Events           | $______  | _____ | $______  | $______ | ___%
  Phone/text       | $______  | _____ | $______  | $______ | ___%

YEAR-OVER-YEAR:
  Metric           | Last Year | This Year | Change
  Revenue          | $______   | $______   | ____%
  Donors           | ______    | ______    | ____%
  Avg gift         | $______   | $______   | ____%
  New donors       | ______    | ______    | ____%
```

### Campaign Comparison Matrix

| Metric | Spring Appeal | Year-End | Gala Event | Giving Tuesday | Peer-to-Peer |
|--------|-------------|----------|-----------|---------------|-------------|
| **Revenue** | $______ | $______ | $______ | $______ | $______ |
| **Cost** | $______ | $______ | $______ | $______ | $______ |
| **ROI** | ____% | ____% | ____% | ____% | ____% |
| **New donors** | ______ | ______ | ______ | ______ | ______ |
| **Avg gift** | $______ | $______ | $______ | $______ | $______ |

## Key Metrics

### Fundraising Health Scorecard

```
ANNUAL FUNDRAISING SCORECARD:

GROWTH METRICS:
  Total revenue:                  $______ (target: $______)
  Revenue growth (YoY):           ____%   (benchmark: 5-10%)
  Number of donors:               ______  (target: ______)
  Donor growth (YoY):             ____%   (benchmark: 5-8%)

RETENTION METRICS:
  Overall retention rate:         ____%   (benchmark: 45-50%)
  First-year donor retention:     ____%   (benchmark: 25-30%)
  Multi-year donor retention:     ____%   (benchmark: 60-65%)
  Donor upgrade rate:             ____%   (benchmark: 10-15%)
  Donor downgrade rate:           ____%   (target: <10%)

EFFICIENCY METRICS:
  Cost to raise a dollar:         $______ (benchmark: $0.20-0.30)
  Fundraising expense ratio:      ____%   (benchmark: <15%)
  Average gift size:              $______
  Revenue per donor:              $______
  Revenue per staff FTE:          $______

DIVERSITY METRICS:
  # of revenue sources:           ______  (target: 5+)
  Largest source % of total:      ____%   (target: <30%)
  Individual vs institutional:    ___% / ___%

HEALTH INDICATORS:
  ✓ Green:  Retention > 50%, Growth > 5%, Diversity > 5 sources
  △ Yellow: Retention 40-50%, Growth 0-5%, 3-4 sources
  ✗ Red:    Retention < 40%, Decline, < 3 sources
```

### Benchmark Comparison

| Metric | Your Org | Sector Avg | Top Quartile | Status |
|--------|---------|-----------|-------------|--------|
| Retention rate | ____% | 45% | 65%+ | |
| First-year retention | ____% | 27% | 40%+ | |
| Cost per dollar | $____ | $0.25 | <$0.15 | |
| Online giving % | ____% | 13% | 25%+ | |
| Major gift % | ____% | 60% | 75%+ | |
| Monthly giving % | ____% | 15% | 30%+ | |

## Trend Analysis

### Multi-Year Trend Template

```
5-YEAR FUNDRAISING TRENDS:

YEAR          | Y-4      | Y-3      | Y-2      | Y-1      | Current
              |----------|----------|----------|----------|--------
Revenue       | $______  | $______  | $______  | $______  | $______
Donors        | ______   | ______   | ______   | ______   | ______
Avg Gift      | $______  | $______  | $______  | $______  | $______
Retention     | ____%    | ____%    | ____%    | ____%    | ____%
New Donors    | ______   | ______   | ______   | ______   | ______
Lapsed Donors | ______   | ______   | ______   | ______   | ______

TREND ANALYSIS:
  Revenue trend:    [Increasing / Stable / Declining] at ___% annually
  Donor base trend: [Growing / Stable / Shrinking] at ___% annually
  Key concern:      [Identify the most worrying trend]
  Key strength:     [Identify the most positive trend]

PROJECTIONS (next 3 years):
  If current trends continue:
    Revenue Y+1: $______
    Revenue Y+2: $______
    Revenue Y+3: $______

  If retention improves by 5%:
    Revenue Y+1: $______
    Revenue Y+2: $______
    Revenue Y+3: $______
```

## Giving Strategy Templates

### Monthly Giving Program Analysis

```
MONTHLY GIVING PROGRAM:

CURRENT STATE:
  Monthly donors:           ______
  Average monthly gift:     $______
  Annual value per donor:   $______ (monthly × 12)
  Total annual revenue:     $______
  % of total fundr