Host Metric Studio
What Is a Good Occupancy Rate for Airbnb? How to Judge Yours

A good Airbnb occupancy rate is one that is comfortably above your break-even occupancy and, combined with your nightly rate, gives the highest RevPAR (revenue per available night) for that season – ideally beating the same month last year. There is no single "good" percentage for every listing: a city studio, a rural cabin and a beach house in winter all have different normal levels, and a very high occupancy can simply mean your price is too low.
Below is the method I'd use to set a target for one property, based on experience at a short-term rental management company with more than 1,000 homes. It needs nothing more than a spreadsheet.
First, calculate occupancy correctly
Occupancy = booked nights / available nights
Available nights = nights in the period - nights you took off sale (owner use, maintenance)
In Google Sheets or Excel, for a month that starts on the date in B1, with blocked nights in B3 and booked nights in B5:
=B5/(DAY(EOMONTH(B1,0))-B3)
Four details change the result a lot:
- Split stays that cross month-end. A 29 June – 3 July stay is 2 nights in June and 2 in July:
=MAX(0,MIN(checkout,EOMONTH(B1,0)+1)-MAX(checkin,B1)) - Exclude cancellations. Count only stays that happened or are still confirmed.
- Remove owner and maintenance blocks from available nights – they weren't for sale.
- ⚠️ Common mistakeDon't remove unsold gap nights. A night nobody could book because of your minimum stay is still an available night that went unsold. Taking it out hides exactly the problem you need to see.
The occupancy shown in a platform's own host statistics may be calculated differently (another period, another treatment of blocked nights). That's fine – use one method consistently and compare like with like. The spreadsheet template guide has all the formulas in one place.
Why occupancy alone misleads
High occupancy can mean your price is too low. Lower occupancy can be perfectly healthy if your rate is higher and your costs are covered. That's why revenue managers read occupancy together with:
ADR = accommodation revenue / booked nights
RevPAR = accommodation revenue / available nights (= ADR × occupancy)
🧮 Example only – invented numbers, not market data.
| Property A | Property B | |
|---|---|---|
| Available nights | 30 | 30 |
| Booked nights | 27 | 21 |
| Occupancy | 90% | 70% |
| ADR | 80 | 115 |
| Accommodation revenue | 2,160 | 2,415 |
| RevPAR | 72 | 80.5 |
Property A "wins" on occupancy, but Property B earns more with six fewer booked nights – and usually fewer turnovers, so less cleaning cost, wear and guest messaging.
So the better question is: "What occupancy, at what price, maximises my RevPAR and my profit?"
Step 1 Your floor – break-even occupancy
The minimum acceptable occupancy is the level at which net payouts cover all your costs. Calculate what each booked night contributes after platform fees and per-stay costs, then:
Contribution per booked night = (Net payouts - Variable costs) / Booked nights
Break-even occupancy = Fixed costs / (Available nights × Contribution per booked night)
🧮 Example only – invented numbers (the same apartment used across this site's guides).
June: net payouts 2,448, variable costs 360, 21 booked nights → contribution ≈ 99.43 per night. Fixed costs 1,370, 28 available nights: 1,370 / (28 × 99.43) ≈ 49.2% (about 14 of 28 nights). Actual occupancy was 75%, so the property is well above break-even.
In Sheets, with fixed costs in B18, available nights in B4 and contribution in B19: =IFERROR(B18/(B4*B19),"n/a"). The full derivation is in the Airbnb profit spreadsheet guide.
If you sit far above break-even month after month and fill up early, you probably have room to test a higher rate. If you're close to it, a price cut to "fill the calendar" can wipe out the margin.
Step 2 Your own history, same month last year
Seasonality is one of the strongest drivers of occupancy, so comparing December with August tells you little. Build a small table – months in rows, years in columns – with occupancy, ADR and RevPAR. A good month is one that beats the same month last year on RevPAR, not necessarily on occupancy.
RevPAR change vs last year = RevPAR this year / RevPAR last year - 1
Also look at occupancy by day of the week. Leisure listings often fill weekends and struggle midweek (or the reverse near business areas); a single monthly figure hides that, and the fix – different weekday and weekend prices, or a shorter minimum stay midweek – is different from a general price change.
Step 3 Your competitive set
Pick five to ten listings near you that are genuinely similar (size, quality, guest type, amenities). Every week, note for the same future dates whether they're available and what they charge. It's manual but free, and far more relevant than a national average. Paid market-data tools can do this at scale; for one or two properties, a weekly check is often enough.
Two cautions from experience:
- An unavailable date is not necessarily a booking. Competitors block nights for owner use, maintenance, or because the property is sold elsewhere. Look at the trend across several listings, not one calendar.
- Compare like with like – same dates, same length of stay, total price including cleaning fee, because that's what guests compare.
If similar listings are filling and you're not, check price first, then minimum stay, photos and reviews. If you're full weeks before they are, your price is probably low for those dates.
Step 4 Check pace and booking window
Your booking window (check-in date − booking date) tells you how far ahead guests normally book for each season. Pacing compares nights already booked for a future month with what you had booked for the same month on the same date last year:
Booking window = check-in date - booking date
Pace vs LY = nights on the books now / nights on the books same date last year - 1
🧮 Example only – invented numbers.
On 15 June, Loft 1 has 4 nights booked for July; a year earlier it had 8 → pace −50%. Last year most of July's nights were booked after 15 June, so being 50% behind on this date is an early warning to track weekly, not yet an alarm; if the gap is still there by 30 June, act on July prices or minimum stay.
Read it both ways: next month nearly full long before your usual booking window opens means you're probably priced too low; an empty calendar inside your usual window means you may be too high – or demand has dropped (check your comp set). The pacing formula is in the Google Sheets guide.
Things that quietly lower occupancy (and what to do)
- Gap nights. One- or two-night holes between stays that your minimum stay doesn't allow. Find them: list confirmed stays for one property sorted by check-in and add
=B3-C2(next check-in − previous check-out); any result above 0 and below your minimum stay is a gap that can't sell. Open those dates to that exact length, ideally only inside your last-minute window. - A minimum stay that ignores lead time. A longer minimum makes sense far out in peak season, when you can wait for longer stays; as the dates get close, shorten it so the remaining nights can still sell. Here's how to set an Airbnb minimum stay by season, check-in day and lead time.
- A minimum stay that ignores season. The minimum that works in August can empty your calendar in November.
- Calendars not synced between channels, so you block nights "just in case".
- Owner or maintenance blocks in peak dates – schedule them in your lowest-RevPAR weeks.
- Rates that are too flat. The same price for a Tuesday in February and a Saturday in July guarantees you're too cheap on one and too expensive on the other.
Setting a realistic target
- 1Floor: break-even occupancy.
- 2Baseline: same month last year (occupancy, ADR, RevPAR).
- 3Reality check: your comparable listings for the same dates.
- 4Goal: the occupancy and rate combination with the highest RevPAR and net profit – not the fullest calendar.
Write a monthly target for occupancy, ADR and RevPAR in your spreadsheet, check pace weekly for the next 90 days, and compare actuals at month-end. After a year you'll know what "good" looks like for your property, which is worth more than any generic benchmark.
FAQ
Is 100% occupancy good?
Rarely. A completely full month – especially one that filled early – usually means some nights sold for less than guests would have paid. Slightly lower occupancy at a higher ADR is the better result whenever RevPAR and profit go up.
Should owner stays count in occupancy?
No. Take owner and maintenance nights out of available nights, so the rate reflects only nights that were for sale.
Why is my Airbnb statistics occupancy different from my spreadsheet?
Platforms may use a different period or a different treatment of blocked nights, and they only see their own bookings. Your spreadsheet covers all channels with your own definition.
How often should I check occupancy?
Actuals once a month; pace for the next three months once a week.
If you'd like this done automatically: the STR Income & Expense Tracker (Excel + Google Sheets) calculates occupancy, ADR, RevPAR, booking window and pacing against your own targets for up to 10 properties – $19 at https://emprendemos.gumroad.com/l/str-income-expense-tracker. The formulas on this page are free to use either way.
Not affiliated with or endorsed by Airbnb, Vrbo or Booking.com. Platform names are used only to describe their data exports. 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.