wowprompt

Sales by PIN code to choose where to open the next outlet

Groups online and store orders by PIN code and area, finds pockets with strong demand far from existing outlets, and ranks candidate locations by orders, value, growth and distance, with the checks needed before signing a lease. Use it for food brands, pharmacies, salons, cloud kitchens and retail chains deciding where the next branch or dark store should go.

A table of PIN codes ranked by orders, value, growth and distance from the nearest outlet, a shortlist of three locations, and a pre-lease checklist
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Business and current outlets: [e.g. a bakery chain with four stores in Indore, with their PIN codes]
  • Order data: [paste rows: order date, PIN code, channel, order value; or a summary by PIN code]
  • Period covered: [e.g. last 12 months]
  • Delivery radius or travel limit that matters: [e.g. 4 km for delivery, 15 minutes for walk-ins]
  • Candidate areas already in mind: [paste, or none]

Task

Find where demand is strong but poorly served, and rank the best places for a new outlet.

Steps

  1. Total orders, value and average order value by PIN code.
  2. Compare the last three months with the same three months a year earlier for growth.
  3. Mark each PIN code by distance band from its nearest outlet: near, edge or far.
  4. Score each PIN code on orders, value, growth and distance, with the weights stated.

Output format

  1. | PIN code | Area | Orders | Value | Avg order | Growth | Nearest outlet | Distance band | Score |
  2. A shortlist of three locations, each with the PIN codes it would serve and the demand it would capture.
  3. What the data cannot show: rent, footfall, competitors, parking; with how to check each.
  4. A one-paragraph recommendation.

Rules

  • Say when a PIN code has too few orders to judge, under about 30 in the period.
  • Never treat online orders from far areas as proof of walk-in demand.
pin code analysisoutlet location planningstore expansion analysissales by areadark store locationretail site selection

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