Gemini Text prompt

Simple Business Dashboard Plan

Plan a one-page dashboard with the 6 numbers that matter most for your business — in Sheets or Looker Studio.

Free No login · Commercial use allowed · Copy and use
  • 0 times copied
  • 72 words
  • Updated November 10, 2026

The prompt

Act as a business intelligence consultant for a [type of business] in India.
My data sources: [e.g. sales sheet, expense sheet, Instagram insights].

1. Pick the 6 most important numbers (KPIs) I should watch weekly and explain why.
2. Design a one-page dashboard layout: what goes where, which chart type for each.
3. Explain how to build it in [Google Sheets / Looker Studio] step by step.
4. Suggest a weekly 15-minute review routine using the dashboard.

What to write in the [brackets]

ReplaceWith
[type of business]Your business
[data sources]Where your numbers live
[Google Sheets / Looker Studio]Your tool

How to use this prompt

  1. Click "Copy prompt" above.
  2. Open Gemini (the free version works for most prompts).
  3. Paste the prompt and replace every part in [square brackets] with your own details.
  4. Send it, then ask follow-up questions to improve the answer (e.g. "make it shorter", "write it in Hindi").
  5. Check facts, prices and numbers before you use the result with customers.

Tips for better results

  • Start with 6 numbers, not 30 — simple dashboards actually get used.
  • Put the date range filter at the top.

Try these variations

After the first answer, send one of these as a follow-up message:

  • Make a version for a coaching centre (admissions, fees, attendance).

FAQ

Does this prompt work only with Gemini?

No. It works in ChatGPT, Gemini, Claude and most other AI chat tools. Results vary a little between tools.

Is this prompt free to use for my business?

Yes. All prompts in the Cracckk Prompt Library are free, including for commercial work. Always check AI output before you publish or send it.

Can I use it in Hindi or another Indian language?

Yes. Add a line like "Reply in Hindi" or "Use Hinglish" at the end of the prompt.