Pickup Report in Hotels: Meaning & Formula

30 Oct 20266 min read

Quick summary: A pickup report in hotel revenue management shows new bookings by stay date. Learn the formula, a worked example, how to read it and common mistakes to avoid.

A pickup report in hotel revenue management shows how many room nights (and how much revenue) were booked over a defined period, such as the last 24 hours or 7 days, for each future stay date. If 5 new rooms were booked yesterday for next Saturday, that is a pickup of 5. The report tells the revenue manager where demand is arriving, which dates are heating up and which are cooling, so rates can be changed quickly.

pickup report guide – topics covered — Pickup Report: what this guide covers

At a glance

New bookings per stay date
Compare with last year
Raise rates on strong pickup

What is a pickup report in hotels?

“Pickup” means net new reservations received in a set time window. A pickup report lists future dates in rows and shows rooms on the books, pickup in the chosen period, revenue and average rate, often next to last year and forecast.

Most hotel systems can produce one, and channel manager dashboards often show similar data. If you do not have the report, you can build a basic version by saving your “on the books” figures daily and subtracting yesterday from today.

Free toolBooking Pace Calculator

Are you ahead of last year?

Try it free →

How a pickup report works

At a fixed time each day, record the rooms on the books for every future date.
Subtract the previous day’s figure from today’s to get the daily pickup.
Add cancellations and modifications to see the net pickup.
Compare pickup with the same period last year and the forecast.
Decide whether to change rates, restrictions or marketing for each date.

Pickup is closely linked to demand forecasting: strong pickup on a date suggests the forecast may be too low, while weak pickup suggests it may be too high.

Pickup report formula and worked example

Net pickup = New bookings in the period − Cancellations in the period

Pickup rooms = Rooms on the books today − Rooms on the books at the start of the period

Consider a hypothetical 40-room hotel in Jaipur looking at a 7-day pickup report on Monday.

Stay date	OTB last Monday	OTB today	7-day pickup	Last year’s 7-day pickup	Average rate on pickup
Sat, 8 Nov	18	27	+9	+5	₹5,900
Sun, 9 Nov	12	14	+2	+4	₹4,700
Fri, 14 Nov	10	11	+1	+3	₹4,500
Sat, 15 Nov	15	16	+1	+4	₹5,000

How to read it: 8 November has strong pickup (+9 against +5 last year) at a good rate, so raise the rate for the remaining rooms and consider a two-night minimum. The dates in the following weekend (14 and 15 November) have weak pickup, so check competitor rates, review OTA visibility and consider a targeted offer for those dates.

Types of pickup reports

Type	Window	Use
Daily pickup	Last 24 hours	Fast reaction on high-demand or event dates
Weekly pickup	Last 7 days	Standard review for rate changes
Monthly pickup	Last 30 days	Seasonal planning and long-lead resorts
Segment pickup	By segment, such as corporate or OTA	Spot which segments are driving demand
Channel pickup	By channel	See which OTAs or direct channels are working

Why a pickup report matters for revenue

Quick action. If a date suddenly picks up, you can raise rates the same day instead of selling cheap rooms to late-booking guests.
Finds problems early. A sudden stop in pickup may signal a rate problem, a channel issue, wrong inventory or a competitor’s offer.
Supports dynamic pricing. It is a main input in hotel dynamic pricing.
Improves marketing. You can see whether a campaign or an OTA promotion produced pickup.
Informs group decisions. Strong pickup on a date may make a group less attractive. See the displacement concept in our revenue management resources.

pickup report – key takeaways — Pickup Report: key takeaways

How to use pickup in a weekly routine

Run the report every morning for the next 30 to 60 days; for long-lead resorts, extend to 120 days.
Highlight dates with pickup above or below your normal range.
For high pickup, raise rates in small steps and restrict low-rate plans.
For low pickup, check rates against competitors, content on OTAs and inventory on all channels.
Record the action taken and review the result in the next report.

Combine pickup with hotel KPIs such as ADR and occupancy for a fuller picture.

Building a simple pickup report without special software

If your PMS does not give a pickup report, create one in a spreadsheet. Every morning at the same time, copy the “rooms on the books” number for each of the next 60 dates into a new column. The difference between today’s column and yesterday’s column is the daily pickup. Over a week you will have seven columns, and the sum is the 7-day pickup.

Stay date	Mon	Tue	Wed	Daily pickup Tue	Daily pickup Wed
Sat 22 Nov	20	22	26	+2	+4
Sat 29 Nov	9	9	10	0	+1

The first date is accelerating, a sign that you may be priced too low. The second is quiet, so check whether the date is live on every channel with correct rates.

Questions to ask when you read pickup

Which channel produced the pickup: direct, OTA, corporate or group?
Was there an event, a promotion or a rate change that explains it?
Is the average rate on the new bookings rising or falling?
Are cancellations offsetting the gains?

Common mistakes

Using only gross pickup and ignoring cancellations.
Reacting to one day’s pickup without checking the trend.
Confusing pickup with pace. Pace compares total rooms on the books with a benchmark; pickup is new bookings in a window.
Not separating group pickup, which can create a false signal.
Forgetting to adjust for events and holidays when comparing with last year.
Failing to act on the report.

Related terms

On the books (OTB): reservations already confirmed.
Booking pace: speed of booking compared with a benchmark.
Forecast: expected final rooms sold.
Lead time: days between booking and arrival.
Cancellation rate: share of bookings cancelled.
STLY: same time last year.

Key takeaways

A pickup report shows net new room nights booked in a set window for each future date.
Strong pickup suggests raising rates; weak pickup suggests investigating rates, channels and content.
Always include cancellations, and compare with last year and forecast.
Review daily or weekly, and record the action taken.

Revgrow360 helps hotels set up pickup reporting and turn it into daily pricing decisions through hotel revenue management. You can book a free consultation to see a sample report.

expert tip on pickup report — Expert tip on pickup report

For more background, see this hotel industry overview on Wikipedia.

Frequently asked questions

What is a pickup report in a hotel?

A pickup report shows how many room nights, and how much revenue, were booked in a specific recent period for each future stay date. It highlights which dates are gaining demand and which are slowing, so the revenue manager can change rates and restrictions quickly.

How do you calculate pickup?

Subtract the rooms on the books at the start of the period from today's rooms on the books. For net pickup, include cancellations. For example, 27 rooms today against 18 a week ago is a 7-day pickup of nine rooms for that stay date.

What is the difference between pickup and booking pace?

Pickup is the number of new bookings in a defined window, such as the last 7 days. Booking pace compares total rooms on the books now with the same point last year or the forecast. Revenue managers use both to read demand direction and speed.

How often should a hotel review its pickup report?

Most hotels review it daily for the next 30 to 60 days and weekly for longer horizons. Long-lead resorts may extend the window to 120 days. For event dates and high-demand periods, check more often so you can raise rates quickly.