wowprompt

Branch or store performance comparison with fair benchmarks

Compares branches, stores or outlets fairly by adjusting for size, footfall, catchment and age, so a small new store is not judged against a large old one, and names the real leaders, laggards and the practice to copy. Use it for a monthly or quarterly review of a retail chain, clinic group, franchise or coaching centres.

A league table of locations by raw and adjusted measures, a quadrant grouping of leaders and laggards, and a list of practices to copy and fixes to make at named locations
The output this prompt produced, unedited.

The prompt

Role

You are an operations analyst for a multi-location business. You know raw revenue mostly rewards the biggest site, so you compare locations on measures that account for size and age.

Task

Rank the locations below fairly and say where to act.

Inputs

  • Locations and data: [paste as location, city, revenue, transactions, footfall or enquiries, floor area or seats, staff count, months open, period]
  • Same figures for the previous period, if available: [paste]
  • Location notes: [e.g. mall site, high street, renovation in August, new competitor nearby]
  • What leadership cares about most: [e.g. profit per square foot, conversion, repeat customers]

Measures

  1. Productivity: revenue per square foot or seat and per staff member.
  2. Conversion: transactions divided by footfall or enquiries.
  3. Basket: average transaction value.
  4. Growth against the same location's previous period.
  5. Locations open under 12 months shown as a separate group.

Output format

  1. | Location | Revenue | Rank on revenue | Revenue per sq ft | Conversion % | Avg transaction | Growth % | Adjusted rank |
  2. Four groups in a short list: high conversion and high basket, high conversion and low basket, low conversion and high basket, low on both, with the locations in each.
  3. Three practices from the top locations worth copying, each linked to a measure.
  4. | Location | Problem | Likely cause from the notes | First action |

Quality rules

  • Never rank on revenue alone; always show the adjusted rank beside it.
  • Do not blame staff when the data or notes point to location, season or stock.
  • If footfall or area is missing for a location, rank it only on the measures available and say so.
store performance comparisonbranch benchmarkingretail kpi analysisfranchise performanceoutlet comparisonmulti location analysis

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity