Skip to content
Case study - Web app

Meta Gap Analysis: where a hotel group loses direct bookings, and why.

A daily command centre that turns six data feeds into revenue-leakage dashboards, AI action plans and automated reports across 47+ hotels and 8 OTAs.

Meta Gap Analysis command centre and geo map on a desktop monitor and a tablet
Client
MetaHotels
Industry
Hospitality - hotel revenue management
Platform
Secure web app (desktop and tablet)
What we did
Product design, Full-stack development, Data engineering, Cloud & AI integration
  • 47+Hotels on one source of truth
  • 8OTAs tracked for rate parity
  • 6Daily data feeds ingested automatically
  • ~5 msReview trend queries, down from ~406 ms
Overview

The client

When a hotel’s room shows up cheaper on Booking.com or Expedia than on the hotel’s own website, guests book through the online travel agency (OTA) and the hotel pays commission on a booking it could have taken directly. Across dozens of properties, these rate parity gaps add up to significant lost revenue.

MetaHotels already collected the raw data - daily rate-shopping exports, price-match widget logs, booking-funnel events, Google Hotel Ads parity checks and guest review snapshots - but it arrived as large CSV files in cloud storage that nobody could act on at that scale.

KloudBoy designed and built Meta Gap Analysis (internally Magic Parity), a rate parity intelligence platform. It ingests every feed automatically each day, turns raw rows into revenue-leakage metrics and presents them in focused dashboards for leadership and hotel managers.

The challenge

Where they started

Revenue managers needed four answers, quickly, across every property.

Where are we losing?

Which hotels, which OTAs, which countries and which devices.

How much is it costing?

Revenue leakage in the group’s own currency, not just parity percentages.

Why is it happening?

Which pattern is behind each loss: mobile-only disparity, lead time, geo pricing, stay dates or OTA undercutting.

What should we do today?

A clear next step for each hotel, delivered to the people responsible.

The solution

What we built

A daily data pipeline feeding focused dashboards, AI action plans and automated reports.

01

Automated daily data pipeline

  • Six feeds from Azure

    Pulls website parity, price-match reports, guest funnel, hotel services, Google Hotel Ads parity and guest reviews from Azure Blob Storage every day.

  • Safe ingestion

    Validates file pairs, matches each row to the right hotel, skips duplicates safely and keeps a full audit log of every ingestion batch.

  • One currency

    Converts every price into a common currency at ingestion, using exchange rates synced nightly.

  • Self-service admin

    Admins can re-run, backfill, download per-hotel data or clean up data without developer involvement.

02

Revenue Gap Command Center

The homepage after login. One screen answers "how are we doing right now?"

  • KPI strip

    Estimated revenue lost, lost bookings and parity rates at a glance.

  • Beat / Meet / Lose

    Is the direct price cheaper than, equal to or higher than the OTA’s? Plus revenue lost over time, the root causes behind losses, and the top leaking countries and devices.

  • Yesterday’s snapshot

    The biggest loss, the top offending OTA, alerts and recommended actions. Each card switches independently between Website and Google Hotel Ads data.

03

Deep-dive and strategy analytics

  • Seven Revenue Gap views

    Parity Overview, Top Offenders, Geo Analysis on an interactive world map, Device Analysis, Date & Demand, Traveller Behaviour heatmaps and a Disparity Explorer with evidence screenshots, each for both Website and Google Hotel Ads parity.

  • Beat Meet Lose dashboard

    Period-over-period deltas, trend lines and breakdowns by channel, device and country, each with its revenue impact.

  • Lose Rate & Demand

    Lose rate set against demand, to separate harmless losses from costly ones.

04

Price Match Magic, booking funnel and market demand

  • Price Match Magic

    Analytics for the hotel’s on-site price-match widget: match success rate, discount levels by OTA, discount risk bands, matches against conversions, and a searchable log with side-by-side screenshots of the OTA price and the hotel’s own price.

  • Booking funnel

    Tracks guest sessions from the booking engine to checkout to a confirmed booking, with drop-off at each step, conversion rate per hotel and daily trends.

  • Market demand

    Upload and preview of Amadeus market occupancy forecasts per city, charted against a forward window, so revenue teams see demand coming before it arrives.

05

Review Gap Analysis

Six pages built on guest review data.

  • Scores and sources

    Overall and category scores, per-source ratings (Google, TripAdvisor, OTAs), topic sentiment and trends.

  • Insights in plain English

    A rules-based insight engine explains each chart: what to fix first, what is slipping and what is worth marketing.

  • Anomaly flags

    Data anomalies are flagged, so a change in data sources is never mistaken for a real change in guest sentiment.

