Skip to Content
ProcessesTasksReportsDailyReportTask

DailyReportTask

The DailyReportTask generates the most detailed report in the system, producing one row per stay date per booking. This report enables day-by-day analysis of occupancy, revenue, and guest activity.

Overview

This report is the foundation for:

  • Daily occupancy analysis
  • Per-night revenue tracking
  • Detailed stay pattern analysis
  • Room-level performance metrics
  • Guest behavior by date

Incremental behavior

This task supports incremental regeneration via the ProcessedAddedRoomModel input. When run in incremental mode the task regenerates daily records for the affected rooms only, upserting using the natural keys:

  • chain_id, property_id, res_id, room_stay_date

If no added/changed rooms are detected the incremental routine will skip execution.

Data Structure

Granularity

One row represents: A single night of a stay in a specific room

Example:

  • Guest books room 101 from Jan 1-3 (2 nights)
  • Result: 2 rows in daily report
    • Row 1: Jan 1, room 101
    • Row 2: Jan 2, room 101

Models

Requires

  • ProcessedGuestModel - Guest information and loyalty metrics
  • ProcessedReservationModel - Reservation details and booking metrics
  • ProcessedRoomModel - Daily room stay data

Provides

  • Writes to {chain_id}_daily database table

Write behavior

  • Writing to the DB is controlled by the write_to_catalog flag passed to the task constructor. When write_to_catalog=True the task will use database_sink.write_chain_table for full writes and database_sink.upsert_chain_table for incremental updates.

Output Schema

The daily report includes (but is not limited to):

Identification

  • chain_id, property_id, res_id, guest_id
  • room_stay_date - The date of this specific night

Guest Information

  • Guest name, email, phone, address
  • Loyalty metrics (stays, lifetime_value, etc.)
  • Guest demographics

Reservation Details

  • Booking date, check-in/out dates
  • Status, booking type
  • Channel, source, market segment
  • Booking window, stay nights

Room Details

  • Room type, room rate code
  • Guests (adults/children)
  • Revenue breakdown:
    • room_stay_date_rate_net - Room revenue for this night
    • room_stay_date_fnb_net - F&B revenue for this night
    • room_stay_date_other_net - Other revenue for this night
    • room_stay_date_total_net - Total revenue for this night

Stay Flags

  • room_stay_date_is_check_in_day
  • room_stay_date_is_check_out_day
  • room_stay_date_is_stay_day
  • room_stay_date_is_stay_night
Last updated on
BookingRoomsReportTaskGuestLoyaltyReportTask