Certified metrics
RevenueTotal realised room revenue from confirmed bookings.
Room Nights SoldSum of nights across confirmed bookings.
BookingsCount of confirmed bookings.
ADR (Average Daily Rate)Revenue divided by room-nights sold. A ratio — never averaged of averages.
Occupancy RateSold room-nights divided by available room-nights. Computed by aggregating sold nights to property-month, joining inventory, then SUM(sold)/SUM(avail). Not defined at room_type grain because inventory has no room-type split.