.png?height=120&name=campspotlogo2019%20(1).png)
Explore setting up Base Pricing by reviewing a few functional examples.
Summary:
To efficiently manage your pricing strategy within the Base Prices for Campsites report, it's essential to understand how to adjust prices based on various factors, such as the day of the week, holidays, and special events.
Learn more! Check out the resources below to dive further into Base Pricing:
Below, we'll explore functional examples of how to utilize this feature effectively:
- Changing Price based on Day of the Week
- Adding Rates for Next Year
- Adding Holiday Rates
- Adding a Special Event Rate
Base Pricing: Site Types VS Add-Ons
The reports used for managing Base Prices comes in two different variations: one for Site Types and one for Add-ons. If your park offers Daily Add-Ons, the information on this page is also applicable to the Base Prices for Add-Ons as well.
Changing Price based on the Day of the Week
To understand the basics of how to fill out the Base Prices for Campsites report, let's take a look at differentiating prices by day of the week. One of the simplest ways to enhance your pricing strategy is to adjust prices based on demand throughout the week.
For instance, let's consider pricing Friday, Saturday, and Sunday nights differently from the rest of the week. To implement this in the Base Prices for Campsites report:
- Duplicate Date Range: Copy and paste the column for the date range you are updating.
- Adjust Days of the Week: Update the abbreviated days of the week in Row 1 for both the columns for the preferred date range.
- In this example, the new column's days of week would be F, S, SU and the original column would be updated to include M, T, W, Th.
- Update Rates: Modify the rates to align with your pricing strategy.
Please Note:
The date range(s) included on the Base Prices for Campsites sheet need to cover all future dates you would like to have reservations bookable for. If a date range is not included on the Base Price sheet it will not generate a site to select when searching for reservations on the reservation grid.
Additional Examples
To demonstrate how to update the Base Prices for Campsites report to meet the needs of other common strategies, take a look at the examples below:
- Adding Rates for Next Year
- Holiday Rates: Add a rate for: Memorial Day, Canada Day / July 4th, Labor Day
- Special Event: Add a Special Event Rate for April 2024
Adding Rates for Next Year
If your goal is to add new rates to your existing rate structure, follow the quick steps below:
- Add New columns: Add the new date ranges to the worksheet by inputting the information in the blank columns on the right of your existing rates. In the example below, this is accomplished by using the copy and paste feature then updating the date range.
- Define Days of the Week
- Update Rates
As an example, view the audio free screen recording below of a park adding in rates for 2025.
Holiday Rates
As part of this park's strategy, you may want to include Holiday Rate for those peak season Holidays. To do this, you will follow similar actions:
- Duplicate Date Range (please see note)
- Adjust Days of the Week (please see note)
- Update Rates
Please Note:
- Positioning of Date Ranges: Ensure that the new date ranges and rates are input into columns before the columns holding the year date range. This is crucial because the system reads the report from left to right. If a reservation falls within the dates on a column, the system will price each individual night within that date range. Including specific date ranges to the left of broader ones ensures accurate pricing.
- Days of the Week Adjustment: In situations where you aim to set pricing for particular date ranges, it's essential to include all days of the week in the designated column. This step is crucial to guarantee a successful upload and fulfill the system's requirements.
By including all days of the week, even if the pricing is only applicable to specific dates within the range, you ensure that the system processes the data accurately. This approach helps maintain consistency and prevents potential errors during the pricing setup process.
View the screenshot below for a visual explanation.
Special Event Rates
To add a special rate for an event, you will follow similar actions:
- Duplicate Date Range
- Adjust Days of the Week
- Update Rates
Most Common FAQ:
Q: Can Date Ranges Overlap?
Date ranges on the Base Price for Campsites can overlap and the price that comes first when reading from left to right will be applied. The ability to overlap date ranges reduces the amount of date range columns needed to produce rates for the entire year.
Q: How do I apply pricing based on Length of Stay?
Prices based on the length of stay cannot be included in the base price report. The values entered in the base price sheet as the price for a particular site type are applied as nightly prices. Click here to learn how to incorporate package pricing into your system:
Q: Why is it important to include all days of the week when adjusting prices based on specific date ranges?
It's essential to include all days of the week in the designated column, even if the pricing is only applicable to specific dates within the range. This step ensures a successful upload and meets the system's requirements, helping to maintain consistency and prevent potential errors during the pricing setup process.
Q: How should I position new date ranges and rates in the Base Prices for Campsites report?
Ensure that the new date ranges and rates are input into columns before the columns holding the year date range. This organization is crucial because the system reads the report from left to right. Including specific date ranges to the left of broader ones ensures accurate pricing.