• Other
  • 15 columns
  • 200 rows
  • 8 formats

Retail In-Store Foot Traffic Counts

This dataset provides anonymized, daily foot traffic counts for physical retail locations, enriched with store details, holiday indicators, weather conditions, and special event annotations. It enables robust sales forecasting, staffing optimization, and marketing campaign impact analysis by correlating footfall with external factors and store attributes.

  • opened 11 times
  • last updated 22 Jul 2025
  • by GoMask
The brief that made it

Sales forecasting based on historical foot traffic patterns

Sample rows

preview · 8 of 200 rows · all 15 columns
foot_traffic_idstringday_of_weekstringfoot_traffic_countintegeris_holidaybooleanstore_statestringstore_idstringstore_namestringstore_street_addressstringstore_citystringstore_postal_codestringstore_countrystringdatedateweather_conditionstringspecial_eventstringdata_sourcestring
FT00001AFriday1298falseCAS1001XFreshMart Downtown101 Market St.San Francisco94103USA2023-11-24ClearBlack Friday Salesensor
FT00002BSaturday3402falseILS1002ZMegaMart Uptown2201 Lincoln Ave.Chicago60614USA2023-12-23OvercastLast-Minute Holiday Shoppingsensor
FT00003CFriday875trueIDFS1003KBoutique Parisienne27 Rue de RivoliParis75001France2023-07-14SunnyBastille Daymanual count
FT00004DSaturday780trueONS1004RMaple Leaf Goods88 King St ETorontoM5C 1G3Canada2023-07-01RainyCanada Daysensor
FT00005EFriday1042trueNSWS1005LSydney Style12 Pitt StSydney2000Australia2024-01-26SunnyAustralia Day Paradesensor
FT00006FMonday117trueNYS1006VQuickMart Midtown401 6th AveNew York10011USA2023-12-25SnowyChristmas Daymanual count
FT00007GSunday643falseBCS1007QUrban Threads310 Granville StVancouverV6C 1S4Canada2023-12-24FoggyChristmas Evesensor
FT00008HSaturday1218falseQLDS1008MCityStyle Mall360 Queen StBrisbane4000Australia2023-11-25HumidPost-Black Friday Dealssensor

What the 200 rows show

from the 200-row sample

Thursday (day of week) stands out: mean foot_traffic_count is 2,880, against 932.2 for the rest.

  • 50%is_holiday = true
  • 703median foot_traffic_count
  • 3data sources
  • 16weather conditions
  • 18store countries
  • 37store cities
Mean foot_traffic_count by day_of_week200 rows
02,0004,000602.8Mond…53 ro…645.1Tues…11 ro…551.5Wedn…18 ro…2,880Thur…18 ro…1,155Frid…29 ro…1,678Satu…39 ro…679.5Sund…32 ro…
foot_traffic_count200 rows, in bands of 2,000
0951901861525106,00012kfoot_traffic_count →

Median 703, from 0 to 10,023.

store_state182 rows with a value · 18 left blank
  1. NY23
  2. ON22
  3. IDF19
  4. ENG17
  5. NSW15
  6. TX14
  7. IL10
  8. VIC10
  9. CA7
  10. WA6
15 columns by typefrom the column list below
  • string 12
  • integer 1
  • date 1
  • boolean 1

Columns

15 columns in four groups
blueprint · 15 columns
columntypedescriptionexample
Text 12 columns
foot_traffic_idstringUnique identifier for each foot traffic recorduniqueFT00001A
store_idstringUnique identifier for the retail store locationS1001X
store_namestringName of the retail store locationoptionalFreshMart Downtown
store_street_addressstringStreet address of the retail store locationoptional101 Market St.
store_citystringCity where the retail store is locatedoptionalSan Francisco
store_statestringState or province where the retail store is locatedoptionalCA
store_postal_codestringPostal or ZIP code for the retail store locationoptional94103
store_countrystringCountry where the retail store is locatedoptionalUSA
day_of_weekstringDay of the week corresponding to the date (e.g., Monday, Tuesday)7 values · optionalFriday
weather_conditionstringGeneral weather condition on the recorded date (e.g., Sunny, Rainy, Snowy)optionalClear
special_eventstringName or description of any special event or campaign affecting foot traffic (if applicable)optionalBlack Friday Sale
data_sourcestringSource or method used to collect the foot traffic data (e.g., sensor, manual count)3 sources · optionalsensor
Numbers 1 column
foot_traffic_countintegerTotal number of people who entered the store on the given date0 or more1298
Dates and times 1 column
datedateDate for which the foot traffic count is recorded2023-11-24
True or false 1 column
is_holidaybooleanIndicates if the date is a public holiday in the store's locationoptionalfalse

Use it for

  • is holiday50%99 of 200 rowsmean foot traffic cou…602.8Mond…645.1Tues…551.5Wedn…2.9kThur…

    A dashboard

    The is_holiday rate, foot_traffic_count by day_of_week and a breakdown of store_state. Excel, Power BI or Tableau.

  • Why do the 18 Thursday rows have a mean foot_traffic_count of 2,880?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable foot traffics with store_id, store_name and store_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset200 rows15 columns
Yours10,000 rows15 columnsstore_street_address: UK only

blueprint · retail-in-store-foot-traffic-counts

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 15 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Counts vary by day-of-week
  • Promotions spike traffic patterns
  • Weather events impact store visits
  • Store type influences baseline counts
  • Special events produce outlier values
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
retail-in-store-foot-traffic-counts

More in Other

Browse all
Also in OtherProduct Warranty Registration RecordsNonprofit Volunteer Engagement MetricsDevice Trade-In and Upgrade EligibilityAll 1,947 datasets
In collectionsDatasets for Teaching Data AnalysisExcel Practice DatasetsPower BI Practice DatasetsRetail and E-commerce Sales DatasetsTableau Practice Datasets

What should your data show?

Preview 20 rows free
No signup. No card.