Host Dashboard Analytics

Design a scalable analytics dashboard that Airbnb hosts use to view aggregated booking metrics across all of their listings. When a host opens the dashboard they see totals and averages for any date range they select: total nights booked, average nightly price, and total revenue. A typical host has 100+ listings and the platform supports millions of bookings per day, so the system must return results in <200 ms without scanning raw booking rows on every request. You should support real-time updates (eventual consistency within a few seconds is acceptable) so that new bookings or cancellations are reflected quickly. The host can first see an aggregated view across all listings and then drill down to individual listing numbers. Outline the high-level architecture, data model, ingestion pipeline, aggregation strategy, query layer, and how you would handle peak loads and failures.