┌──────────────────────────────────────────────────────────────────────┐
│ ORGANIZATION/WORKSPACE │
│ (Caritas Nairobi - Top Level) │
│ - Contains all programs, strategic goals, users, and settings │
│ - Manages organization-wide M&E framework │
│ - Equivalent to: ClickUp Team/Workspace │
└────────────────────┬─────────────────────────────────────────────────┘
│
┌──────────┴───────────┐
│ │
↓ ↓
┌─────────────────┐ ┌──────────────────────────────┐
│ PROGRAM │ │ STRATEGIC GOALS │
│ HIERARCHY │ │ (OKRs/Targets) │
│ (Implementation)│ │ (Performance Tracking) │
└─────────────────┘ └──────────────────────────────┘
│ │
↓ ↓
═══════════════════════════════════════════════════════════════════════
PROGRAM IMPLEMENTATION HIERARCHY
═══════════════════════════════════════════════════════════════════════
┌──────────────────────────────────────────────────────────────────────┐
│ LEVEL 1: PROGRAM MODULES │
│ (Major Thematic Areas) │
│ Equivalent to: ClickUp Space │
└────────────────────┬─────────────────────────────────────────────────┘
│
↓
┌────────────────────────────────────────────────────────┐
│ 📋 FIVE (5) PROGRAM MODULES: │
│ │
│ 1. 🌾 Food, Water & Environment │
│ (Food Security & Livelihoods) │
│ │
│ 2. 💼 Socio-Economic Empowerment │
│ (Financial Inclusion & Livelihoods) │
│ │
│ 3. 👥 Gender, Youth & Peace │
│ (Equality & Development) │
│ │
│ 4. 🆘 Relief & Charitable Services │
│ (Humanitarian Assistance) │
│ │
│ 5. 📚 Capacity Building │
│ (Training & Development) │
└────────────────────────────────────────────────────────┘
│
│ contains
↓
┌──────────────────────────────────────────────────────────────────────┐
│ LEVEL 2: SUB-PROGRAMS / PROJECTS │
│ (Specific Initiatives within Module) │
│ Equivalent to: ClickUp Folder │
│ Examples: │
│ - Climate-Smart Agriculture Project │
│ - Water Access Initiative │
│ - Youth Entrepreneurship Program │
│ - Emergency Relief Operations │
└────────────────────┬─────────────────────────────────────────────────┘
│
│ contains
↓
┌──────────────────────────────────────────────────────────────────────┐
│ LEVEL 3: PROJECT COMPONENTS │
│ (Work Packages / Thematic Areas) │
│ Equivalent to: ClickUp List │
│ Examples: │
│ - Agricultural Training Component │
│ - Input Distribution Component │
│ - Monitoring & Reporting Component │
│ - Beneficiary Registration Component │
└────────────────────┬─────────────────────────────────────────────────┘
│
│ contains
↓
┌──────────────────────────────────────────────────────────────────────┐
│ LEVEL 4: ACTIVITIES │
│ (Specific Implementation Actions) │
│ Equivalent to: ClickUp Task │
│ Examples: │
│ - Farmer Field School Training (Date: 15-Jan-2025) │
│ - Seed Distribution Event (Location: Parish A) │
│ - Youth Skills Training Workshop │
│ - Emergency Food Distribution │
│ │
│ 📊 Activity Details: │
│ - Activity Name & Description │
│ - Location (Parish/Ward/County) │
│ - Date & Duration │
│ - Facilitators/Staff Assigned │
│ - Target Beneficiaries (Number & Type) │
│ - Budget Allocated & Spent │
│ - Status (Planned/Ongoing/Completed/Cancelled) │
│ - Approval Status (Draft/Submitted/Approved/Rejected) │
└────────────────────┬─────────────────────────────────────────────────┘
│
│ contains
↓
┌──────────────┴──────────────────┐
│ │
↓ ↓
┌──────────────────┐ ┌─────────────────────┐
│ SUB-ACTIVITIES │ │ ACTIVITY CHECKLIST │
│ (Optional) │ │ (Implementation) │
│ │ │ │
│ Equivalent to: │ │ Equivalent to: │
│ ClickUp Subtask │ │ ClickUp Checklist │
│ │ │ │
│ Examples: │ │ Examples: │
│ - Setup venue │ │ ☑ Register attendees│
│ - Prep materials │ │ ☑ Conduct training │
│ - Follow-up │ │ ☑ Collect feedback │
│ │ │ ☑ Upload photos │
│ │ │ ☐ Submit report │
└──────────────────┘ └─────────────────────┘
═══════════════════════════════════════════════════════════════════════
STRATEGIC GOALS & PERFORMANCE TRACKING HIERARCHY
═══════════════════════════════════════════════════════════════════════
┌──────────────────────────────────────────────────────────────────────┐
│ LEVEL 1: GOAL CATEGORIES │
│ (Organizational Objectives) │
│ Equivalent to: ClickUp Goal Folders │
│ Examples: │
│ - Annual Strategic Goals 2025 │
│ - Quarterly Performance Goals (Q1 2025) │
│ - Program-Specific Goals │
│ - Donor-Funded Project Goals │
└────────────────────┬─────────────────────────────────────────────────┘
│
│ contains
↓
┌──────────────────────────────────────────────────────────────────────┐
│ LEVEL 2: STRATEGIC GOALS │
│ (High-Level Objectives) │
│ Equivalent to: ClickUp Goal │
│ │
│ Examples: │
│ 🎯 Goal: "Improve Food Security for 5,000 Households" │
│ - Owner: Program Manager │
│ - Timeline: Jan - Dec 2025 │
│ - Progress: 45% Complete │
│ │
│ 🎯 Goal: "Train 500 Youth in Entrepreneurship" │
│ - Owner: Youth Coordinator │
│ - Timeline: Q1-Q2 2025 │
│ - Progress: 68% Complete │
│ │
│ 🎯 Goal: "Reach 50,000 Beneficiaries with Relief Services" │
│ - Owner: Relief Coordinator │
│ - Timeline: 2025 │
│ - Progress: 32% Complete │
└────────────────────┬─────────────────────────────────────────────────┘
│
│ measured by
↓
┌──────────────────────────────────────────────────────────────────────┐
│ LEVEL 3: INDICATORS / TARGETS │
│ (Measurable Key Results) │
│ Equivalent to: ClickUp Target/Key Result │
│ │
│ Four Types of Indicators: │
│ │
│ 📊 1. NUMERIC INDICATORS │
│ Example: "Number of farmers trained" │
│ - Target: 1,000 farmers │
│ - Current: 450 farmers │
│ - Progress: 45% │
│ - Tracking: Manual entry or auto from activities │
│ │
│ 💰 2. FINANCIAL INDICATORS │
│ Example: "Savings mobilized in VSLAs" │
│ - Target: KES 5,000,000 │
│ - Current: KES 2,100,000 │
│ - Progress: 42% │
│ - Tracking: Manual entry │
│ │
│ ✅ 3. BINARY INDICATORS (Yes/No) │
│ Example: "M&E framework developed" │
│ - Status: ✓ Completed │
│ - Tracking: Checkbox │
│ │
│ 📋 4. ACTIVITY-LINKED INDICATORS │
│ Example: "Complete all training activities" │
│ - Linked to: 15 training activities │
│ - Completed: 7 activities │
│ - Progress: 47% (auto-calculated) │
│ - Tracking: Automatic from linked activities │
└────────────────────┬─────────────────────────────────────────────────┘
│
│ links to
↓
┌──────────────┐
│ ACTIVITIES │
│ (from main │
│ hierarchy) │
└──────────────┘
═══════════════════════════════════════════════════════════════════════
CROSS-CUTTING ENTITIES
═══════════════════════════════════════════════════════════════════════
┌──────────────────────────────────────────────────────────────────────┐
│ BENEFICIARIES │
│ - Registered individuals/households receiving services │
│ - Can be linked to multiple activities │
│ - Tracks demographics, location, vulnerability status │
│ - Examples: Farmer John Doe, Youth Group ABC, Household ID 12345 │
└──────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────┐
│ LOCATIONS │
│ - Geographic hierarchy: County → Sub-County → Ward → Parish │
│ - Linked to activities and beneficiaries │
│ - Used for geographic reporting and mapping │
└──────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────┐
│ ATTACHMENTS & EVIDENCE │
│ Equivalent to: ClickUp Attachments │
│ - Photos from field activities │
│ - Attendance sheets │
│ - Training materials │
│ - Distribution lists │
│ - Monitoring reports │
│ - Financial documents │
└──────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────┐
│ COMMENTS & NOTES │
│ Equivalent to: ClickUp Comments │
│ - Activity updates │
│ - Challenges encountered │
│ - Lessons learned │
│ - Approver feedback │
│ - M&E observations │
└──────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────┐
│ TIME TRACKING │
│ Equivalent to: ClickUp Time Entries │
│ - Staff time spent on activities │
│ - Volunteer hours contributed │
│ - Activity duration tracking │
└──────────────────────────────────────────────────────────────────────┘
═══════════════════════════════════════════════════════════════════════
DETAILED MODULE BREAKDOWN
═══════════════════════════════════════════════════════════════════════
## 🌾 **MODULE 1: FOOD, WATER & ENVIRONMENT**
### Sub-Programs (Folders):
1. Climate-Smart Agriculture
2. Water & Irrigation Projects
3. Environmental Conservation
4. Farmer Group Development
5. Market Linkages
### Project Components (Lists):
- Farmer Training Activities
- Input Distribution Records
- Crop Production Monitoring
- Livestock Development
- Water Point Management
- Tree Planting Initiatives
- Farmer Field Schools
### Activities (Tasks):
- "Conduct FFS on Maize Production" (Date, Location, Facilitator)
- "Distribute Drought-Resistant Seeds" (Beneficiaries, Quantity)
- "Establish Drip Irrigation System" (Location, Budget)
- "Form Farmer Marketing Cooperative" (Members, Products)
### Indicators (Targets):
- Number of farmers trained (Target: 1,000)
- Hectares under irrigation (Target: 500 ha)
- Trees planted and surviving (Target: 10,000 trees)
- Increase in crop yields (Target: 30% increase)
- Households achieving food security (Target: 5,000)
---
## 💼 **MODULE 2: SOCIO-ECONOMIC EMPOWERMENT**
### Sub-Programs (Folders):
1. Financial Inclusion & VSLAs
2. Micro-Enterprise Development
3. Business Skills Training
4. Value Chain Development
5. Market Access Support
### Project Components (Lists):
- VSLA Formation & Training
- Business Grants Management
- Entrepreneurship Training
- Savings Mobilization
- Loan Disbursement Tracking
### Activities (Tasks):
- "Form Village Savings & Loans Group" (Members, Location)
- "Business Management Training Workshop" (Participants, Duration)
- "Disburse Micro-Enterprise Grants" (Recipients, Amount)
- "Market Linkage Event" (Businesses, Buyers)
### Indicators (Targets):
- VSLAs formed and active (Target: 100 groups)
- Savings mobilized (Target: KES 5M)
- Businesses supported (Target: 300 enterprises)
- Beneficiaries trained (Target: 800 people)
- Income increase (Target: 40% increase)
---
## 👥 **MODULE 3: GENDER, YOUTH & PEACE**
### Sub-Programs (Folders):
1. Gender Equality & Women Empowerment
2. Youth Development (Beacon Boys)
3. Peacebuilding & Cohesion
4. Persons with Disabilities Support
5. Vulnerable Children Support (OVC)
### Project Components (Lists):
- Gender Sensitization Training
- Youth Skills Development
- Peace Committee Activities
- Disability Inclusion Programs
- Child Protection Services
### Activities (Tasks):
- "Gender-Based Violence Prevention Training" (Participants)
- "Youth Leadership Skills Workshop" (Location, Duration)
- "Peace Dialogue Meeting" (Community, Issues)
- "Disability Rights Awareness Campaign" (Reach)
### Indicators (Targets):
- Women trained on rights (Target: 500)
- Youth skilled and employed (Target: 300)
- Peace committees active (Target: 20)
- PLWDs supported (Target: 150)
- OVCs in school (Target: 400)
---
## 🆘 **MODULE 4: RELIEF & CHARITABLE SERVICES**
### Sub-Programs (Folders):
1. Emergency Response Operations
2. Refugee Support Services
3. Child Care Centers
4. Food Distribution Programs
5. Social Protection Services
### Project Components (Lists):
- Emergency Relief Activities
- Refugee Registration & Assistance
- Child Welfare Services
- Food Aid Distribution
- Shelter & Non-Food Items
### Activities (Tasks):
- "Emergency Food Distribution" (Location, Beneficiaries, Quantity)
- "Refugee Registration Drive" (Number, Needs)
- "Distribute Non-Food Items" (Items, Families)
- "Child Protection Training" (Caregivers)
### Indicators (Targets):
- Beneficiaries reached with relief (Target: 50,000)
- Refugees assisted (Target: 5,000)
- Children in care centers (Target: 300)
- Emergency responses conducted (Target: 15)
- Families receiving support (Target: 8,000)
---
## 📚 **MODULE 5: CAPACITY BUILDING**
### Sub-Programs (Folders):
1. Staff Training & Development
2. Volunteer Mobilization & Management
3. Community Leadership Training
4. Organizational Development
5. Knowledge Management
### Project Components (Lists):
- Staff Training Programs
- Volunteer Recruitment & Training
- Community Facilitator Development
- M&E Capacity Building
- Documentation & Learning
### Activities (Tasks):
- "M&E Training Workshop for Staff" (Participants, Topics)
- "Volunteer Orientation Session" (New volunteers, Hours)
- "Community Facilitator Training" (Trainees, Skills)
- "Knowledge Sharing Event" (Programs, Lessons)
### Indicators (Targets):
- Staff trained (Target: 50)
- Active volunteers (Target: 200)
- Community leaders trained (Target: 150)
- Documentation products (Target: 20)
- Best practices documented (Target: 30)
═══════════════════════════════════════════════════════════════════════
DATABASE STRUCTURE
═══════════════════════════════════════════════════════════════════════
```sql
-- PROGRAM HIERARCHY
organizations (id, name, settings)
↓
program_modules (id, org_id, name, code, description)
↓
sub_programs (id, module_id, name, description, budget)
↓
project_components (id, sub_program_id, name, description)
↓
activities (id, component_id, name, date, location, status, approval_status)
↓
├── sub_activities (id, parent_activity_id, name, status)
├── activity_checklists (id, activity_id, item, completed)
├── activity_beneficiaries (activity_id, beneficiary_id, role)
├── activity_attachments (id, activity_id, file_url, type)
├── activity_comments (id, activity_id, user_id, comment)
└── activity_expenses (id, activity_id, amount, category)
-- GOALS & PERFORMANCE
goal_categories (id, org_id, name, period)
↓
strategic_goals (id, category_id, name, description, target_date, progress)
↓
indicators (id, goal_id, name, type, baseline, target, current, unit)
↓
indicator_values (id, indicator_id, value, date, source)
-- CROSS-REFERENCES
indicator_activity_links (indicator_id, activity_id)
-- Links indicators to activities for auto-tracking
-- CROSS-CUTTING
beneficiaries (id, name, demographics, location, vulnerability)
locations (id, name, type, parent_id, coordinates)
users (id, name, email, role, program_assignments)
attachments (id, entity_type, entity_id, file_url, description)
═══════════════════════════════════════════════════════════════════════ WORKFLOW & APPROVALS ═══════════════════════════════════════════════════════════════════════
- Draft → Field Officer creates activity
- Submitted → Officer submits for review
- Under Review → M&E Officer reviews
- Approved → Activity approved and counted in reports
- Rejected → Sent back with feedback for corrections
- Set Goal → Define strategic goal with deadline
- Create Indicators → Add measurable targets
- Link Activities → Connect activities to indicators
- Auto-Update → Progress auto-calculates from completed activities
- Review Progress → Monitor dashboards and alerts
- Generate Reports → Produce performance reports
═══════════════════════════════════════════════════════════════════════ KEY REPORTS & DASHBOARDS ═══════════════════════════════════════════════════════════════════════
- Program overview (all 5 modules)
- Activities by status and location
- Beneficiary reach statistics
- Budget utilization
- Geographic coverage maps
- Monthly activity summary (by program/location)
- Quarterly progress reports
- Annual performance reports
- Donor-specific reports
- Strategic goals progress dashboard
- Indicator tracking reports
- Target vs actual analysis
- Trend analysis over time
- Data quality assessment
- Indicator achievement rates
- Lessons learned documentation
- Best practices compilation
═══════════════════════════════════════════════════════════════════════ IMPLEMENTATION SUMMARY ═══════════════════════════════════════════════════════════════════════
✅ ADVANTAGES OF THIS MAPPING:
- Clear Hierarchy: Follows logical program structure
- Flexible: Can add/remove programs and projects easily
- Scalable: Supports growth and new initiatives
- Integrated: Links activities to goals for automatic tracking
- User-Friendly: Familiar structure for NGO staff
- Comprehensive: Captures all M&E data needs
- Audit-Ready: Complete approval workflow and history
- Donor-Compliant: Generates required reports automatically
✅ CLICKUP → M&E MAPPING SUMMARY:
| ClickUp Entity | M&E Equivalent | Purpose |
|---|---|---|
| Team/Workspace | Organization | Top-level container |
| Space | Program Module | Major thematic area (5 modules) |
| Folder | Sub-Program/Project | Specific initiatives |
| List | Project Component | Work packages |
| Task | Activity | Implementation actions |
| Subtask | Sub-Activity | Detailed steps |
| Checklist | Activity Checklist | Implementation steps |
| Goal Folder | Goal Category | Organize goals (Annual, Quarterly) |
| Goal | Strategic Goal | High-level objectives |
| Target | Indicator | Measurable key results |
| Comment | Activity Note | Updates and observations |
| Attachment | Evidence | Supporting documents |
| Time Entry | Time Tracking | Staff/volunteer hours |
═══════════════════════════════════════════════════════════════════════
This structure provides a complete M&E system that leverages ClickUp's proven hierarchy while adapting it perfectly for monitoring and evaluation needs!