Reporting average nights stayed

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\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.