Monthly Revenue /revenue-report

{
  "skill": "revenue-report",
  "month": "2026-04",
  "windows": {
    "current_month": [
      "2026-04-01",
      "2026-04-30"
    ],
    "previous_month": [
      "2026-03-01",
      "2026-03-31"
    ],
    "year_over_year": [
      "2025-04-01",
      "2025-04-30"
    ],
    "trailing_30d": [
      "2026-03-29",
      "2026-04-28"
    ],
    "forward_30d": [
      "2026-04-28",
      "2026-05-28"
    ]
  },
  "totals": {
    "current_month_revenue": 48833.11,
    "current_month_reservations": 39,
    "previous_month_revenue": 62626.09,
    "yoy_month_revenue": 38242.45,
    "trailing_30d_revenue_prorated": 53174.29,
    "trailing_30d_revenue_raw": 118971.25,
    "forward_30d_projected": 67764.57,
    "forward_30d_reservations": 25
  },
  "by_property_trailing_30d": [
    {
      "listing_id": 222900,
      "name": "Cherrytown Chalet",
      "booked_nights": 15,
      "occupancy_pct": 50.0,
      "revenue": 5503.79,
      "adr": 366.92,
      "reservations": 5
    },
    {
      "listing_id": 422513,
      "name": "Hommel House",
      "booked_nights": 14,
      "occupancy_pct": 46.7,
      "revenue": 5373.81,
      "adr": 383.84,
      "reservations": 5
    },
    {
      "listing_id": 290588,
      "name": "Valley Vista",
      "booked_nights": 17,
      "occupancy_pct": 56.7,
      "revenue": 5306.0,
      "adr": 312.12,
      "reservations": 6
    },
    {
      "listing_id": 396986,
      "name": "Wanderwood Lodge",
      "booked_nights": 3,
      "occupancy_pct": 10.0,
      "revenue": 5164.06,
      "adr": 1721.35,
      "reservations": 2
    },
    {
      "listing_id": 341135,
      "name": "Porter's Lodge",
      "booked_nights": 8,
      "occupancy_pct": 26.7,
      "revenue": 5157.32,
      "adr": 644.66,
      "reservations": 4
    },
    {
      "listing_id": 299281,
      "name": "Jade Getaway",
      "booked_nights": 12,
      "occupancy_pct": 40.0,
      "revenue": 4942.9,
      "adr": 411.91,
      "reservations": 4
    },
    {
      "listing_id": 369689,
      "name": "Goat Hill Cottage",
      "booked_nights": 13,
      "occupancy_pct": 43.3,
      "revenue": 4134.51,
      "adr": 318.04,
      "reservations": 4
    },
    {
      "listing_id": 340620,
      "name": "Red Fox Stables",
      "booked_nights": 2,
      "occupancy_pct": 6.7,
      "revenue": 3981.6,
      "adr": 1990.8,
      "reservations": 1
    },
    {
      "listing_id": 487778,
      "name": "Blau Haus",
      "booked_nights": 12,
      "occupancy_pct": 40.0,
      "revenue": 3937.56,
      "adr": 328.13,
      "reservations": 3
    },
    {
      "listing_id": 451270,
      "name": "Blackberry Cottage",
      "booked_nights": 6,
      "occupancy_pct": 20.0,
      "revenue": 2948.5,
      "adr": 491.42,
      "reservations": 3
    },
    {
      "listing_id": 505182,
      "name": "Waterfall House",
      "booked_nights": 5,
      "occupancy_pct": 16.7,
      "revenue": 2648.13,
      "adr": 529.63,
      "reservations": 2
    },
    {
      "listing_id": 493486,
      "name": "Timberledge Cabin",
      "booked_nights": 8,
      "occupancy_pct": 26.7,
      "revenue": 2613.46,
      "adr": 326.68,
      "reservations": 4
    },
    {
      "listing_id": 343880,
      "name": "The Ridge House",
      "booked_nights": 2,
      "occupancy_pct": 6.7,
      "revenue": 819.79,
      "adr": 409.89,
      "reservations": 1
    },
    {
      "listing_id": 429948,
      "name": "Hilltop Oasis",
      "booked_nights": 2,
      "occupancy_pct": 6.7,
      "revenue": 642.86,
      "adr": 321.43,
      "reservations": 1
    }
  ],
  "revenue_log_trend": [
    {
      "date": "2026-04-22",
      "health": "PROBLEM",
      "summary": "Multiple properties require urgent attention this session, including two PROBLEM-tier properties with zero occupancy across both windows, floor pressure anomalies, and a new listing milestone approach",
      "type": "Weekly"
    },
    {
      "date": "2026-04-22",
      "health": "PROBLEM",
      "summary": "Full-portfolio pass with owner-stay-adjusted MPI (new): 1 HEALTHY / 6 WATCH / 6 PROBLEM. 5 base/min writes + 61 DSOs (18 Ridge LMD + 43 portfolio comp-cap rollout with \u22653-comp, -20% cap, owner-stay guardrails). Hommel & Hilltop flipped HEALTHY\u2192PROBLEM after adjustment. Timberledge comp set CRITICAL (3 comps only).",
      "type": "Weekly"
    },
    {
      "date": "2026-04-20",
      "health": "PROBLEM",
      "summary": "The portfolio is in PROBLEM status, with two zero-booking properties, three additional listings severely underperforming their markets, and an apparent revenue manager transition underway.",
      "type": "Weekly"
    },
    {
      "date": "2026-04-15",
      "health": "PROBLEM",
      "summary": "Multiple properties remain well below occupancy targets in spring shoulder season, with Cherrytown Chalet, The Ridge House, Timberledge Cabin, and Wanderwood Lodge all showing 27+ point gaps and mixed",
      "type": "Weekly"
    },
    {
      "date": "2026-04-14",
      "health": "PROBLEM",
      "summary": "7 changes approved: 4 deferred floor raises applied (Jade, Porter's, Wanderwood, Cherrytown) + Valley Vista min, Ridge House base, Red Fox base; 3 properties flagged for listing audits.",
      "type": "Weekly"
    },
    {
      "date": "2026-04-13",
      "health": "PROBLEM",
      "summary": "Portfolio is in PROBLEM status driven by two zero-booking properties, one luxury property with no near-term pickup, and several listings with forecasted occupancy lagging their markets heading into spring.",
      "type": "Weekly"
    },
    {
      "date": "2026-04-12",
      "health": "PROBLEM",
      "summary": "Multiple properties require base or floor adjustments due to persistent occupancy gaps and floor pressure signals, with two zero-occupancy listings and one luxury property showing no bookings at all.",
      "type": "Weekly"
    },
    {
      "date": "2026-04-12",
      "health": "PROBLEM",
      "summary": "Multiple properties remain significantly below seasonal occupancy targets in off-season, with Blackberry Cottage and Red Fox Stables showing zero occupancy across all windows and requiring immediate a",
      "type": "Weekly"
    }
  ],
  "anomalies": [],
  "validation": {
    "skill": "revenue-report",
    "started_at": "2026-04-28T18:21:13.674207+00:00",
    "checks_run": [
      "properties",
      "hostaway_auth",
      "reservation_sanity",
      "revenue_analysis_log"
    ],
    "summary": {
      "errors": 0,
      "warnings": 0,
      "info": 0
    },
    "findings": []
  }
}