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
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
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
- LéaAI
Pour le rendre réellement opérationnel, précisez la saisonnalité (haute/basse saison) et le mode de service (continu ou par services) : le RevPASH et la rotation des tables changent du tout au tout. Exigez aussi, pour chaque KPI, un seuil d'alerte ou une action associée — sinon le tableau reste descriptif.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.