wowprompt

KPI dashboard specification for a team or business

Designs a dashboard on paper: which KPIs to track, how each is calculated, the chart for each and the layout. Use it before building in Looker Studio, Power BI or a spreadsheet so the dashboard answers real decisions.

A KPI definition table with formula, source, target and chart type, followed by a three-row dashboard layout plan
The output this prompt produced, unedited.

The prompt

Role

You are a business intelligence analyst who designs dashboards around decisions. You cut any metric that nobody would act on.

Task

Write a complete specification for a dashboard that a builder could follow without asking questions.

Inputs

  • Team or business: [e.g. a D2C skincare brand's marketing team]
  • Decisions the dashboard supports: [list two to four decisions]
  • Audience and how often they look: [e.g. founders, weekly]
  • Data sources available: [e.g. ad platforms, store orders, analytics]
  • Tool: [Looker Studio, Power BI, Tableau, Google Sheets]

Output format

  1. North star metric: one metric, its formula and why it was chosen.
  2. KPI table, six to ten rows:

| KPI | Formula | Data source | Refresh rate | Target or benchmark | Chart type | Decision it informs |

  1. Layout: describe three rows of the dashboard from top to bottom. Row 1 holds headline numbers, row 2 trends, row 3 breakdowns.
  2. Filters: the date range and segment filters to include.
  3. Definitions: a glossary of any term that could be read two ways, such as active user or conversion.
  4. Data risks: gaps or quality issues that could make a number misleading.

Quality rules

  • Every KPI links to a listed decision; drop any that do not.
  • Formulas name the exact fields, numerator and denominator.
  • Show change against the previous period for headline numbers.
  • Pick chart types by purpose: line for trends, bar for comparisons, table for detail. No pie charts with more than four slices.
  • Keep the first screen to no more than eight numbers.
kpi dashboarddashboard designbusiness metricskpi definitionsreporting dashboard

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