FlowsBook a callSign inCreate free accountSign up
Footfall and mobility

A weekly footfall report for a store network

How a retail or restaurant network can get one Monday report on how busy the area around every store was: what to include, how to read it and what it cannot say.

Part of the guide Location intelligence automation

By the xMap team · · 5 min read

A weekly footfall report for a store network lists every store with how busy the area around it was over the latest week of data, its busiest hour and day, and the change on the week before, ranked so the biggest moves come first. Read it as a picture of the street, not the till: footfall is people-hours of presence around each store, and each day arrives about ten days late, so the report describes the week before last, not yesterday.

This article is for operations and area managers in retail, restaurant and service chains with ten to a few hundred sites. It covers what belongs in the report, how to read each figure, a made-up week from a chain in Madrid and Mexico City, and how an AI employee builds and sends it every Monday.

What to put in the report

Keep it to one page per region and a few columns that answer the questions a manager actually asks on Monday morning:

  • Footfall per day: the average day's people-hours around the store over the days covered.
  • Change on the week before: up or down, in per cent. This is the column people read first.
  • Busiest hour and busiest day: for staff rotas and deliveries.
  • How the day splits: morning, midday, evening and late night as shares, which shows whether a store's street is a commuter street or an evening one.
  • The dates covered: so nobody mistakes a ten-day-old week for last week.

How to read the week-on-week change

A weekly change in footfall is useful only when you know what else changed. Before acting on a store that is down 15%, check three things:

  1. Is the whole network down? A public holiday, a heatwave or a school break moves every store together. Compare each store's change with the network's.
  2. Is something local going on? Road works outside, a closed station entrance or a new mall nearby pulls people away from one street. The Traffic incidents block lists closures and road works near each store.
  3. Do your own sales agree? Footfall down and sales flat means your customers still come; footfall flat and sales down points inside the store, at range, staff or prices.

A worked example: one week in Madrid and Mexico City

A made-up case; every store and figure is invented. A chain of 24 bakery-cafes, 14 in Madrid and 10 in Mexico City, gets its report on a Monday. The trend compares the seven days ending ten days earlier with the seven before them.

StoreFootfall per dayOn the week beforeBusiest hourBusiest day
Madrid, Chamberi38,400-14%08:00Tuesday
Mexico City, Roma Norte52,100+9%19:00Saturday
Madrid, Salamanca44,800-2%13:00Thursday
Mexico City, Polanco61,300+1%14:00Friday

Invented figures for four of the 24 stores, to show the reading.

Chamberi's fall stands out because the other Madrid stores barely moved. The area manager finds that the metro entrance beside it was closed for works that week, so the morning commuters, its busiest hour, went elsewhere. Nothing is wrong with the store, and the morning shift is trimmed until the entrance reopens. Roma Norte's rise comes with an evening peak, so the store tries opening an hour later on Fridays and Saturdays.

Mistakes to avoid

  • Reading footfall as visitors. A street full of people waiting for buses can show high footfall and few customers.
  • Forgetting the delay. The report is about the week before last. Do not tie a fall to something that happened yesterday.
  • Comparing very different sites. A station store and a suburban store live on different scales. Compare each with its own past and with similar stores.
  • Reacting to one week. One odd week is often noise. Two in a row in the same direction is a pattern.

Doing it with an AI employee

An AI employee in xMap Flows can build the report every Monday and send it as a PDF. One way:

  1. Schedule: every Monday at 07:00.
  2. My data: your stores as a table with their addresses or positions.
  3. Mobility Footfall: each incoming place, the time window of the last 14 days so the trend can compare two weeks, with Footfall, Busy hours, Busiest days and Trend switched on.
  4. Sort and limit: by the trend, biggest moves first.
  5. xMap LLM working on the whole list, told to write five sentences for the operations team naming the stores that moved most and their busiest hours, and never to add a figure that is not in the data.
  6. Make a report: a PDF with your logo, emailed to the area managers.

What lands in the inbox each Monday is the PDF: the written summary, the figures, the table of stores with footfall per day, the trend, busiest hour and day and the dates covered, and a map. A store with no data yet says so rather than showing a zero. The template A monthly brief on your store network covers the monthly version, and What opens near my stores adds the new competitors that may explain a fall.

Questions

Why does the report cover the week before last?

Each day's footfall arrives about ten days later, so the latest full week ends roughly ten days before the report is made. The report says which dates it covers.

Is footfall the number of people who entered my store?

No. It is people-hours of presence in the area around the store, up to a few hundred metres. It shows how busy the street was, not how many came in.

Can I compare a store with the same week last year?

Not yet: the footfall data starts on 17 October 2026. Week-on-week and month-on-month comparisons work now; year-on-year will come as the history builds.

Does it work for stores in every country?

Footfall covers most of the world, but not Australia yet. A store without data gets a note saying so instead of figures.

Templates that do this

Read next

More on footfall and mobility · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.