# Compare where your customers are with who lives there, and find the gaps

Set your customers, area by area, against census figures for the same areas, and see which kinds of neighbourhood you reach less than their share.

Video: Compare where your customers are with who lives there, and find the gaps (1 min 17 s): /images/docs/videos/customers-against-who-lives-there.mp4

## Best for

Anyone who needs to know whether their customers look like the place they serve: lenders, clinics, membership bodies, councils, retailers, charities. You end up with every area sorted into a class, your share of customers in each class beside that class's share of the population, the areas where you have nobody, and a map of them against your sites.

The question is always the same shape. A fifth of the homes are in this kind of neighbourhood. Is a fifth of our business?

**The example in this guide** is a community bank in Milwaukee County, Wisconsin, checking how its home loans are spread across richer and poorer neighbourhoods. Three public sources are used. The loans are the bank's 2023 record under the Home Mortgage Disclosure Act, from the Consumer Financial Protection Bureau: 255 loans, totalled to the 123 census tracts they fall in. The branches are its 17 offices in the county, from the Federal Deposit Insurance Corporation. The census figures Mapstack fetched itself. With your own customers, attach your list and keep the shape of the asks.

## What you need

- **Your customers**, with something that places each one: an address, a postcode or the code of a census area. A table already totalled by area works too.
- **Your sites**, if distance to them matters.
- **The measure to sort areas by**: income, age, tenure, deprivation. Name it and Mapstack fetches it.
- **A Free, Creator or Creator Max seat.**

## Before you start

- **Say what the benchmark is.** "Low income" has to be low against something. Name it: the metro area, the county, the country.
- **Say what your share is set against.** People, households, owner-occupied homes, businesses. Pick the one your customers come from.
- **Areas with no customers are the point.** A table of customers leaves them out. Say that an area missing from your file has none.

## The prompt

> Attached are our 2023 home loans totalled by census tract (tracts with no loans are not in the file) and our 17 Milwaukee County branches. Sort every census tract in Milwaukee County into low, moderate, middle or upper income by comparing its median family income with the median family income of the Milwaukee-Waukesha metro area, not the county. Then tell me what share of our loans went to each kind of tract, set against the share of the county's owner-occupied homes in each kind of tract. Then show me on a map the low- and moderate-income neighbourhoods where we made no loans, and which of those are more than a mile from any of our branches.

## What to expect

1. **Mapstack fetches the census and sorts every area**

   It fetches the areas and the measure you named: in the example the county's 301 census tracts, each with its median family income and its count of owner-occupied homes.

   Then it works out the benchmark and tells you how. No single figure for the metro area was to hand, so Mapstack built one from the four counties that make it up, weighted by the number of families in each. It gave the figure, $101,932, and the income cut-offs that follow from it. A benchmark you can see is one you can check against your own.

2. **You get your share beside the population share**

   Ask for the table by name if the first reply gives you the map without it:

   > Give me the table: for low, moderate, middle and upper income tracts, the number of tracts, our loans and our share of loans, and the share of the county's owner-occupied homes.

   | Tract income | Tracts | Loans | Share of loans | Share of owner-occupied homes |
   |---|---|---|---|---|
   | Low | 79 | 17 | 6.67% | 10.39% |
   | Moderate | 78 | 60 | 23.53% | 25.22% |
   | Middle | 87 | 121 | 47.45% | 40.04% |
   | Upper | 46 | 57 | 22.35% | 23.12% |
   | Not classed | 11 | 0 | 0.00% | 1.23% |

   Read across a row. The low and moderate rows together hold 35.61% of the county's owner-occupied homes and 30.20% of the bank's loans. That gap is the finding.

3. **It counts the areas where you have nobody**

   Of the 157 low- and moderate-income tracts, the bank made no loans in 109. Mapstack split those by distance to the nearest branch: 90 are more than a mile from every branch, and 19 are within a mile of one.

   The two groups call for different things. The 19 are near a branch that is not reaching them. The 90 have no branch to go to.

4. **The map shows the gaps against your sites**

   Every tract is coloured by its class and whether you serve it, with your sites on top. In the example the unserved tracts far from a branch fill the north and centre of Milwaukee, and the branches sit to the south and west. The key counts the tracts in each class, and a reader can search by tract code or branch name.

   ![Example: Milwaukee County's 301 census tracts and the bank's 17 branches. The 90 tracts in red are low or moderate income, had no loans and are more than a mile from every branch. The 19 in orange are within a mile of one.](/images/docs/customers-against-who-lives-there/milwaukee-tracts-and-branches.jpeg)

5. **You turn it into the next step**

   The same table answers the questions that follow:

   > List the 19 tracts within a mile of a branch, with the nearest branch and the number of owner-occupied homes in each, most homes first.

   That is a list a branch manager can act on. Ask for a report of the whole comparison when it has to go to a board or a regulator: see [Make a report](/docs/make/reports).

## Make it your own

> Which areas look most like the three where we do best, on age, income and home ownership? Give me the 15 closest and map them.

> Where do people aged 65 and over live across the county? Give me a ranked list by ZIP code for the mail house.

> Do the same comparison by the share of loans in dollars, not in number.

## Common questions

**My customers are a list of addresses, not totals by area.**

Attach the list. Mapstack places each address and counts the customers into the areas first. See [Add the area to every row of your list](/docs/guides/which-area-each-record-is-in).

**Which census figures can it fetch?**

Population, age, income, tenure, households and many more, for the levels each statistics body publishes. See [Census and official statistics](/docs/find-data/census-and-statistics).

**The benchmark is not the official one we are measured against.**

Give Mapstack the official figure and it uses yours. It always says which figure it used and where that came from.

**Can it find more places like our best ones?**

Yes. Name your best areas and the measures that matter, and Mapstack ranks every other area by how alike it is. See [Decide where to go next](/docs/answers/where-to-go-next).

## Related

- [Get census and official statistics](https://mapstack.io/docs/find-data/census-and-statistics.md)
- [Count and summarise by area](https://mapstack.io/docs/answers/count-and-summarise-by-area.md)
- [Choose where to go next](https://mapstack.io/docs/answers/where-to-go-next.md)
- [Add the area to every row of your list, then count and rank by area](https://mapstack.io/docs/guides/which-area-each-record-is-in.md)
- [Find where there is room for more stores, and roughly how many](https://mapstack.io/docs/guides/how-many-more-stores.md)
