OTA PortalHarth Living
Dữ liệu đọc tới 24/09/2026 (số liệu Booking) · PriceLabs 27/09/2026 · nguồn sửa lần cuối 29/09/2026 09:28
Tổng quan › Dữ liệu & báo cáo › Kho dữ liệu

fact_reviews

Booking · 16 dòng · đọc gần nhất 24/09/2026

Tổng quanBáo cáo & auditKho dữ liệuTài liệu kỹ thuậtVề dữ liệu

1Bảng này là gì

Nguồn: metrics/README.md

fact_reviews.csv — từng review một

fact_metrics.csv chỉ giữ hai con số về review (review_count, review_score). Payload gốc có nhiều hơn thế, nên có bảng riêng: ngày ở, sáu điểm thành phần, nhận xét tốt/xấu, quốc tịch, ngôn ngữ, đã trả lời hay chưa.

python3 scripts/ota-reviews-extract.py          # dựng lại từ payload ĐÃ CÓ trong _raw/, không cần mạng
node scripts/ota-read-booking-reviews.mjs --out <dir>   # tải mới, rows=500 nên không sót trang sau

🔴 Điểm thành phần 0 nghĩa là KHÔNG ĐÁNH GIÁ, không phải điểm không. Thang chạy 2,5–10 theo nửa điểm; khách không tiếp xúc hạng mục nào thì ô đó về 0 (vd nhận phòng tự động → không chấm staff). Bảng giữ nguyên 0 vì đó là thứ payload trả về — mọi phép trung bình phải WHERE <cột> > 0, nếu không một ô trống kéo tụt cả danh mục. Đo 23/09/2026: gộp cả ô 0 thì staff ra 9,11 và đội sổ; loại ra thì 9,81 và đứng thứ hai từ trên.

⚠️ Trang reviews.html chỉ nạp 10 review đầu. Căn nào nhiều hơn là bộ cào theo trang mất phần đuôi (alacarte305: pageCount 2, lấy 10/12). Dùng script .mjs ở trên — nó xin thẳng rows=500 qua review/fetch_reviews.json, và phải có &ses=<token> lấy từ tab extranet đang mở, thiếu là Booking đá sang trang đăng nhập dù Chrome vẫn đăng nhập.

Không lưu tên khách và số đặt phòng: lớp này để phân tích, không để liên hệ.

2Từ điển cột (tự đo)

Nguồn: metrics/fact_reviews.csv · Đọc ngày: 24/09/2026
CộtKiểuCó giá trịGiá trị khác nhauVí dụ
snapshot_datengày1612026-09-24
channelchữ161booking
slugchữ16341lehycat, alacarte305, alacarte502
external_idsố16313311503, 14756473, 15668481
review_idsố16165124377906, 5131576150, 5145227309
completed_atngày16162025-01-26 03:21:16, 2025-02-19 13:48:26, 2025-04-09 04:43:27
stay_statuschữ161stayed
countrychữ169au, ca, de
languagechữ165en, ja, ru
scoresố16410.0, 7.0, 8.0
cleansố16210.0, 7.5
comfortsố16310.0, 5.0, 7.5
locationsố16210.0, 7.5
servicessố16210.0, 7.5
staffsố1630.0, 10.0, 7.5
valuesố16210.0, 7.5
titlechữ66Despite of those small detailed obstacles we still think the apparentment and it
positivechữ1111Great host, near the beach and restaurants, I appreciate the host's responsivene
negativechữ77Dirty mirrows and dust in the corners of the doors and A/C holes, broken baseboa
has_replysố1610
anonymoussố1610
source_filechữ16401-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz

3Xem trước (16 dòng cuối)

