FlowsBook a callSign inCreate free accountSign up
Footfall and mobility

Footfall on rainy days versus dry days: how to measure the difference

Does rain empty your street or fill it? A method to sort weeks into wet and dry, line them up with footfall around each site, and read the gap honestly.

Part of the guide Location intelligence automation

By the xMap team · · 5 min read

You measure the effect of rain on footfall by comparing wet periods with dry ones at the same site, on the same kind of day, over enough weeks to see past chance. Because footfall in xMap Flows comes as averages over a window of at least a week and arrives about 10 days late, the practical unit is a wet week against a dry week, not one rainy Tuesday against one sunny Wednesday. Keep a daily rain record, sort the weeks, and compare the average footfall of each group.

This article is for venues whose trade swings with the sky: outdoor terraces, waterfront promenades, markets, museums and aquariums, cinemas, malls and the brands that run promotions by the forecast. It explains how to decide what counts as wet, how to pair the two records, a made-up example in Singapore, what goes wrong, and an AI employee that builds the comparison for you.

Decide what counts as a wet week

The word rainy hides very different weather. A drizzle at dawn and a storm that floods the evening rush are both rainy days in a simple yes-or-no record. Before you collect anything, write your own rule. Three that work:

  • Rain days in the week. The forecast marks a day as a rain day at 0.5 mm or more. A week with four or more such days is wet; a week with none or one is dry; the rest you set aside.
  • Total rain in the week. Add up the millimetres. Useful where it rains a little most days and what matters is the heavy weeks.
  • Rain at the hours that count. For a terrace that lives on evenings, an hour-by-hour record at the site's city shows whether the rain fell at 7 pm or at 7 am.

Setting aside the in-between weeks feels wasteful, but it makes the comparison sharper. Two clear groups say more than one blurry line.

Why the records arrive on different days

Weather forecast only looks forward, so the day's rain has to be written down on the day, from the forecast for that same day. That is an estimate rather than a measurement from a rain gauge, and you should say so when you share results. Mobility Footfall looks backward: people-hours of presence around each place over a window that ends about 10 days ago. So a week's footfall is read about ten days after the week ended, and you match it to the rain rows for those dates using footfall_from and footfall_to.

A made-up example in Singapore

Invented figures, for illustration only. A company runs two attractions in Singapore: an open-air garden walk and an indoor aquarium a short drive apart. Afternoon showers are common, so a light shower means little; the team counts a wet week as one with four or more days of 5 mm or more, and a dry week as one with at most one such day.

After twelve weeks, five count as wet, four as dry and three are set aside. Using weekend footfall within 200 m of each site, the team finds (made-up figures) the garden averages 9,800 people-hours on dry weekend days and 7,300 on wet ones, while the aquarium moves from 6,200 to 7,100. They also notice the garden's busiest hour moves earlier in wet weeks, from late afternoon to late morning, before the showers start.

The decision that follows is small and testable: in weeks forecast to be wet, the garden opens its guided walk an hour earlier and the aquarium adds a timed-entry slot in the afternoon. After another twelve weeks the team checks whether the gap held.

SiteDry weekend dayWet weekend dayBusiest hour in wet weeks
Garden walk9,8007,300Earlier, late morning
Indoor aquarium6,2007,100Unchanged, early afternoon

Invented people-hours for illustration; not real figures for any site in Singapore.

Mistakes to avoid

  • Comparing single days. The footfall window is at least seven days, so the figures are averages. Compare weeks, not days.
  • Mixing weekdays and weekends. Run the weekday and weekend figures separately with the Day type setting, or a wet week full of school days looks like a rain effect.
  • Letting holidays decide. A public holiday or a big event can move footfall more than any shower. Mark those weeks and leave them out.
  • Using one site's answer for all. Rain may push people into a mall and away from the street outside it. Each site needs its own comparison.
  • Calling it cause. Wet weeks also tend to be cooler or fall in a certain season. A gap in your groups is a reason to plan, not proof.

An AI employee that builds the comparison

Two flows share one spreadsheet in Google Sheets. The first keeps the rain record:

  1. Schedule: every day at 22:00 in the sites' time zone.
  2. My data: your sites with their positions.
  3. Weather forecast: Each incoming place, 1 day, Rain and Temperature.
  4. A Google Sheets step adding a row per site: the date, rain_total_mm and weather_today.

The second adds footfall each Monday to the same sheet:

  1. Schedule: every Monday at 08:00.
  2. My data: the same sites.
  3. Mobility Footfall: Each incoming place, 7 days, Day type weekends (a copy of the flow for weekdays), Footfall and Busy hours.
  4. A Google Sheets step adding a row per site to a second tab: footfall_from, footfall_to, footfall_daily and footfall_peak_hour.
  5. Email to you with the week's figures, as a reminder to update the comparison.

In the sheet, one formula column labels each footfall week wet, dry or set aside by counting the rain rows between its footfall_from and footfall_to dates, and a pivot table averages footfall for each label, site and day type. Each Monday the email tells you a new week has arrived. Early on the groups are small, so read the gap loosely; after a season it becomes something you can plan around.

Questions

Can I compare footfall on one rainy day with one dry day?

Not directly. Mobility Footfall gives averages over a window of at least seven days, so compare wet weeks with dry weeks instead.

Where does the rain record come from?

From Weather forecast run each evening for that same day, saved to a sheet. It is the day's forecast, so treat it as a close estimate rather than a gauge reading.

Why might footfall rise when it rains?

Footfall counts people-hours. In covered places people stay longer when it rains, which raises presence even if no more people arrive.

How many weeks do I need?

Enough to have several wet and several dry weeks of the same day type. A season is a reasonable start; a handful of weeks is a hint at most.

Does this work in every city?

Footfall covers most of the world from 17 October 2026, but not Australia yet. A place with no data says so and is not charged.

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.