Building the Perfect KPI Dashboard for Your Hotel
A prompt to generate a comprehensive and actionable hotel KPI dashboard, including key metrics (RevPAR, ADR, etc.), their formulas, sources, alerts, and visualizations.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a hotel revenue management consultant. Build a KPI dashboard for [PROPERTY_NAME] ([PROPERTY_TYPE]: hotel, residence, palace) located in [LOCATION]. This property has [NUMBER_OF_ROOMS] rooms and primarily targets [CLIENT_SEGMENT] (business, leisure, mixed). The dashboard should enable the [USER_ROLE] (general manager, revenue manager, marketing manager) to monitor performance in real time. Include the following KPIs: RevPAR (Revenue per Available Room), ADR (Average Daily Rate), Occupancy Rate, EBITDA Margin, Customer Acquisition Cost (CAC), Revenue per Distribution Channel (direct, OTA, corporate), Booking Conversion Rate, Satisfaction Score (GRI/NPS), Repeat Booking Rate, and Ancillary Revenue Contribution (SPA, F&B). For each KPI, specify the calculation formula, a typical data source (PMS, CRM, booking tool), update frequency (daily, weekly, monthly), and an alert threshold (e.g., if RevPAR < [REVPAR_THRESHOLD] €). Add suggested visualizations: gauge for occupancy, line chart for RevPAR/ADR, bars for channel performance. The dashboard should include segmentation by [SEGMENTATION_TYPE] (booking date, channel, guest type). Also provide 3 actionable recommendations based on historical KPI trends (e.g., if ADR drops by [ADR_CHANGE]%, then adjust pricing strategy via yield management). Everything should fit on one A4 page for weekly reporting.
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 creates a hotel-specific KPI dashboard using key variables like <strong>[PROPERTY_NAME]</strong>, <strong>[PROPERTY_TYPE]</strong>, <strong>[LOCATION]</strong>, etc. to personalize the result. It is designed for B2B executives and marketers who need precise financial and operational KPIs.</p><ul><li>Start by replacing the bracketed variables with your property's actual data.</li><li>The prompt includes formulas and alert thresholds that you can adjust according to your goals.</li><li>Use the result as a basis for your BI tool (Power BI, Tableau) or for a paper report.</li></ul><p>This prompt ensures non-generic content by incorporating industry-specific constraints such as distribution channels (OTA, direct), revenue management, and seasonality. Adapt the alert thresholds and recommendations to your market for maximum relevance.</p>
Use Cases
Expected Output
A complete KPI dashboard, with for each metric: formula, data source, update frequency, alert threshold, suggested visualization, segmentation, and actionable recommendations.
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 un reporting hebdo, le CAC et le NPS sont trop peu fréquents : sortez-les dans une vue mensuelle dédiée. Ajoutez plutôt le booking pace (reste à vendre comparé à N-1) et le pick-up (réservations prises sur 7 jours), issus du PMS, pour anticiper la demande. Fixez aussi le seuil d’alerte du RevPAR sur les prévisions, pas sur l’historique, afin de déclencher les arbitrages de yield avant la date d’arrivée.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Mistral Prompt for Creating a Business Plan
Crafting a solid business plan is a crucial step for any entrepreneur, whether to convince investors, secure bank financing, or simply structure their vision. Mistral, the French AI model, excels at drafting strategic documents in French thanks to its fine understanding of linguistic nuances and the Francophone economic context. By using a well-constructed prompt, you can generate a comprehensive business plan covering market analysis, business model, financial projections, and operational strategy. Mistral's advantage lies in its ability to produce structured, professional content adapted to the standards expected by French and European banks and investment funds. Whether you're launching a tech startup, a local business, or a consulting activity, an optimized prompt will allow you to obtain a workable draft document in minutes, which you can then refine with your actual data. Here's how to get the best out of Mistral for this strategic task.
Prepare a Powerful Client Kick-Off for a Law Firm
Structured prompt to generate a client kick-off plan tailored for B2B law firms, with sector variables.
Offer Submission Summary
Making buyer offers stand out in competitive markets
Write OKRs for a product team
Set product team OKRs