Harthliving OTA · bản chữ cho AI · dựng từ vault (nguồn sửa lần cuối 29/09/2026 22:33) · mục lục: https://harthliving-ota.pages.dev/ai/index.txt

# Bảng dữ liệu: Booking.com funnel (`fact_funnel`)

Search impressions → page views → bookings with peer benchmarks, per property and period (30/60/90/365 days; periods overlap).

- Nền tảng: booking · Nhóm: funnel · Mỗi dòng: one property × period × crawl date
- Số dòng: 35 · Cập nhật: 2026-09-24
- Tải: CSV https://harthliving-ota.pages.dev/data/fact-funnel.csv · JSON https://harthliving-ota.pages.dev/data/fact-funnel.json · HTML https://harthliving-ota.pages.dev/library/data/fact-funnel/

## Cột

| Cột | Kiểu | Nghĩa |
|---|---|---|
| `snapshot_date` | date | Date the data was crawled from the platform (NOT the date the numbers refer to) |
| `channel` | string | Sales channel / platform key: booking / agoda / airbnb / pricelabs |
| `slug` | string | Internal property key (e.g. 25anthuong11, alacarte305). Join key across all datasets |
| `external_id` | string | Property/listing ID on the platform (Booking hotel_id, Agoda property ID, Airbnb listing ID) |
| `period_days` | integer | Length of the funnel period (30/60/90/365). Periods overlap — do not subtract them |
| `period_label` | string | Reporting period label as shown by the platform |
| `window_start` | date | Start of the funnel window |
| `window_end` | date | End of the funnel window |
| `window_days` | string | Days in the window; a range like '27–31' when the window was back-derived |
| `lag_days` | integer | Reporting lag of the dashboard in days (~7–11) for back-derived rows |
| `window_method` | string | declared-by-booking · derived-exact · derived-approx · unknown |
| `window_mismatch` | integer | 1 if the derived window disagrees with the declared one |
| `window_ambiguity_days` | integer | Uncertainty of the derived window in days |
| `search_impressions` | number | Times the property appeared in search results |
| `search_impressions_peer` | number | Peer-group benchmark for search_impressions |
| `page_views` | number | Property page views |
| `page_views_peer` | number | Peer-group benchmark for page_views |
| `bookings` | number | Bookings in the period |
| `bookings_peer` | number | Peer-group benchmark for bookings |
| `ctr` | number | Click-through rate (search → property page), ratio |
| `ctr_peer` | number | Peer-group benchmark for ctr |
| `conversion` | number | Conversion rate (page view → booking), ratio |
| `conversion_peer` | number | Peer-group benchmark for conversion |
| `rank_in_city` | integer | Booking's own rank of the property in the city |
| `rank_total` | integer | Number of properties in the ranking that rank_in_city is out of |
| `property_page_score` | number | Property page score (content completeness), ratio |

## Dữ liệu

**Phần 1/1** — dòng 1–35 / 35 · (hết bảng)

```csv
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,,,
```

**Phần 1/1** — dòng 1–35 / 35 · (hết bảng)