Hotel pickup report: how to read booking pace day by day

A pickup report shows the rooms and revenue added to the books for each future stay date since your last snapshot. A pace report compares those on-the-books numbers with the same number of days before arrival last year. Read both net of cancellations, by segment and channel, and aligned by holiday and day of week.

The total on the books for next month has not moved since last week, so the morning looks calm. The detail says something else: rooms arrived and rooms cancelled, in different segments, at different rates, and the single total hid both. This article shows you how to build a hotel pickup report you can defend in a meeting: what counts as pickup, how to calculate pace against last year, how to compare years fairly in Türkiye, and what decisions the report should trigger.

What is a hotel pickup report?#

A pickup report lists, for every future stay date, the rooms and revenue that were added to the books since a fixed earlier moment. It answers one question: what changed since we last looked.

Two dates matter and must never be confused. The booking date is when the reservation was made or changed; the stay date is the night the guest sleeps in the room. Pickup is counted on the stay date, filtered by booking activity since the snapshot. A report that mixes the two will show you when people booked rather than what they booked, and both are useful only when kept apart.

A pickup report is only as good as its snapshot. Fix a daily cut-off time, take the same cut-off every day, and keep the snapshot file. Without a stored earlier position there is nothing to subtract from. Pull the report from your own reservation system, not from a channel extranet: an extranet sees one channel, while the property system sees the whole house, including direct, agency and group business.

Gross pickup is everything added. Net pickup subtracts cancellations, room-night reductions and no-shows. Report both, decide on net. Pace is a different report built on the same data: it takes the total on the books today and compares it with the total on the books on the same day before arrival last year.

State the as-of moment on every page you circulate. A pickup report without a timestamp invites two managers to argue about two different numbers.

For the wider context of pricing and inventory decisions, see hotel revenue management: a working guide for independent hotels.

What counts as pickup? Gross, cancellations and net#

Gross pickup counts every new room night and every added room night; net pickup is gross minus cancellations, reductions and no-shows, and it is the only figure worth acting on.

A modification is not a new booking. If a guest extends a stay from three nights to five, the pickup is two room nights, not five; systems that re-flag the whole reservation inflate gross pickup. A rate change on an existing reservation is revenue pickup with zero room pickup. Keep the two columns separate, or a discount campaign will look like growth.

A cancellation belongs to the stay date it removed, not to the day the guest called. Otherwise a single bad week of cancellations lands on a date that is already full. A date move is a cancellation plus a new booking, and it should appear as both: netting it silently hides which stay date lost the room night.

No-shows and early departures arrive late, often after the stay date has passed. Run a second, backward-looking pickup check for the last seven days before you trust the forward numbers. Finally, attribute cancellations to the segment and channel that made the booking, not to the segment that replaced it. A group block that washes out and is refilled by retail is a mix change, not a pickup.

How do you calculate pace against last year?#

Compare the on-the-books total for a stay date today with the on-the-books total for the same stay date on the same number of days before arrival last year, then express the gap in rooms and in revenue.

Days before arrival is the only fair clock. A comparison of 1 March this year with 1 March last year measures two different points on the booking curve, because the two dates sit at different distances from their arrival dates. Choose a fixed set of checkpoints, for example 120, 90, 60, 30 and 7 days before arrival, and keep them every year so the series stays comparable.

Report the gap twice: in room nights, absolute, and as a percentage of last year's position. A percentage on a small base is noise; a room-night gap on a large base is a decision. Keep pickup and pace apart in the report. Pickup tells you what moved this week; pace tells you where you stand against last year. Mixing them produces a chart nobody can defend in a meeting.

Run pace by segment and by channel, not only for the house. A house that is level overall while retail is behind and groups are ahead is a different problem from a house that is level everywhere. Use the same room count and the same room types in both years: a renovation that removed rooms from sale changes the denominator, and the comparison must say so.

For the underlying metrics, see RevPAR, ADR and occupancy rate: formulas and common mistakes.

How do you compare years fairly in Türkiye?#

Align the comparison by holiday and by day of week, and read revenue in the contract currency as well as in lira, because bayram dates move and the lira does not hold still.

