Host Metric Studio

Airbnb Seasonal Pricing: Build Your Own Season Calendar

Published 2026-11-17

Airbnb Seasonal Pricing – Host Metric Studio

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:

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:

Google Sheets / Excel
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:

💡 Pro tip

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:

Google Sheets / Excel
=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.

82%
Friday and Saturday nights occupied
57.5%
Sunday–Thursday nights occupied
64.5%
overall occupancy

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

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:

  1. 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.
  2. 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.
  3. 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.