How to Build an Indicator Tracking System for NGOs

An indicator tracking system for an NGO's M&E has two parts: an indicator tab for each indicator that holds the raw data and a summary table that rolls them up for reporting. Together they make an Indicator Performance Tracking Table (IPTT). This guide shows how to choose indicators, define each one clearly, and run them in an IPTT. It comes with a downloadable template to adapt and an AI prompt to clean up your existing indicator list.

It draws on field experience: M&E in a country office, a global indicator system for a large NGO, and scaling data management across that NGO including postings in Afghanistan and the Middle East.

#Key Takeaways

• Track fewer indicators well. Every indicator is data someone must collect every reporting period
• Define each indicator as plainly as possible so a new field officer could collect it without asking a question
• For a percentage, track the numerator and denominator and let the spreadsheet calculate the ratio
• Disaggregation is a filter on one indicator, not extra indicators
• Keep two parts in your tracking system: indicator tabs with the raw data and a summary table linked to them by formulas

#What is an indicator?

An indicator is a specific, measurable signal that shows whether your program is on track. "Improved health in the district" is a goal. "Percentage of trained health workers who correctly apply the new protocol" is an indicator, because you can define it, collect it, and watch it change over time.

Indicators come in three levels: output, outcome, and impact. The further up you go, the less control you have over the result. The ladder below gives an example of each.

Many programs track mostly output indicators because they are the easiest to count. Without outcome indicators, a report shows activity but not change.

To see how outputs lead to outcomes and impact, read our guide to the theory of change. The monitoring and evaluation framework guide shows where indicators fit in the wider system and designing the right M&E system helps you decide what to build first.

#How to choose your indicators

Choose the smallest set that answers your key questions and add more only when a real gap appears. BetterEvaluation and ANZSOG advise the same: organizations usually select a limited set of indicators to collect and report routinely, which keeps cost and effort down and avoids data that doesn't inform decisions (BetterEvaluation and ANZSOG, 2022).

Apply two filters to each candidate:

• Is it SMART? Specific, measurable, achievable, relevant, and time-bound. Catholic Relief Services publishes indicator guidance built around this criteria (2025).
• Does it map to a result? Each indicator should measure a result in your logframe or theory of change. If you can't name the result, drop the indicator.

Consult the field staff who will collect it whether its feasible to capture. An indicator that field staff can't practically gather produces unreliable data so its best to pilot first.

You rarely need to start from a blank page. IndiKit, built by People in Need, is a free library of more than 500 commonly used indicators across 25 thematic areas with guidance on how to measure each. Start there and adapt.

#How to define an indicator: the reference sheet

Choosing an indicator is not the same as defining it. "Number of people trained" sounds clear until one officer counts everyone who attended and another counts only those who passed. A reference sheet fixes this by writing down exactly how the indicator is counted. You complete it when you create the indicator and everyone who collects the data uses the same rules.

The format is not new. USAID's Performance Indicator Reference Sheet (PIRS) is an early example and still worth reading as background (USAID, archived). That document is no longer actively updated so follow your current donor's requirements. Monitoring templates from the European Commission's humanitarian aid department (ECHO) are a useful humanitarian comparison.

#Style and format of a good indicator

Follow the same writing habits for every indicator. Writing them all the same way keeps a plan of twenty or more indicators easy to read and check.

• Use one sentence pattern. Start with "Number of" or "Percentage of" then answer three questions: what are you counting, what has to be true for it to count, and where or for whom? For example: "Number of health workers who completed training and passed the assessment by facility."
• Number indicators consistently. IDs such as IND-01 and IND-02 are common in NGOs and the leading zero keeps them in order when you sort. Any format works as long as you use it consistently everywhere.
• Keep one convention. Write "Number of", not a mix of "#", "No." and "Number". State the unit.
• Write plainly. Short concrete names and definitions. Leave out adjectives and anything a field officer would have to interpret.
• Spell out the numerator (the part you count) and the denominator (the whole group) for every percentage. "Percentage of workers applying the protocol" hides two questions: who counts as applying it and who the whole group is. Naming both forces you to check that a data source exists for each.

Collect the two numbers then let the spreadsheet work out the percentage. In each example below, the first two boxes are counts you collect and they are often outputs you already track. The last box is a third indicator, calculated from them so nobody has to enter it.

#Collection frequency and reporting period

Each indicator runs on two schedules. Collection frequency is the interval at which data comes in, such as after each training, monthly, or twice a year. The reporting period is the interval at which you report it, such as quarterly or annually. The two can differ: you might collect attendance after every training and report it quarterly.

Set both when you define the indicator and check that the source can deliver at that interval. A quarterly target backed by an annual survey can't be reported on time. Digital collection tools can handle frequent collection and add up the data automatically. Before you commit to weekly or other short-interval manual collection, check that your team has the time.

#Baselines and targets

A baseline is where you start when you are not starting from zero. A target is the benchmark you measure achievement against. Without a baseline, an end figure of 68% tells you little: you can't say whether it rose from 22% or fell from 80%. Some indicators like a simple output count don't need one.

