Skip to main content

Reports - Campground Occupancy Report

Written by Andy Hornbeak

The Campground Occupancy report measures how full your park was, night by night. Rather than one row per reservation, it produces one row per space per day, which is what lets it calculate occupancy percentage and average daily rate (ADR) over any period you choose.

This article assumes you already know the basics of the Sharper reporting module — the Name, Token, Subtotal, column picker, and filter fields. For a full walkthrough of the reporting form itself, see the Sharper Reporting Reference Guide. For how occupancy reporting works across Marina, Campground, and Booking together, see Reports - Occupancy Reports. This article covers what's specific to the campground.


Why This Report Matters

Occupancy and average daily rate are the two numbers that describe how a park is performing, and they are what an owner, lender, or franchise will ask for. Because this report is built per night, it can answer questions a reservation list cannot:

  • What percentage of spaces were filled over a holiday weekend, and how that compares with last year

  • What the park actually earned per occupied space per night, rather than list rate

  • Which loops or space types run full and which consistently sit empty

  • How occupancy builds and falls away across the season


One Row Per Space Per Night

This is what makes the Occupancy report different from every other campground report, and what you need to understand before reading its numbers. A single one-month stay does not produce one row — it produces roughly thirty, one for each night, each carrying that night's share of the revenue.

Because revenue is spread across nights, do not read a single row's Total as the value of the reservation — it is that one night's portion. Equally, a row count is a count of space-nights, not a count of bookings. When you want reservation-level figures, use the Campground Reservations report instead. Use Occupancy when you want rates and percentages over a period.

Only spaces actually assigned to a reservation contribute occupied nights. A booking taken but never given a space will not count toward occupancy.


Building an Occupancy Report

  1. Go to Reports → Campground → Occupancy in the left sidebar.

  2. If a shipped report is close to what you need, use the ⋯ menu → Copy first — shipped reports can only be edited by the Sharper team.

  3. Otherwise click + New and give it a Name, such as "Seasonal Occupancy."

  4. Add the columns below. For a summary rather than a night-by-night listing, select a period column such as Date YYYYMM together with Occupied and ADR.

  5. Turn on Summarize Report if you want totals rather than every individual space-night.

  6. Turn on All Outlets to compare parks side by side.

  7. Click Save, then Get Report to set your date range and run it.


Recommended Columns

Field

What It Shows

Occupied

Whether the space was occupied that night — the basis of every occupancy percentage

ADR

Average daily rate: revenue divided by occupied space-nights. The single most useful performance figure on the report.

Date

The night the row represents

Year, Month, Day, Day Name

The same date broken out, so you can group by month or compare weekends against weekdays

Date YYYYMM

Year and month as one value — the easiest column to group a monthly occupancy summary on

Calculated Days, Duration

The length of the stay behind the row

Unit Name, Unit Group Name

The space and its loop — group on Unit Group Name to compare loops

Unit Inactive

Whether the space is out of service. Filter these out before calculating occupancy, or a loop closed for maintenance will drag your percentage down.

Booking Type Name

The kind of booking the space takes — lets you separate nightly from seasonal performance

Subtotal, Tax, Total

That night's share of the revenue

Customer Name

Who was in the space that night, when you need detail rather than a summary

Product Name, Product Category Name, Income Account

What was billed and where the revenue posts

Note: Occupancy reports do not behave like other reports on the run screen — the period comes from the report's own date handling rather than the standard date fields. If your figures look wrong for the period you expected, check the date range on the run screen before assuming the data is at fault.


Useful Filters

  • Exclude out-of-service spaces: Field Unit Inactive, set to No. Apply this to almost any occupancy report.

  • Occupied nights only: Field Occupied, set to Yes — use this when calculating ADR on its own.

  • One loop: Field Unit Group Name, set to the group.

  • Weekends only: Field Day Name, set to Friday and Saturday.

  • Nightly business only: Field Booking Type Name, set to your nightly type.

  • A single month: Field Date YYYYMM, set to the month.

A saved report grouped by Date YYYYMM with Occupied and ADR selected, filtered to exclude inactive spaces, gives you a month-by-month performance summary you can run at the end of every season.

Did this answer your question?