Reporting average nights stayed

DISCLAIMER: This article involves Advanced Customizations, which can be technically challenging to get working and is not part of standard support.  This is programming and must be done precisely or the results can be unpredictable.  This information is provided as a service for those who have the technical skills to work through it -- we cannot help you solve any issues with getting it working.  For more information about Advanced Customizations, see the full documentation:

https://campgroundmaster.com/help/overview32.html

Q: Is there a report I can pull for average length of stay?

There isn't a standard report for that, but there are a couple options:

If you run the Occupancy report and the Arrivals statistics report for the same time period, then you can divide the occupancy total (total nights) by the arrivals total (total # stays) to get the average nights per stay.

Or, if you have version 4.0 or later installed, there is a sample Query you can import that does show the average nights per stay.

1. Go to Maintenance / Advanced Customizations / Queries, and click Import query.

2. Locate the folder C:\Program Files (x86)\Campground Master\Samples.  (In the "Look In" drop-down at the top, start by clicking on the C: drive, then double-click the Program Files folder, etc. until you reach the Samples folder.)

Select the file "Sample Query - Average nights per stay, by site type" and Open it.  That will add the query to the list.  Close that dialog, and now you'll see a Query tab, between the Payments Due tab and the Transactions tab.  Click on that, and select the above query from the drop-down list.  Then just put in the date range needed.