PickupReportTask

The PickupReportTask generates a comprehensive pickup and pace report by comparing current bookings with historical snapshots taken at different time intervals. This enables forecast accuracy analysis and booking pace monitoring.

Overview

This report tracks booking velocity by:

• Creating snapshots at multiple time points
• Comparing current bookings to past snapshots
• Calculating pickup (new bookings since snapshot)
• Enabling year-over-year comparisons
• Supporting pace analysis across dimensions

Snapshot Strategy

Snapshot Definitions

Data Flow

Dimensions

Data is aggregated by these dimensions:

• room_stay_date - The stay date
• nationality - Guest nationality
• address_state - Guest state
• address_country - Guest country
• source - Booking source
• secondary_source - Secondary source
• room_rate_code - Rate code
• market_segment - Market segment
• travel_agent - Travel agent
• company - Company

Calculated Metrics

Current Bookings (TY)

• this_year_rev - Total revenue in current snapshot
• this_year_rooms - Total rooms in current snapshot

Snapshot Comparisons

For each snapshot (1d, 3d, 7d, 30d ago):

• revenue_Xd_ago - Revenue X days ago
• rooms_Xd_ago - Rooms X days ago
• pickup_rev_Xd - Revenue gained since X days ago
• pickup_rooms_Xd - Rooms gained since X days ago

Year-over-Year

• last_year_rev - All revenue from last year
• last_year_rooms - All rooms from last year
• stly_rev - Revenue at same time last year
• stly_rooms - Rooms at same time last year
• ty_vs_last_year_rev - Revenue difference vs last year
• ty_vs_last_year_rooms - Rooms difference vs last year
• ty_vs_stly_rev - Revenue difference vs STLY
• ty_vs_stly_rooms - Rooms difference vs STLY

Models

Requires

• ProcessedGuestModel - Guest information
• ProcessedReservationModel - Reservation details
• ProcessedRoomModel - Daily room data

Provides

• Writes to {chain_id}_pickup database table

Related Reports

• DailyReportTask - Source data
• ReportsTask - Parent orchestrator

Best Practices

1. Schedule wisely: This report takes time; run during off-peak hours
2. Archive old data: Pickup data becomes less relevant over time
3. Monitor storage: This report grows quickly
4. Index dimensions: Index on room_stay_date and other commonly queried dimensions