Create a Donor Report with AI

You are a senior M&E reporting specialist. I need to write a donor progress report. Start by organizing the indicator data I provide. Create an indicator performance table with columns: - Indicator - Baseline value - Target (for this period) - Actual (achieved this period) - Cumulative progress (% of end-of-project target) - Status (on track / slightly behind / significantly behind / ahead of target) - Brief explanation (one sentence per indicator explaining the status) Then write a performance summary paragraph (150-200 words) that highlights: - Number of indicators on track vs. behind - The strongest results - The most concerning gaps - Any data quality caveats Here is my indicator data: [Paste your indicator data, targets, and actuals]

Based on the indicator performance summary, draft the narrative sections of the progress report: 1. **Executive summary** (200-250 words): Key achievements, challenges, and decisions needed. A busy reader should get the full picture from this alone. 2. **Progress by outcome** (one section per outcome, 200-300 words each): For each outcome, describe what was accomplished, what is behind schedule and why, and what corrective action is planned. Reference specific indicators. 3. **Activity highlights** (300-400 words): 3-5 notable activities from this period with concrete details (who, where, how many, what happened). Include at least one challenge alongside successes. 4. **Context and external factors** (100-150 words): Anything outside the program's control that affected implementation this period (weather, political events, partner delays, COVID impacts). Write in the voice of the implementing organization reporting to a donor. Be direct and honest. Do not hide problems or overstate achievements.

Review the narrative sections and strengthen them with evidence integration: 1. **Beneficiary voices**: For each outcome section, suggest where a direct quote from a beneficiary or stakeholder would strengthen the narrative. If I provide quotes, integrate them. If not, flag where they should be added later. 2. **Data visualization suggestions**: For the indicator data, recommend 2-3 specific charts or graphs that would communicate trends more effectively than tables. Describe what each visualization shows (e.g., "bar chart comparing target vs. actual for the 4 outcome indicators" or "trend line showing cumulative reach over 6 quarters"). 3. **Comparison framing**: Where possible, add comparison context (this quarter vs. last quarter, this year vs. last year, program site vs. control, progress vs. sector benchmarks). 4. **Evidence gaps**: Flag any claims in the narrative that are not currently supported by data and suggest what evidence would strengthen them.

Write a lessons learned section (300-400 words) for this progress report. Include: 1. **What worked** (2-3 lessons): Specific approaches or decisions that produced better-than-expected results. Be precise: not "community engagement worked well" but "conducting separate consultations with women's groups before mixed community meetings doubled female participation in decision-making." 2. **What did not work** (1-2 lessons): Approaches that underperformed and why. Frame constructively but honestly. 3. **Adaptations made**: Changes to the program approach based on monitoring data or implementation experience this period. What triggered the change, what was changed, and what was the result? 4. **Implications for next period**: How these lessons will influence the workplan, budget, or strategy going forward. Write lessons that are specific to this program. Generic lessons ("stakeholder engagement is important") are not useful.

Write a recommendations section for this progress report. Include 5-8 recommendations, each with: - **Recommendation** (one specific sentence starting with an action verb) - **Rationale** (one sentence linking back to evidence from the report) - **Responsible party** (who should act on this, leave as TBD for me to fill) - **Priority** (high, medium, low) - **Timeframe** (by when) Organize by priority. High-priority recommendations first. Recommendations must be: - Specific (actionable by a named party in a defined timeframe) - Grounded in evidence from this report (not generic advice) - Realistic (achievable within existing resources and authority) - Limited (5-8 total, not a wish list) End with a brief closing paragraph (2-3 sentences) that summarizes the overall program trajectory and outlook for the next period.