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.