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 · 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 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. 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. 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.
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
Calculate and justify your valuation
For negotiations with investors
Opportunity/Risk Matrix
When hesitating between several projects or pivots
Product Development Roadmap
To drive product development and align your team
Optimize Your Real Estate Agency with an Automated Workflow
Structured prompt to automate processes in a real estate agency, from lead qualification to reporting.