Open Doorway
Open Doorway Institutional Real Estate Intelligence
?

Data Health & SLO Dashboard

Freshness, coverage, accuracy SLAs per table and integration

Loading...
Overall Health check_circle
87%
6 compliant, 1 warning, 1 breached
Sources Compliant source
6/8
check 2 sources nearing breach
Tables Within SLA table
12/15
3 tables at risk
Avg Freshness schedule
4.2h
Target: < 6h

table_chart Table-Level SLOs

Table Name Freshness SLA Actual Freshness Status Completeness % Accuracy % Last Checked Trend
properties< 5m2m 14sCompliant99.8%98.2%30s agotrending_up
images< 15m8m 42sCompliant97.4%96.1%2m agotrending_up
market_data< 1h24m 10sCompliant100%99.4%5m agotrending_up
deals< 30m1h 12mWarning91.5%88.7%12m agotrending_flat
analytics_events< 5m3m 55sCompliant100%99.9%1m agotrending_up
user_sessions< 1m45sCompliant100%100%15s agotrending_up
search_queries< 10m28m 30sBreached84.2%79.5%22m agotrending_down
ml_predictions< 1h48m 12sCompliant96.8%95.2%10m agotrending_up
cache_invalidation< 2m1m 30sCompliant99.2%98.8%45s agotrending_up
alerts< 1m52sCompliant100%100%10s agotrending_up
property_metrics< 15m22m 18sWarning93.0%91.4%8m agotrending_flat
integration_logs< 5m4m 10sCompliant98.5%97.8%3m agotrending_up
feed_subscriptions< 1h2h 04mBreached79.1%82.3%35m agotrending_down
notification_queue< 1m38sCompliant100%100%5s agotrending_up
audit_trail< 5m12m 45sWarning95.0%97.1%7m agotrending_flat

source Source-Level SLOs

Source Type Expected Refresh Actual Refresh Status Breach Count Consecutive Alert?
MLS FeedAPIEvery 5m4m 20sCompliant20check_circle
Market Data APIAPIEvery 15m18m 30sWarning73warning
Zillow WebhookWebhookOn change2m 10s avgCompliant00check_circle
Price Feed CSVFileEvery 1h1h 45mBreached145priority_high
Data Lake SyncFileEvery 6h5h 30mCompliant10check_circle
CDN AnalyticsAPIEvery 10m12m 05sWarning41warning
Auth0 LogsWebhookReal-time8s avgCompliant00check_circle
Weather DataAPIEvery 1h3h 22mBreached218priority_high

bar_chart Data Freshness Gantt

How stale each source is relative to its SLA

MLS Feed4m 20s / 5m SLA
Market Data API18m 30s / 15m SLA
Zillow Webhook2m 10s / real-time
Price Feed CSV1h 45m / 1h SLA
Data Lake Sync5h 30m / 6h SLA
CDN Analytics12m 05s / 10m SLA
Auth0 Logs8s / real-time
Weather Data3h 22m / 1h SLA

coverage Data Coverage

% of required fields populated per table

properties99.8%
images97.4%
deals91.5%
search_queries84.2%
feed_subscriptions79.1%

Missing Fields (Top 5)

  • error properties.energy_rating — 12.4% missing
  • error images.alt_text — 22.1% missing
  • error deals.closing_date — 8.7% missing
  • error search_queries.user_id — 15.8% missing
  • error feed_subscriptions.webhook_url — 31.4% missing

verified Accuracy

Field-level validation pass/fail rates

Email format99.9% pass
Phone number98.2% pass
Postal code95.7% pass
Price range92.4% pass
Coordinate bounds88.1% pass

Top Validation Errors

  • error Invalid coordinates: 142 records
  • warning Out-of-range prices: 89 records
  • warning Malformed URLs: 67 records
  • info Missing required fields: 45 records

notifications_active Recent Alerts

Severity Source Title Timestamp Acknowledged
CriticalPrice Feed CSVFeed stale for 45m past SLA23:14:52No
WarningMarket Data API3 consecutive refresh breaches22:55:03No
WarningCDN AnalyticsRefresh delay 2m over SLA22:41:37YesAcknowledged
CriticalWeather Data8 consecutive breaches — source degraded21:18:09No
InfoData Lake SyncSync completed successfully20:30:00YesAcknowledged

tune SLO Configuration

Current SLA targets per source and table (read-only view)

Source SLAs

MLS FeedEvery 5m
Market Data APIEvery 15m
Zillow WebhookOn change
Price Feed CSVEvery 1h
Data Lake SyncEvery 6h
CDN AnalyticsEvery 10m
Auth0 LogsReal-time
Weather DataEvery 1h

Table Freshness SLAs

properties< 5m
images< 15m
market_data< 1h
deals< 30m
search_queries< 10m
feed_subscriptions< 1h
sync Auto-refresh: every 30s
Last updated: --:--:-- UTC