Back to Blog Analytics

Hotel Occupancy Reports: What to Track and How to Use the Data

Most Indian hotel owners know their occupancy percentage roughly - they can estimate it from memory or do a quick mental count of occupied rooms. What very few have is a systematic view of occupancy data broken down by room type, booking source, guest segment, and time period. That systematic view is what separates reactive management ("we had a slow month, let us discount") from proactive revenue management ("we will have a slow month in 8 weeks, here is our strategy to fill the gap").

This article explains what an occupancy report should contain, which metrics to track at different time horizons, and how to use the data to make decisions that actually improve revenue.

The Core Metrics in a Hotel Occupancy Report

Occupancy Rate (%)

Rooms sold divided by rooms available, expressed as a percentage. Track this daily, weekly, monthly, and year-over-year. A hotel with 30 rooms that sold 22 on a given day has a 73.3% occupancy rate.

Average Daily Rate (ADR)

Total room revenue divided by rooms sold. ADR tells you what you actually earned per occupied room on average. If your listed rates vary by room type and season, your ADR shows the blended average after discounts, deals, and corporate rates.

Revenue Per Available Room (RevPAR)

ADR multiplied by occupancy rate. RevPAR is the single most important revenue metric in hotel management because it captures both how full you are and what you charged. A hotel at 90% occupancy with an ADR of Rs. 1,200 has a RevPAR of Rs. 1,080. A hotel at 70% occupancy with an ADR of Rs. 1,700 has a RevPAR of Rs. 1,190 - and is actually generating more revenue per available room despite lower occupancy.

Average Length of Stay (ALOS)

Total room nights occupied divided by total number of bookings. ALOS tells you whether your guests are staying for one night or five. Properties that attract longer stays generally have lower cost per booking (less housekeeping turnover, fewer check-in transactions) and higher total revenue per guest.

Booking Lead Time

How far in advance guests book. Knowing that 60% of your bookings come in with less than 3 days lead time tells you something important about your pricing strategy - you may be attracting primarily last-minute price-seekers. Or it may just reflect your local market (business travellers often book at short notice).

Segmenting Your Occupancy Data

Raw occupancy numbers are useful, but segmented data is where the insights live. The key dimensions to segment by:

By Room Type

Which room categories fill fastest - deluxe, standard, suite? If your deluxe rooms fill first and your standard rooms have 40% vacancy on the same days, you are likely underpricing your deluxe rooms relative to standard. Or your standard rooms may have a perception or quality issue worth investigating.

By Booking Source

What percentage of bookings come from MakeMyTrip, Goibibo, Booking.com, direct call/walk-in, your website, and other channels? This tells you where your marketing investment is working and where OTA commissions are concentrated. If 80% of bookings come from one OTA, you have a dependency risk.

By Guest Segment

Leisure vs. corporate, domestic vs. foreign, individual vs. group, repeat vs. new. Each segment has different price sensitivity, booking behaviour, and revenue characteristics. If corporate bookings have a 2.5x average length of stay compared to leisure, but are only 15% of your volume, there is an opportunity to grow that segment.

By Day of Week

Most Indian hotels have a strong weekend-weekday pattern. Knowing the specific occupancy numbers for Monday through Sunday helps you price correctly for each day rather than using a flat weekly rate.

How to Read a Monthly Occupancy Report

A monthly occupancy report for an Indian hotel should show:

• Month overview: total rooms available, total rooms sold, occupancy %, ADR, RevPAR
• Weekly breakdown: which weeks were stronger and weaker
• Day-of-week analysis: Monday to Sunday average occupancy and ADR
• Booking source breakdown: what percentage came from each channel
• Room type performance: occupancy and ADR by room category
• Cancellation rate: percentage of bookings that cancelled and from which source
• Year-over-year comparison: how this month compares to the same month last year

This report should take no more than 10-15 minutes to review. If your current system requires you to build this manually from multiple sources, that is a strong signal that you need better reporting tools.

Using the Data to Make Decisions

Setting Rates for the Next 30-60 Days

Look at your current booking pace - how many bookings do you have for the coming 30 days versus the same point in time last year? If you are 20% ahead of last year's pace, you can afford to hold or increase rates. If you are 20% behind, you may need to stimulate demand through promotions or rate adjustments.

Identifying Your Slow Periods

Occupancy data across 12 months makes your seasonal pattern very clear. Use this to plan your annual marketing calendar - promotional campaigns, corporate outreach, and event targeting should be concentrated in the 4-6 weeks before your historically slow months, not during them.

Evaluating OTA Relationships

If your booking source report shows that one OTA contributes 40% of your bookings but also accounts for 60% of your cancellations, that is a significant issue. High cancellation rates from a specific platform may mean that platform is attracting a different type of booker than you want, or that the booking conditions on that platform (free cancellation policies) need adjustment.

Assessing Room Type Strategy

If one room type consistently has higher occupancy and ADR than others, consider whether you can convert lower-performing room types to match what the market is willing to pay for. A standard double that stays at 90% occupancy while your superior double sits at 55% suggests a pricing or presentation gap between the two categories.

Building a Review Cadence

The frequency with which you review occupancy data should match how quickly you can act on it:

• Daily: Check yesterday's occupancy, today's expected arrivals, and the next 7-day booking pace. This takes 5 minutes and keeps you informed without overwhelming you with data.
• Weekly: Review the week's performance against the same week last year. Adjust rates for the following 2-3 weeks based on current booking pace.
• Monthly: Full monthly occupancy report review. Identify trends, compare to targets, plan the following 60 days.
• Quarterly: Look at the quarter's performance against your annual targets. Make strategic decisions about channels, pricing tiers, and market segments.

Data without action is just numbers. The hotels that use occupancy reporting effectively are those that have built a regular review practice and built pricing adjustments into the output of that review. The time investment is small; the revenue impact compounds over months and years.