What is a hotel pickup report and how do you read it?
You open the hotel's occupancy report in the morning: 65% today. Yesterday it was 60%. Is that good? You do not know — because this report gives you today's snapshot, not the movement. How many rooms were added for next Saturday, is that speed good against the same point last year, which date is filling slower than expected? None of that is in the occupancy report; all of it is in the pickup report.
This article explains what a pickup report is, its three-column structure, how it is compared with last year, what negative pickup tells you, and how the report turns into a pricing decision in five minutes each morning. At the end there is a fictional example and the four mistakes I see most often.
What is pickup, and how is it different from OTB?
The two concepts are constantly confused. OTB (on the books) is the total room nights sold to date for a given stay date: a snapshot of stock. Pickup is the room nights added to that date between two readings: a measure of speed. If Saturday's OTB is 70 rooms and yesterday's OTB was 62, yesterday's pickup is 8.
Pickup
Pickup(date) = OTB today − OTB at the previous reading
Daily readings give daily pickup, weekly readings give weekly pickup; cancellations are netted off, so the result can be negative
An occupancy report is an OTB report — and on its own it misleads, because the same 65% can be reached two different ways: a date that filled fast and has stalled, or a date filling slowly but steadily. The pricing decision differs between the two; the only thing that shows the difference is pickup.
The report's three columns
A good pickup report is not complicated. Rows are future stay dates; there are three columns:
| Column | What it shows | Why it is needed |
|---|---|---|
| OTB | Room nights sold to date for that stay date | Where you are |
| Pickup | Room nights added since the last reading (net of cancellations) | How fast you are moving |
| Same point last year | Last year's OTB with the same number of days to arrival | Whether that speed is good or bad |
The third column is what makes the report a report. Pickup of 8 rooms — is that good? If OTB at the same point last year was 55 and you are at 70 today, yes; if it was 85, you are behind. The comparison is made by days to arrival, not by calendar date: this year's OTB 20 days before Saturday is compared with last year's OTB 20 days before that Saturday.
Taking the same calendar day last year is a common mistake: holidays, weekends and event days shift from year to year. Compare on the "days to arrival" axis and, where possible, for the same day of the week.
An optional fourth column is the channel or segment split: of the 8-room pickup, how many were OTA, direct, group. That column shows the difference between "demand arrived" and "the right demand arrived"; you can start without it in the first weeks and add it in month two.
How to read the report in five minutes each morning
Reading a pickup report does not mean looking at all 90 days ahead. Three questions are asked every morning, and the report is scanned against them:
- Which dates are clearly ahead of last year? For these, check remaining inventory; if it is shrinking, move the rate up one band and switch on restrictions (minimum stay).
- Which dates are clearly behind last year? The first reflex here is not a discount. Check channel visibility first (is the date on sale in every channel, is a stop-sale still in place), then restrictions, and the rate last.
- On which dates is pickup negative? One day is noise; three consecutive days call for a cause: group cancellation, competitor rate move, channel problem.
The remaining dates — those tracking in line with last year — are the dates you do not touch that morning. That is the report's real value: it stops you touching dates that should be left alone. A hotel that moves every date's rate every morning is not reading pickup; it is reacting.
Example: Sample Hotel's morning report
The figures below are fictional and do not belong to any real property. Sample Hotel has 120 rooms in a city centre; a Tuesday-morning report for the coming weekend and two weeks out:
| Date | To arrival | OTB | Pickup yesterday | Same point last year | Reading |
|---|---|---|---|---|---|
| Friday | 3 days | 98 | +6 | 88 | Ahead; 22 rooms left → BAR up one band |
| Saturday | 4 days | 112 | +9 | 95 | Ahead, inventory running out → 2-night minimum stay |
| Sunday | 5 days | 41 | +1 | 58 | Behind → check channels first; extension offer from Saturday |
| Saturday (+1 week) | 11 days | 64 | −4 | 60 | Negative pickup, third day → group cancellation or competitor? |
| Wednesday (+2 weeks) | 15 days | 70 | +5 | 68 | In line → leave alone |
Three of five rows produced a decision, two did not — and not acting on those two is a decision as well. The Sunday row is the most instructive: the first move for a date that is behind is not a discount, it is offering Sunday night as a package to the guests already staying Saturday; Saturday is full and those guests are in the building. The cheapest way to generate pickup without cutting rate is to extend the stay of the guest you already have.
On a negative-pickup row the rate is not touched until the cause is found. If it is a four-room group cancellation there is no pricing problem; if a competitor cut its rate by 20% for the same night, the subject is price — but the answer is still not an automatic discount, it is a measured decision using rate shopping.
The four most common mistakes
1. Mistaking the occupancy report for a pickup report
"We are at 65% today" is an OTB reading. What changed since yesterday and where you stand against last year are not in that sentence. Without the second and third columns, pickup has not been read.
2. Comparing last year by calendar date
15 October and last year's 15 October are not the same day; one may be a Friday, the other a Wednesday. Compare on the days-to-arrival and day-of-week axes. This is a one-off job when the report is set up; skipped, every comparison misleads.
3. Reacting to every pickup with a rate change
The reflex of raising on high pickup and cutting on low pickup turns the report into a price swing. On high pickup ask about remaining inventory and source first; on low pickup ask about channel visibility and restrictions first. Rate is the last question.
4. Opening the report once a week
Weekly pickup is last week's news. Daily window for the next 30 days, weekly for 30–90; if the morning reading takes more than five minutes, there are too many columns or too many dates.
How to set it up in your own hotel
- Export OTB by stay date from the PMS end-of-day report every morning. Most systems have this ready as a "pace" or "production" report; if not, a simple table taking the difference between yesterday's and today's file is enough.
- Build last year's daily OTB series once: for each stay date, OTB at 0, 1, 2 … 90 days to arrival. This one-off job is what makes the third column possible.
- Start the report with three columns; add the channel split in month two. A five-column report on day one is read by nobody.
- Tie the morning routine to three questions: dates ahead, dates behind, dates negative. Write the answers down — three months later those notes show which decisions worked.
- Link pricing decisions to your seasonal calendar: the pickup report moves a band one step; it does not write a rate from scratch.
Related concepts
- OTB — the stock snapshot pickup is written on top of; defined in the glossary.
- Booking pace — pickup's curve over time; the technical name for the last-year comparison.
- Seasonal pricing calendar — the band structure pickup moves; the previous article.
- Hotel KPI list — pickup's place in the pricing-decision group and its daily reading frequency.
- Forecast — OTB plus expected pickup; the subject of a coming article.
Summary
- OTB says where you are, pickup says how fast you are moving; an occupancy report on its own is OTB.
- The report has three columns: OTB, pickup, same point last year. Without the third, pickup cannot be interpreted.
- Compare on days to arrival and day of the week, not calendar date.
- Three morning questions: dates ahead, dates behind, dates negative. Leave the rest alone.
- On high pickup check inventory first; on low pickup check channels and restrictions first; rate is the last question.
- The report takes five minutes a morning; longer means too many columns or dates.
Frequently Asked Questions
- What is the difference between pickup and OTB?
- OTB (on the books) is the total room nights sold to date for a stay date — a snapshot of stock. Pickup is the room nights added to that date between two readings — a measure of speed. OTB says where you are, pickup says how fast you are moving; they are read together.
- How often should the pickup report be read?
- Every morning. A daily window for the next 30 days and a weekly one for 30–90 days is enough. A pickup report opened once a month is already too late for a pricing decision.
- What does negative pickup mean?
- More cancellations than new bookings arrived for that date. One day can be noise; three consecutive days of negative pickup is a signal — usually a competitor rate move, a group cancellation, or a channel visibility problem.
- Which report is the source for pickup?
- The PMS end-of-day (night audit) report. Most systems have it under a name like "production" or "pace"; if not, export OTB by stay date every morning and take the difference from yesterday. A three-column table is enough; an RMS is not required.
- If pickup is ahead of last year, do you raise the rate straight away?
- Not straight away, but you ask the question. First look at the source: is the extra demand one group, or a low-rate channel? If demand is broad-based and remaining inventory is shrinking, the rate moves up one band; if it is a single group booking, read the date again after removing that group.
The service this article belongs to
Build the Infrastructure for Data-Driven DecisionsMost hotels have data; few have data that can be read. I bring occupancy, ADR and RevPAR reporting, channel mix analysis and forecast-versus-budget tracking into one order. Then I build dashboards management can look at weekly and act on. Performance becomes transparent, and action no longer waits for month-end.
Not familiar with the terms? Revenue management glossary
The next step
Let's read your hotel's numbers together; we'll decide where to start on the first call.
Other articles
- Hotel rate shopping: how to read competitor rates
- How to build a hotel channel mix
- How to build upselling and cross-selling in a hotel
- How to measure a hotel reservations team: six metrics and a team scorecard
- Choosing a booking engine: what to look for in a hotel reservation system
- How to build a seasonal pricing calendar for a hotel
- Hotel KPI list: which metric answers which decision?
- How to calculate RevPAR: formula, worked example and common mistakes
