Intelligence · Component · inbound-hotel-timepoint-analysis
Inbound hotel cohort timepoint metrics
What it does
Reads hotel IDs from XLSX and joins order/UV/PV metrics across predefined monthly periods with batching and caches.
Core pattern
Workbook entities joined to historical values + period summaries
- Input
- Hotel workbook and historical warehouse data
- Output
- Per-hotel CSV and aggregate JSON summaries
Key parameters
| Name | Type | Default | Values |
|---|---|---|---|
| operation | string | read_cohort | read_cohort · query_periods · join_metrics · export |
| source_xlsx | string | — | — |
| periods | array | — | — |
| snapshot_dates | — | — | — |
| period_windows_in_source | — | — | — |
Maturity and limits
Workbook parsing, ID normalization, period windows and separate order/traffic caches are present. Reclassified from Travel/Hotel after reading calculation/SQL code. Source inspected statically; tests and external integrations were not executed.
Historical warehouse availability and confidential hotel data; period definitions are partly hard-coded.
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 workbook entities joined to historical values followed by period summaries.
- Logistics & supply chainTransferable use
For weekly review of warehouse orders and delivery lead times, use workbook entities joined to historical values followed by period summaries.
Skills pack
Contract scaffold and deterministic mock
Download · 12KBSHA-256 3ab36c852b26048ef93ffe08f94a1d46db7f27b1d5b94ed8319f43e6e798fed0
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