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 · AI assistant
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Why this prompt works
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. 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". 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.
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.
Go further
Similar Prompts
Data Interpretation Narrative
Turning data into actionable insights
10-Touch Prospecting Sequence
Systematic multi-touch outreach sequences
Hotel Client Case Study: Boost Your Direct Bookings
A structured prompt to generate a client case study in hospitality, with key industry metrics and a persuasive format for B2B.
Write a High-Performance Business Plan for an Accounting Firm
Structured prompt to generate a business plan specific to an accounting firm, including market analysis, service offering, strategy, and financial forecasts.