{"product_id":"airbnb-kpi-dashboard","title":"Airbnb KPI Dashboard Spreadsheet – Portfolio Occupancy, ADR, RevPAR, Lead Time \u0026 Source Mix, Targets vs Actual, 12-Month Charts, No Canva","description":"\u003cp\u003e\u003cstrong\u003ePortfolio KPI Dashboard\u003c\/strong\u003e is an Excel and Google Sheets workbook that turns your monthly booking numbers into one clear dashboard for up to six rental properties. Type nights booked, revenue, bookings by source and lead time once a month, and see occupancy, ADR, RevPAR, average stay, average lead time and source mix per property, with 12-month trend charts and a targets-vs-actual table that shows variance and pace.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eNo Canva needed.\u003c\/strong\u003e This is a plain spreadsheet with no macros and no add-ons. Yellow cells are for typing and gray cells hold the formulas. It works in Excel, Google Sheets and Numbers.\u003c\/p\u003e\n\u003ch3\u003eWhat is inside (5 sheets)\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard\u003c\/strong\u003e - seven KPI tiles (occupancy, ADR, RevPAR, revenue, average stay, average lead time, direct share), a property scorecard with source mix, a revenue and pace table (variance $, variance %, pace, Ahead \/ On pace \/ Behind, projected 12-month revenue), an occupancy, ADR and RevPAR vs target table, four trend charts and two heat maps.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInputs\u003c\/strong\u003e - your portfolio name, up to six properties with occupancy, ADR and direct-share targets, the on-pace band, and four booking source names you can rename to your own channels.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly Data\u003c\/strong\u003e - one row per property per month: nights blocked, nights booked, revenue, bookings from each source and average lead time. Available nights, bookings, occupancy, ADR, RevPAR and average stay calculate.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTrend Data\u003c\/strong\u003e - the 12-month table behind the charts. A dropdown on the Dashboard switches every chart between the whole portfolio and a single property.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead Me\u003c\/strong\u003e - how to set it up, every formula in plain words and tips for Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSample data is included (three made-up properties with 12 months of consistent numbers: a lakeside cabin, a downtown loft and a mountain chalet), so every number, flag and chart shows a real result from the first click. Replace it with your own in about 20 minutes.\u003c\/p\u003e\n\u003ch3\u003eFiles you receive\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003ePortfolio-KPI-Dashboard.xlsx - editable workbook\u003c\/li\u003e\n\u003cli\u003ePortfolio-KPI-Dashboard.pdf - printable overview of every sheet\u003c\/li\u003e\n\u003cli\u003eSTART-HERE-How-to-Edit.pdf - editing guide for Excel, Google Sheets and Numbers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eHow it works\u003c\/h3\u003e\n\u003col\u003e\n\u003cli\u003eDownload the ZIP after checkout.\u003c\/li\u003e\n\u003cli\u003eOpen the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.\u003c\/li\u003e\n\u003cli\u003eOn Inputs, list your properties and set your targets.\u003c\/li\u003e\n\u003cli\u003eEach month, type the numbers on Monthly Data and read the Dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch3\u003eFAQ\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eDo I need Canva?\u003c\/strong\u003e No, this is an Excel file.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDoes it connect to any booking site?\u003c\/strong\u003e No. You type or paste numbers from your own reports, so it works with any platform or with direct bookings only, and it does not connect to or scrape anything.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHow many properties can I track?\u003c\/strong\u003e Up to six. Unused rows stay empty and do not appear on the Dashboard.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat do RevPAR and pace mean?\u003c\/strong\u003e RevPAR is revenue divided by available nights. Pace compares your revenue so far with the target for the same months.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDoes it work in Google Sheets?\u003c\/strong\u003e Yes. Upload the file and open it with Google Sheets. The formulas avoid add-in functions.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eLicense:\u003c\/em\u003e personal and single-business use. Please do not resell or redistribute the files. Template only, not legal, tax or financial advice; have a local professional review your numbers. Airbnb, VRBO and Booking.com are trademarks of their respective owners; this product is not affiliated with or endorsed by them.\u003c\/p\u003e","brand":"Welcome Desk Co.","offers":[{"title":"Default Title","offer_id":68054983049468,"sku":"WDC-B8-031","price":4.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/kpi-dashboard__01-hero.jpg?v=1793533657","url":"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-kpi-dashboard","provider":"Welcome Desk Co.","version":"1.0","type":"link"}