Data Analysis · Small Business & Shops

KPI dashboard design for Small Business & Shops

Use this before building a dashboard so it drives decisions. Written for a small business such as a shop, local service or home business with 1 to 20 people.

Your prompt is ready 0 brackets to fill
You are an expert in this kind of work, and you know the Small Business & Shops sector from the inside.

## Your task
Design a KPI dashboard for local customers, walk-in buyers and followers on WhatsApp and Instagram at a small business such as a shop, local service or home business with 1 to 20 people. Choose eight metrics including monthly sales and repeat customers; for each give the definition, formula, data source, refresh rate, target and chart type. Arrange them in a layout from most to least important and explain what action each one triggers.

## About my situation
- What we must respect: GST and local shop rules, a tight budget and very little staff time

## What matters in Small Business & Shops
- Numbers that matter: monthly sales; repeat customers; average bill value; profit margin per product; cash in hand at month end; Google rating and number of reviews; enquiries from WhatsApp and Instagram.
- Tools commonly used: WhatsApp Business; Google Business Profile; Instagram; UPI apps and QR codes; billing apps such as Vyapar, Khatabook or Tally; Canva.
- Rules and standards that usually apply: GST registration, invoices and returns once turnover crosses the limit (in India); shop and establishment registration and local trade licences; FSSAI licence for anything involving food; consumer-protection rules on prices, MRP and refunds; consent before adding people to WhatsApp or SMS broadcast lists.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.

## How to work through it
1. Pick eight metrics.
2. Define formula, source, refresh, target and chart type for each.
3. Arrange them by importance.
4. Explain the action each one triggers.

## What to deliver
- Metric table
- Layout description
- Action triggers

## Rules
- Make every point specific to my situation and my industry; replace generic advice with detail that fits.
- Use plain language, short sentences, and tables where they make the answer easier to scan.
- Use only the facts I give you. Do not invent figures, laws, sources or quotes. Mark anything you had to assume with "Assumption:".
- If something important is missing, ask me up to 3 short questions before you start.

## Before you answer
Check your draft against this list and fix anything that fails:
- Every number comes from my data or is marked as an assumption, and correlation is never presented as cause.
- It is written for a small business such as a shop, local service or home business with 1 to 20 people; nothing in it would read the same for any other business.
- Nothing in it breaks GST and local shop rules, a tight budget and very little staff time.
- Every item under "What to deliver" is included.
Open in ChatGPT Claude Perplexity

How to use this prompt

  1. Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
  2. Fill the brackets. Add any details about your situation.
  3. Paste and send. Paste it into ChatGPT, Claude and Gemini and send. Ask follow-up questions to refine the answer.

Why this prompt works

The “KPI dashboard design” prompt tells the assistant exactly what to hand back: metric table; layout description; and action triggers. It makes the assistant work through 4 steps in order, starting with "pick eight metrics", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 4 tests and fixes anything that fails.

This version is written for a small business such as a shop, local service or home business with 1 to 20 people, so the assistant keeps GST and local shop rules, a tight budget and very little staff time in mind and judges the result by monthly sales and repeat customers. If an important detail is missing, it asks you up to 3 short questions before it starts.

How to get the best answer

  1. Fill every bracket with real detail: add real names, numbers and dates about your situation.
  2. Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
  3. Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
  4. Check the result: review it against what you know about monthly sales and repeat customers before you share it.

Other industries

Same prompt for other industries

The same kpi dashboard design prompt, rewritten for each industry.

FAQ

Frequently asked questions

Which AI assistant works best with the “KPI dashboard design” prompt?

The “KPI dashboard design” prompt works in any chat assistant and suits ChatGPT, Claude and Gemini best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.

What do I fill in before sending the “KPI dashboard design” prompt?

Nothing is required, but adding your own details makes the answer more specific.

Is the “KPI dashboard design” prompt only for Small Business & Shops?

No. This version is written for a small business such as a shop, local service or home business with 1 to 20 people, and the same prompt is also written for 15 other industries, listed on this page.

Is the “KPI dashboard design” prompt free to use?

Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.

Can I trust the answer the “KPI dashboard design” prompt gives?

Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.

Keep exploring

Browse more Small Business & Shops prompts