Harthliving OTA · bản chữ cho AI · dựng từ vault (nguồn sửa lần cuối 29/09/2026 09:28) · mục lục: https://harthliving-ota.pages.dev/ai/index.txt # Harthliving OTA — toàn bộ nội dung, Phần 28/35 · tiếp: https://harthliving-ota.pages.dev/ai/full/part-29.txt Trong phần này: fact_agoda_summary · fact_agoda_summary · fact_agoda_transactions · fact_agoda_transactions · fact_funnel · fact_funnel --- # fact_agoda_summary URL: https://harthliving-ota.pages.dev/library/data/fact-agoda-summary/ [Tổng quan](https://harthliving-ota.pages.dev/) › [Dữ liệu & báo cáo](https://harthliving-ota.pages.dev/library/) › [Kho dữ liệu](https://harthliving-ota.pages.dev/library/data/) # fact_agoda_summary Agoda · 84 dòng · đọc gần nhất 24/09/2026 ## Bảng này là gì Nguồn: `metrics-agoda/README.md` 🔴 README chưa có mục riêng cho bảng này. ## Từ điển cột (tự đo) Nguồn: `metrics-agoda/fact_agoda_summary.csv` · Đọc ngày: **24/09/2026** | Cột | Kiểu | Có giá trị | Giá trị khác nhau | Ví dụ | |---|---|---|---|---| | `snapshot_date` | ngày | 84 | 1 | 2026-09-24 | | `channel` | chữ | 84 | 1 | agoda | | `slug` | chữ | 84 | 7 | 15nuocman5, 181tohienthanh, 25anthuong11 | | `external_id` | số | 84 | 7 | 63382515, 84463560, 84463562 | | `metric` | chữ | 84 | 3 | bookings, revenue, room_nights | | `unit` | chữ | 84 | 3 | VND, count, nights | | `period_type` | số | 84 | 4 | 0, 1, 2 | | `period_label` | chữ | 21 | 1 | booked so far this month | | `value` | số | 84 | 18 | 0, 1, 10 | ## Xem trước (84 dòng cuối) Nguồn: `metrics-agoda/fact_agoda_summary.csv` · Đọc ngày: **24/09/2026** | snapshot_date | channel | slug | external_id | metric | unit | period_type | period_label | value | |---|---|---|---|---|---|---|---|---| | 2026-09-24 | agoda | 15nuocman5 | 84463562 | bookings | count | 0 | | 0 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | bookings | count | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | bookings | count | 2 | | 2 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | bookings | count | 3 | | 3 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | revenue | VND | 0 | | 0 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | revenue | VND | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | revenue | VND | 2 | | 29016656 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | revenue | VND | 3 | | 36520736 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | room_nights | nights | 0 | | 0 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | room_nights | nights | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | room_nights | nights | 2 | | 9 | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | room_nights | nights | 3 | | 11 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | bookings | count | 0 | | 2 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | bookings | count | 1 | booked so far this month | 1 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | bookings | count | 2 | | 5 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | bookings | count | 3 | | 10 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | revenue | VND | 0 | | 10985742 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | revenue | VND | 1 | booked so far this month | 8235937.5 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | revenue | VND | 2 | | 39167804 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | revenue | VND | 3 | | 111993840 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | room_nights | nights | 0 | | 4 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | room_nights | nights | 1 | booked so far this month | 3 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | room_nights | nights | 2 | | 14 | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | room_nights | nights | 3 | | 37 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | bookings | count | 0 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | bookings | count | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | bookings | count | 2 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | bookings | count | 3 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | revenue | VND | 0 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | revenue | VND | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | revenue | VND | 2 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | revenue | VND | 3 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | room_nights | nights | 0 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | room_nights | nights | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | room_nights | nights | 2 | | 0 | | 2026-09-24 | agoda | 25anthuong11 | 96450982 | room_nights | nights | 3 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | bookings | count | 0 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | bookings | count | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | bookings | count | 2 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | bookings | count | 3 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | revenue | VND | 0 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | revenue | VND | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | revenue | VND | 2 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | revenue | VND | 3 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | room_nights | nights | 0 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | room_nights | nights | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | room_nights | nights | 2 | | 0 | | 2026-09-24 | agoda | 41lehycat | 84463560 | room_nights | nights | 3 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | bookings | count | 0 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | bookings | count | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | bookings | count | 2 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | bookings | count | 3 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | revenue | VND | 0 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | revenue | VND | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | revenue | VND | 2 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | revenue | VND | 3 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | room_nights | nights | 0 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | room_nights | nights | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | room_nights | nights | 2 | | 0 | | 2026-09-24 | agoda | alacarte305 | 63382515 | room_nights | nights | 3 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | bookings | count | 0 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | bookings | count | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | bookings | count | 2 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | bookings | count | 3 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | revenue | VND | 0 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | revenue | VND | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | revenue | VND | 2 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | revenue | VND | 3 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | room_nights | nights | 0 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | room_nights | nights | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | room_nights | nights | 2 | | 0 | | 2026-09-24 | agoda | alacarte404 | 84510952 | room_nights | nights | 3 | | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | bookings | count | 0 | | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | bookings | count | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | bookings | count | 2 | | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | bookings | count | 3 | | 1 | | 2026-09-24 | agoda | alacarte502 | 84463577 | revenue | VND | 0 | | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | revenue | VND | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | revenue | VND | 2 | | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | revenue | VND | 3 | | 6240000 | | 2026-09-24 | agoda | alacarte502 | 84463577 | room_nights | nights | 0 | | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | room_nights | nights | 1 | booked so far this month | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | room_nights | nights | 2 | | 0 | | 2026-09-24 | agoda | alacarte502 | 84463577 | room_nights | nights | 3 | | 4 | ## Tải về [CSV](https://harthliving-ota.pages.dev/data/fact-agoda-summary.csv) · [JSON](https://harthliving-ota.pages.dev/data/fact-agoda-summary.json) --- # fact_agoda_transactions URL: https://harthliving-ota.pages.dev/library/data/fact-agoda-transactions/ [Tổng quan](https://harthliving-ota.pages.dev/) › [Dữ liệu & báo cáo](https://harthliving-ota.pages.dev/library/) › [Kho dữ liệu](https://harthliving-ota.pages.dev/library/data/) # fact_agoda_transactions Agoda · 28 dòng · đọc gần nhất 24/09/2026 ## Bảng này là gì Nguồn: `metrics-agoda/README.md` 🔴 README chưa có mục riêng cho bảng này. ## Từ điển cột (tự đo) Nguồn: `metrics-agoda/fact_agoda_transactions.csv` · Đọc ngày: **24/09/2026** | Cột | Kiểu | Có giá trị | Giá trị khác nhau | Ví dụ | |---|---|---|---|---| | `snapshot_date` | ngày | 28 | 1 | 2026-09-24 | | `channel` | chữ | 28 | 1 | agoda | | `slug` | chữ | 28 | 4 | 15nuocman5, 181tohienthanh, alacarte305 | | `external_id` | số | 28 | 4 | 63382515, 84463562, 84463574 | | `transaction_id` | số | 28 | 28 | 10330703988, 10496353526, 10530884449 | | `reference_number` | chữ | 28 | 25 | 1558664156, 1609038648, 1647763853 | | `transaction_type` | chữ | 28 | 2 | Adjustment, Reservation | | `is_adjustment` | số | 28 | 2 | 0, 1 | | `created_date` | ngày | 28 | 23 | 2025-03-06, 2025-05-08, 2025-09-07 | | `checkin` | ngày | 28 | 22 | 2025-03-18, 2025-05-26, 2025-10-31 | | `checkout` | ngày | 28 | 23 | 2025-03-20, 2025-05-28, 2025-11-20 | | `booking_value` | số | 28 | 17 | -4438157.9, -532000.0, 0.0 | | `collection_amount` | số | 28 | 17 | -4438157.9, -532000.0, 0.0 | | `currency` | chữ | 28 | 1 | VND | | `payment_method` | chữ | 28 | 1 | Telex Transfer | ## Xem trước (28 dòng cuối) Nguồn: `metrics-agoda/fact_agoda_transactions.csv` · Đọc ngày: **24/09/2026** | snapshot_date | channel | slug | external_id | transaction_id | reference_number | transaction_type | is_adjustment | created_date | checkin | checkout | booking_value | collection_amount | currency | payment_method | |---|---|---|---|---|---|---|---|---|---|---|---|---|---|---| | 2026-09-24 | agoda | 15nuocman5 | 84463562 | 10496353526 | 1739184041 | Reservation | 0 | 2026-06-19 | 2026-06-26 | 2026-06-28 | 7504000.0 | 7504000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | 10716866751 | 1750220315 | Reservation | 0 | 2026-07-21 | 2026-08-02 | 2026-08-06 | 12895760.0 | 12895760.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | 10719425744 | 2017336129-11079 | Adjustment | 1 | 2026-07-21 | 2026-07-21 | 2026-07-21 | -4438157.9 | -4438157.9 | VND | Telex Transfer | | 2026-09-24 | agoda | 15nuocman5 | 84463562 | 10993681288 | 1743114920 | Reservation | 0 | 2026-07-01 | 2026-07-16 | 2026-07-21 | 16119703.8 | 16119703.8 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10330703988 | 1731187602 | Reservation | 0 | 2026-05-26 | 2026-06-15 | 2026-06-20 | 18000000.0 | 18000000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10530884449 | 2017336129 | Reservation | 0 | 2026-05-30 | 2026-07-10 | 2026-07-13 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10538254719 | 1740896512 | Reservation | 0 | 2026-06-24 | 2026-07-10 | 2026-07-12 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10543750985 | 2021076598 | Reservation | 0 | 2026-06-10 | 2026-07-16 | 2026-07-20 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10577667623 | 2028258226 | Reservation | 0 | 2026-07-01 | 2026-07-15 | 2026-07-20 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10676898443 | 2017336129-11079 | Adjustment | 1 | 2026-07-15 | 2026-07-15 | 2026-07-15 | -4438157.9 | -4438157.9 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10719423231 | 2017336129-11079 | Adjustment | 1 | 2026-07-21 | 2026-07-21 | 2026-07-21 | 4438157.9 | 4438157.9 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10770689755 | 1754586651 | Reservation | 0 | 2026-07-28 | 2026-09-04 | 2026-09-07 | 8248890.0 | 8248890.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10849371105 | 1759236001 | Reservation | 0 | 2026-08-08 | 2026-12-26 | 2026-12-30 | 10998520.0 | 10998520.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10883945606 | 1761214569 | Reservation | 0 | 2026-08-13 | 2026-08-30 | 2026-09-02 | 8936298.0 | 8936298.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10953911633 | 988554310 | Reservation | 0 | 2026-04-06 | 2026-08-17 | 2026-08-24 | -532000.0 | -532000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 10978198338 | 1766609131 | Reservation | 0 | 2026-08-26 | 2026-09-18 | 2026-09-19 | 2749630.0 | 2749630.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 11071059358 | 1771814012 | Reservation | 0 | 2026-09-08 | 2026-10-20 | 2026-10-23 | 8248890.0 | 8248890.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 9677584332 | 1700138196 | Reservation | 0 | 2026-02-19 | 2026-02-19 | 2026-02-20 | 3200000.0 | 3200000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 9677873853 | 1700156672 | Reservation | 0 | 2026-02-19 | 2026-04-15 | 2026-04-18 | 9600000.0 | 9600000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 9731473738 | 632865171 | Reservation | 0 | 2026-02-27 | 2026-03-06 | 2026-03-13 | 21280000.0 | 21280000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | 181tohienthanh | 84463574 | 9993122865 | 988554310 | Reservation | 0 | 2026-04-06 | 2026-08-17 | 2026-08-24 | 21280000.0 | 21280000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | alacarte305 | 63382515 | 7506448239 | 1558664156 | Reservation | 0 | 2025-03-06 | 2025-03-18 | 2025-03-20 | 2980000.0 | 2980000.0 | VND | Telex Transfer | | 2026-09-24 | agoda | alacarte305 | 63382515 | 7880119913 | 1609038648 | Reservation | 0 | 2025-05-08 | 2025-05-26 | 2025-05-28 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | alacarte305 | 63382515 | 8617612639 | 1647763853 | Reservation | 0 | 2025-09-07 | 2025-10-31 | 2025-11-20 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | alacarte305 | 63382515 | 9055132385 | 1953782804 | Reservation | 0 | 2025-11-17 | 2026-01-20 | 2026-01-23 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | alacarte305 | 63382515 | 9200181058 | 1676580203 | Reservation | 0 | 2025-12-08 | 2026-03-26 | 2026-03-28 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | alacarte305 | 63382515 | 9243325056 | 944491738 | Reservation | 0 | 2025-12-15 | 2026-02-07 | 2026-02-13 | 0.0 | 0.0 | VND | Telex Transfer | | 2026-09-24 | agoda | alacarte502 | 84463577 | 10954292212 | 2025001589 | Reservation | 0 | 2026-06-22 | 2026-07-16 | 2026-07-20 | 6240000.0 | 6240000.0 | VND | Telex Transfer | ## Tải về [CSV](https://harthliving-ota.pages.dev/data/fact-agoda-transactions.csv) · [JSON](https://harthliving-ota.pages.dev/data/fact-agoda-transactions.json) --- # fact_funnel URL: https://harthliving-ota.pages.dev/library/data/fact-funnel/ [Tổng quan](https://harthliving-ota.pages.dev/) › [Dữ liệu & báo cáo](https://harthliving-ota.pages.dev/library/) › [Kho dữ liệu](https://harthliving-ota.pages.dev/library/data/) # fact_funnel Booking · 35 dòng · đọc gần nhất 24/09/2026 ## Bảng này là gì Nguồn: `metrics/README.md` #### `fact_funnel.csv` — phễu theo KỲ Cùng dữ liệu phễu với `fact_metrics` nhưng ở dạng **rộng** (một dòng đọc thẳng được) và có thêm chiều **kỳ**: Ranking Dashboard cho chọn **30 · 60 · 90 · 365 ngày**, mỗi kỳ một dòng. `node scripts/ota-read-booking-funnel.mjs # đổi bộ chọn kỳ, bắt response, lưu payload thô python3 scripts/ota-funnel-extract.py # nạp vào bảng ` | Cột | Nghĩa | |---|---| | `period_days` · `period_label` | kỳ Booking đo; `(dò ngược)` là dòng suy ra trước khi biết có bộ chọn kỳ | | `window_start` · `window_end` · `lag_days` | chỉ có ở dòng dò ngược — dashboard **có độ trễ ~7–11 ngày** | | `window_method` | `declared-by-booking` · `derived-exact` · `derived-approx` · `unknown` | | `window_ambiguity_days` | biên xê dịch được bao nhiêu ngày mà vẫn khớp; `0` là chắc | | `` + `_peer` | số của mình và của comp set, cùng thang | | `rank_total` | tổng số chỗ nghỉ ở thành phố — **mẫu số của hạng, KHÔNG phải mức đối chuẩn** | 🔴 **Các kỳ CHỒNG lên nhau.** Kỳ 90 ngày đã bao trùm kỳ 30 ngày — **trừ kỳ này cho kỳ kia rồi đọc thành "hai tháng trước" là sai**, vì không biết phần chênh rơi vào ngày nào. 🔴 **`bookings` đếm đơn ĐƯỢC ĐẶT trong kỳ, GỒM CẢ đơn sau này huỷ.** Nên `conversion` ở đây là chuyển đổi sang *lượt đặt*, không phải sang *đêm ở*. Với tỷ lệ huỷ 53% của danh mục, hai thứ đó cách nhau rất xa — muốn con số thật thì nối sang `fact_reservations` qua `(slug, booked_at)` và lọc `status = 'ok'`. ⚠️ **365 ngày là trần.** Xa hơn Booking không phục vụ. Muốn chuỗi thời gian thật của phễu thì phải **tự tích luỹ qua từng mốc cào hằng tuần** — khác hẳn doanh thu, vốn có sẵn chuỗi tháng lùi tới 2023-06. ## Từ điển cột (tự đo) Nguồn: `metrics/fact_funnel.csv` · Đọc ngày: **24/09/2026** | Cột | Kiểu | Có giá trị | Giá trị khác nhau | Ví dụ | |---|---|---|---|---| | `snapshot_date` | ngày | 35 | 2 | 2026-09-23, 2026-09-24 | | `channel` | chữ | 35 | 1 | booking | | `slug` | chữ | 35 | 7 | 15nuocman5, 181tohienthanh, 25anthuong11 | | `external_id` | số | 35 | 7 | 13311503, 14740288, 14756473 | | `period_days` | số | 35 | 4 | 30, 365, 60 | | `period_label` | chữ | 35 | 5 | Last 30 days, Last 30 days (dò ngược), Last 365 days | | `window_start` | ngày | 7 | 1 | 2026-08-17 | | `window_end` | ngày | 7 | 1 | 2026-09-12 | | `window_days` | chữ | 35 | 5 | 27–31, 30, 365 | | `lag_days` | số | 7 | 1 | 7 | | `window_method` | chữ | 35 | 2 | declared-by-booking, derived-exact | | `window_mismatch` | số | 7 | 1 | 0 | | `window_ambiguity_days` | số | 7 | 1 | 4 | | `search_impressions` | số | 35 | 33 | 10260, 10260.0, 10907 | | `search_impressions_peer` | số | 35 | 35 | 103436.93622056446, 133694.66691032506, 13803.906670503648 | | `page_views` | số | 35 | 33 | 1171, 138, 138.0 | | `page_views_peer` | số | 35 | 35 | 1123.7177832832172, 1168.2174136073852, 1456.3790318649712 | | `bookings` | số | 35 | 17 | 0, 0.0, 1 | | `bookings_peer` | số | 35 | 32 | 1.0, 1.1190932930429576, 1.120197087522092 | | `ctr` | số | 35 | 33 | 0.004828592061851291, 0.006555975201311195, 0.007849588719153937 | | `ctr_peer` | số | 35 | 35 | 0.01017526739514728, 0.0102, 0.010467976931426889 | | `conversion` | số | 35 | 27 | 0, 0.0, 0.0012953367875647669 | | `conversion_peer` | số | 35 | 35 | 0.0054, 0.005449671638907308, 0.0064 | | `rank_in_city` | số | 7 | 7 | 1039, 1228, 1483 | | `rank_total` | số | 7 | 1 | 3241 | | `property_page_score` | số | 7 | 3 | 0.7011, 0.7215, 1.0 | ## Xem trước (35 dòng cuối) Nguồn: `metrics/fact_funnel.csv` · Đọc ngày: **24/09/2026** | snapshot_date | channel | slug | external_id | period_days | period_label | window_start | window_end | window_days | lag_days | window_method | window_mismatch | window_ambiguity_days | search_impressions | search_impressions_peer | page_views | page_views_peer | bookings | bookings_peer | ctr | ctr_peer | conversion | conversion_peer | rank_in_city | rank_total | property_page_score | |---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---| | 2026-09-23 | booking | 15nuocman5 | 15668679 | 30 | Last 30 days (dò ngược) | 2026-08-17 | 2026-09-12 | 27–31 | 7 | derived-exact | 0 | 4 | 4964.0 | 7659.0 | 138.0 | 174.0 | 0.0 | 1.0 | 0.0278 | 0.022799999999999997 | 0.0 | 0.0064 | 1657 | 3241 | 0.7215 | | 2026-09-23 | booking | 181tohienthanh | 14740288 | 30 | Last 30 days (dò ngược) | 2026-08-17 | 2026-09-12 | 27–31 | 7 | derived-exact | 0 | 4 | 7520.0 | 8792.0 | 187.0 | 206.0 | 5.0 | 1.0 | 0.024900000000000002 | 0.0233 | 0.026699999999999998 | 0.0054 | 1483 | 3241 | 1.0 | | 2026-09-23 | booking | 25anthuong11 | 16927056 | 30 | Last 30 days (dò ngược) | 2026-08-17 | 2026-09-12 | 27–31 | 7 | derived-exact | 0 | 4 | 10907.0 | 8857.0 | 239.0 | 274.0 | 1.0 | 3.0 | 0.0219 | 0.031 | 0.0042 | 0.0102 | 1493 | 3241 | 0.7011 | | 2026-09-23 | booking | 41lehycat | 15668481 | 30 | Last 30 days (dò ngược) | 2026-08-17 | 2026-09-12 | 27–31 | 7 | derived-exact | 0 | 4 | 8249.0 | 9772.0 | 86.0 | 209.0 | 4.0 | 2.0 | 0.0104 | 0.0206 | 0.04650000000000001 | 0.011699999999999999 | 1619 | 3241 | 1.0 | | 2026-09-23 | booking | alacarte305 | 13311503 | 30 | Last 30 days (dò ngược) | 2026-08-17 | 2026-09-12 | 27–31 | 7 | derived-exact | 0 | 4 | 20817.0 | 28107.0 | 278.0 | 477.0 | 5.0 | 25.0 | 0.0134 | 0.017 | 0.018000000000000002 | 0.0526 | 1039 | 3241 | 1.0 | | 2026-09-23 | booking | alacarte404 | 15702704 | 30 | Last 30 days (dò ngược) | 2026-08-17 | 2026-09-12 | 27–31 | 7 | derived-exact | 0 | 4 | 6400.0 | 6948.0 | 211.0 | 73.0 | 0.0 | 2.0 | 0.033 | 0.0102 | 0.0 | 0.026099999999999998 | 1855 | 3241 | 1.0 | | 2026-09-23 | booking | alacarte502 | 14756473 | 30 | Last 30 days (dò ngược) | 2026-08-17 | 2026-09-12 | 27–31 | 7 | derived-exact | 0 | 4 | 10260.0 | 9779.0 | 159.0 | 176.0 | 0.0 | 2.0 | 0.0155 | 0.018000000000000002 | 0.0 | 0.0127 | 1228 | 3241 | 1.0 | | 2026-09-24 | booking | 15nuocman5 | 15668679 | 30 | Last 30 days | | | 30 | | declared-by-booking | | | 4964 | 7659.339402911774 | 138 | 174.32092387563577 | 0 | 1.1190932930429576 | 0.027800161160354553 | 0.022759263522042897 | 0 | 0.006419730162979989 | | | | | 2026-09-24 | booking | 15nuocman5 | 15668679 | 365 | Last 365 days | | | 365 | | declared-by-booking | | | 83220 | 89679.75784282005 | 1544 | 1123.7177832832172 | 2 | 11.509811589704537 | 0.01855323239605864 | 0.012530339179246393 | 0.0012953367875647669 | 0.010242617640236856 | | | | | 2026-09-24 | booking | 15nuocman5 | 15668679 | 60 | Last 60 days | | | 60 | | declared-by-booking | | | 16566 | 22284.414761199907 | 404 | 381.02851370815296 | 1 | 3.396581332545441 | 0.024387299287697693 | 0.01709843035104398 | 0.0024752475247524753 | 0.008914244499683394 | | | | | 2026-09-24 | booking | 15nuocman5 | 15668679 | 90 | Last 90 days | | | 90 | | declared-by-booking | | | 26689 | 36406.08589229238 | 689 | 595.563780909677 | 1 | 6.23462300834923 | 0.025815879201169022 | 0.016358907207757956 | 0.001451378809869376 | 0.010468438827536375 | | | | | 2026-09-24 | booking | 181tohienthanh | 14740288 | 30 | Last 30 days | | | 30 | | declared-by-booking | | | 7520 | 8792.14642728179 | 187 | 205.55313452733057 | 5 | 1.120197087522092 | 0.024867021276595746 | 0.023288120633518906 | 0.026737967914438502 | 0.005449671638907308 | | | | | 2026-09-24 | booking | 181tohienthanh | 14740288 | 365 | Last 365 days | | | 365 | | declared-by-booking | | | 147069 | 97611.20936115115 | 2282 | 1544.4896648798551 | 32 | 29.594848300109902 | 0.015516526256383058 | 0.015822871932314728 | 0.014022787028921999 | 0.019161570953219728 | | | | | 2026-09-24 | booking | 181tohienthanh | 14740288 | 60 | Last 60 days | | | 60 | | declared-by-booking | | | 21946 | 28356.02925134046 | 447 | 516.9596889495832 | 9 | 9.199727017395205 | 0.020368176433062973 | 0.01817597862429277 | 0.020134228187919462 | 0.017795830533882135 | | | | | 2026-09-24 | booking | 181tohienthanh | 14740288 | 90 | Last 90 days | | | 90 | | declared-by-booking | | | 34105 | 46325.12009883675 | 709 | 800.3275154136323 | 16 | 17.876820048028296 | 0.02078874065386307 | 0.017276318198551827 | 0.022566995768688293 | 0.022336880469227702 | | | | | 2026-09-24 | booking | 25anthuong11 | 16927056 | 30 | Last 30 days | | | 30 | | declared-by-booking | | | 10907 | 8857.474732259298 | 239 | 274.43761552552115 | 1 | 2.797794799196434 | 0.02191253323553681 | 0.030983731122145655 | 0.0041841004184100415 | 0.010194647675534314 | | | | | 2026-09-24 | booking | 25anthuong11 | 16927056 | 365 | Last 365 days | | | 365 | | declared-by-booking | | | 33662 | 92026.13258500017 | 368 | 1536.0282678140218 | 4 | 18.419696303445438 | 0.010932208424930189 | 0.016691218294925796 | 0.010869565217391304 | 0.011991769090069666 | | | | | 2026-09-24 | booking | 25anthuong11 | 16927056 | 60 | Last 60 days | | | 60 | | declared-by-booking | | | 33662 | 22394.061802656277 | 368 | 554.4855601639008 | 4 | 7.193448273042874 | 0.010932208424930189 | 0.024760383580710237 | 0.010869565217391304 | 0.012973193153878628 | | | | | 2026-09-24 | booking | 25anthuong11 | 16927056 | 90 | Last 90 days | | | 90 | | declared-by-booking | | | 33662 | 35082.81263475326 | 368 | 840.2730968826115 | 4 | 11.70692991942647 | 0.010932208424930189 | 0.023951132585368358 | 0.010869565217391304 | 0.013932291730937043 | | | | | 2026-09-24 | booking | 41lehycat | 15668481 | 30 | Last 30 days | | | 30 | | declared-by-booking | | | 8249 | 9772.466420583412 | 86 | 209.2217141756665 | 4 | 2.4397145521366337 | 0.010425506121954177 | 0.020628426202900778 | 0.046511627906976744 | 0.011660905091754497 | | | | | 2026-09-24 | booking | 41lehycat | 15668481 | 365 | Last 365 days | | | 365 | | declared-by-booking | | | 70621 | 147617.6085294575 | 341 | 2263.4525057700453 | 5 | 32.71399634726581 | 0.004828592061851291 | 0.01533321484014129 | 0.01466275659824047 | 0.01445314017584665 | | | | | 2026-09-24 | booking | 41lehycat | 15668481 | 60 | Last 60 days | | | 60 | | declared-by-booking | | | 21275 | 25419.895786253914 | 167 | 473.4458605608235 | 5 | 6.022973541307562 | 0.007849588719153937 | 0.01792452690827868 | 0.029940119760479042 | 0.012721567644868639 | | | | | 2026-09-24 | booking | 41lehycat | 15668481 | 90 | Last 90 days | | | 90 | | declared-by-booking | | | 28066 | 36996.620382913214 | 184 | 729.3308045883425 | 5 | 8.414613457000813 | 0.006555975201311195 | 0.01889179190644561 | 0.02717391304347826 | 0.011537444194133948 | | | | | 2026-09-24 | booking | alacarte305 | 13311503 | 30 | Last 30 days | | | 30 | | declared-by-booking | | | 20817 | 28106.97633400745 | 278 | 476.68959537999336 | 5 | 25.06730434551198 | 0.013354469904405053 | 0.01695983195471769 | 0.017985611510791366 | 0.052586220862508165 | | | | | 2026-09-24 | booking | alacarte305 | 13311503 | 365 | Last 365 days | | | 365 | | declared-by-booking | | | 172617 | 306998.1025716552 | 1832 | 5127.802953910992 | 76 | 215.5058951464549 | 0.010613091410463628 | 0.016703044451925015 | 0.04148471615720524 | 0.042026945474199204 | | | | | 2026-09-24 | booking | alacarte305 | 13311503 | 60 | Last 60 days | | | 60 | | declared-by-booking | | | 49068 | 79916.07267408808 | 520 | 1168.2174136073852 | 13 | 61.44909520133138 | 0.010597538110377435 | 0.01461805334668513 | 0.025 | 0.05260073551855409 | | | | | 2026-09-24 | booking | alacarte305 | 13311503 | 90 | Last 90 days | | | 90 | | declared-by-booking | | | 59540 | 133694.66691032506 | 643 | 1963.2711250362515 | 16 | 101.7508974690561 | 0.010799462546187437 | 0.01468473777157547 | 0.024883359253499222 | 0.051827226597231844 | | | | | 2026-09-24 | booking | alacarte404 | 15702704 | 30 | Last 30 days | | | 30 | | declared-by-booking | | | 6400 | 6948.0569517093045 | 211 | 73.31233968689536 | 0 | 1.91377345126298 | 0.03296875 | 0.01017526739514728 | 0 | 0.026104383783635658 | | | | | 2026-09-24 | booking | alacarte404 | 15702704 | 365 | Last 365 days | | | 365 | | declared-by-booking | | | 63060 | 34695.991969808296 | 1171 | 363.1968435529258 | 2 | 5.672060786800504 | 0.018569616238503013 | 0.010467976931426889 | 0.0017079419299743809 | 0.015617043175029573 | | | | | 2026-09-24 | booking | alacarte404 | 15702704 | 60 | Last 60 days | | | 60 | | declared-by-booking | | | 13500 | 13803.906670503648 | 318 | 147.96313698596447 | 0 | 3.155042088617335 | 0.023555555555555555 | 0.010667315912964536 | 0 | 0.02132316300455712 | | | | | 2026-09-24 | booking | alacarte404 | 15702704 | 90 | Last 90 days | | | 90 | | declared-by-booking | | | 19134 | 20394.879926779166 | 525 | 230.24679596385968 | 0 | 4.5940701675784466 | 0.027438068359987456 | 0.011237107085697943 | 0 | 0.01995280823929271 | | | | | 2026-09-24 | booking | alacarte502 | 14756473 | 30 | Last 30 days | | | 30 | | declared-by-booking | | | 10260 | 9779.473004077292 | 159 | 176.42636280348393 | 0 | 2.2403959222668735 | 0.015497076023391813 | 0.018040477511408602 | 0 | 0.012698759338831826 | | | | | 2026-09-24 | booking | alacarte502 | 14756473 | 365 | Last 365 days | | | 365 | | declared-by-booking | | | 113701 | 103436.93622056446 | 1401 | 1456.3790318649712 | 35 | 22.764571231092678 | 0.012321791365071548 | 0.014079874028359187 | 0.024982155603140613 | 0.01563093860390274 | | | | | 2026-09-24 | booking | alacarte502 | 14756473 | 60 | Last 60 days | | | 60 | | declared-by-booking | | | 37616 | 28540.249876115857 | 415 | 402.1277774519692 | 3 | 6.4812910290793235 | 0.011032539344959591 | 0.014089847818343496 | 0.007228915662650603 | 0.016117491485286562 | | | | | 2026-09-24 | booking | alacarte502 | 14756473 | 90 | Last 90 days | | | 90 | | declared-by-booking | | | 46509 | 44993.23447608527 | 637 | 619.5230880080582 | 10 | 11.72572439917529 | 0.01369627383947193 | 0.013769249871052191 | 0.015698587127158554 | 0.018927017614269726 | | | | ## Tải về [CSV](https://harthliving-ota.pages.dev/data/fact-funnel.csv) · [JSON](https://harthliving-ota.pages.dev/data/fact-funnel.json) --- Phần 28/35 · tiếp: https://harthliving-ota.pages.dev/ai/full/part-29.txt