Data Health
Connection status for every Phase 1 system. Missing or stale data is never shown silently.
Figure labels:SAMPLE MISSING MANUAL REPORT ACTUAL CALCULATED FORECAST ASSUMPTION AI RECOMMENDATIONThis template uses only SAMPLE (fake layout data — repeated digits like 11, 22, $1,111 so they can never pass for real figures), MISSING (source not connected), and MANUAL REPORT (owner-provided counts from the Park Profile). No live data is connected.
Phase 1 connections
SOURCE: Dashboard connection monitorAS OF: template build Oct 2, 2026 3:29 PM MT
| Source | Status | Last updated | Next update | Action required |
|---|---|---|---|---|
| Campspot — reservations & reports (view/report-only) | AWAITING ACCESS | Never (not connected) | After access: 6:30 AM · 12:30 PM · 5:30 PM MT | Confirm the bot's Campspot user + delivery method (scheduled CSV to a dashboard inbox, property-contact exports, or Reservation Activity Feed). |
| Campspot Analytics (dashboards & scheduled CSV) | AWAITING ACCESS | Never (not connected) | After access: daily | Confirm the park's free Analytics seat is active and who holds it; decide if an Explorer license (data integrations) is worth it. |
| Google Business Profile (Beargrasslodging@gmail.com) | AWAITING ACCESS | Never (not connected) | After access: 6:30 AM MT daily | Grant the bot Manager access to the Business Profile (no passwords in chat). |
| Airbnb (legacy — prior owner) | MANUAL WEEKLY REPORT | No report received yet | Weekly — due day TBD | Owner contact arranges weekly export. A staff-provided Airbnb earnings report is on Drive, held for setup review (not ingested). |
| Booking.com (legacy — prior owner) | MANUAL WEEKLY REPORT | No report received yet | Weekly — due day TBD | Owner contact arranges weekly export. |
| VRBO (legacy — prior owner) | MANUAL WEEKLY REPORT | No report received yet | Weekly — due day TBD | Owner contact arranges weekly export. |
| Staff schedule | DATA SOURCE UNKNOWN | Never (not connected) | — | Tell us where the schedule lives (calendar, sheet, app, paper). |
| Housekeeping assignments (lead housekeeper, verbal) | DATA SOURCE UNKNOWN | Never (not connected) | — | Owner decision: simple tracking tool (e.g., evaluate Campspot Housekeeping module). |
| Housekeeping cleaning / READY status | DATA SOURCE UNKNOWN | Never (not connected) | — | Same tracking-tool decision. Stays MISSING until chosen. |
| Maintenance log | DATA SOURCE UNKNOWN | Never (not connected) | — | Tell us where issues are logged (paper, sheet, or app). |
| Camp store POS | DATA SOURCE UNKNOWN | Never (not connected) | — | Tell us what rings up store sales (Campspot POS, Square, cash register, other). |
| Camp store inventory list (Drive, staff-provided) | PENDING SETUP REVIEW | File received — not ingested | — | Review at setup; item cost still MISSING. |
| QuickBooks / financials | PHASE 4 | — | — | Not part of Phase 1. Do not connect. |
| Refresh scheduler (6:30 AM · 12:30 PM · 5:30 PM MT) | NOT CONFIGURED | — | — | Turns on after layout approval and first source connects. |
| Park Profile (inventory counts, roles, brand) | MANUAL REPORT | Park Profile (as provided) | On change | None — RV site types still MISSING. |
Refresh schedule (Mountain Time)
| When | What |
|---|---|
| 6:30 AM, 12:30 PM, 5:30 PM | Occupancy, arrivals, departures, turnovers, bookings, cancellations, reservation revenue |
| 6:30 AM only | Google reviews, camp store, forward bookings |
| Weekly (file upload) | Legacy OTAs (Airbnb, Booking.com, VRBO) |
| Not in Phase 1 | QuickBooks |
Status: NOT CONFIGURED — turns on after layout approval. If a refresh fails, the last good data is kept, the section is marked STALE, and the failure time and fix are shown.