1. Pickup measures the change in bookings on the books for the same future stay dates between two review times.
2. Separate new reservations from cancellations and modifications; a busy inbox can still produce weak net pickup.
3. Finish with a decision for specific dates or room types, not a hotel-wide discount based on one headline total.
Last week's future booking list and this week's list answer a useful question together: how much business did the hotel gain or lose for the dates it is trying to fill? This is booking pickup. It is different from counting arrivals this week or reporting revenue from stays already completed.
A weekly hotel reporting review needs a repeatable comparison, an explanation of the change, and a decision while the stay dates are still ahead. Start with room nights, because one three-night booking contributes three nights rather than one room night.
Save Two Views of Exactly the Same Stay Dates
Choose a future stay window, such as 9–22 November, and a consistent weekly review time in the property's local time zone. At both reviews, select those exact stay dates, property, room types, reservation statuses, and revenue definitions. Record the capture time.
Do not compare last week's next-14-days view with this week's next-14-days view without checking the dates. A moving window drops some nights and adds others, so its difference is not a clean pickup measure for one fixed period.
Save the opening view before the next week's reservations change it. Use the supported comparison report or retain dated reservation exports with the needed stay-date detail. A live dashboard tells you the current position; it cannot, by itself, show what you saw last Monday unless that history is available.
Smart Order's hotel reporting and analysis provides reservation, room-revenue, and channel information for this review. Save comparable dated views or exports, then use the difference to identify the dates needing attention. Do not mistake an updated current total for a recorded week-on-week comparison.
Give the Weekly Review a Consistent Starting Point
Review reservation source and room revenue with the same stay-date filters, then preserve the figures needed to compare next week's position.
Keep Booked Revenue Separate From Cash
Use booked room revenue on the same basis at both captures. Do not mix it with deposits received, OTA payouts, taxes, or optional extras in just one view. These can change without a corresponding change in room-night demand.
Also keep the treatment of tentative bookings, complimentary rooms, and group blocks consistent. Count a held group allocation and the reservations drawn from it according to the report's definitions, not as two separate additions to demand.
Explain the Change Before Calling It Strong Demand
Consider a hypothetical 20-room hotel reviewing a fixed 14-night future window. With no room closures, that is 280 available room nights. The opening snapshot shows 84 booked room nights; the next weekly snapshot shows 102.
Net room-night pickup is 102 minus 84 = 18. Booked occupancy rose from 30% to about 36.4%, a gain of approximately 6.4 percentage points. That is a booking-position comparison, not realized occupancy from completed stays.
Suppose the reservation movement explains it as 26 newly booked room nights, ten canceled room nights, and two net extra nights from modifications. Then 26 minus 10 plus 2 = 18. Review events and snapshot definitions so the same modification is not counted once as a new booking and again as an extension.
Separate Gross Additions From Net Pickup
The 26 added nights show sales activity. The 18 net nights show how much the booked position improved after losses and changes. If cancellations were much larger, active booking activity could coexist with little improvement or a decline.
Open the underlying records in the hotel front desk reservation view when the movement does not explain the totals. Look for shortened stays, bookings moved into or out of the selected window, duplicate entries, and status changes. Do not label an unexplained report difference as a surge in demand.
Read Revenue Pickup Alongside Room Nights
Assume the same snapshots show booked room revenue rising from $8,400 to $10,680 on a consistent basis. Net booked revenue pickup is $2,280. This includes the effect of added, removed, and modified business, and may also include repricing of existing reservations.
Dividing $2,280 by 18 gives about $126.67 per net added room night. Do not automatically describe that number as the average rate of newly booked stays. To evaluate the price of new bookings, inspect those new reservations separately from cancellations and other revenue changes.
All figures in this example are illustrative. Use the hotel's actual room-night and revenue definitions, and retain the records that explain the movement.
Use the Review to Choose One Focused Action
Break the fixed window into stay dates, room types, and channels. The hotel could gain 18 nights overall while most additions fall on already-strong Fridays and a Tuesday remains almost empty. A single property-wide percentage hides that difference.
Review the open rooms and remaining lead time on the dates that matter. Compare with a relevant prior booking pattern at the same distance from arrival where that history exists. Last year's final occupancy is context, not a substitute for last year's booked position at the equivalent review point.
Use this short review agenda to convert the findings into a decision:
- Identify the date or room type whose booked position changed meaningfully in actual room nights, not just percentages.
- Explain the movement using new bookings, cancellations, modifications, and any price-only changes.
- Check the current offer: rate, availability, minimum stay, cancellation terms, and whether the intended rooms can actually be booked.
- Choose a bounded action or a documented no-change decision, and set the next review point.
For a weak Tuesday with little new demand, inspect whether a restriction or unavailable rate is preventing sales before discounting. For a Friday filling quickly, review remaining demand and prices rather than applying the Tuesday's offer to the whole hotel. A pickup figure is a prompt to investigate, not an automatic instruction to raise or cut rates.
If the decision changes channel rates or availability, apply it through the approved hotel channel manager workflow and verify the affected offers. Record what changed so the next review can distinguish your intervention from an unrelated cancellation or booking event.
For a small hotel, counts are especially important: one room booked on one night can visibly move the percentage. Do not treat one large reservation, event shift, or group release as a stable trend without examining its context.
If Last Week's Snapshot Was Not Saved
Check whether the reporting system retains a dated booked-position comparison or enough reservation history to reconstruct it accurately. A list of reservations created last week alone is insufficient: it can miss cancellations of older bookings, modifications, and the opening position.
If that evidence is unavailable, mark historical pickup as unavailable and begin a baseline now. You can still review current availability and new booking activity, but do not present those figures as a verified week-on-week net pickup.
Save today's filters, capture time, room nights, booked room revenue, and decision. At the next review, compare the same stay dates again and explain the difference before choosing another action. That creates a usable weekly habit without building an oversized dashboard or pretending missing history exists.
