Blog

How to automate rate and demand reports across your hotel portfolio

Before every revenue call, someone on your team makes the same manual report.

Italian version

Know which dates need attention

A typical event report requires several pieces of data.

You check competitor rates, review changes, look at the events calendar, compare pickup and examine early demand indicators. Then, you export the findings and compile them in a spreadsheet or presentation.

With Ernest, you can ask for the complete analysis.

For example, just ask: “Which event dates across the portfolio show the strongest change in competitor pricing, forward demand and pickup over the next two weeks?”

You receive an answer grounded in the Lighthouse data made available through your plans and permissions.

Each figure links back to its underlying source, so your team can validate the analysis before it informs a pricing decision or appears in front of senior management, ownership or an asset manager.

The result is a clear starting point for action, focused on the hotels and dates that need a review.

You can see:

  • Which hotels may be underpriced before a compression period

  • Which event dates are experiencing higher demand faster than expected

  • Which properties have not responded to a market move

  • Which rate changes deserve validation

  • Where a closer review is justified before the revenue call

See how the market is moving

A rate shop tells you where competitors are priced today. It doesn’t always show how quickly the market has moved, or who changed first.

Ahead of an event, that history can be useful. You may find that several competitors have raised rates over the past week while one of your hotels has remained unchanged. Or, a competitor increases rates as a single move and you mistake it for a wider market shift.

Looking at rate changes over time gives your team more context before adjusting price. It helps them judge whether the market is genuinely strengthening, whether the hotel is falling behind and whether the current strategy is still appropriate.

Competitor pricing is only one part of that decision. Pickup, availability, room type, business mix and restrictions still need to be considered.

By highlighting the properties and dates where pricing has changed most, Ernest helps teams decide where a closer review is needed.

Act before demand reaches the books

Pickup shows how bookings for a future date have changed between two points in time. It's one of the main signals a revenue team uses, but it only tells you about demand that has already converted.

Forward-looking demand signals provide an earlier indication.

A hotel may still have limited business on the books while destination search activity, flight interest or market pricing begins to increase. That doesn't prove the demand will convert for your property, but it gives the revenue team a reason to investigate. 

With demand signals, event context, market pricing and pickup all in the same conversation, the team has stronger information to revisit strategy.

When several of those indicators begin moving together, the questions worth asking follow naturally: whether the date is likely to compress, whether current rates still hold and which properties are most exposed to underpricing before the next call.

Ernest also watches for these patterns on his own, scanning the next 90 days for material pricing opportunities and risks. When something requires attention, you can review the supporting Lighthouse data before deciding what to do.

Standardize reporting across the portfolio

For a large hotel group, automation is about more than saving time. It also helps teams report performance in a consistent way.

Without a shared process, properties and clusters may use different pickup windows, comparison periods, compset views or report structures. Senior leaders need to spend time reconciling reports before they can discuss performance.

With Ernest, one report structure runs across the portfolio and every team can work from the same definitions. You only need to set the metrics, comparison periods, property groups and output format once. Portfolio leaders can receive a group-level view. Cluster and property teams can receive reports for the hotels they manage. Each report uses the same underlying data and reporting logic.

That makes it easier to compare performance and answer practical questions:

  • Which hotels need support?

  • Which markets are moving faster than the portfolio?

  • Where is pricing discipline inconsistent?

  • Which issues can wait?

Your revenue call begins with important decisions instead of debating the numbers.

Set the report to run automatically

A routine is a recurring report that Ernest builds and sends on a schedule. You choose:

  • What the report includes

  • Which properties it covers

  • How often it runs

  • Who receives it

  • Which available output format it uses

You can also upload a report or presentation your team already uses and Ernest will follow that structure.

A weekly routine may support the regular revenue call. Before a major event, the same analysis can run more frequently so the team can follow changes in market rates, demand and pickup more closely.

Ernest’s reporting logic can also support different levels of the organization.

A portfolio director may need the full group view. A cluster revenue leader may need exceptions across a smaller set of hotels. A general manager may need a concise summary for one property.

Ernest sends each person the level of detail they need, while the underlying definitions remain consistent.

Start the revenue call with the decision

Automating reports doesn’t automate decisions.

Your revenue team still decides how to respond. Your day is different because discussions can start with a sourced, consistent view of what changed, which properties need attention and where action may be required. When every figure links to its source, reports can be easily checked before use in a revenue call or shared with senior stakeholders.

One weekly report may not take long to build. The time savings become clear when the same process is repeated across dozens of hotels, clusters and reporting periods. That's a lot of manual reporting for professionals whose time is better spent reviewing strategy, supporting hotels and acting on opportunities. 

Automating the reporting process also reduces the need to reconcile different spreadsheets and report formats. The result is a more consistent view of the portfolio, less time spent assembling data and more time spent deciding what to do with it.

Ernest is rolling out to Lighthouse customers. Join the wait list to be one of the first teams to automate rate, demand and event reporting across your portfolio.

FAQs

What is Ernest?

Ernest is Lighthouse's AI teammate for hotel commercial teams. He works on top of the Lighthouse platform, so you can ask questions in plain language, get answers traced back to the underlying data, and automate the reports your team builds by hand. He is built for hospitality rather than adapted from a general-purpose model.

Does Ernest replace revenue managers?

No. Ernest handles the scanning, data gathering and report assembly that eat into the day. The commercial decisions, pricing an event and judging how far to move on rate, stay with your team. He surfaces what changed and shows the reasoning behind it, and the call is still theirs.

What data does Ernest need to build these reports?

Ernest works from the Lighthouse data you already have, within your plans and permissions. He draws on rates, demand and calendar data from Lighthouse Pricing, and pickup, benchmarking and portfolio data from Lighthouse Performance. The more of the platform you use, the more he can bring into a single report. Ernest requires Lighthouse Performance.

Is my data safe with Ernest?

Yes. Your commercial data stays scoped to your environment, is never shared with other customers and is never used to train shared AI models. Ernest reads anonymized, market-level intelligence from the wider Lighthouse network, but your own rates, occupancy and strategy stay private. Ernest runs on Lighthouse's existing ISO 27001-certified infrastructure.

How do I get access to Ernest?

Ernest is rolling out to Lighthouse customers through an early access program and is not generally available yet.

Join the waitlist and the team will be in touch as access opens up.

Loading author...