In February 2026, Jack in the Box told investors it was working with franchisees to close 150 to 200 underperforming restaurants. The company said those restaurants averaged about $1.2 million a year in sales and lost about $70,000 each at the four-wall level. It also said early results showed about 30% of sales moving to nearby Jack in the Box restaurants. So the decision to close came from two things, a store-level financial test and how much of the sales the neighboring restaurants would keep.
A profit ranking gives you the first one. A map gives you the second. From your own store and customer files, it shows which candidates share customers with a sister store, how many of a closed store’s customers would still have a store within reach, and how many would be left with none. Then you add those three readings to the closure list.
The Financial Screen That Comes Before the Map
The closure list starts with the financials. Four-wall profit is a store’s own sales minus its own cost of goods, labor, rent and other in-store costs, before any corporate overhead is charged to it. A store with a negative number loses money before it pays for anything at headquarters, which is why it’s the usual first test. Operators then look at the sales trend and at when each lease runs out. All of those numbers come from your own records, and each one you want on the map has to be a column in your store file.
What a Map Can and Cannot Tell You About a Store Closure
A map can’t tell you what it costs to get out of a lease, what the landlord will agree to, or what a franchise agreement allows. It doesn’t know your margins, your staffing or what a remodel would cost. Maptive will display and total those numbers if you load them as columns, but it doesn’t supply or calculate them.
It also doesn’t forecast how many sales your other stores keep. Maptive doesn’t calculate a recapture percentage or an overlap percentage. It gives you the counts, and you apply the assumption in a spreadsheet.
What a map can tell you is where each store’s customers live relative to every other store. That matters because stores share customers, so the weakest store on paper isn’t always the right one to close. The readings help with the ranking, and the decision stays with the people who own the lease and the P&L.
Mapping Stores and Customers on One Map
The store file has each address, sales, four-wall profit, the lease expiry date and a status column with values like keep, watch and candidate. The customer file has each address, the store that customer shops at, what they spend and a customer ID.
Layering the Store File and the Customer File
Make a map from each file. Click “Create New Map”, name it and click “Continue”. Drag and drop the spreadsheet or click “Add File”, then click “Map Now”, check the column matching and click “Done”.
Then layer the two. Open either map, click the tool box on the left side of the map, then “Layering Maps” and “Create New Layered Map”. Name it, choose a connection option, select the store map and the customer map, check the column matching and click “Layer Maps Now”. Layering adds the locations from both maps together. Each source data set has its own location limit, and the combined map must fit your account’s map capacity. After that, edit data on the individual maps.
Coloring and Filtering the Closure Candidates
The layered map comes with a new column called Map Layer, which records the map each row came from. Open Map Tools, select the “Grouping Tool / Colored Pins Tool”, pick a column and click “Group Now”. Group by Map Layer to tell stores from customers, or by your status column to color the candidates.
To cut the list down to the candidates, open Map Tools, open the Filter Tool and click “Create Filters”. Put a Date filter on the lease expiry column to show only the stores whose leases end within your planning window. Put a Number filter on four-wall profit and use its slider to show only the stores that are losing money.
How to Measure Customer Overlap Between Two Neighboring Stores
A candidate near a healthy sister store may be sharing its customers with that store. Maptive has no overlap report. You measure overlap by drawing an area around each store, exporting the customers inside each one and comparing the two lists.
Draw a Drive Time Area Around Each Store
Open Map Tools and click on the Drive Time Polygon Tool. Enter the store’s address, or click the store’s marker and add it from the right side menu. Add in the number of hours, minutes or both, then click “Add Drive Time Polygon”. Do the same for the neighboring store.
Use the drive time that fits your own customers. A trade area is usually defined as the area where most of a store’s sales come from, about 60% to 75%. Try a time, check the count and adjust until the area contains roughly that share of the store’s customers.
The area assumes ideal driving conditions and doesn’t account for traffic.
Export the Customers Inside Each Area
Click an area and the right side panel shows the number of locations that fall inside it, along with totals for the markers in the area. Click “Customize Metrics” to choose those totals. Under “Spreadsheet data” you can pick Sum, Average, High Value or Low Value for a numeric column, or Group Count to list a column’s values. A Group Count on the Map Layer column separates customers from stores in the panel. A Sum on the spend column totals what those customers spend.
To get the list itself, click the 3 dots and then “Export Locations”. That exports the spreadsheet rows that fall within the polygon. Make one file per store.
A Worked Comparison of Two Customer Lists
Say Store A is the candidate and Store B is four miles away. These numbers are invented. Store A’s 12-minute area has 1,840 customers in it. Store B’s has 2,310. When you match the two files on customer ID in a spreadsheet, 760 customers appear in both.
That means 760 of 1,840, or 41%, of Store A’s nearby customers already live inside Store B’s area. The other 1,080 don’t.
The column for the store each customer shops at tells you how many of the 760 are Store A shoppers and how many already buy at Store B.
This is a count of customers who could reach the other store, and it doesn’t forecast how many will. For that, you need the published figures on what happened after real closures.
What Published Figures Say About Sales Transfer After a Closure
Published figures vary a lot. A 2023 Marketing Science Institute working paper studied two retailers. It estimated that a mass merchandiser that closed more than 100 stores kept over 90% of the revenue from the closed stores. A membership warehouse club that closed more than 50 stores saw its remaining stores gain only about 30% of the closed stores’ sales. The Jack in the Box figure is at that low end.
What stayed consistent was distance. Households farther from the nearest open store were less likely to switch to it, which is why the overlap count is worth doing.
Online sales don’t automatically make up the difference. ICSC’s 2023 Halo Effect III study found retailers lose nearly 12% in online sales in the local trading area after a closure.
You can’t count on one transfer percentage. Apply the low and high ends to your own overlap count as a range.
How to Count the Customers a Closure Leaves Out of Reach
Customers Outside Every Remaining Store’s Drive Time
Keep a drive time area on every store that would stay open, and remove the candidate’s with “Delete Polygon” in the 3 dot menu. Maptive doesn’t say if a hidden area is left out of the export, so delete it instead of hiding it.
Then click “Export File”, which exports the data for all polygons and radii. That file lists every customer inside at least one remaining store’s area. Match it against your full customer list on customer ID. The customers who aren’t in the file are out of reach.
Counting Out-of-Reach Customers With Radius Circles
If you measure reach in miles, the Distance Radius Tool has this export built in. Switch “Apply To” from “Individual Location” to “Group”. Pick your status column under “Select Group Column” and the value for the stores staying open under “Select Group”, then click “Add Proximity Radius”. That puts a circle on every remaining store at once. In the export options, choose “All Markers outside the Results”, and the file will contain the spreadsheet data that isn’t inside the circles.
Population and Income Around the Candidate Store
For this reading, use the radius tool, because a radius circle can show demographic data when you click it. Open Map Tools and click on the Distance Radius Circles tool. Click the candidate’s marker, click the tools icon and choose “Add Radius”. Enter the size under “Proximity Within” and click “Add Proximity Radius”.
Click the circle, then “Customize Metrics”, then “Demographic Data”. Pick the region, then the demographic group, then population, and click “Add to Proximity Details”. Go through the same choices again for household income.
Maptive’s Census data covers the United States and Canada and is included on every plan. In the United States it goes down to ZIP and tract level. The two figures tell you if the people around the candidate still look like the customers the store was opened for. They describe the area as it is now, so they can’t show how it has changed.
Re-Ranking the Closure List With Three Map Readings
Add the three readings to each candidate’s row, next to finance’s ranking.
You lose the least by closing a candidate with high overlap and few customers left out. With low overlap and many left out, closing means giving up that market. Put that second kind in a group you fix or renegotiate. Walgreens kept a group like that in 2024, when it announced 1,200 closures and another 800 stores it would work on.
The numbers in this table are invented.
| Candidate | Shared with a sister store | Left out of reach | Reading |
|---|---|---|---|
| Store A | 41% | 310 customers | Lose the least by closing |
| Store C | 12% | 1,450 customers | Closing means giving up the area |
| Store F | 28% | 620 customers | Depends on the lease terms |
When a store closes or a lease date changes, run the three readings again for the remaining candidates. The first closure changes every neighbor’s numbers.





