Reporting average daily rate

Q: How can I get a report showing the average daily rate collected?

A: There's a sample query that might help, but it has some limitations.  It reports average amount paid per night, by site type and date.  

1. Go to Maintenance / Advanced Customizations / Queries

2. Click the Import Query button, and you'll get a typical Windows file-open dialog labeled "Import Query".

3. You need to locate the sample Forms folder, which is typically C:\Program Files\Campground Master\Samples (most likely you just need to double-click the "Samples" folder to get there, but you may have to navigate to the C: drive first using the "Look In" drop down at the top").

4. Now select the file "Sample Query - Average daily amt paid, by site type.csv", and click Open.  You'll see one or more queries added to the list.  When done importing, click Close.

Now that query will be added to the Query tab view (that tab will be newly added in front of the Transactions tab if you didn't have any Queries before this).  Just go to the Queries tab and select it from the list.

It's not perfect, but that's the closest we can come at the moment.  Note that the numbers in the central grid are NOT accurate (they're intermediate totals) -- only look at the last "Average" column and bottom "Average" row.  Also note that it reports as of each reservation's Last Night - e.g. if they stayed 5 nights, the average will show up only on the last night, not each night separately.  Also, for linked reservations the combined total will all appear on the master site, since the transactions are combined.