mcpField
F
fundraising-analyzer

fundraising-analyzer

github.com/travisjneuman营销与增长106149 次安装1 天前更新
代码仓库

关于 fundraising-analyzer

fundraising-analyzer 是帮助非营利团队评估筹款表现并制定数据驱动策略的技能，模板涵盖捐赠者细分与终身价值、活动对比、趋势、月捐和大额捐赠流程。

主要功能

  1. 01捐赠者细分与终身价值
  2. 02筹款活动表现与对比
  3. 03筹款健康指标与基准
  4. 04多年趋势分析
  5. 05月捐项目分析
  6. 06大额捐赠流程跟踪

适用场景

  1. 01比较不同活动的收入、成本和投资回报
  2. 02检查捐赠者留存率与筹款基准
  3. 03跟踪多年收入和捐赠者变化
  4. 04评估月捐项目及大额捐赠流程

安装

复制下面的命令，在终端中运行。

$npx skills add https://github.com/travisjneuman/.claude --skill fundraising-analyzer

安装后在 Claude Code 中输入/fundraising-analyzer确认已加载。

详细介绍

筹款分析器

用于分析非营利组织筹款表现、划分捐赠者群体、评估活动效果以及制定数据驱动筹款策略的框架。

捐赠者分析

捐赠者细分框架
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 (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 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       | ______    | ______    | ____%
活动对比矩阵
指标春季募捐年终募捐筹款晚会慈善星期二点对点筹款
收入$______$______$______$______$______
成本$______$______$______$______$______
投资回报率____%____%____%____%____%
新捐赠者______________________________
平均捐赠金额$______$______$______$______$______

关键指标

筹款健康评分卡
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
基准对比
指标你的组织行业平均值前 25%状态
留存率____%45%65%+
首年留存率____%27%40%+
每筹集一美元的成本$____$0.25<$0.15
在线捐赠占比____%13%25%+
大额捐赠占比____%60%75%+
月度捐赠占比____%15%30%+

趋势分析

多年趋势模板
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: $______

捐赠策略模板

月度捐赠计划分析
MONTHLY GIVING PROGRAM:

CURRENT STATE:
  Monthly donors:           ______
  Average monthly gift:     $______
  Annual value per donor:   $______ (monthly × 12)
  Total annual revenue:     $______
  % of total fundraising:   ____%
  Retention rate:           ____%  (benchmark: 80-90%)

GROWTH ANALYSIS:
  New monthly donors (this year):    ______
  Upgraded from one-time:            ______
  Cancelled:                         ______
  Net change:                        ______

UPGRADE OPPORTUNITIES:
  Donors giving < $25/month:         ______ → Upgrade to $35
  Donors giving $25-49/month:        ______ → Upgrade to $50
  Donors giving $50-99/month:        ______ → Upgrade to $100
  Potential revenue increase:        $______/year

ACQUISITION CHANNELS:
  Channel              | Conversions | Avg Gift | Cost/Acquisition
  Website popup        | ______      | $______  | $______
  Email campaign       | ______      | $______  | $______
  Direct mail insert   | ______      | $______  | $______
  Thank-you page upsell| ______      | $______  | $______
大额捐赠渠道
MAJOR GIFT PIPELINE: FY[Year]

STAGE           | # Prospects | Total Value | Avg Gift  | Probability
----------------|-------------|-------------|-----------|------------
Identification  | ______      | $______     | $______   | 10%
Qualification   | ______      | $______     | $______   | 25%
Cultivation     | ______      | $______     | $______   | 50%
Solicitation    | ______      | $______     | $______   | 75%
Closed          | ______      | $______     | $______   | 100%

WEIGHTED PIPELINE VALUE:
  = Σ (Value at each stage × Probability)
  = $______

PIPELINE METRICS:
  Average cultivation time:    ______ months
  Close rate (solicited):      ____%
  Average solicitation:        $______
  Average closed gift:         $______
  Gifts above ask:             ____%
  Gifts below ask:             ____%

另请参阅

评论

支持 Markdown