Data
Build a hotel rate report
Pace, pickup and the comp set, in the one view a revenue manager rebuilds daily.
Fill it in
On the books by date.
The level means nothing without it.
Where you sit, not just where you are.
Your prompt
Build the morning report. Show PACE against the same point last year, not the current level. Occupancy of 62% for next Tuesday means nothing on its own; 62% when you were at 48% at the same lead time last year is the whole story. Separate pickup by segment and channel. Group business behaves differently from transient and a blended pickup hides which one softened. Include the comp set rates for the same dates. Your rate is only meaningful relative to what is around you. Flag the dates that need action today, with the reason. A dashboard that shows everything and recommends nothing gets rebuilt in a spreadsheet anyway.
Use Build a hotel rate reportOpens with everything above already filled in.
Why this works
Occupancy of 62% for next Tuesday means nothing alone. 62% when you were at 48% at the same lead time last year is the story. This shows pace rather than level, splits pickup by segment, and flags the dates that need action today.