History tracking for pushed spot rates?

Status: Requested 3 Votes
Rich S
Dec 9, 2019 7:32 PM
Joined Dec, 2018 301 posts

Maybe I'm asking for too much here, but would be nice if OR would keep track of every pushed nightly rate/min nights.

For instance, let's say I'm really organized and I push spot rates every monday throughout the winter season. By summer I have pushed rates maybe 20 times for the months of Dec->Apr. For the earliest Dec dates I might have only pushed them 1 or two times, but for the late April dates I might have pushed them 20 times.

Would be nice to have a graphical view for every single day showing how and when the rate changed. This would also be a nice way to check that nothing crazy ever happened to my rates.

I'm thinking of a vertically oriented calendar with one date per row, and next to the given date is a small sparkline type of chart. If the sparkline is flat and then drops by 50% it's obvious that I kept rates high and then cut them in half. Or maybe it would show a few rate reductions. Hovering over the sparkline should show exact values.

Maybe there is an easier way to portray this, haven't given it too much thought. I just like the idea that there is a track record of when spot rates were updated, and how they changed. The fact that some dates will have just a few updates and other might have many complicates this.

In addition, another feature I'd like would be that OR only pushes changes. At the moment everything gets pushed, and it's really hard to identify what I might have changed. If I have a session of 30 minutes where I'm using the rate calendar across multiple units I might have made 30 or more tiny changes/tweaks. But I can't see just those changes in the detail before pushing. Would be nice if OR could recognize which changes were made since the last push, and then just show those in the list. That would make me more confident that I didn't accidentally change dates that I didn't intend to change. And that there are the changes I thought I made. As an example, if I accidentally am looking at the wrong property (easy to do) I could mistakenly change rates, but I'd detect it when I went to push rates if I glanced at the details of each property before pushing any. I'd certainly notice if I thought I'd changed rates for every property but one ended up with no changes.

VacationDaytona
Dec 11, 2019 10:02 AM
Joined Apr, 2019 2 posts

I dont really understand the difference between regular rates and spot rates.
Seems like 1 trumps the other - so not sure which I should change - so I just adjust my regular rates.
I currently adjust rates weekly - but agree it would be nice to download my changes or see a history to see where I started with the rates for the next year.

Rich S
Dec 11, 2019 5:48 PM
Joined Dec, 2018 301 posts

VacationDaytona said:

I dont really understand the difference between regular rates and spot rates.
Seems like 1 trumps the other - so not sure which I should change - so I just adjust my regular rates.
I currently adjust rates weekly - but agree it would be nice to download my changes or see a history to see where I started with the rates for the next year.

I believe that spot rates can be thought of as an override to "regular rates". And spot rates are specific to a given date.

When you look at the Rate Calendar do you see the rates you expect? I would expect that the Rate Calendar will show regular rates in your case. And then if you wanted to modify a few days you could do so directly from the Rate Calendar, and I would *think* that would create a spot rate.

You should always be able to download your rates regardless of whether they are regular or spot rates. Try going to Tools/Import Export and then look for two places where you can Export Rates/Seasons or Export Spot Rates.

Chris Hynes
Dec 13, 2019 8:39 AM
OR Team Member Joined Oct, 2012 1401 posts

Yep, history with some sparklines would be cool to see changes over time. Right now we just track the current rate and don't factor in changes, but something to mull over to see how we can handle it. That can get to be a lot of data records to keep though :D

Rich S said:

I believe that spot rates can be thought of as an override to "regular rates". And spot rates are specific to a given date.

Yep, that's exactly it -- spot rates override seasonal rates. Think of it as spot rates "painting on top" of the seasonal rates. The Tools > Rate Calendar will show whatever rate is currently in effect for the date whether it be a spot rate or seasonal.

If you want to actually change the seasonal rates for the entire period of the season it's easier to update the seasonal rates. If you want to set just a couple nights here and there, using the spot rate is easiest.

Toni LP
Jul 16, 2021 1:44 PM
Joined Nov, 2019 13 posts

yes we have some owners that question us with how much we increases the rates and when...It becomes hard to track the history of when we did that!