Help & Examples

27 questions your hotel data can answer — and how to ask them.

Once your PMS, channel manager and OTA statements are combined into one clean Cleva file, you — or any AI assistant — can ask these questions directly. No dashboards, no spreadsheets, no analyst required.

Revenue

What's my actual net revenue after OTA commissions, by channel?
See what you really keep after Booking.com, Agoda and other OTA fees — not just the headline booking amount.
Which room type earns me the most per night?
Compare revenue per night across room types to see where to focus upselling and pricing.
Which months are my strongest and weakest?
Spot seasonality so you know when to push promotions and when rates can hold firm.
What do I have confirmed on the books for the next 90 days?
See your forward revenue — what's already locked in for the next 3 months.
How does my booking pace compare to this time last year — and what would it take to close the gap?
Know if you're ahead or behind last year, and roughly how many bookings would close the gap.
How many new bookings came in for my upcoming dates in the last 7 days — is pickup speeding up or slowing down?
This is "pickup" — the most-used report in revenue management. A burst of pickup on a date can support raising the rate; a quiet date may need a push.
Is this week's pickup running ahead of or behind the same week last year?
Comparing pickup to last year accounts for seasonality — if you're behind, demand may genuinely be softer this year.

Distribution & Channels

What % of my revenue comes from each OTA vs direct?
See how exposed you are to OTA commissions vs direct bookings.
How much commission am I paying, and to which OTA?
Know the real cost of each distribution channel, in ringgit.
Which channel has the highest cancellation rate?
Find out which OTA brings the least reliable bookings.
When do most bookings happen — what day, what time, and how far ahead of arrival?
Know when guests are actively shopping, so you can time promotions and flash deals.
Are bookings concentrated at the start, middle, or end of the month?
See if guests book in a pattern tied to payday or month-end — useful for timing campaigns.

Guests

Where do my guests come from — top 10 countries?
See which markets to focus on for marketing and ads.
What % of my bookings are from repeat guests?
A simple loyalty score — track it over time to see if guests are coming back.
Do repeat guests spend more than first-time guests?
See if it's worth investing more in keeping guests coming back.
What's the average length of stay, and does it vary by room type?
Know which rooms attract longer stays — useful for housekeeping and pricing.

Operations

How many bookings are stuck in "ghost" status — checked in but never checked out, or never actioned at all?
Catch bookings the front desk forgot to close out — these can throw off your numbers.
How complete is my guest contact data — how many bookings are missing an email or phone number?
Know how many guests you can actually reach for marketing or follow-up.

Marketing & Retargeting

How many guests can I build a retargeting audience from?
See the size of your audience, ready to upload to Facebook or Google.
Which guests haven't stayed in 12+ months — my win-back list?
A ready-made list of lapsed guests worth re-engaging.
How many Booking.com Genius members have stayed with me — can I target them directly to cut commission costs?
Genius bookings cost more in commission — retargeting these guests directly can save you money.
What guest segments show up in my data, and which should I prioritise for ads?
Let AI find natural groupings — repeat guests, long-stayers, international visitors — so you know who to target.
Build me a ready-to-upload audience of guests from Malaysia who stayed in the last 6 months.
Ask your AI assistant this directly — it can filter your file and hand you a list ready to upload.

Reconciliation

How much commission could I potentially recover?
The headline number — money that may already belong to you.
Which bookings are cancelled in our system but still marked active by the OTA?
These are commission charges you can dispute with the OTA.
Are there bookings where the OTA charged a different rate than what we actually received?
Spot rate mismatches that quietly eat into your revenue.
Did I get charged commission on any no-shows?
OTAs sometimes charge full commission on no-shows — this checks if that happened to you.
Beta

Works once you have a Cleva master file.

Forward your PMS and OTA exports to one email address — we'll send back a clean file ready for any AI assistant.

Request early access →