Building the 7-day rate calendar · Forecasting & Pricing Decisions

A 7-day rate calendar is the operational artifact that turns forecast and strategy into actual rates customers see. It lives in the channel manager, propagates to every OTA and the direct booking engine, and is reviewed every week without fail.

What the calendar contains

For each of the next 90 days, the calendar specifies: BAR by room category, derived rates (advance-purchase, member, package), restrictions (BAR-LOS, MLOS, CTA, CTD), and channel-level overrides if any. The 90 days are color-coded by demand level (high/normal/low) so the operator can see the rate shape at a glance.

The weekly review

Every Tuesday morning, the revenue manager opens the 90-day calendar, the OTB curve, and the comp-set rate-shopping report side by side. The question for each date with significant pace variance (±5% or worse) is: should the rate move, should a restriction open or close, should we change channel exposure?

Changes are made in increments. A €15 BAR move is the largest single change you should make week-over-week without specific demand justification. Larger moves trigger guest-perception issues (people who shopped yesterday at €220 and come back today to €260 share screenshots and feel deceived).

Propagation discipline

A change made in the channel manager should propagate to all connected OTAs within 30-60 minutes. Audit this monthly by checking a sample of dates across 4-6 channels — if Booking.com shows €240 and Agoda still shows €220 four hours after the change, your channel manager has a propagation lag and your parity is structurally broken.

The 1-week, 2-week, 4-week, 8-week pattern

The shape of the calendar evolves with lead time. Dates 1-2 weeks out are tactical — most demand has already arrived, you are managing the last 10-20% of inventory. Dates 4-8 weeks out are strategic — pace data is meaningful, rate moves should be deliberate. Dates 8+ weeks out are aspirational — you are setting the anchor that the market will adjust to.

A practitioner-level revenue manager treats these four horizons differently and writes different commentary for each in the weekly review.