Host Metric Studio
Airbnb Seasonal Pricing: Build Your Own Season Calendar

The best seasonal pricing calendar is built from your own data: calculate RevPAR for each of the last 12 months, divide it by your annual RevPAR to get a seasonal index, and group months into peak, high, shoulder and low. Then add two layers – weekday versus weekend, and specific event dates – and give each season its own base rate, minimum stay and price floor. Done once, it takes about an hour and becomes your pricing plan for next year. Below is the method, the formulas and a fully worked (invented) example.
From experience at a short-term rental management company with more than 1,000 homes: owners almost always described their seasons as "summer is high, winter is low". The data usually showed something more useful – shoulder months that behaved like high season, a dead fortnight inside "high" season, and one or two event weeks worth more than a whole month.
Why a seasonality calendar beats "high season / low season"
Two seasons force one price onto very different weeks. You end up too cheap on the best dates and too expensive on the weakest ones – and you only notice the second problem. A calendar with four tiers plus events lets you:
- set base rates that match demand rather than habit,
- change minimum stay rules at the right moment,
- give each season its own price floor,
- schedule owner stays and maintenance where they cost least.
Build it from your own data: RevPAR by month
Use RevPAR (accommodation revenue ÷ available nights), not occupancy or ADR alone – it captures both price and demand (how RevPAR combines the two). In a Season sheet, one row per month: A Month, B Available nights, C Booked nights, D ADR. Then:
E Accommodation revenue =C2*D2
F RevPAR =E2/B2
G Seasonal index =F2/(SUM($E$2:$E$13)/SUM($B$2:$B$13))
H Tier =IF(G2>=1.3,"Peak",IF(G2>=1.05,"High",IF(G2>=0.8,"Shoulder","Low")))
The index compares each month with your annual RevPAR (total revenue ÷ total available nights), so 1.00 is an average month. The tier thresholds are a starting point – adjust them so each tier has a meaningful number of months.
🧮 Example only – invented numbers.
Loft 1, last 12 months (June 2026 is the same month used across this site's guides). Annual RevPAR ≈ 72.32.
| Month | Occupancy | ADR | RevPAR | Index | Tier |
|---|---|---|---|---|---|
| Jul 2025 | 83.9% | 140 | 117.42 | 1.62 | Peak |
| Aug 2025 | 87.1% | 145 | 126.29 | 1.75 | Peak |
| Sep 2025 | 73.3% | 118 | 86.53 | 1.20 | High |
| Oct 2025 | 64.5% | 105 | 67.74 | 0.94 | Shoulder |
| Nov 2025 | 46.7% | 86 | 40.13 | 0.55 | Low |
| Dec 2025 | 54.8% | 98 | 53.74 | 0.74 | Low |
| Jan 2026 | 41.9% | 85 | 35.65 | 0.49 | Low |
| Feb 2026 | 50.0% | 88 | 44.00 | 0.61 | Low |
| Mar 2026 | 58.1% | 95 | 55.16 | 0.76 | Low |
| Apr 2026 | 66.7% | 105 | 70.00 | 0.97 | Shoulder |
| May 2026 | 71.0% | 112 | 79.48 | 1.10 | High |
| Jun 2026 | 75.0% | 120 | 90.00 | 1.24 | High |
What a revenue manager would notice here:
- September is high season, not "after summer". Pricing it like October would give money away.
- December and March sit in "low" as months, but may contain peak weeks (Christmas–New Year; Easter, which falls in March or April depending on the year). Monthly data hides them – that's what the event layer is for. For the holidays themselves, use a date-by-date Christmas and New Year's Eve plan.
- January is the weakest month – the obvious place for owner stays and maintenance.
If you have two or more years of data, average the indices; one year can be distorted by a single event or a slow start. If you have none, use your comp set's prices for future dates as a rough guide and replace them with your own data as it builds up.
Add the weekday layer
Monthly numbers hide the weekly pattern. Count Friday and Saturday nights booked in each stay with NETWORKDAYS.INTL, whose seven-character mask (Monday to Sunday) marks with 0 the days to count. In a helper column of the Bookings tab, for the month in Dashboard!B1:
=IF(J2="Cancelled",0,IF(MIN(C2,EOMONTH(Dashboard!$B$1,0)+1)>MAX(B2,Dashboard!$B$1),
NETWORKDAYS.INTL(MAX(B2,Dashboard!$B$1),MIN(C2,EOMONTH(Dashboard!$B$1,0)+1)-1,"1111001"),0))
Available Friday and Saturday nights in the month: =NETWORKDAYS.INTL(B1,EOMONTH(B1,0),"1111001") (minus any you blocked). Divide one by the other for weekend occupancy; do the same with mask "0000110" for Sunday–Thursday.
🧮 Example only – invented numbers.
Over the last 12 months, Loft 1's Friday and Saturday nights were 82% occupied and Sunday–Thursday nights 57.5% – an overall 64.5%. Weekend nights are clearly under-priced relative to weekdays, or weekdays are over-priced, or both.
How to set the weekend uplift: don't copy a percentage from elsewhere. Raise weekend rates in small steps on dates far enough out to learn from, and watch whether weekends still fill earlier than weekdays. When they stop filling much earlier, you're close to the right gap.
Turn the calendar into rules
One row per tier in your sheet:
| Tier | Base rate | Weekend | Minimum stay (far out) | Floor |
|---|---|---|---|---|
| Peak | Last year's ADR, adjusted for pace | Uplift tested | Longest | Highest |
| High | … | … | … | … |
| Shoulder | … | … | … | … |
| Low | … | … | Shortest | Lowest |
- Base rate: start from last year's ADR for that tier and adjust with what you've learned – did those months fill early (raise), or late and only with discounts (hold or lower)? If your platform fee structure changed since last year (for example Airbnb's move to a single host-paid fee in 2026), last year's ADR isn't comparable as it stands – adjust it first.
- Minimum stay: longer in peak, shortest in low season, always relaxed inside your booking window.
- Floor: from the lowest rates that sold in that tier last year.
On Airbnb, hosts can set prices for specific dates in the calendar, and hosts using its professional tools can save rule-sets with seasonal prices and trip-length rules (checked 27 October 2026). If a third-party pricing tool manages your rates, set the same tiers there as seasonal minimums and base adjustments – make sure only one system is setting nightly prices.
Events, holidays and shoulder weeks
Make an event list for the next 12 months: public holidays and long weekends, school holidays in your main guest markets, local festivals, trade fairs, sports events, concerts. For each, record the dates and a tier override (usually "Peak").
Three practical rules:
- 1Price the event nights and the nights around them. Guests arriving for a Saturday event often want Friday too – consider a two-night minimum on those dates.
- 2Load events early. Event demand can book further ahead than normal – check when last year's event dates were booked. If your event prices go up late, the early bookings got last year's price.
- 3Watch shoulder weeks. The first and last weeks of a season behave like the neighbouring season. Let your index tiers follow weeks, not just months, once you have enough data.
Plan owner stays and maintenance in your lowest-RevPAR weeks
Every night you block in January (index 0.49 in the example) costs just over a quarter of a night blocked in August (index 1.75). Use the calendar to agree owner dates and repairs early – before guests book those weeks. Blocked nights come out of available nights, so they won't distort occupancy.
FAQ
How do I set seasonal pricing on Airbnb?
Build your tiers from your own RevPAR, then apply them as date-specific prices, rule-sets or seasonal settings in your pricing tool – with a floor and minimum stay per tier.
What if I have no history?
Use comparable listings' prices for future dates as a starting point and replace them with your own data month by month.
How often should I update the season calendar?
Once a year in full, and after each season check whether any month behaved differently from its tier.
Should I lower prices in the slow season?
Only to the level your low-season floor allows. Shorter minimum stays often help more than deeper discounts.
The STR Income & Expense Tracker builds the 12-month view (occupancy, ADR and RevPAR per month) automatically from your booking export – $19 at https://emprendemos.gumroad.com/l/str-income-expense-tracker.
Not affiliated with or endorsed by Airbnb, Vrbo or Booking.com. Platform features are described as checked on 27 October 2026 and may change. Example figures are invented. This article is not tax or financial advice.
Short on time? I can set it up for you.
If you'd rather not build this yourself, I set up the income and KPI tracker for your properties, using your own bookings and costs, so you can start reading your numbers right away. See the service on Upwork.