Hotel Segment Forecasting

Measure weekly forecasting accuracy for room nights and ADR across segments, and uncover data-driven refinement opportunities.



📊 Reading Report Output

Report analgising to determine the how to spread RevPAR, Occupancy and Rate targets through all major segments and accounts. These output helps to read into Monthly Bases the total property view “total Properties 13 Boutique hotels”

Executive Summary page
The first Section, with expected roomnight, mix and ADR change for 2019 and 2020.
The second report page is a 2019 Segment Conribution to RevPAR growth

📊Properties Averages Summary

Visualize weekly differences between forecasted and actual room nights sold and ADR, highlighting deviations that guide forecast improvements.

Properties Segment Overview

understanding what drives RevPAR change helps you: Identify whether growth is volume-driven (Occupancy) or rate-driven (ADR). Adjust strategy: If ADR is flat but occupancy rises → pricing opportunity. Align forecasting and pricing strategy by segment or season.

Properties' Averages
proprties avg
Average Changes
Average Changes Table
Drivers of RevPAR Changes
ADR Change Table

Segment Total

Room Nights How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 Tracks segment growth (e.g., Is OTA growing while Direct is shrinking?) 💰 Revenue strategy alignment (e.g., push high-ADR segments) 🎯 Marketing targeting (e.g., re-engage underperforming channels)

MIX (%) by Segmentfor each year — which shows how much each Segment to the total business annually. 🧠 Why This Query is Important Shows reliance on OTAs, Direct, TO/TA, etc. Helps identify shifts in booking patterns over time Useful for strategic planning and segment targeting Reveals disintermediation opportunities (e.g., shift OTA to Direct)

Room Nights by Segment
Room Nights Table
MIX (%) by Segment
Pickup Variance Table
Charts - Room Nights by Segment
Chart 9
Chart 10
Chart 11
Chart 12
Charts - MIX (%) by Segment
Chart 13
Chart 14
Chart 15
Chart 16

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16

Segment Changes

What This Query Is About: This query tracks CHANGES happened on Room Nights, ADR ,Mix ,RevPAR and Revenue by Segment (e.g., Corporate, Group, Contract) across three years (2014–2016), and it categorizes them into:

🧠Why This Query Is Important: 📊 Segment Change : It tells you which segments are growing or declining in contribution. 📈 Transient vs Group mix tracking: Helps you monitor balance between transient (short-stay, rate-sensitive) and group (block) business. 🧩 Forecasting & Budgeting: These trends guide how to allocate sales effort, adjust rate strategy, or optimize inventory. 🔍 Strategy Refinement: Spot where demand shifts are occurring by year.

MIX (%) by Segmentfor each year — which shows how much each Segment to the total business annually. 🧠 Why This Query is Important Shows reliance on OTAs, Direct, TO/TA, etc. Helps identify shifts in booking patterns over time Useful for strategic planning and segment targeting Reveals disintermediation opportunities (e.g., shift OTA to Direct)

Room Nights Change by Segment
Room Nights Table
MIX (%) by Segment
Pickup Variance Table
Charts - Room Nights by Segment
Chart 9
Chart 10
Chart 11
Chart 12
Charts - MIX (%) by Segment
Chart 13
Chart 14
Chart 15
Chart 16

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16

🔎 Segment-Level Forecast Accuracy

Track how accurately each market segment performed against projected values. Pinpoint which segments are most predictable and which need better modeling.

Segment Forecast Accuracy

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16

📅 Booking Window Impact

Understand how lead time affects forecasting reliability. Longer lead windows often introduce more volatility and deviation from expected demand.

Lead Time and Forecast Accuracy

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16

📉 Forecast Error by Week

Analyze weeks with largest forecasting errors to adjust model assumptions and improve future planning for revenue, staffing, and inventory.

Forecasting Error by Week

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16

📈 Trend of Forecast Accuracy Over Time

Evaluate whether forecasting performance is improving year-over-year, indicating successful adjustments and model tuning.

Forecast Accuracy Trend

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16

ADR by Segment How many were generated by each distribution channel (segment) over three years. Why it's important: 🧭 It tracks pricing trends by Segment. 🎯 Helps identify underpriced or overpriced segments. 💰 Supports revenue optimization and strategic rate setting. 📈 Helps identify high-yield vs low-yield segments Informs pricing strategies by segment and year Enables benchmarking over time Foundation for RevPAR decomposition (ADR × Occ%)

Revenue by SegmentCalculates total revenue per segment for each year from 2014 to 2016. 🧠 Why This Query is Important Tracks revenue contribution by segment across years. Identifies growth trends or underperforming channels. Useful for budgeting, forecasting, and strategic allocation.

ADR by Segment
ADR by Segment Table
Revenue by Segment
Pickup Variance Table
Charts - DR by Segmentt
Chart 9
Chart 10
Chart 11
Chart 12
Charts - Revenue by Segment
Chart 13
Chart 14
Chart 15
Chart 16