Daily Resort Standup & 24h Forward Look
Today & Tomorrow 🔄 Turnover Alert 🎂 Birthday 🇦🇼 HolidayLoading daily resort operations briefing, weather, and arrivals...
Live Interactive Park Map
⚡ResortIQ LiveReal-time villa occupancy, guest statuses & turnover monitoring
Occupancy / Status (Color)
Operations & Housekeeping (Icon)
Knowledge Base is now integrated inside Frank AI Hub
All resort policies, amenities, and AI facts have been unified directly with Frank's Persona & Model Engine.
Reservations & Payment Ledger
Single Source of TruthLive resort reservation management, balance tracking, manual payment recording, and Stripe billing.
| Ref & Channel | Guest Contact | Villa | Stay Dates | Financials ($) | Payment Status | Actions |
|---|
Loading live reservations ledger...
No reservations found matching your criteria
Try changing your filters or clearing your search term.
Multi-Calendar
⚡ResortIQ SyncChannex Channel Manager Engine
● Connected: Merlot Villas Aruba STAGINGReal-time 2-way ARI (Availability, Rates & Inventory) connection for Airbnb, Booking.com, VRBO, and direct bookings.
Hostaway Shadow Sync & Parity Cockpit
● Loading status...Realtime parity monitoring between Hostaway Channel Manager and PostgreSQL database.
🗺️ Unified Listing & Channel Routing Cockpit
Multi-Calendar rental listings mapped across Hostaway (Legacy) and Channex (Primary Next-Gen).
| Listing Unit & Specs | Type & Rules | 🟢 Hostaway Route | 🟣 Channex Route | Live Rate & Min | Migration Status |
|---|
📜 Realtime Webhook & Activity Feed
Shadow AI & WhatsApp Feed
⚡ResortIQ Shadow AgentInbound guest messages and AI draft responses for Frank's review and approval.
Guest Journey & Automated Messaging
⚡ResortIQ Autopilot Loading touchpoints...Personalized lifecycle communications sent via preferred channel (WhatsApp/Email/OTA) with dynamic MyStay Portal links.
Automated Lifecycle Steps
Click any card to preview🛡️ Staging & Approval Queue
0 Pending Review| Guest & Villa | Touchpoint | Channel | Draft Message | Action |
|---|---|---|---|---|
| No staged messages in queue. Everything is calm and under control. | ||||
📜 Recent Dispatched Journey Events
| Date & Time | Touchpoint | Recipient | Status | Message Snippet |
|---|---|---|---|---|
| Loading dispatch history… | ||||
Pre-Arrival Welcome
Trigger: -7d at 12:00 AST
Merlot Villas Aruba
Verified Resort Business
\{\{guest_name\}\} \{\{villa_name\}\} \{\{check_in_date\}\} \{\{door_code\}\} \{\{gate_code\}\} \{\{wifi_password\}\} \{\{portal_link\}\}
Edit Journey Template
Revenue & Pacing Intelligence Engine
⚡ResortIQ Yield EngineLive yield recommendations based on historical bookings, orphan gap-night detection across all 12 managed rental villas, and attached group combo pricing.
📈 12-Month Forward Pacing vs. Historical Curve
Compares current forward bookings with 8-year historical same-month baseline to calculate yield recommendations.
🌙 Smart Gap-Night Opportunity Spotter (Next 90 Days)
Scans all 14 villas for 1–3 open orphan nights between existing reservations to recover unbooked revenue.
👑 Official Hostaway Attached Combo Group Pricing Matrix
Per-bedroom efficiencies, group discounts, and holiday rate recommendations for large groups & celebrations.
Booking Velocity & Channel Intelligence
⚡ResortIQ Velocity Pickup & YoY VelocityReal-time booking arrival pace over time, Year-over-Year (YoY) pickup momentum, OTA channel distribution, and lead-time horizon.
🏨 Channel Performance & Yield Matrix (12-Month Share, ADR & ALOS)
Compares revenue generation, ADR per night, length of stay, and lead times across Airbnb, VRBO, Booking.com, and Direct.
🎯 Target Stay-Month Horizon (Where Last 30 Days Pickup Lands)
Distribution of recent reservations across upcoming check-in months.
⏳ Lead Time Windows
How far in advance guests book.
Photo & Media Manager
⚡ResortIQ MediaHigh-res WebP image pipeline, hero banner selection and multi-language captions.
Generate Stripe Payment Link
Creates an instant live checkout link to insert into chat
Manage Dates
Villa 47LQuickly block dates, enter owner stays, direct bookings, or adjust rates
Teach Frank AI a New Fact
Permanently index a rule or policy so Frank responds accurately next time
Frank AI Host & Knowledge Hub
⚡ResortIQ Intelligence EngineCentral command center for Frank's hospitality persona, reasoning engine, authoritative knowledge base, and live simulation.
Set strict prohibitions, allowed services, and safety rules that Frank must enforce in every response:
Provide specific instructions and behavioral priorities that Frank AI follows on the website, MyStay portal, and email drafts:
Knowledge Base & AI Retrieval Context
⚡ResortIQ Context Loading...Authoritative resort policies, villa amenities, check-in instructions, and island tips retrieved dynamically by Frank AI.
| Topic | Keywords & Answer Summary | Status | Actions |
|---|
💬 Live AI Simulation & Guardrail Verification
Test real guest questions against Frank AI to verify prompt guardrails, tone, and retrieved Knowledge Base facts in real time.
Listing Profiles
⚡ResortIQ CatalogResort Catalog & Operational Listing Hierarchy
Website Direct Booking Incentive
ActiveExclusive savings applied directly in the website reservation engine to boost direct conversions.
🏷️ Select Category...
Configure website pricing, guest copy & assigned villa pool
When a guest books this category, Frank can assign any of these physical villas according to operational convenience. Toggling villas automatically recalculates the category base rate (average rounded up to the nearest multiple of 25):
Control seasonal visibility and bookability on the website. In unselected months (high season), this category is hidden from the catalog grid and marked as fully booked in the booking engine, directing guests to 4BR+ estates.
🏡 Select Villa...
These highlights are displayed on website villa cards and referenced by Frank AI in conversations.
Enter comma-separated keywords. Frank AI uses these tags to match and recommend this villa to guests.
⚡ Listing Type & Channel Configuration
📡 Channel Manager External IDs
Hostaway Listing Amenities (Shadow Sync)
0 AmenitiesRead-only sync from Hostaway API. Updates automatically every 2 weeks or on demand.
Merlot Villas · Analytics & Telemetry
⚡ResortIQ Telemetry ● PostgreSQL LiveReal database telemetry, conversion funnels, Frank AI topics & click behavior
📈 Visitors & Searches Timeline
Period🌍 Visitors & Bookings by Origin Country
🎯 Conversion Funnel Flow
🏆 Top Performing Villas (Traffic & Inquiries)
| Date | Unique Visitors | Searches | Villa Pageviews | Frank AI Chats | Bookings | Conversion % |
|---|
🤖 Most Asked Topics by Guests
💬 Live Guest Inquiries & Frank AI Answers
Latest interactions📄 Most Visited Website Pages
| Page Path / URL | Views | Share % |
|---|
🖱️ Button & Link CTA Click Distribution
| Button / Link Label | Page | Clicks | Share % |
|---|
Operations & Staff Scheduling Cockpit
⚡ResortIQ Ops 12 Merlot VillasDaily turnovers, 7/14-day matrices, 1-click smart auto-allocation, and live housekeeping Kanban.
👥 Authorized Staff Members & WhatsApp Access
HR Master Records: manage team members, operational roles, and WhatsApp mobile numbers✏️ Edit Staff Member
| Name | Role | WhatsApp Number | Birthday 🎂 | Max Workload | Status | Actions |
|---|---|---|---|---|---|---|
| Loading staff records... | ||||||
| Staff Member | Role | Today's Status | Shift Hours | Assigned Villas (47A - 47N) | Roster Actions |
|---|---|---|---|---|---|
| Loading daily roster... | |||||
Live WhatsApp & Housekeeping Activity Log 0 events
Real-time audit log of staff WhatsApp inquiries, automated cleaning status updates, and dispatch events.
| Time | Staff Member | Direction | Message Content | Automated Action | Status |
|---|---|---|---|---|---|
| Loading activity log... | |||||
📅 7-Day Capacity Horizon Forecast
Review peak days and adjust staffing rosters proactively.| Date & Day | Checkouts (Turnovers) | Midstays | Required (Hours) | Available (Hours) | Workload Ratio % | Status Forecast |
|---|---|---|---|---|---|---|
| Loading forecast horizon... | ||||||
🌅 Daily Housekeeping Morning Dispatch (07:00 AM AST)
Official Spanish turnover briefing for staff WhatsApp & Email with verified 47-villa numbers.
Housekeeping Dispatch & Operations Templates
Mutate morning briefings, priority turnover alerts, and work order dispatch with Twilio & Meta compliance.
WhatsApp business-initiated messages outside 24h require approved Content SIDs. Submitting registers the template directly with Twilio & Meta.
Notify Housekeeping — Check-in & Check-out Timing Update
Transmits real-time updated turnover times or flight arrivals to the on-site cleaners via WhatsApp.
Resort & Operations Settings
⚡ResortIQ ConfigConfigure single-source-of-truth pricing & taxes, housekeeping standards, morning turnover dispatch, and security access.
PostgreSQL Database & Storage Engine
⚡ResortIQ PostgreSQL ● PostgreSQL 16 Active Pool: Connected Host Mount: ./backupsCore relational data store for reservations, villas, guests, and operational logs. Features automated gzip night-dumps and 1-command fail-safe disaster recovery.
📦 Compressed Backup Archives Catalog
Directly downloadable for offline offsite archival| Archive Filename | Compressed Size | Created Date / Time | Actions |
|---|---|---|---|
| Loading database backups... | |||
Disaster Recovery & Fail-Safe Restore
To restore any backup archive with zero downtime risk, run the fail-safe restore script from the project root:
./scripts/restore_database.sh backups/merlot_backup_YYYYMMDD_HHMMSS.sql.gz