06

AI suggestions and automated reporting

  • A per-hotel decision engine

    Pick one hotel and a date range, and the platform assembles its parity, price-match, funnel and review data into one context and streams prioritised, practical actions across Pricing & Parity, Direct Booking, SEO, Paid Ads and Reputation - each with an impact and effort rating and a way to measure success.

  • Daily email reports

    HTML email reports to hotel managers every day, with a delivery log, plus on-demand reports for any hotel.

  • One-click PDF export

    Any dashboard page, with its current filters, in a print-ready layout. AI results can be copied, downloaded or exported to PDF too.

07

Engineering highlights

  • Built for daily data growth

    Indexes and queries were tuned against measurements from the live database rather than assumptions: review trend queries went from ~406 ms to ~5 ms, and booking-funnel queries were cut by nearly half.

  • Two-layer caching

    Redis caches expensive metrics across requests and clears automatically after each ingestion. If Redis is unavailable, requests fall back to the database without errors.

  • Security

    Role-based access with hotel-level data scoping on every API, reCAPTCHA v3, per-IP rate limiting, account lockout after repeated failures, CSRF origin checks and short-lived sessions that log out automatically.

  • Configurable without code

    SMTP, thresholds, branding colours, AI settings and email schedules live in the database and are managed from an admin console. Users pick their own Beat / Meet / Lose colours and a light or dark theme.

  • Incremental releases

    The platform grew from v1 to v4.4 through additive database migrations, with no historical data lost along the way.

The result

Inside the platform

Screens from the live Meta Gap Analysis app. Hotel names, people and every rate are blurred to protect the client's data.

Revenue Gap Command Center: revenue lost, lose rate, Beat / Meet / Lose and the top issues
Revenue Gap Command Center: revenue lost, lose rate, Beat / Meet / Lose and the top issues
Geo Analysis: revenue loss by shopper country on an interactive world map
Geo Analysis: revenue loss by shopper country on an interactive world map
Traveller Behaviour: when OTAs undercut the direct rate, by day and hour
Traveller Behaviour: when OTAs undercut the direct rate, by day and hour
Price Match Magic: match success, discounts by OTA and recent matches
Price Match Magic: match success, discounts by OTA and recent matches
Review Gap Analysis: headline scores and the rating trend
Review Gap Analysis: headline scores and the rating trend
Impact

Before and after

AreaBefore KloudBoyWith KloudBoy
Rate parity viewBeforeManual review of raw CSV exportsAfterOne source of truth across 47+ hotels and 8 OTAs
Revenue leakageBeforeRaw rows nobody could act on at scaleAfterLeakage quantified in money, not only percentages, so teams prioritise the costliest hotels and channels
From data to actionBeforeNo clear next step for each hotelAfterAI action plans, plain-English chart explanations and daily emails to the people responsible
OperationsBeforeLarge CSV files landing in cloud storage every dayAfterData arrives, is processed, cached and reported every day without manual work
Query speedBefore~406 ms review trend queriesAfter~5 ms, with booking-funnel queries cut by nearly half
Our role

From raw data to daily action

KloudBoy delivered Meta Gap Analysis for MetaHotels across product design, full-stack web development, data engineering, cloud integration and AI integration.

The platform replaced manual review of raw exports with one source of truth, and every insight now leads to a next step: AI action plans, plain-English chart explanations and daily emails to the people responsible. Data arrives, gets processed, cached and reported every day, and admins have self-service tools for the exceptions.

Technology

Platform & tools

  • Next.js 16
  • React 19
  • TypeScript
  • Tailwind CSS
  • shadcn/ui
  • Recharts
  • D3-geo
  • Prisma
  • PostgreSQL
  • Redis
  • Azure Blob Storage
  • NextAuth.js
  • OpenAI GPT-4o
  • React Email
  • Headless Chrome PDF
Services used

Need the same?

Next case study

Kerala Spices Online

Kerala Spices Online storefront on a laptop and a phone
D2C e-commerce - spices & exports · Since January 2022

Kerala Spices Online

Edge caching, database tuning, security and a full UI/UX and SEO overhaul for a high-SKU WooCommerce spice store, partnered since January 2022.

  • Managed cloud
  • Performance
  • WooCommerce engineering
  • UI/UX & SEO
Read the case study

Sitting on data you cannot act on?

Tell us about your data feeds and the decisions they should drive. An engineer, not a salesperson, will reply.