# HotelInsight — Full Platform Documentation > HotelInsight is an intelligent hotel revenue management platform that helps hoteliers maximise revenue through demand forecasting, dynamic rate optimisation, and multi-factor market analysis. It integrates weather, flights, local events, holidays, and competitor rates into a composite demand score, then recommends optimal room rates for every stay date. - Source: https://hotelinsight.ai/llms-full.txt - Index: https://hotelinsight.ai/llms.txt - Version: 2026 --- ## Platform Overview HotelInsight is a multi-tenant SaaS platform built for independent hotels and boutique properties. It combines property management system (PMS) data with external market signals to produce a composite demand score (0–100 %) and AI-powered rate suggestions per stay date. Managers can accept, adjust, or ignore each suggestion; every decision is logged in an immutable audit trail. **Core value proposition:** - Replace manual rate-setting with data-driven dynamic pricing - Surface demand signals (events, flights, holidays, competitors) in a single dashboard - Provide a traceable audit log of every pricing decision - Enable AI-assisted revenue advice through a built-in chat interface --- ## Authentication & Access Control HotelInsight uses Replit Auth (OpenID Connect) for sign-in. After authentication, users are assigned to one or more hotels by an admin. Role-based access control (RBAC) determines which features are visible: - **Admin**: full platform access, user management, module configuration - **Manager**: rate decisions, AI advisor, analytics, reports - **Viewer**: read-only access to dashboards and reports Session cookies are used for authentication persistence. API routes require a valid session; unauthenticated requests are redirected to `/login`. --- ## Dashboard Sections ### Main Dashboard **Dashboard Overview** (`/dashboard`) Central command centre showing today's demand score, upcoming high-demand dates, a summary of recent rate decisions, active alerts, and quick-links to all major sections. ### Forecast & Rates **AI Rate Suggestions** (`/dashboard/forecast/ai-suggestions`) Displays AI-generated rate recommendations per stay date. Each suggestion shows the composite demand score, suggested rate, and current rate. Managers can Accept (use the AI rate), Change (enter a custom rate), or Ignore each suggestion. Decisions are stored with a timestamp and user ID. **AI Rate History** (`/dashboard/forecast/ai-rate-history`) Paginated, filterable audit log of all past rate decisions. Columns: stay date, decision type (accepted / changed / ignored), AI-suggested rate, actual rate applied, manager name, decision timestamp. Exportable to CSV. **Demand Calendar** (`/dashboard/forecast/demand-calendar`) Heatmap calendar visualising the composite demand score for every future date. Colour bands: Very High (≥80), High (60–79), Medium (40–59), Low (20–39), Very Low (<20). **Forecast Reports** (`/dashboard/forecast/reports`) Configures and schedules automated weekly/monthly PDF demand forecast emails. Admins choose recipients, report sections (occupancy, rates, demand, competitors), send cadence, and time zone. Reports are narrated by Gemini AI and delivered via SMTP. History stored in `report_configs` and `report_logs`. **Demand Intelligence** (`/dashboard/forecast/demand-intelligence`) Aggregated demand signal dashboard combining events, flights, holidays, search trends, and competitor occupancy into a single ranked view for the next 90 days. **Group Bookings** (`/dashboard/forecast/group-bookings`) Track confirmed group blocks and tentative inquiries. Shows group room nights by arrival date and calculates the remaining transient inventory available for dynamic pricing. **Rates** (`/dashboard/forecast/rates`) Rate management view listing every stay date's current published rate alongside the AI-suggested rate, demand score, and last decision. Managers can bulk-accept or individually adjust rates from this page. **Seasonality Planner** (`/dashboard/forecast/seasonality`) Year-over-year demand pattern view overlaying historical occupancy with current forward bookings and seasonal event calendars to help managers plan rate strategies months in advance. ### Analytics **Demographics** (`/admin/analytics/demographics`) Breakdown of guest nationality, source market, and booking channel based on PMS reservation data. **Pickup Tracking** (`/dashboard/analytics/pickup`) Day-by-day booking velocity: how many room nights were picked up in each booking window relative to the arrival date. **Analytics Reports** (`/admin/analytics/reports`) Operational analytics including room type occupancy/ADR/RevPAR, day-of-week demand cycles, cancellation revenue impact, and hotel benchmarking KPIs compared against a configurable competitive set. ### Competitor Intelligence **Rate Shopping** (`/dashboard/rate-shopping`) Pulls competitor room rates from OTA channels (via Makcorps API or ScrapingBee). Each sync batch is recorded for traceability. Parity score shows how the property's rates compare across channels. **Rate Map** (`/dashboard/rate-map`) Interactive Leaflet map pinning competitor hotels and displaying their current rates colour-coded by price range. **Online Reputation Index** (`/dashboard/insights/ori`) Composite reputation metric (review score × review count weighting) for each competitor, enabling side-by-side benchmarking. **Product Analysis** (`/dashboard/insights/product-analysis`) Side-by-side comparison of room products scraped from Booking.com and Agoda using ScrapingBee or Playwright with Gemini AI extraction fallback. **Search Ranking** (`/dashboard/search-ranking`) Tracks the property's position in Booking.com search results over time. **Health Check** (`/dashboard/health-check`) Composite Booking.com performance dashboard aggregating search ranking, pricing competitiveness, guest rating, and availability. ### Market Insights **Flight Analytics** (`/dashboard/insights/flight-analytics`) Multi-source airline capacity database. An AI-powered quality control agent validates data integrity. Feeds the `airline_capacity` table via a unified pipeline. **Event Insight** (`/dashboard/insights/event-insight`) Local events sourced from PredictHQ. Events are scored by expected attendance and proximity to the property, then weighted into the composite demand score. **Holiday Analytics** (`/dashboard/insights/holiday-analytics`) Public holiday data from Nager.Date API. Users can add or remove target countries for monitoring. Holiday proximity is a weighted factor in the demand score. **Google Hotels Snapshots** (`/dashboard/insights/google-hotels`) Historical pricing and availability snapshots from Google Hotels for demand trend analysis. **Hotel Supply** (`/dashboard/insights/hotel-supply`) Tokyo ward-level lodging supply (facility counts, room counts) synced from Tokyo Health Bureau; Inside Airbnb quarterly listing snapshots aggregated by neighbourhood and room type; JTA Minpaku bi-monthly PDF statistics on registered short-term rental accommodation. **Demand Monitor** (`/dashboard/forecast/demand-monitor`) Spreadsheet-style interface for manually tracking news, trends, and market signals. Entries can be injected into AI advisor prompts. **Demand Index** (`/dashboard/demand-index`) Composite demand index chart showing the weighted aggregate of all demand factors over a rolling 90-day forward window with trend lines and score breakdown. **Market Demand** (`/dashboard/insights/market-demand`) City-level market demand view aggregating SerpAPI Google Trends data, competitor sold-out nights, and macro travel signals to contextualise the property's own demand position. **Hotel Search Trends** (`/dashboard/insights/hotel-search-trends`) Google Hotels search volume trends for the destination, sourced via SerpAPI. Shows relative search interest over time to anticipate booking surges before they hit the property's own inventory. **Booking Health Check** (`/dashboard/booking-health-check`) Composite Booking.com performance view combining search ranking, review score, rate competitiveness, and availability signals into a single health score with trend history. **Rate Parity** (`/dashboard/rate-parity`) Compares the property's published rates across all OTA channels and the hotel's own website. Surfaces parity violations where a channel is undercut and displays an overall parity score. **Rate Intelligence** (`/dashboard/rate-intelligence`) Rate shop comparison view showing how the property's rates benchmark against the competitive set day-by-day, with historical trend overlays and parity gap analysis. **Competitors** (`/dashboard/competitors`) Competitor property list management. Add, edit, or remove hotels from the competitive set used for rate shopping, ORI scoring, and benchmarking. **Benchmark** (`/dashboard/insights/benchmark`) KPI benchmarking of the property against the configured competitive set: ADR, RevPAR, occupancy rate, and review score comparisons over configurable date ranges. **Hotel Market Benchmark** (`/dashboard/insights/hotel-market-benchmark`) Broader market benchmarking pulling aggregate data from multiple sources to position the property within its city's overall hotel market performance. **Hotel Insight 360** (`/dashboard/insights/360`) Unified 360-degree property performance view combining PMS data, demand scores, competitor rates, reputation scores, and market trends on a single screen. **OTA Extranet Analytics** (`/dashboard/insights/ota-extranet`) Analytics derived from OTA extranet data (Booking.com metrics, visibility scores, conversion rates) to help managers optimise their online distribution strategy. **Review Management** (`/dashboard/insights/reviews`) Aggregated guest review feed across OTA platforms with sentiment tagging, score trends, and response tracking. **Sentiment Analysis** (`/dashboard/insights/sentiment`) AI-powered sentiment analysis of guest reviews. Identifies recurring positive and negative themes to surface operational improvement opportunities. **SEO Health** (`/dashboard/seo`) Booking.com listing SEO health audit — keyword coverage, title and description quality, image count, and completeness score with actionable recommendations. ### AI Tools **Content Creator** (`/dashboard/ai/content-creator`) AI-assisted content generation for hotel descriptions, room copy, and marketing materials. Uses Gemini AI with property context to produce channel-ready text. **SEO Specialist** (`/dashboard/ai/seo-specialist`) AI-powered SEO advisor that analyses the property's Booking.com listing and recommends keyword-optimised copy updates to improve search visibility. ### Tourism Intelligence **Chinese Outbound** (`/admin/system-source/china-outbound`) MCT (Ministry of Culture and Tourism) and CTA (China Tourism Academy) historical outbound data (2015–2026-Q1) with cross-reference validation against JNTO/KTO/STB/HKTB inbound records. **Western Outbound** (`/admin/system-source/western-outbound`) Historical outbound travel data for USA (NTTO/ITA), UK (ONS Travelpac), Australia (TRA), France (DGE), and Germany (Destatis/DRV), 2015–2026-Q1. Three-tab dashboard: destination trends, ranked destinations, cross-reference validation. Tables: `western_outbound_stats`, `western_outbound_rankings`. **Visitor Insights** (`/dashboard/insights/visitor-insights`) Integration with official tourism statistics APIs from Hong Kong (HKTB), Japan (JNTO), Korea (KTO), and Singapore (STB) tourism boards, with AI-powered inbound arrival predictions. **Tokyo Lodging Supply** (`/admin/system-source/tokyo-lodging-supply`) Ward-level hotel facility and room counts synced from Tokyo Health Bureau data. **Real Estate Indicators** (`/admin/system-source/real-estate`) Residential Property Price Index (RPPI) and Housing Starts from MLIT and e-Stat. **CPI Rent Index** (`/admin/system-source/cpi-rent`) Monthly rent price index by city-size group and region from Japan's Statistics Bureau via e-Stat API. **e-Stat Accommodation / MLIT** (`/admin/system-source/estat`) Overnight stays and room usage by facility type from MLIT Excel files; e-Stat accommodation statistics for Japan. ### Integrations & PMS **PMS Integration** (`/dashboard/integrations/pms`) Pulls live reservation, occupancy, and revenue data from Cloudbeds PMS via OAuth. Sync cadence is configurable. **AirHost** (`/dashboard/integrations/airhost`) Pulls reservation data from AirHost PMS. Modular connector; can be enabled/disabled per hotel. **Channel Adjustments** (`/dashboard/channel-adjustments`) Configures per-channel markup percentages. Centralised channel definitions determine how rates are pushed to each OTA. ### Alerts **Alert Feed** (`/dashboard/alerts`) In-app feed of anomaly alerts with severity filters (info / warning / critical). Users can dismiss or mark alerts as reviewed. Sidebar badge shows unread count. Configurable thresholds for the anomaly detection engine: occupancy vs baseline delta, pickup velocity delta, and competitor rate movement thresholds. ### Configuration **Property Config** (`/dashboard/config/property`) Hotel-level settings: total room count, property type, target occupancy, algorithm parameters (min/max rates, booking window strategy). **Algorithm Settings** (`/dashboard/config/algorithm`) Configurable AI rate algorithm parameters: target occupancy %, minimum rate, maximum rate, booking window strategy. --- ## Admin Panel ### Core Admin Pages **Admin Home** (`/admin`) Platform administration overview — quick links to all admin sub-sections. **Users** (`/admin/users`) User management, hotel assignments, and module access control per hotel. Admins assign hotels to users and enable or disable platform modules per property. **Site Config** (`/admin/site-config`) Global platform settings and base URL configuration. **Cities** (`/admin/cities`) City-based provider management and data source configuration. **Data Sources** (`/admin/data-sources`) Configurable data source categories and external integration providers. **Database** (`/admin/database`) Export and import database tables; universal data upload page for bulk ingestion. **API Usage** (`/admin/api-usage`) Centralised API call logging and usage monitoring dashboard for all external integrations. **Browse.ai** (`/admin/browseai`) Browse.ai scheduled background monitoring configuration for automated rate tracking. **Rate Shopping Admin** (`/admin/rate-shopping`) OTA rate shop proxy health, batch tracking, and scraping configuration. **Currency** (`/admin/currency`) SGD-based exchange rate tracking versus currencies of configured cities with historical charting. **Data Summary** (`/admin/data-summary`) Sync logs and data licensing overview for all connected data sources. **Product Fetch Logs** (`/admin/product-fetch-logs`) Playwright and ScrapingBee extraction logs and failure tracking for product analysis scraping. **Hotel Management** (`/admin/config/hotel-management`) Enable or disable platform modules per hotel (e.g. turn off Airbnb intelligence for properties in non-Tokyo markets). **Channel Management** (`/admin/channels`) Centralised channel definitions and per-channel markup percentages. Determines how rates are pushed to each OTA or distribution channel. **Data Integration Home** (`/admin/data-integration`) Overview hub for all external data integrations — quick status cards for each connected source with links to detailed configuration pages. ### Property Data (/admin/data/*) **Occupancy** (`/admin/data/occupancy`) Historical and forward occupancy data ingested from the PMS. Displays daily and monthly occupancy trends with variance against the same period in prior years. **Reservations** (`/admin/data/reservations`) Full reservation list from the connected PMS with filters for date range, room type, channel, and status. Each row links to the reservation detail page. **Rate Logs** (`/admin/data/rate-logs`) Audit log of every rate pushed or updated in the PMS, showing the date, rate value, channel, and triggering event (AI acceptance, manual change, etc.). **Rate Diagnostics** (`/admin/data/rate-diagnostics`) Diagnostic view for troubleshooting rate discrepancies — compares the published rate against the PMS rate, OTA listed rate, and AI-suggested rate with a diff view. **Room Type Diagnostics** (`/admin/data/room-type-diagnostics`) Room type mapping health check — verifies that PMS room type codes match the platform's configured room types and flags any unmapped or mismatched codes. ### Admin Reports (/admin/reports/*) **Ward Supply & Demand Report** (`/admin/reports/ward-supply-demand`) Tokyo ward-level report cross-referencing hotel room supply (from Tokyo Health Bureau) against inbound visitor demand (JNTO/STB) to identify supply-demand imbalances by district. **Long-Stay Demand Report** (`/admin/reports/long-stay-demand`) Analysis of extended-stay demand patterns (7+ nights) combining PMS length-of-stay data with market signals to identify corporate and long-stay traveller segments. ### City Data Management (/admin/data-city/*) **Events Data** (`/admin/data-city/events`) Manage and upload local event records by city for demand scoring. **Holidays Data** (`/admin/data-city/holidays`) Manage public holiday data by country and city for demand scoring. **Weather Data** (`/admin/data-city/weather`) View and manage weather records used in demand analysis. **Flights Data** (`/admin/data-city/flights`) Manage airline capacity and flight schedule records by city. **Flights Table** (`/admin/data-city/flights-table`) Tabular explorer for flight data records with filtering. **Visitor Arrivals Data** (`/admin/data-city/visitor-arrivals`) Upload and manage raw inbound visitor arrival records by city. ### System Source Integrations (/admin/system-source/*) **Holidays Integration** (`/admin/system-source/holidays`) Nager.Date public holiday integration — sync and manage holiday data for configured countries. **Flights Integration** (`/admin/system-source/flights`) AviationStack flight data integration — sync airline capacity and schedule data. **Events Integration** (`/admin/system-source/events`) PredictHQ demand intelligence integration — sync local events for configured cities. **STB Integration** (`/admin/system-source/stb`) Singapore Tourism Board inbound arrival statistics integration. **HKTB Integration** (`/admin/system-source/hktb`) Hong Kong Tourism Board inbound visitor arrival statistics integration. **JNTO Integration** (`/admin/system-source/jnto`) Japan National Tourism Organization inbound visitor statistics integration. **KTO Integration** (`/admin/system-source/kto`) Korea Tourism Organization inbound visitor arrival statistics integration. **China Outbound** (`/admin/system-source/china-outbound`) MCT/CTA Chinese outbound travel intelligence (2015–2026-Q1) with cross-reference validation. **Western Outbound** (`/admin/system-source/western-outbound`) Western source-market outbound travel data — USA, UK, Australia, France, Germany (2015–2026-Q1). **Short-Term Rentals** (`/admin/system-source/short-term-rentals`) Inside Airbnb quarterly Tokyo listing snapshots aggregated by neighbourhood and room type. **CPI Rent Index** (`/admin/system-source/cpi-rent`) Japan CPI rent index by city-size group and region from Statistics Bureau via e-Stat API. **Real Estate Indicators** (`/admin/system-source/real-estate`) Residential Property Price Index (RPPI) and Housing Starts from MLIT and e-Stat. **e-Stat Accommodation** (`/admin/system-source/estat`) e-Stat / MLIT overnight stays, accommodation statistics, and facility type breakdown for Japan. **Tokyo Lodging Supply** (`/admin/system-source/tokyo-lodging-supply`) Tokyo Health Bureau ward-level hotel facility and room count supply data. **SEA Tourism Integration** (`/admin/system-source/sea`) Southeast Asia inbound tourism statistics hub covering Thailand, Indonesia, Vietnam, Malaysia, the Philippines, and Singapore. Each country has a dedicated sub-page with arrivals data, source-market breakdown, and year-over-year trends. **Singapore ICA** (`/admin/system-source/sg-ica`) Singapore Immigration and Checkpoints Authority inbound arrival statistics integration — monthly visitor counts by nationality and entry point. **Japan MOJ** (`/admin/system-source/japan-moj`) Japan Ministry of Justice inbound foreign national entry statistics — monthly arrivals by nationality, used to cross-reference JNTO tourism numbers. **Tokyo Tourism Data Catalog** (`/admin/system-source/tokyo-tourism`) Tokyo Metropolitan Government tourism data catalog integration — accommodation occupancy, average length of stay, and revenue statistics for Tokyo wards. **Tokyo Ward Visitors** (`/admin/system-source/tokyo-ward-visitors`) Ward-level inbound visitor counts for Tokyo sourced from the Tokyo Metropolitan Government, displayed as a choropleth map and data table. **Tokyo Visitor Table** (`/admin/system-source/tokyo-visitor-table`) Tabular explorer for the raw Tokyo ward-level visitor data with filters by ward, nationality, and date range. **Tokyo Kunibetsu (Country-by-Country)** (`/admin/system-source/tokyo-kunibetsu`) Country-by-country breakdown of inbound visitors to Tokyo from JNTO/Tokyo metropolitan data — shows which source markets drive Tokyo tourism and their year-over-year growth rates. **JNTO Statistics** (`/admin/system-source/jnto-statistics`) Detailed JNTO inbound visitor statistics explorer with monthly breakdowns by nationality, purpose of visit, and prefecture — supplementing the main JNTO integration with deeper drill-down capability. **APAC Outbound** (`/admin/system-source/apac-outbound`) Asia-Pacific source-market outbound travel data covering key feeder markets (Australia, India, and other APAC economies) with historical trends and destination rankings. **Real Estate Transactions** (`/admin/system-source/real-estate-transactions`) Japan real estate transaction data from MLIT — land and building sale prices by prefecture and district, used as a proxy for local economic vitality in demand modelling. --- ## AI Features ### Composite Demand Score The demand score (0–100 %) is computed server-side for each future stay date from weighted factors: | Factor | Weight | |---|---| | Search trends (Google Hotels / SerpAPI) | High | | Sold-out levels in the competitive set | High | | Airline capacity to destination | Medium | | Local events (PredictHQ attendance score) | Medium | | Public holidays (proximity and country relevance) | Medium | | Rate index (property rate vs market average) | Low | Scores map to demand levels: **Very High** (≥80), **High** (60–79), **Medium** (40–59), **Low** (20–39), **Very Low** (<20). ### AI Rate Suggestions For each future date the platform computes a suggested rate by applying demand-score multipliers to the property's base rate, constrained by the configured min/max rate band. The suggestion pipeline: 1. Fetch composite demand score for the date 2. Apply occupancy-adjusted pricing curve 3. Clip to [min_rate, max_rate] from algorithm settings 4. Store suggestion in `ai_rate_suggestions` table 5. Surface in the AI Suggestions dashboard for manager review ### Gemini AI Advisor An in-dashboard chat widget lets managers ask free-form revenue questions. The advisor receives: - Current demand scores for the next 30 days - Recent occupancy and pickup data from the PMS - Any Demand Monitor entries flagged for AI injection - Hotel configuration (city, property type, room count) The advisor responds with specific, data-grounded recommendations rather than generic advice. ### Gemini AI Data Extraction The platform uses Gemini AI for structured data extraction in several pipelines: - Parsing uploaded Excel / PDF files from tourism authorities - Extracting room product details from Booking.com when ScrapingBee returns unstructured HTML - Generating natural-language narration for scheduled forecast reports - Running the flight data quality control agent ### Anomaly Detection Engine A server-side detection service runs every 6 hours and compares: - Current occupancy vs rolling baseline (same weekday, prior 4 weeks) - Pickup velocity delta (bookings in last 24 h vs 7-day average) - Competitor rate movements exceeding the configured threshold Triggered alerts are stored in `alert_events` with severity (info / warning / critical). Optional email notifications via nodemailer require SMTP credentials. --- ## Data Model Overview Key database tables (PostgreSQL via Drizzle ORM): | Table | Purpose | |---|---| | `hotels` | Multi-tenant hotel registry | | `users` | Platform users with role assignments | | `hotel_users` | Many-to-many: users ↔ hotels | | `site_config` | Global platform configuration | | `reservations` | PMS-synced reservation records | | `ai_rate_suggestions` | AI-generated rate per stay date | | `rate_decisions` | Manager accept / change / ignore decisions | | `demand_scores` | Composite demand score per hotel per date | | `competitor_rates` | Rate shop snapshots per competitor | | `rate_shop_batches` | Traceability log for each rate sync run | | `alert_events` | Fired anomaly alerts with severity | | `alert_configs` | Per-hotel anomaly thresholds | | `report_configs` | Scheduled report configurations | | `report_logs` | Delivery history for forecast reports | | `flight_data` | Raw multi-source flight records | | `airline_capacity` | Unified pipeline output of airline capacity | | `events` | Local events from PredictHQ | | `blog_posts` | CMS-managed blog articles | | `western_outbound_stats` | Western source market outbound travel stats | | `western_outbound_rankings` | Ranked destination data for western markets | | `api_usage_logs` | External API call audit trail | --- ## REST API Endpoints (Selected) All API routes are served from the same origin under `/api/`. Authenticated routes require a valid session cookie. Admin routes additionally require the admin role. ### Demand & Rates ``` GET /api/demand-scores?hotelId=&from=&to= Composite demand scores for a date range GET /api/ai-suggestions?hotelId= AI rate suggestions (upcoming dates) POST /api/rate-decisions Record a manager rate decision GET /api/rate-decisions?hotelId=&from=&to= Rate decision history (audit log) GET /api/rate-decisions/export?hotelId= Export rate decisions as CSV ``` ### Hotels & Configuration ``` GET /api/hotels List hotels accessible to the current user GET /api/hotels/:id Hotel detail and configuration PUT /api/hotels/:id/config Update hotel configuration GET /api/algorithm-settings/:hotelId AI algorithm parameters PUT /api/algorithm-settings/:hotelId Update AI algorithm parameters ``` ### Analytics ``` GET /api/analytics/pickup?hotelId=&date= Pickup curve for an arrival date GET /api/analytics/dow?hotelId=&from=&to= Day-of-week performance breakdown GET /api/analytics/room-types?hotelId= Room type occupancy and revenue GET /api/analytics/cancellations?hotelId= Cancellation revenue impact ``` ### Competitor Intelligence ``` GET /api/rate-shop?hotelId= Latest competitor rate snapshots POST /api/rate-shop/sync Trigger a new rate shop sync GET /api/rate-shop/batches?hotelId= Rate shop sync batch history GET /api/ori?hotelId= Online Reputation Index scores ``` ### Data Sources ``` GET /api/flights?hotelId= Flight capacity data POST /api/flights/sync Trigger flight data sync GET /api/events?hotelId=&from=&to= Local events in date range GET /api/weather?city= Current weather for a city GET /api/holidays?country=&year= Public holidays for a country/year GET /api/currency?base=SGD&targets= Exchange rates ``` ### Alerts ``` GET /api/alerts?hotelId= Alert feed (unread first) POST /api/alerts/:id/dismiss Dismiss an alert POST /api/alerts/:id/review Mark an alert as reviewed GET /api/alert-configs/:hotelId Alert thresholds PUT /api/alert-configs/:hotelId Update alert thresholds ``` ### Admin ``` GET /api/admin/users All platform users (admin only) POST /api/admin/users/:id/hotels Assign a hotel to a user GET /api/admin/api-usage External API call log GET /api/site-config Global site configuration PUT /api/site-config Update site configuration ``` ### Forecast Reports ``` GET /api/report-configs?hotelId= Scheduled report configurations POST /api/report-configs Create a report schedule PUT /api/report-configs/:id Update a report schedule POST /api/report-configs/:id/send Send a report immediately GET /api/report-logs?hotelId= Report delivery history ``` --- ## External Integrations | Service | Purpose | |---|---| | **Cloudbeds** | PMS — reservations, occupancy, revenue | | **AirHost** | PMS — reservations | | **AviationStack** | Live and scheduled flight data | | **PredictHQ** | Local event intelligence | | **SerpAPI** | Google Hotels pricing and Google Trends | | **Makcorps** | OTA competitor rate shopping | | **ScrapingBee** | Booking.com structured data extraction | | **Browse.ai** | Scheduled background rate monitoring | | **Nager.Date** | Public holiday data (free API) | | **Gemini AI** | Rate narration, chat advisor, data extraction, QC | | **HKTB** | Hong Kong Tourism Board statistics | | **JNTO** | Japan National Tourism Organization statistics | | **KTO** | Korea Tourism Organization statistics | | **e-Stat / MLIT** | Japan Statistics Bureau and Ministry of Land | | **Inside Airbnb** | Short-term rental supply snapshots | --- ## Machine-Readable Resources - [llms.txt](https://hotelinsight.ai/llms.txt): AI agent crawl index - [llms-full.txt](https://hotelinsight.ai/llms-full.txt): This document — full platform documentation - [Sitemap](https://hotelinsight.ai/sitemap.xml): Full XML sitemap - [Blog Sitemap](https://hotelinsight.ai/blog-sitemap.xml): Blog posts XML sitemap - [RSS Feed](https://hotelinsight.ai/feed.xml): Blog RSS feed