Business & Revenue OpsFree
Location Performance Comparison and Ranking
Send your location-level performance export and each site's tier and tenure, get every site ranked by what it controls instead of by raw revenue.
Every location ranking on the market sorts sites by raw revenue or same-store growth, then calls the bottom of the list underperforming. Comparing raw revenue across locations with different characteristics tells you almost nothing, since a smaller store working every square foot harder can outperform a much larger one on the number that actually measures efficiency. A site three months old sits on the same list as one with six years to mature, and the newer site loses every time on a measure that was never fair to it.
This run reads your export by tier, so a drive-thru at a high-traffic corridor is judged against other drive-thrus at high-traffic corridors, never against a walk-in counter in a quiet strip mall. Each site's revenue per square foot is compared against what a mature site in its own tier should produce, discounted by a ramp curve for tenure under a year, and the gap between actual and expected becomes a dollar residual. The ranking runs on that residual instead of on revenue, so it credits what a manager actually controls.
On a worked estate for Milltide Coffee Co., an eleven-site coffee chain, the raw-revenue ranking and the residual ranking disagree on all eleven sites. The location doing the most business in dollar terms drops to tenth once its tier and 60 months of tenure are priced in. A 900-square-foot walk-in sitting seventh on raw revenue climbs to second on what it actually earned above expectation, and three sites account for 79.9 percent of the estate's negative residual dollars, which is where a site visit belongs first.
What makes a location comparison actually fair
Circumstance is not a vibe, it is a small number of facts about a site that nobody assigned to a manager. Format and trade area are the two that matter most. A drive-thru on a highway corridor pulls a different customer than a walk-in counter in a quiet neighborhood, and demographics and foot traffic patterns explain a real share of the gap between two locations before either manager has done anything. Grouping sites into tiers by those two facts, then comparing only within a tier, keeps the comparison honest.
Tenure is the second fact, and it is the one most rankings skip entirely. A new location can take twelve to eighteen months to reach the performance of an established one, and comparing a six-month-old site against a six-year-old site sets an expectation neither can honestly meet. Retailers with a public comparable-sales metric solve this by excluding new stores outright: Walmart's own definition, published in its quarterly earnings terminology, counts only stores open twelve months or more. A ramp curve does the same job without dropping the newest sites from the report.
None of this replaces checking what a manager actually controls. Waste rate, attach rate, and labor cost as a share of revenue sit underneath the residual, and a site with a large negative number usually has one of the three sitting well off the company average. On the worked estate, all three of the worst-ranked sites ran at least one lever a third or more off that average. The residual says where to look, and the lever says what to fix once you're there.
How it works
Send the export
Revenue and square footage per site, plus tier, trade area, and open date for each one.
Group by tier
Sites grouped by format and trade area, so a drive-thru is only judged against other drive-thrus.
Compute the residual
Actual revenue per square foot compared against tier-and-tenure expectation, and the gap turned into a dollar figure.
Rank and flag
Every site ranked by residual dollars, with the three worst sites named for a visit or a call.
What you get
- Every site's revenue per square foot compared against its own tier and tenure, not the company-wide average
- A dollar residual per site instead of a ranking based on raw revenue or same-store growth alone
- A ramp curve for sites under a year old, judged against their own maturation curve, not a veteran's
- Waste rate, attach rate, and labor cost checked against the residual to name each worst performer's actual cause
- A ranked chart of adjusted performance, built to survive a manager questioning their own site's placement
- A document naming the three sites worth a visit this month, and the reason behind each one
Common questions
What do I need to send?
A performance export with revenue and square footage per site, plus what makes each site's circumstance different: format, trade area, and the date it opened. Waste rate, labor cost, and attach rate are optional, but sending them lets the run name the specific lever behind a low residual instead of stopping at a site being underperforming.
How do you decide the tiers?
By format and trade area, the two facts that explain most of the gap between two locations before either manager has done anything. A drive-thru on a busy corridor and a walk-in counter on a quiet street face structurally different demand. Tell the run what varies across your estate, usually two to four tiers, and every site gets compared only against others in its own tier.
What if a site doesn't have twelve months of history yet?
It still gets ranked, on an expectation discounted for its exact tenure rather than excluded the way a comparable-sales report would exclude it. A four-month-old site is judged against what a new site at that age should produce, not against a six-year veteran. Once the opening sequence is behind it, the discount closes on its own.
Isn't this just adjusting the numbers until the ranking looks nicer?
No. The expected-performance line comes from your own mature sites in each tier, not a number picked to flatter anyone, and the residual is reported in dollars so it can be checked against the raw revenue you already have. A manager who disputes their tier assignment can say so, which is a more useful argument than disputing an average.
How is this different from comparable-store sales growth?
Comparable-store sales tracks one site's own change against its prior year, which answers a different question. It says nothing about whether that site's current level is good for its tier, since two sites can post the same percentage change off very different bases. This comparison says which site is earning what its tier and age should produce right now.
What do I do with the three flagged sites?
Read the doc first. It names the specific lever behind each of the three worst residuals, not just the fact that they're low. From there, a site visit turns a diagnosed cause into a fix logged against that site's own record, and the same run next quarter shows whether it held.
Does this replace our multi-location standards or audit checklist?
No, it feeds it. Multi-location standards hold the policy every site is measured against; this comparison says which sites are worth spending that policy's exceptions and follow-ups on first, ranked by dollars rather than by whichever site a regional manager happened to visit last.
Location Performance Comparison and Ranking
Fill in the form and your workspace opens with the work already underway.