Total Nights Accumulated Metric for Each Guest/Contact with Multiple Bookings (Added to Contacts List Export)

Status: Requested 1 Vote
Lauren S
Feb 20, 2024 10:11 PM
Joined Sep, 2022 1 post

Add a "Total Nights Accumulated" metric to the data captured when the Contacts List is exported.

This will be useful in determining or tracking how many nights each guest has stayed at the STR, no matter how many different times they have stayed. Such a metric will be useful for any loyalty program or rewards program based on number of nights accumulated over multiple bookings.

At the moment, when the Contacts List is exported, it only provides the number of bookings a guest has booked, 
but it does not indicate how many nights - in total - that includes. Other reports, such as Booking Detail, list each booking by the same guest separately (as designed) so one would have to merge those manually. Furthermore, that report does not use a unique identifier to parse the guests other than their name (and the booking #). While most guests don't have the same name, it is possible that some do and their phone number or email should be used as a unique identifier to parse the info instead (as in the Contacts List).

Image below of the current Contacts List export with my suggestion in yellow.

[Future Bonus: Using this metric to create a system for instituting a rewards program, should a host choose to do so. For example, the host can set the parameters such as "Every 10th Night is Free" and a metric will be available that indicates how many free nights have been accumulated, how many have been redeemed, etc.]

Thanks!