Nguồn: metrics/fact_reviews.csv · Đọc ngày: 24/09/2026
snapshot_datechannelslugexternal_idreview_idcompleted_atstay_statuscountrylanguagescorecleancomfortlocationservicesstaffvaluetitlepositivenegativehas_replyanonymoussource_file
2026-09-24booking41lehycat1566848153285353182026-08-16 18:25:34stayedinxu10.010.010.010.010.010.010.0Excellent stay with elevator, pool and sauna roomStay is very close to a river and close to My Khe beach and airport as well. In itself, place has a pool, sauna room and a proper kitchen. My family enjoyed all the services provided by the stay thoroughly. Overall a 10/10 stay.Nothing at all. Stay was perfect0001-admin.booking.com_hotel_hoteladmin_extranet__018-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150351243779062025-01-26 03:21:16stayedauen7.010.07.57.510.010.07.500alacarte305-13311503.json
2026-09-24bookingalacarte3051331150351315761502025-02-19 13:48:26stayedcaxu8.010.010.010.010.07.510.0Very nice place to stay, good view. Just a bit weird how the rooms are not affiliated with the hotel that they’re in so the people at the front desk cannot help you with anything and you have to organize a meeting with someone to pay and you can’t freely use the facilities in the building.00alacarte305-13311503.json
2026-09-24bookingalacarte3051331150351452273092025-04-09 04:43:27stayedvnvi8.07.57.57.57.50.07.50001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150352468707912026-01-02 15:08:37stayedgben8.010.010.010.07.510.010.0Great host, near the beach and restaurants0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150352480536372026-01-05 04:11:30stayedtten9.010.010.010.010.07.510.0Impeccable apartment. Comfortable stay.I appreciate the host's responsiveness and we absolutely enjoyed an extremely comfortable stay. The beds were comfortable, and the apartment was pristinely clean. The location was prime with access to many restaurants, cafe, streetfood vendors, pharmacies, supermarkets. The staff were also quite professional. We would certainly stay at this listing and would highly recommend it to our friends and family.We had no complaints0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150352693643562026-03-20 16:48:25stayeddeen9.010.07.510.010.010.010.0Despite of those small detailed obstacles we still think the apparentment and its prices were really great and worth. IfPrice was worthy for the location, facilities and airport pick-up. The staff were really nice and helpful. Though the apartment does not belong to (but private managed) the hotel but even the hotel staff were friendly and helpful in any cases. There are two separated bathrooms and it was for us the highlight. At the balcony of the living room we can see the sea very well and it is not too loud even though it locates directly at the main streets.Since we have a small child, it is obvious that the floor is not so clean. My child seemed to collect dirt on the floor quite well. But it is just a tiny problem. But we don’t like and don’t understand, why there is no way to get fresh air in one bed room and there is no window in the other room. It was quite difficult to fresh up the apartment since we do not like turning on the air condition all the time.0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150352851977502026-05-07 04:03:12stayedgben10.010.010.010.010.010.010.0Would come back to stay anytimeThe facilities were excellentNothing0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150352940945492026-05-31 21:38:47stayedruen7.07.55.010.07.510.07.5Location and the zone is good, several good restaurants nearby, also a morning market. Rooms are independent, 2 bathrooms.Dirty mirrows and dust in the corners of the doors and A/C holes, broken baseboard. No room service during a week while promised a couple of times.0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150353039066952026-06-26 07:37:11stayedruru9.010.07.510.010.010.010.0Приятные апартаменты, очень отзывчивые хозяева, есть трансфер от аэропорта, за что отдельное спасибо! Нам всё понравилосОчень близко к пляжу, большая площадь апартаментов (мы брали с двумя спальнями). Есть все необходимое: большие бутыли с водой, посуда, моющие/чистящие, куча вешалок и полотенец.В одной спальне в душе очень маленькая перегородка, но это вина застройщика. После переселились в другие апарты в этом же здании, там то же самое. Соответственно, когда ты моешься, то вода заливает весь санузел.0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150353068966782026-07-03 05:42:54stayedauen10.010.010.010.010.010.010.0Location, clean.Nothing to report.0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150353380797312026-09-05 16:20:57stayedruru10.010.010.010.010.010.010.0Современные чистые апартаменты. Жили две недели семьёй 4 человека, удобно ходить на пляж, вид на море только с балкона, апарты расположены с торца здания, уборка по запросу, есть питьевая вода в бутылях. Из минусов, музон от ежедневной дискотеки до 22:00, бассейн на крыше платный, не хватает стиральной машины. Это частные апартаменты и к гостинице они не относятся. Но в целом, все понравилось, прижились:)), за все время поймал штук пять муравьев и одного таракана, хороший результат. Для первой линии цена просто класс. Спасибо хозяйке. Что можно улучшить. Поставить диспенсер (крантик в бутылке так себе решение) и стиральную машину.0001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte3051331150353453917762026-09-23 02:56:58stayedjpja10.010.010.010.010.010.010.00001-admin.booking.com_hotel_hoteladmin_extranet__006-review_fetch_reviews.json.gz
2026-09-24bookingalacarte5021475647353099417412026-07-10 09:25:14stayedvnvi9.010.010.010.010.010.010.00005-admin.booking.com_hotel_hoteladmin_extranet__049-review_fetch_reviews.json.gz
2026-09-24bookingalacarte5021475647353392593642026-09-08 03:58:05stayedruru10.010.010.010.010.010.010.00005-admin.booking.com_hotel_hoteladmin_extranet__049-review_fetch_reviews.json.gz
2026-09-24bookingalacarte5021475647353421607892026-09-15 04:12:18stayedgben10.010.010.010.010.010.010.0Great place to stay 5 stars to the hotel and staff be booking here again in 8 monthsThe property was perfect and I had a a amazing time0005-admin.booking.com_hotel_hoteladmin_extranet__049-review_fetch_reviews.json.gz

4Tải về

CSV · JSON