MASP IV Data Platform — Instructions & Methodology
Solidaridad East & Central Africa · 2026–2030
Overview
This platform collects, processes, and visualises results for the twelve MASP IV KPIsacross Solidaridad's East & Central Africa programme (Kenya, Uganda, Tanzania, Ethiopia) from 2026 to 2030. These comprise Network mandated KPIs (S6.1–S6.5, S2.1, S2.5) and five REC Level Indicators (REC01–REC05). Outcome data enters through KoboToolbox surveys; REC indicators are entered directly in the Targets & Achievements tab as annual counts. The system distinguishes between two measurement approaches — sample-based extrapolation for farmer-level production KPIs, and direct counting for institutional, company, and REC KPIs. 2026 is the first year of MASP IV, continuing directly from the MASP III cycle (2021–2025).
KPI Framework
Sample-based KPIs
S6.1, S6.2, S2.1 use household survey samples. Achievement is extrapolated from the sample to the full target population using a post-stratification estimator. Cards in the dashboard show an est. badge. In 2026, raw sample counts are shown — no extrapolation is applied until sufficient survey data has been collected.
Count-based KPIs
S2.5, S6.3, S6.4, S6.5 are direct counts from KoboToolbox submissions. REC01–REC05are also direct counts, entered manually each year in the Targets & Achievements tab — no survey form or CSV upload is required for these. Cards show a count badge. No sampling or extrapolation is involved.
Data Collection Process
Farmer surveys (S6.1, S6.2, S2.1, S2.5)
1
Sampling frame
Project teams define the target population for each project (e.g. all registered farmers in the programme area). Targets are entered in the Targets & Achievements tab, disaggregated by KPI and gender where available.
2
Sample design
A random or systematic sample of farmers is drawn from the target population. Gender-stratified sampling is recommended so that female and male farmers are sampled in proportion to their share of the target.
3
Survey administration
Enumerators use the KoboToolbox form (download above) on mobile devices. Each response is submitted to the Solidaridad KoboToolbox server in real time. The form covers S6.1, S6.2, S2.1, and S2.5 in a single interview per farmer.
4
Export & upload
Project officers export the completed survey as a CSV from KoboToolbox and upload it via the Import CSV tab on this platform. Submissions enter a review queue before being approved and counted.
Institutional surveys (S6.3, S6.4, S6.5)
1
Respondent identification
Country managers identify the CSOs (for S6.3) and companies (for S6.4/S6.5) engaged in each project during the survey year.
2
Form completion
Respondents complete the dedicated CSO or Company KoboToolbox form. These are separate forms from the farmer survey. (S6.3, S6.4, S6.5 company forms are under development.)
3
Upload & review
Completed CSVs are uploaded via Import CSV. Each submission is reviewed before approval.
4
No extrapolation
All S6.3–S6.5 counts are reported directly. Every regulation improved, and every qualifying company, is counted as one unit. No sampling or estimation is applied.
Extrapolation Methodology (S6.1 · S6.2 · S2.1)
For sample-based KPIs, the number of farmers meeting the threshold in the full target population is estimated using a post-stratification estimator. This corrects for unequal sampling rates between female and male strata.
Formula (with gender stratification)
Achievement = (f_threshold / f_surveyed) × Target_Female
+ (m_threshold / m_surveyed) × Target_Male
+ (m_threshold / m_surveyed) × Target_Male
f_threshold = female farmers in sample who meet the threshold
f_surveyed = total female farmers surveyed
m_threshold / m_surveyed = same for male
Target_Female / Target_Male = gender-disaggregated target population
f_surveyed = total female farmers surveyed
m_threshold / m_surveyed = same for male
Target_Female / Target_Male = gender-disaggregated target population
Formula (total target only — no gender split)
Achievement = (sample_count / sample_size) × Target_Total
Used when gender-disaggregated targets are not available for a project. sample_count = farmers in sample who meet the KPI threshold.
S6.1 — Threshold
Resilience Index ≥ 18/35 (provisional). From 2027: improvement from the 2026 reference score.
S6.2 — Threshold
Farm Viability Index > 10/30 (>33% of maximum — per monitoring protocol).
S2.1 — Qualifies if
Farmer received ≥1 new service OR at least one service quality improved. Confirmed by SP triangulation.
Index Scoring Details
S6.1 Resilience Index (max 35)
| Sub-score | Max | Source |
|---|---|---|
| Soil health (C:N ratio) | 5 | Lab test — f_S61_soil_C / f_S61_soil_N |
| Collective membership | 5 | f_S61_membership (0–5 scale) |
| Local decision-making | 5 | f_S61_decision (0–5 scale) |
| Income: expense coverage | 5 | f_S61_income_expenses (0–5) |
| Income: shock resilience | 5 | Recategorised(impact × recovery) |
| Income: savings buffer | 5 | f_S61_income_savings (0–5) |
| Income diversification | 5 | f_S61_income_sources (0–5) |
S6.2 Farm Viability Index (max 30)
| Sub-score | Max | Source |
|---|---|---|
| Yield growth | 5 | f_S62_yield_increase + increase % |
| Income diversification | 5 | f_S62_income_diversifcation (0–5) |
| Income perception | 5 | f_S62_income_perception (0–5) |
| Service quality (NPS proxy) | 5 | f_S62_services_netpromoter (1–10 → 1–5) |
| Market access | 5 | f_S62_markets (0–5) |
| GAP adoption (of 9) | 5 | Count of f_S62_markets_practices selected |
Disaggregation
Gender (Female / Male)
Required for S6.1, S6.2, S2.1, S2.5. Gender is captured in the Farmer Profile section of the survey form (
f_profile_gender). The post-stratification estimator uses gender strata when gender-disaggregated targets are provided.Youth (≤ 35 years)
Required for S6.1, S6.2, S2.1. Youth status is automatically derived from age:
is_youth = age ≤ 35. Captured via f_profile_age in the farmer survey. Youth is a cross-cutting disaggregation applied against the total target population.Country & Commodity
Every submission is tagged with a project code which links to a country and commodity. The dashboard filter bar lets users slice all KPIs by country (Kenya, Uganda, Tanzania, Ethiopia) and by commodity (Coffee, Tea, F&V, Gold, Dairy, etc.).
Survey Form
About the Form
The MASP IV Farmer Survey V1.1 covers S6.1, S6.2, S2.1, and S2.5 in a single combined interview. It is an XLSForm compatible with KoboToolbox and ODK Central. Download it from the Import CSV tab and upload to your KoboToolbox account to deploy to enumerators.
Note: Separate forms for CSO (S6.3) and Company (S6.4/S6.5) respondents are under development and will be released as V1.2.
Before Deploying
- Set
_project_codeto exactly match the code in the Projects table (e.g.KE-ANK-001) - Confirm enumerators select the correct
_countryfrom the dropdown - Enable GPS on all devices before the first interview
- Run a 3–5 farmer pilot; export and import the pilot CSV to validate before full deployment
- Enter annual targets in Targets & Achievements before starting fieldwork so the extrapolation formula has a denominator
Exporting from KoboToolbox
- Open your project in KoboToolbox and go to Data → Downloads
- Select CSV format, all fields, all versions
- Click Export and download the file to your computer
- Upload via the Import CSV tab — select the survey year and click Upload
After Uploading
Uploaded rows enter a pending queue. The M&E Officer reviews each submission in the Submissions page for completeness and plausibility before approving. Only approved submissions are counted in KPI cards and charts. Rejected submissions are flagged with a reason for correction and re-upload.
Solidaridad East & Central Africa · MASP IV Data Platform · 2026–2030
For technical support contact the ECA M&E team