P
💼BusinessIntermediateAll AIs

Build Your Restaurant KPI Dashboard

Prompt to design a custom KPI dashboard for a restaurant, including financial, operational, customer, and marketing metrics.

Paste in your AI

Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.

You are a data consultant specializing in commercial food service. Your mission is to design a comprehensive and actionable KPI dashboard for a [RESTAURANT_TYPE] restaurant (e.g., fast-casual, fine dining, chain, food truck) located in [CITY_OR_NEIGHBORHOOD] with a capacity of [NUMBER_OF_COVERS] covers and an average check of [AVERAGE_TICKET] EUR.

The dashboard must include at least 4 sections:

  1. Financial Performance: daily revenue, COGS (cost of goods sold) as % of revenue, gross margin, net profit.
  2. Operational Productivity: table turnover rate, average wait time, employee productivity (revenue/employee/hour).
  3. Customer Satisfaction: average rating on review platforms, complaint rate, estimated Net Promoter Score (NPS).
  4. Marketing Metrics: customer acquisition cost (CAC), customer return rate, social media engagement.

For each indicator, specify: the calculation formula, update frequency (daily, weekly, monthly), data source (e.g., POS, CRM, Google Reviews), and a target or industry benchmark. Include at least one composite KPI such as RevPASH (Revenue per Available Seat Hour) or Food Cost per Cover. Propose a suitable visualization (gauge, line chart, bar chart, heatmap) for each metric.

At the end, provide 3 priority recommendations to improve performance based on the most critical KPIs for this type of restaurant. The entire output must be presented in a structured and directly usable format (tables, lists).

Personalize this prompt with Léa

Answer 3 questions and Léa tailors the prompt to your situation.

Why this prompt works

<p>This prompt is designed to generate a KPI dashboard specific to the restaurant industry. It forces the AI to use industry vocabulary (COGS, RevPASH, table turnover) and tailor recommendations to the restaurant type defined by the user.</p><p>To use it, replace the variables in square brackets with your restaurant's or client's data. For example, for a fast-casual in Paris, specify "fast-casual", "Paris 3rd", "60 covers", "15 EUR".</p><p>The result will be a structured dashboard plan with formulas, frequencies, sources, and targets. It can then be implemented in a BI tool (Tableau, Power BI) or a spreadsheet.</p>

Use Cases

A restaurant owner wants to track performance in real-timeA marketing agency creates client reporting for a restaurant groupA operations optimization consultant standardizes KPIs for a chain

Expected Output

A structured document with 4 KPI sections, each indicator detailed (formula, frequency, source, target) and 3 priority recommendations. Format: tables and lists.

Improve this prompt

Run this prompt through the Optimizer to strengthen its context, constraints and expected format.

Improve this prompt with the Optimizer

Comments

Be the first to comment on this prompt.

📬 Get new prompts every week

Join our newsletter and never miss a prompt.

Go further

Similar Prompts

💼BusinessIntermediateAll AIs

Define impactful OKRs for your tech startup

Structured prompt to define OKRs specific to a B2B tech startup, incorporating sector-specific constraints and levers.

090
💼BusinessBeginnerAll AIs

Project Brief Template

Getting all the information needed before starting work

0188
💼BusinessIntermediateAll AIs

Develop Your Gym Pricing Strategy

This prompt helps you build a comprehensive pricing strategy for a gym, taking into account competitors, customer segments, and financial goals.

0111
💼BusinessIntermediateAll AIs

Root Cause Analysis

Diagnosing the real source of client problems

0155
Restaurant KPI Dashboard: Performance Builder | Prompt Guide