Impact report for donors: people around each site

The reach section of the donor report, from the people around each site.

MediumMonthlyAI

Non-profits, charities & humanitarianNon-profit

Use this template

What it does

Every quarter: each of your programme sites with the people living within 2 km (men, women, children, seniors), summed up by xMap AI as the reach section of the donor report, made into a branded PDF report and slides for the donors and emailed to you.

In one sentence: Monthly on the 1st at 08:00, take your table, count who lives around, work out new fields, write a report with xMap AI, then make a report and slides and email it and email the list to you.

Why it is useful

Donors ask how many people a programme reaches. The numbers around each site, written up, make that section easy.

Who it is for

Non-profits, charities & humanitarian. NGOs, charities, aid agencies and community groups who need to reach people in need, find partners and report their impact. Every use case for non-profits & humanitarian

Best use cases

  • An NGO’s grants team
  • A foundation reporting to its board
  • A community health programme

What each run gives you

  • A report in Google Drive

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 180 minutes each time; it runs about 1 time a month, so it saves about 3 hours a month (an estimate). It is medium: 7 blocks.

The flow, block by block

  1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
  2. Our programme sitesYour data · My dataBrings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
  3. Who lives aroundxMap data · DemographicsWho lives in an area: the number of residents, men and women, and nine age groups, from xMap’s population grid (hexagons of about 0.1 km², about 100 countries).
  4. Children and seniorsLogic · Calculated fieldAdds fields worked out from the others: a number, a text or a yes/no.
  5. Write the reach sectionxMap AI · xMap LLMTell the AI what to do in plain words.
  6. Make the donor reportAction · Make a reportTurns the items that reach it into a clean PDF report with your logo and colour: the summary an xMap LLM block wrote for the whole list, the figures, charts of kinds and cities, a map and the list.
  7. Email me the resultsAction · EmailSends one email per run with all the items, or one email per item.

Every block can be changed after you use the template: the city, the type of place, the score, where the results go.

Use it now

Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.

How to set it up

More for Non-profits, charities & humanitarian