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
Answer 3 questions and Léa tailors the prompt to your situation.
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
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
Area Overview for an Investor
Attract and convince investors for a targeted sector
Plan a project from scratch
Start a new project in a structured way
Writing a Custom SOP for a Web Agency
Structured prompt to generate a complete and actionable SOP for a web agency, incorporating industry vocabulary and constraints.
Prompt to Write an Organizational Change Announcement Email
Create a clear, reassuring and structured organizational change announcement email to inform your teams while maintaining their engagement.