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
Answer 3 questions and Léa tailors the prompt to your situation.
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
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