Network KPI Measurement — MASP IV Data Platform

Network KPI Measurement — 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 recorded as indicators (codes REC01–REC05) in each project’s Measurement Framework on the Projects’ Progress page, every 6 months. 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

Code	Indicator	Pathway	Measurement	What is counted
S6.1	Farmers with enhanced resilience	Production	Sample + Extrapolation	Farmers whose Resilience Index (0–35) improved from their 2026 reference score. Index sums 7 sub-scores: soil health (C:N ratio), collective membership, local decision-making, income stability, shock recovery, savings buffer, income diversification.
S6.2	Farmers with improved farm viability	Production	Sample + Extrapolation	Farmers whose Farm Viability Index (0–30) exceeds 33% threshold (score > 10). Index sums 6 sub-scores: yield growth, income diversification, income perception, service quality, market access, GAP adoption (of 9 practices).
S2.1	Farmers accessing new/improved services	Services	Sample + Extrapolation	Farmers who received at least one new or quality-improved service from a Solidaridad-supported service provider. Confirmed by farmer survey + SP triangulation.
S2.5	Individuals co-owning businesses	Services	Direct Count	Direct count of farmers and service providers holding recognised co-ownership stakes in value-addition or service businesses. No extrapolation — reported headcount only.
S6.3	Regulations / frameworks improved	Governance	Direct Count	Direct count of mandatory regulations or voluntary frameworks improved, established, or implemented. Reported by CSOs using a Tier 1/2/3 progress scale. No sampling involved.
S6.4	Companies rewarding farmers directly	Market	Direct Count	Direct count of partner companies that have adopted and implemented direct farmer reward mechanisms (e.g. premium payments, bonus schemes). Reported by company respondents.
S6.5	Companies with responsible procurement	Market	Direct Count	Direct count of partner companies with responsible procurement policies in place. Scored on 5 criteria: policy document, SMART commitments, action plan, country coverage, third-party verification.
REC Level Indicators — recorded in each project’s Measurement Framework (Projects’ Progress; no KoboToolbox form)
REC01	Processors with reduced pollution	Production	Direct Count	Direct count of processors (mills, factories, aggregators) that have adopted verified pollution-reduction measures within the reporting year.
REC02	Workers under improved working conditions	Production	Direct Count	Direct count of workers along the value chain (farm workers, factory workers, casual labourers) whose employment conditions have been demonstrably improved through Solidaridad-supported interventions.
REC03	Green jobs created	Services	Direct Count	Direct count of new jobs created that contribute to environmental sustainability — including agroforestry, organic certification, environmental monitoring, and climate-smart service delivery roles.
REC04	CSOs with enhanced capacity in policy processes	Governance	Direct Count	Direct count of civil society organisations that have received capacity-building support and actively engaged in commodity policy or regulatory processes during the reporting year.
REC05	Farmers receiving premium prices	Market	Direct Count	Direct count of smallholder farmers who received a verified price premium above the standard market price as a result of Solidaridad-supported linkages to certification or direct buyer relationships.

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, recorded every 6 months as indicators REC01–REC05 in the project’s Measurement Framework (Projects’ Progress → open the project) — no survey form or CSV upload is required for these. Cards show a count badge. No sampling or extrapolation is involved.

Measurement Framework (per project)

Each project’s window on Projects’ Progress shows its logframe indicators below the MASP IV KPI targets. It replaces the former quarterly Output and REC sections.

Indicators— M&E Officers and Admins add or edit each project’s indicators: code, level (Goal / Outcome / Output), unit, baseline, end-of-project target, yearly targets and whether values are cumulative.
Values — entered for June and December of the selected year: total, female, male and youth. Female + male cannot exceed the total.
Progress — running totals (cumulative = Y) use the latest value; per-period indicators (N) are summed across periods. Values entered for a period that has not yet ended are marked provisional.
Farmers trained / reachedon Network KPIs is cumulative to date and comes from each project’s measurement framework sheet: the one indicator tagged farmers_trainedin the sheet’snetwork_kpi column, counted the same way as on the project’s scorecard.
“OUT.2 – OUT.6 (label to confirm)” indicators were converted from earlier output counts — please rename them with their proper indicator names.

Data Collection Process

Farmer surveys (S6.1, S6.2, S2.1, S2.5)

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 Projects’ Progress tab, disaggregated by KPI and gender where available. Under commodity-wise deployment, the extrapolation formula aggregates targets across all projects sharing the same commodity and country before estimating achievement.

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.

Survey administration

Enumerators use the KoboToolbox form (V2.0, download from the Import CSV page) 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. V2.0 uses commodity-wise deployment: one KoboToolbox project covers all field projects within a commodity. Enumerators select their commodity first, then their specific project code from a filtered dropdown.

Export & upload

Project officers export the completed survey as a CSV from KoboToolbox and upload it via the Import CSV page on this platform. Submissions enter a review queue before being approved and counted.

Institutional surveys (S6.3, S6.4, S6.5)

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.

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.)

Upload & review

Completed CSVs are uploaded via Import CSV. Each submission is reviewed before approval.

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
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

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 commodity (_commodity), a project code (_project_code), and a survey round (_survey_round). The commodity and project code together link each submission to a country and target population for extrapolation. 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 V2.0 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 page and upload to your KoboToolbox account to deploy to enumerators.

V2.0 introduces commodity-wise deployment: instead of one KoboToolbox project per field project (20+ deployments), one deployment covers all projects within a commodity (~10 deployments total). The form has three new admin fields at the top: _commodity (select commodity first),_project_code (filtered dropdown showing only projects in that commodity), and _survey_round (Baseline / Midline / Endline / Annual). All KPI field names are unchanged from V1.1.

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

Select _commodity first (e.g. Coffee) — this filters the project list automatically
Select _project_code from the filtered dropdown — use only codes listed in the Projects’ Progress table (e.g. KE-COF-001). Wrong codes will cause import failures.
Select _survey_round — Baseline (2026), Midline, Endline, or Annual monitoring
Confirm enumerators select the correct _country from 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 Projects’ Progress 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. In V2.0 the CSV contains all projects within the commodity — the importer handles mixed _project_code values automatically
Upload via the Import CSV page — 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