report with weekly/monthly occupancy by room type
1 Comment
hi - this is still a pretty major hole in the reporting functionality... there is currently no way to pull monthly occupancy data other than running a comparison report again and again for every single month.
please think about updating the reporting suite - it's a big opportunity for improvement and the fact that basic reports like this have been missing for years is frustrating. it shouldn't be so hard to just pull monthly occupancy - it really doesn't get much more basic than this.
1 person likes this idea
we would like a report that very simply shows occupancy by room type by week or by month. similar to what shows up on the dashboard (today's occupancy, tomorrow's occupancy, occupancy for the month, occupancy for the year). we'd just like to have quick access to more of that kind of data into the future.
this type of data is very helpful when deciding how to adjust prices throughout the season. this year we filled up more quickly than we expected to for april and, had we known this earlier, could have increased prices to take advantage of the demand. conversely, if we are coming up on a period that is not selling well, we may want to reduce prices or put certain room types on sale for those dates.
i can get to this data by running daily production, exporting to csv, importing to google sheets, manually changing the dates to put all the months together, and creating a pivot table that organizes the data by room type and then calculates occupancy.
but this data is too important and needed too frequently to repeat this cumbersome process on a regular basis.. please give us access to these critical business health metrics.