Intelligence · Component · booking-stay-pattern-analysis
Booking lead-time and stay-pattern analysis
What it does
SQL recipes and report scripts compare destination/site stay profiles, booking-to-stay matrices, lead-time distributions and event windows.
Core pattern
Time-grouped records + lead-time and cycle comparisons
- Input
- Authorized booking/stay records
- Output
- Segment tables, lead-time/stay profiles and Markdown/CSV analysis
Key parameters
| Name | Type | Default | Values |
|---|---|---|---|
| operation | string | stay_profile | stay_profile · leadtime · matrix · event_comparison |
| filters | — | — | — |
| windows | object | — | — |
| destination_site_and_date_constants_in_sql | — | — | — |
| history_window | — | — | — |
Maturity and limits
Substantial SQL and formatting scripts exist, but several analyses are one-off with fixed places and dates. Reclassified from Travel/Hotel after reading calculation/SQL code. Source inspected statically; tests and external integrations were not executed.
Private customer/order data; event comparisons cannot establish weather or holiday causality.
1 sentence citing source paths or vendor names omitted for publication.
Used in pipelines
Industry tags
- Travel & hotelsSource-supported industry
For work involving destinations, room rates and bookings, use time-grouped records followed by lead-time and cycle comparisons.
- Logistics & supply chainTransferable use
For weekly review of warehouse orders and delivery lead times, use time-grouped records followed by lead-time and cycle comparisons.
Skills pack
Contract scaffold and deterministic mock
Download · 12KBSHA-256 a36bcb306057074d78cc2400c30e4986904312c0df29c7bc9dffa0b38b86c07b
Related components
-
Announcement event studies
Events aligned with historical values + windowed outcome analysis
Working 1 pipeline -
Campaign and holiday evidence enrichment
Changes aligned with calendar candidates + source review queue
Working 1 pipeline -
Audited curation and database publishing pipeline
Human merge and override decisions + controlled data sync
Working 1 pipeline -
Dashboard table extraction
Authorized dashboard table extraction + scope and source metadata
Working 1 pipeline