Which stores should we close, and what should we open instead?
Golden puts every store on a map, colors it by what it earns per square foot, and lets you drill from state to county to a 50-mile radius in a few clicks.
357 stores, one board meeting
Marcus runs retail operations for a 357-store chain. The board wants a plan: close or convert the weakest stores, and open more of the format that earns the most per square foot.
He has 18 months of monthly sales by store. What he doesn't have is a way to see whether the weak stores are a regional problem, a format problem, or both, and which ones sit close enough to each other to merge.
Geography comes built in
Golden recognizes state, county, ZIP, city and latitude/longitude columns on import and wires up the state to county drill for you. No geocoding project, no boundary files.
You compute sales per square foot once, the right way (summed sales over summed square feet), and it holds at every level: state, county, format, single store.
How Golden answers it
Color the country by productivity
Drop State on a choropleth and color it by sales per square foot. The entire Pacific coast lands in the lowest band.
Click Texas to drill into counties
Texas has the most stores, so click it. The map drills into the 12 counties with stores and shades them with the same measure. A breadcrumb takes you back.
Plot every store as a circle
Size each store by total sales and color it by productivity. Big pale circles are Flagships earning little per foot; small dark ones are Express. Click any circle to cross-filter the rest.
Compare formats two ways
Rank formats by sales per square foot, then by total sales. The ranking flips: Flagship wins on volume, Express on productivity.
Draw a 50-mile circle around Dallas
Add a radius filter, type Dallas, TX, set 50 miles. Every sheet narrows to the 24 stores in range, which is your consolidation shortlist.
The map tells the story
- 01Pacific stores earn $24.50 per square foot a month, against $30 to $33 in every other region.
- 02Express earns $45.60 per square foot, Standard $31.20, Flagship $26.00, even though a Flagship sells $1.31M a month to Express's $212K.
- 03Texas has 59 stores to California's 38, with 10 in Dallas County and 9 in Collin.
- 0424 stores sit within 50 miles of downtown Dallas.
From map to plan
Ask the AI to build the whole dashboard in one prompt: KPI cards, the choropleth, the store map, a bottom-10 table and Region and Format slicers. Then forecast Pacific sales to see whether the gap closes on its own (I wouldn't bet on it).
Share the link with regional managers. The Region slicer lets each of them see their own stores.
Put your stores on the map
Bring your store data and see where the weak spots cluster in an afternoon.