Religious holidays move earlier each year, so a stay date that fell in a quiet week last year may sit inside a bayram this year. Compare holiday to holiday, then compare the ordinary weeks around them. Day of week matters for city and business hotels: a stay date that was a Tuesday last year and a Friday this year will look like a demand change when it is a calendar change.

Split revenue pace by contract currency. A book that is flat in euros and up in lira is telling you about the exchange rate, not about demand. Convert for reporting only, at daily central-bank exchange rates, and say on the page which day's rate you used. Conversions for tax and invoicing are a separate question for your accountant.

Two things sit side by side and are often confused. The currency a contract is agreed in and the currency a price is shown in to the traveler can differ, and each channel may carry its own convention. State the contract currency on the report itself, so that every later conversion has a clear starting point, and confirm the rules that apply to your own contracts and channels with a legal adviser.

Do not adjust the comparison for inflation with a figure you cannot source. If you want a real-terms view, agree the index and the method with your accountant before the report goes to the owner.

For how board and room revenue interact in all-inclusive houses, see ADR in all-inclusive hotels: separating room and board revenue.

How do you read pickup by segment and channel?#

Read the same pickup twice, once by segment and once by channel, because the house total can be level while the mix underneath it has changed completely.

Segment and channel are different axes. A tour-operator booking and a direct booking can both be leisure; a corporate booking can arrive through an agency. Keep one fixed definition of each and never change it mid-season. Watch length of stay alongside room nights: twenty room nights in ten bookings of two nights is a different house from twenty room nights in four bookings of five nights, and it changes housekeeping and breakfast load.

Contracted allotments that are released back show up as cancellations. If releases cluster on one channel, the pickup report is describing your release policy, not guest behavior. Group blocks wash at their own rate and on their own schedule, so track group pickup separately and check it against the block's cut-off date, not against the retail curve.

Rate-code hygiene decides whether any of this works. A booking coded to the wrong channel poisons both the pickup and the pace series, and the error is invisible in the total. Also look at arrival-date concentration: pickup that all lands on the same three stay dates is a different risk from pickup spread evenly across the month.

What decisions should a pickup report trigger?#

A pickup report should end in a short list of dated decisions with an owner, or it was a report about nothing.

Set thresholds in room nights, not in feelings. Agree in advance how far behind pace a stay date must fall before a rate or restriction changes, and write the threshold down. When you act, change one lever at a time so the next pickup report can tell you what worked: open or close a minimum stay, close or open arrival, or adjust a public rate.

Sales calls follow from pace, not only from rate moves. A channel that is behind pace is a call to the account, not a rate cut on the website; bring the pace chart to the call. If a date is ahead of pace and a partner still holds unsold rooms, ask for the rooms back before you discount the public rate. Before accepting a large group block on a date that is already ahead, check what retail business the block would replace, using the same pace series.

Record the decision next to the number that caused it, with the date. Next month you will want to know whether the move worked, and memory will not be enough.

What can a pickup report not tell you?#

It cannot tell you what demand would have been, because it only records the guests who booked, not the ones who looked and left.

It is not a forecast. It describes the book as it stands; turning that into an expectation of the final house requires assumptions about the booking curve that the report does not contain. It cannot see unconstrained demand: a date that was closed, restricted or priced out of the market shows weak pickup for reasons the report will never display. It also cannot see competitors, new supply, a route change or a source market's own holiday calendar unless someone adds that context by hand.

Small numbers are noisy. On a date with a handful of rooms on the books, one group decision moves the percentage wildly; read the room-night gap instead. And published occupancy is not your occupancy: the Ministry of Culture and Tourism reported an occupancy rate of 49.54% in Ministry-certified (İşletme and Basit) facilities for 2025, and the definition behind that column is not stated, so it is not a benchmark for your own house. Source: Ministry of Culture and Tourism, accommodation bulletin 2025. Public data. No endorsement implied.

Ask any figure presented to you as an industry norm for its publisher, title and date, and treat a figure that arrives without them as an opinion rather than a benchmark.

If software suggests rates to you, the same discipline applies: see AI rate recommendations: what a revenue manager should check.

What to do next#

Fix one habit before you add any tooling. Take a snapshot at the same time every day, keep last year's position at the same days before arrival, and review net pickup by segment and channel once a week against holiday-aligned, currency-aware pace. Then write down each decision next to the number that caused it, so the next report tells you whether the decision worked.