{"product_id":"airbnb-review-rating-tracker","title":"Airbnb Review Tracker Spreadsheet – Rating \u0026 Review Log with Category Scores, Trend Chart, Issue Tally \u0026 Response Status, Excel, No Canva","description":"\u003cp\u003e\u003cstrong\u003eReview \u0026amp; Rating Tracker\u003c\/strong\u003e is an Excel and Google Sheets workbook that turns your guest reviews into numbers you can act on. Log every review once, with its overall score and six category scores, and the workbook shows your rolling averages, a 12-month trend chart, the issues guests mention most, your weakest category and how fast you reply.\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 (6 sheets)\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eReviews\u003c\/strong\u003e - 100 rows (60 filled with sample reviews): date, platform dropdown, guest, property, overall score 1 to 5, six category scores (cleanliness, accuracy, check-in, communication, location, value), keywords, sentiment dropdown (Positive, Neutral, Negative), main issue dropdown (None, Cleanliness, Noise, Wi-Fi, Check-in, Amenities, Comfort, Communication, Value, Other), response status dropdown (Replied, Pending, Not needed) and the response date. Calculated for you: category average, days to respond (blank-safe) and a review number. AutoFilter is switched on, and low scores, negative sentiment and pending replies are highlighted.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRolling Averages\u003c\/strong\u003e - the average of your last 10 and last 20 reviews, the change against the 10 before, and a table of the last 12 months with reviews, average overall rating and 5-star share, with a line chart of the monthly average. Month names have no year in them, so the table never goes out of date.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eIssue Tally\u003c\/strong\u003e - how many reviews mention each issue, the share of all reviews, the average rating of reviews with that issue and your reply rate for them, a bar chart and a top issue that finds itself.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCategory Scores\u003c\/strong\u003e - the average of each of the six categories, the gap against your overall average, scores below 4, a rank, the lowest and highest category and a column chart.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard\u003c\/strong\u003e - overall average, last 10 average, 5-star share, review count, response rate, average days to respond, pending replies, top issue, lowest category, your last 5 reviews with the newest first, a monthly rating chart and an issue chart.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead Me\u003c\/strong\u003e - how to use the workbook, how to change the dropdown lists and what the colors mean.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSample data is included (60 made-up reviews for two homes over 12 months), so every flag, average and chart shows real numbers from the first click. Replace it with your own reviews.\u003c\/p\u003e\n\u003ch3\u003eFiles you receive\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eReview-Rating-Tracker.xlsx - editable workbook\u003c\/li\u003e\n\u003cli\u003eReview-Rating-Tracker.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\u003eReplace the sample reviews with your own, newest last.\u003c\/li\u003e\n\u003cli\u003eCheck the Dashboard for your average, trend, top issue and the replies you still owe.\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 import my reviews automatically?\u003c\/strong\u003e No. You type or paste each review's scores, so it works with any booking site and does not connect to or scrape any platform.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCan I track more than one property?\u003c\/strong\u003e Yes. The Property column lets you filter by home. The averages cover all rows, so use one copy of the file per property if you want separate numbers.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat if a platform has no category scores?\u003c\/strong\u003e Leave those cells empty. The category average and the Category Scores sheet only count the scores you enter.\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. 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":68026644136188,"sku":"WDC-B7-039","price":4.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/review-rating-tracker__01-hero.jpg?v=1793190739","url":"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-review-rating-tracker","provider":"Welcome Desk Co.","version":"1.0","type":"link"}