Retail banking · Shanghai, China · Site selection

Cash machines that follow the street, not last year

Mei runs the cash machine network for one of Shanghai’s largest banks. Her team looks after four hundred machines across the city.

Listen to the story:

The challenge

Every year she decides which machines to move, using last year’s withdrawals. But streets change fast: a mall opens, a market closes, and a busy machine goes quiet. Moving one costs a small fortune, so a wrong guess hurts twice.

How the flow works

With xMap Flows, Mei built Atlas. Atlas is an AI employee: a flow of 6 blocks.

  1. On the first day of each quarter,

    First day of the quarter (Schedule)

  2. Atlas takes the bank’s four hundred machines,

    Our four hundred machines (My data)

  3. counts the shops and restaurants within three hundred metres of each,

    Shops and food around each (Nearby places)

  4. gives each machine a busy score,

    A busy score (Calculated field)

  5. picks the quietest twenty,

    The quietest twenty (Sort and limit)

  6. and adds them to the team’s network plan.

    Into the network plan (Microsoft Excel 365)

What it solves

The result

This quarter, Atlas flagged twenty quiet machines. Six stood on streets where most of the shops had closed. Mei’s team moved those six first, and checked the other fourteen on the ground.

Mei stopped moving machines on last year’s numbers. She moves them to where people are.

400machines checked each quarter
20quiet machines flagged
6moved first, no guessing

An illustrative scenario: the figures are modelled to show what the flow produces, not a customer's results.

The flow, block by block

  1. 1

    First day of the quarter

    Schedule

    Starts the flow on a timetable.

  2. 2

    Our four hundred machines

    My data

    Brings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.

  3. 3

    Shops and food around each

    Nearby places

    Places around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.

  4. 4

    A busy score

    Calculated field

    Adds fields worked out from the others: a number, a text or a yes/no.

  5. 5

    The quietest twenty

    Sort and limit

    Puts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.

  6. 6

    Into the network plan

    Microsoft Excel 365 · Excel

    Spreadsheet software by Microsoft

Templates to build it

Ready-made flows with the same blocks. Open one, change the city and the kind of place, and run it.

Industries

Learn how it works

More stories from Banking & fintech

All 137 stories →

Build this flow on your own city

Run a live search on the home page without an account, or let Ask xMap build the flow from one sentence.