Revenue managers and GMs: how do you go from numbers to insights and decisions?

UPDATE: Thanks to everyone for the enthusiasm. For now we have gathered a wide range of customers interview and we are working through the insights and learnings we got from the calls.

We will be sure to come back once we have some prototypes to share and get your feedback!

Hi Mews Community :waving_hand:

We’re trying to understand how hoteliers get from raw numbers to the handful of things that actually matter each day, and whether that journey is harder than it should be.

If you run some kind of (morning) routine with occupancy, pickup, booking, or segment numbers, whether that lives in Mews, in a BI tool, or in your own Excel setup, I’d love to grab 30 minutes to understand how you’ve got it set up, how you actually look at the data, and how you get from the numbers to a decision. Not the ideal version, just what you actually do.

There’s nothing to prepare for. I may ask you to share screen and talk through how you work, what you typically look at, and then ask about a few recent examples.

If you’re up for it, fill in this short form* and I’ll be in touch to schedule a time with you.

Thank you!

Sylvia

5 Likes

​@sylvia.tang done!

1 Like

​@sylvia.tang
such an important topic!
Form is filled :slight_smile:

1 Like

Hi Silvia, I’ve completed and submitted the form. In the event the final question does not return the full character count because of its length, here is what I wrote answering the final question.

I copy data from the Availability & occupancy report, specifically the arrivals, departures, stayovers, customers, and out of order rooms, and drop them into what has become a quite large Excel workbook with many worksheets serving different purposes.

These worksheets are connected by formulas in specific cells to avoid having to copy the data into multiple worksheets. Within each worksheet depending on its purpose, data is then calculated through formulas that multiple, divide, add, or subtract to derive new data.

Worksheets include historical data pulls from years past; monthly rate calculations that when paired with data extracted from Expedia is used to determine optimal rate changes (up or down) as well as determine the cost of promotional offers being run through different channels; draft schedules for our key Hotel departments including the Front Desk and Housekeeping which are then manually copied into Square, the digital resource used by our company for tracking schedules and time cards upstairs in our Hotel, but also purchases in our ground floor venues that are not connected with Mews; and several other worksheets that influence or drive decisions about our operation.

The biggest challenge in the current version of Mews is that it is not possible to set the formatting of an export, even a scheduled and recurring export, but instead, the formatting is all the same and includes a plethora of data that is irrelevant to the purpose of creating the export. Filters and sorting methods have recently been added to onscreen displays of data, but even these are not saved by Mews. As a result, a simple screen change whether intended or not results in having to reset the filters and sorting.

i am happy to share visuals with you through screen-sharing during a video call to bring these issues to life. I work Thursdays through Mondays, and generally can take calls/meetings between 10:00 AM and 4:00 PM Eastern Time on these days.

2 Likes

DavidFoxx wrote:

The biggest challenge in the current version of Mews is that it is not possible to set the formatting of an export, even a scheduled and recurring export, but instead, the formatting is all the same and includes a plethora of data that is irrelevant to the purpose of creating the export. Filters and sorting methods have recently been added to onscreen displays of data, but even these are not saved by Mews. As a result, a simple screen change whether intended or not results in having to reset the filters and sorting.

ChatGPT/Codex saves me so much time with the CSV export files from Atomize to create my revenue forecasts. I have my own spreadsheet, not as complicated as yours since it’s focused on the revenue management. The way the CSVs are exported from Atomize make it a nuisance for me to copy the information easily. I import it into ChatGPT, ask it to combine the CSVs in a specific order, and it does it for me quickly.

I wish the exports from Business Intelligence were better as well. I don’t want to know the top ten companies/rates for production, but see all the data and then filter down. The reporting in Mews is one of the few things I don’t like using compared to other PMSes I’m familiar with.

2 Likes

Hi Sylvia

We use Microsoft Power BI for daily data analysis, with the Mews reservation report as the data source. We have also begun using Mews BI. I’d be very happy to have a call and show you.

Many thanks

Sami

1 Like

Thank you everyone, the response and interest here has been awesome! I’ve started reaching out to everyone who’s filled in the form.

​@DavidFoxx and ​@foursides thank you for taking the time to write it all out - that paints a very clear picture.

David - noted on your working hours, looking forward to speaking soon.

Foursides - if you’d be open to showing me your ChatGPT+CSV workflow, I’d love to grab some time to chat - would you mind going through this form so I can follow up?

And if anyone reading this runs a similar routine and would be open to a 30 minute chat with me to pick your brains, please let me know through the form in the original post above! :blush:

Thanks again,

Sylvia

1 Like