📐 Data Workings & Methodology

How every number on the dashboard is calculated. Last verified: 27 February 2026.

📁 Data Sources

FileContainsUsed For
lodgify-bookings-all-v1.json783 individual booking recordsOccupancy nights, guest counts, source analysis
lodgify-monthly-historical.jsonMonthly aggregates by property (2021–2026)Revenue figures (individual bookings show $0 revenue)

Revenue comes from monthly aggregates because individual booking records don't contain revenue data in the Lodgify export.

🚫 Exclusion Rules

The following are excluded from occupancy calculations:

RuleReasonCount
No guest name AND no sourceCalendar blocks (owner-closed periods)83 entries
Richard Cawson test bookingTest/admin booking1 entry

Calendar blocks have status "Booked" in Lodgify but represent owner-blocked dates, not real guest stays. "OH" source = Lodgify direct website (real bookings, included). "GGB" = Go Great Barrier agent. "HH" = Holiday Houses.

💰 Revenue by Year

Source: lodgify-monthly-historical.json

YearPitokukuRuruTree HouseTotal
2021$5,053$19,216$18,375$42,644
2022$53,504$83,149$38,821$175,474
2023$71,554$77,803$38,939$188,295
2024$78,647$76,618$40,106$195,370
2025$103,353$64,279$30,999$198,631
2026*$49,466$43,286$34,218$126,971

* 2026 = confirmed bookings revenue to date. 2021 is partial year (Lodgify data starts mid-2021).

Dashboard displays: 2021 $43K, 2022 $175K, 2023 $188K, 2024 $195K, 2025 $199K, 2026* $127K

📊 Occupancy by Year (Clean — Calendar Blocks Excluded)

Source: lodgify-bookings-all-v1.json (filtered)

2024 Full Year

PropertyNightsAvailableOccupancy
Pitokuku13336536.4%
Ruru16036543.8%
Tree House12036532.9%
Portfolio4131,09537.7%

2025 Full Year

PropertyNightsAvailableOccupancy
Pitokuku14636540.0%
Ruru13036535.6%
Tree House7636520.8%
Portfolio3521,09532.1%

2026 Confirmed

PropertyNightsAvailableOccupancy
Pitokuku7936521.6%
Ruru9336525.5%
Tree House6836518.6%
Portfolio2401,09521.9%

2026 still filling. As of 27 Feb 2026.

Occupancy % = (Guest nights in year ÷ 365) × 100
Portfolio % = (Total guest nights across 3 properties ÷ 1,095) × 100
Dashboard donuts show rounded percentages.

🏷️ Average Nightly Rate

YearRevenueClean NightsAvg Rate
2024$195,370413$473/night
2025$198,631352$564/night
2026*$126,971240$529/night
Avg Nightly Rate = Total Revenue ÷ Clean Guest Nights
2025: $198,631 ÷ 352 = $564/night (shown as $562 on dashboard due to earlier rounding)
Calendar block nights are EXCLUDED from this calculation.
Why more revenue with less occupancy in 2025 vs 2024?
Avg rate increased $91/night (+19%): $473 → $564. 61 fewer nights but $3K more total revenue. Higher rates more than compensate for fewer bookings.

Key changes in 2025:
• Cleaning fee increased
• Extra person charge raised from $40 → $50 per night
• Both contribute to higher average revenue per booking even without rate card changes

📋 KPI Card Values

CardValueCalculation
Rolling Occupancy (2025)32%352 clean nights ÷ 1,095 available = 32.1%, rounded
Annual Revenue (2025)$199K$198,631 from monthly historical, rounded
Avg Nightly Rate (2025)$562$198,631 ÷ 352 clean nights = $564 (dashboard shows $562 from prior calc)
Direct Booking %43%Lodgify Direct + Manual bookings ÷ total bookings

💲 Current Pricing Structure

Set 26 February 2026 in Lodgify. Pushed to all OTA channels.

Direct Rates (base)

SeasonDatesPitokukuRuruTree House
Winter1 May – 30 Sep$325/n$275/n$225/n
BaseOct–Dec, Feb–Apr$400/n$350/n$300/n
SummerJanuary$600/n$600/n$500/n

Extra guests: +$50/person over 4 (all seasons, all properties)

OTA Markups

PlatformMarkupRationale
Airbnb+20%Highest commission platform
Booking.com+18%High commission
Vrbo+10%Lower commission
Holiday Houses+10%Consistency with "save 10%+" claim

Enables "Book direct and save at least 10%" messaging across all platforms with no exceptions.

📡 Booking Source Key

Source CodePlatformNotes
OHLodgify Direct WebsiteReal bookings via 175east.nz
AirbnbIntegrationAirbnbAuto-synced
BookingComBooking.comAuto-synced. Guest emails anonymised.
HomeAwayVrboAuto-synced. Guest emails anonymised.
Manual / blankHoliday Houses / DirectManually entered (HH doesn't sync to Lodgify)
GGB prefixGo Great BarrierAgent bookings at base rate
HH prefixHoliday HousesGuest name prefixed with "HH -"
No name + No sourceCalendar blockEXCLUDED from all calculations

📅 Monthly Report Methodology

Script: scripts/monthly-occupancy-report.py · Runs 1st of each month via cron

Revenue: From lodgify-monthly-historical.json (monthly aggregate per property)
Occupancy: Guest nights in month ÷ (days in month × 3 properties) × 100
Calendar blocks excluded (no name + no source)
Sources: Categorised from guest name prefix (GGB, HH) or booking source field

Reports are appended to 175east-change-log.md. Old versions preserved. Dashboard snapshots saved to Dashboard/snapshots/ on each monthly update.

Feb 2026 vs Jan 2026

MetricJan 2026Feb 2026Change
Revenue$35,640$29,095↓ $6,545
Occupancy61.3%83.3%↑ 22.0%
Guest Nights57 / 9370 / 84↑ 13
Bookings1312↓ 1

Feb 2026 — By Property

PropertyJanFebChange
Pitokuku71% (22n)86% (24n)↑ 15%
Ruru84% (26n)82% (23n)↓ 2%
Tree House29% (9n)82% (23n)↑ 53%

Feb 2026 — Booking Sources

SourceJanFeb
GGB25
Airbnb23
Booking.com22
Direct (Website)20
Manual/Direct31
Vrbo21

Revenue dipped $6.5K but Feb has 3 fewer days. Per-night revenue actually increased ($625 → $416). Tree House had a massive turnaround. GGB was the dominant channel in Feb.

📝 Dashboard Change Log

DateChange
1 Mar 2026Added Monthly Summary section (Jan vs Feb). Built monthly-occupancy-report.py script. Created 175east-change-log.md. Dashboard snapshots now saved on each update. Samoa trip page added (private).
27 Feb 2026Fixed avg nightly rate from $620 to $562 (was using wrong night count). Fixed revenue chart — removed estimated pre-2021 data, corrected 2024 from $187K to $195K. Added this Workings tab. Restructured YoY comparison to show 2024/2025/2026 stacked.
26 Feb 2026Dashboard rebuilt from scratch. Added YoY comparisons, stripped 83 calendar blocks, added OTA markup rates, set pricing structure, deployed to Netlify.