区位 Location:雅加达中西部 Slipi / Grogol 区|自营店 Self-operated:Model J Hotel Central Park|追踪竞对 11 家 Competitors tracked: 11
CP 竞对月度收入 Competitor Revenue(Rp b)
Menara PeninsulaMAPLE GROGOLKimaya Slipi JakartaSANTIKA PREMIERE SLIPIPosto Dormire GrogolModel J Hotel Central Park (自营/Self)Grand Tjokro JakartaB Fashion HotelAston KartikaHotel Ciputra JakartaHARRIS SUITES MANSION PURI INDAHGrand Tropic Suite Hotel Jakarta
CP 竞对月度 RevPAR Competitor RevPAR(Rp k)
Menara PeninsulaMAPLE GROGOLKimaya Slipi JakartaSANTIKA PREMIERE SLIPIPosto Dormire GrogolModel J Hotel Central Park (自营/Self)Grand Tjokro JakartaB Fashion HotelAston KartikaHotel Ciputra JakartaHARRIS SUITES MANSION PURI INDAHGrand Tropic Suite Hotel Jakarta
OCC 与 ADR 双增长(OCC 84.5%→94.9%,ADR +29.6%),是三店中量价齐升最健康的店,RevPAR 同步走高。6月被 SANTIKA PREMIERE SLIPI 反超收入(Rp 4.68b vs Rp 2.58b)——但 SANTIKA 体量(售房 5889 间夜)约为自营(2897)的 2 倍,自营单房效率更高。潜力点:房间数受限下,继续拉 ADR;关注 SANTIKA/Hotel Ciputra 价格战对自营 OTA 转化的压力。 Both OCC and ADR grew (OCC 84.5%→94.9%, ADR +29.6%) — the healthiest store in volume+price, RevPAR rising. SANTIKA overtook on revenue in Jun (Rp 4.68b vs Rp 2.58b), but its volume (5889 room-nights) is ~2x self (2897), so self has higher per-room efficiency. Keep pushing ADR under limited room count; watch SANTIKA/Hotel Ciputra price pressure on OTA conversion.
跨店共性机会 Cross-Store Opportunities
OTA 评分运营 OTA rating ops:BSD 区竞对评分普遍 9.0+,自营需维持在 9.0 以上以守住转化;Airport/CP 区竞对评分多在 7.x,自营 7.7 已具优势,可加大 Booking/Trip 评价引导转化为直销。 BSD competitors 9.0+ (self must stay above 9.0); Airport/CP competitors at 7.x (self 7.7 already advantaged) — push Booking/Trip reviews toward direct booking.
RevPAR 监控 RevPAR monitoring:RevPAR = ADR × OCC,已按公式统一计算并入趋势。建议以 RevPAR 作为各店收益管理核心北极星指标。 RevPAR = ADR × OCC, now computed uniformly; use it as the north-star revenue metric.
价格动态化 Dynamic pricing:三店均呈现高 OCC 特征,可引入按 OCC 阈值自动调价规则(OCC>85% 加价、<65% 促销)。 All stores run high OCC; introduce OCC-threshold pricing rules (raise when >85%, promote when <65%).
数据说明与更新方法 Data Notes & How to Update
数据来源与口径 Source & Methodology
原始数据:印尼三店每日手工填写的竞对对比 Excel(每个工作表为一天,含自营+竞对的 OTA 评分与当日/月累计经营指标)。 Daily manual competitor Excel for the 3 Indonesia stores (one sheet per day, with OTA scores and TODAY/MTD ops metrics for self + competitors).
清洗规则 Cleaning:① 酒店名归一(去除括注/换行/别名);② 印尼数字格式转数值(Rp87.499.999→87499999,96,40%→96.4,9,1/10→9.1,4,3/5→8.6);③ 日期校验:优先 A1 日期,若与工作表标签日不符则采用标签日;④ 异常评分过滤(>10.5 视为脏值);⑤ 同店同日多文件覆盖时保留最新文件记录。 Hotel-name normalization; Indonesian number parsing; date validation (prefer A1, fall back to sheet-tab day); outlier rating filtering (>10.5); latest-file-wins for overlaps.
月度口径 Monthly method:月收入=当月各日 TODAY 收入求和;月售房=各日 TODAY 售房求和;OCC/ADR=各日 TODAY 均值;RevPAR=ADR×OCC÷100;OTA 评分=当月各渠道日均分再求均。金额单位 k/m/b Rp。 Revenue = sum of daily TODAY; rooms sold = sum of daily TODAY; OCC/ADR = daily average; RevPAR = ADR×OCC÷100; OTA = avg of daily per-channel scores. Currency in k/m/b Rp.
如何更新 How to update:将新 xlsx 放入 竞对分析专项/ 文件夹,运行 & 'd:\AI folder\竞对分析专项\_tools\Update-Reports.ps1',自动重跑清洗→聚合→报告。 Drop new xlsx into the folder and run Update-Reports.ps1; auto re-runs clean→aggregate→report.