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:
- Financial Performance: daily revenue, COGS (cost of goods sold) as % of revenue, gross margin, net profit.
- Operational Productivity: table turnover rate, average wait time, employee productivity (revenue/employee/hour).
- Customer Satisfaction: average rating on review platforms, complaint rate, estimated Net Promoter Score (NPS).
- 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
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 OptimizerComments
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
Define impactful OKRs for your tech startup
Structured prompt to define OKRs specific to a B2B tech startup, incorporating sector-specific constraints and levers.
Project Brief Template
Getting all the information needed before starting work
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.
Root Cause Analysis
Diagnosing the real source of client problems