Build a Hotel Activity Dashboard to Drive Your Performance
A detailed prompt to generate a hotel dashboard with specific KPIs, customer segmentation, and B2B levers.
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. Design an activity dashboard for [PERIOD] for [PROPERTY_NAME], which is a [HOTEL_TYPE] (e.g., boutique, chain, resort). The dashboard should be intended for executives, marketers, agencies, and B2B sales teams. Include at least the following indicators:
- Commercial performance: RevPAR, ADR, OCC, TRevPAR, GOPPAR, with evolution vs [PREVIOUS_PERIOD].
- Customer segmentation: % of revenue by segment (corporate, leisure, group, OTAs, direct) and associated gross margin.
- Operational levers: acquisition cost per channel, conversion rate of B2B inquiries (groups, seminars), average booking lead time.
- Seasonal constraints: effect of [PEAK_PERIODS] and [LOCAL_EVENTS] on occupancy and pricing.
- Recommended actions: identify 3 priority levers to increase RevPAR by [TARGET_%] within [TIMEFRAME]. Formats: bar charts for monthly KPIs, a table for segmentation, and a health indicator (traffic light) for goal achievement. The language should be professional and suitable for a non-technical audience. Constraint: the dashboard must be easily updatable (e.g., via Google Data Studio or Power BI). Provide a clear structure with titles and subtitles.
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 obtain a structured plan for a hotel activity dashboard. It integrates key indicators specific to the hotel sector: RevPAR, ADR, GOPPAR, and customer segmentation. Variables in square brackets allow customization of the property, period, and objectives.</p><p>To use it, replace the variables with your actual data. For example, [PROPERTY_NAME] could be 'Hotel Le Plaza', [HOTEL_TYPE] '4* boutique', [PERIOD] 'Q1 2024'. The prompt explicitly asks for actions for the B2B audience, making it actionable for sales and marketing teams.</p><p>The expected result is a detailed document (text or plan) that you can then implement in a BI tool. We recommend adjusting KPIs if the hotel has specific constraints, such as local events or strong seasonality. This prompt is suitable for all AI models.</p>
Use Cases
Expected Output
A structured dashboard plan with indicators, segmentation, levers, and recommendations, ready to be implemented in a data visualization tool.
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
Demandez en plus, pour chaque KPI, sa formule exacte et sa source (PMS, channel manager, rapport OTA) : sans ce mapping, le dashboard reste déclaratif. Précisez le périmètre du TRevPAR (chambres + F&B + spa), rarement disponible dans le seul PMS, et la convention GOPPAR (USALI). Vous obtenez alors un cahier des charges directement branchable sur Looker Studio ou Power BI.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Generate a Project Plan for a Consulting Firm in 60 Minutes
AI prompt to generate a complete and actionable project plan for a consulting firm, with customizable variables.
Automatically detect suspicious activities
Set up a suspicious activity detection system tailored to your organization with concrete indicators and accessible tools.
Analyze customer feedback effectively
Transform your customer feedback into a structured improvement plan with sentiment analysis, root causes, and prioritized solutions.
Define Your Value Proposition
To clarify your messaging and market differentiation