Set targets you will revisit: an end point such as each year plus quarterly milestones you review and adjust as you learn.

#Disaggregation is a filter, not more indicators

Disaggregation breaks one indicator down by group, usually sex, age, or location. A common mistake is to list each breakdown as its own indicator. "Number of health facilities at country level" and "number of health facilities at regional level" are one indicator ("number of health facilities") filtered by region.

Each breakdown multiplies the data staff collect and the data points you have to process and report on. Disaggregate only where the result will change a decision. DG ECHO (the European Commission's humanitarian aid department) asks for information on affected people to be disaggregated by gender wherever possible.

#How an indicator tracking system works: the IPTT

Teams often treat the tracking system as one spreadsheet and never think about its two parts separately. Donors often call the whole thing an IPTT. We split it into two parts:

• Indicator tabs hold the raw data. Each indicator (IND-01, IND-02 and so on) gets its own with one row per record: date, period, group, numerator, and denominator.
• The summary table has one row per indicator, with baseline, target, and the actual for each reporting period. Donors, managers, and teams read this one.

The link between them is the key feature. The summary's period figures are formulas that read from the indicator tabs, so nobody retypes a number and a new row in a tab updates the summary. Design the tabs around your real data source first, then build the summary on top. Keep one record per row and one value per cell and avoid merged cells so you can sort and filter the data. When teams start from the summary view, the raw data ends up bolted on afterward and the two drift apart. Think through the roll-up before you finalize each definition.

Two spreadsheet functions do most of the work:

• COUNTIFS counts the tab rows that match a period or group and SUMIFS adds up their values.
• For a percentage, divide the summed numerator by the summed denominator.

#Download the indicator tracking template (IPTT)

The IPTT template (.xlsx) opens in Excel or Google Sheets. It has a README, a summary sheet, and three linked indicator tabs with sample health and water data so you can see the formulas working.

A spreadsheet is the right start and for a small program it may be enough. Move to a database or M&E platform when the same figures are entered more than once, several people edit at the same time, or you roll up across countries by hand.

#Use AI to set up your IPTT

Most teams already have an indicator list somewhere: a PDF, a logframe, a half-finished spreadsheet. AI is good at the tedious part, such as spotting inconsistent names, percentages without a denominator, and wordy definitions. It won't choose your indicators and you should check every change. If your team is new to AI assistants, our guide to AI training for nonprofits points to free courses to start with.

Don't paste beneficiary data or other personal information into a public AI tool. Indicator names and definitions are fine.

Copy the prompt below and paste it into your AI assistant. It asks you for your indicators so you can paste text or attach a PDF, a screenshot, or a spreadsheet. If your assistant can open web links, it downloads the IPTT template for you.

You are an experienced M&E specialist. Clean up my indicator list so
it can go into an Indicator Performance Tracking Table (IPTT). It may
be a country portfolio or a single project.

Step 1. Ask me for my indicators before you do anything else. Say I
can paste the text or attach a PDF, a screenshot, or a spreadsheet.
Wait for my reply. Use only the indicators I give you. Never make up
indicators, data sources, targets or numbers. If you cannot read an
attachment, tell me and ask me to paste the text instead.

Step 2. After I reply, get the template. If you can open web links
or download files, download the IPTT template from
https://hikaya.io/blog/indicator-performance-tracking-table-template.xlsx
and use its structure. If you cannot, tell me, and use the column
names in the output table below.

Step 3. Clean up the list using these rules:
1. SMART: each indicator is specific, measurable, achievable,
   relevant, and time-bound. Flag any that are not.
2. One pattern: "Number of [what] that [condition], [where or for
   whom]" or "Percentage of ...". Never use "#" or "No.".
3. For a percentage, list the numerator and the denominator as
   separate items to track, and show the percentage as a calculated
   field. Use only data sources I name. If something is missing, write
   "MISSING: please confirm". Do not invent it.
4. Disaggregation is a filter. Merge indicators that are the same
   count split by sex, age, or location, and list the filter instead.
5. Flag different indicators that measure the same thing.
6. Write in plain, simple language. No em dashes, no jargon, no
   filler. Definitions must be clear enough for a new field officer.
7. Do not change my meaning. State any assumption you make.

Output a table with these columns: Ref | Cleaned name | Definition |
Calculation | Data source | Flags. In Flags, list the original item
numbers each row came from. Leave baseline, target, collection
frequency and reporting period blank for me to fill unless I gave
them. Put outcome statements that are not indicators in a separate
list called "Not yet an indicator". Then list
your changes, the questions I need to answer, and, once, any missing
targets or timeframes.

At Hikaya, we help NGOs and nonprofits worldwide build and improve indicator systems, from a first spreadsheet to an integrated platform whether you run a five-person team or a global portfolio.

If you are building an indicator tracking system or improving the one you have, we'd welcome the conversation. See how we've done this for other organizations in our work.