Report contents
Every run with valid prices becomes one Excel report
2 automatic runs a day; each run that gets valid prices produces an Excel report. A full analysis that completes normally has 10 sheets; when data or an individual analysis is unavailable, some sheets are skipped or marked as having no data. Every sheet below is excerpted with its real columns.
Demo data: 曙光旅店 (your hotel) and 5 competitors, 100 stay dates starting 2026-10-06, the same fictional data as the program screens in the screen tour. The demo size is only meant to show every column; your actual scope depends on your plan.
Sheet names, column headings and explanations on this page are translated into English for reference; hotel names, room types and some Booking terms are kept in Traditional Chinese, as Booking's Traditional Chinese pages show them.
Market
Your prices and each competitor's, your position across the month, and the market range.
Booking price comparison
Question it answers: For each stay date, what prices do you and each competitor show on Booking, and who is more expensive or cheaper than you?
| Hotel name | 2026-10-06 | 2026-10-07 | 2026-10-08 | 2026-10-09 | 2026-10-10 | 2026-10-11 | 2026-10-12 |
|---|---|---|---|---|---|---|---|
| 曙光旅店 | 2,100 | 2,795 | 3,330 | 2,595 | 3,290 | 3,825 | 2,490 |
| 河畔商旅 | 2,560 | 2,625 | 2,690 | 3,055 | 3,120 | 3,185 | 2,950 |
| 晴嶼旅宿 | 2,670 | 2,735 | 2,800 | 3,165 | 3,230 | 3,295 | 3,060 |
| 森光飯店 | 2,780 | 2,845 | 2,910 | 3,275 | 3,340 | 3,405 | 3,170 |
| 星灣旅館 | 2,890 | 2,955 | 3,020 | 3,385 | 3,450 | 3,515 | 3,280 |
| 雲岸旅店 | 3,065 | 3,130 | 3,495 | 3,560 | 3,625 | 3,390 |
Red = this hotel is more expensive than youBlue = this hotel is cheaper than youBlank = no usable price this timeShaded row = your hotel
Prices are each hotel's lowest visible price at the time; the same room type or rate is not guaranteed. The actual report has one column per stay date, with the first column frozen. A blank price does not necessarily mean the hotel is sold out; check Booking manually before drawing any conclusion.
Price calendar
Question it answers: On a monthly calendar, is your price above, below or close to the market median each day?
Report generation time: 2026-10-06 11:04:12
Price observation time: see “Observed” in each day's cell; it is when the prices were actually obtained, not the report generation time
One block per month, Monday first. Cell text, in order: date, your price, competitor median, gap, market position, valid competitor count and observation time; unmonitored days are marked separately.
Market price position
Question it answers: For each stay date, where does your price rank among competitors, and which side of Q1–Q3 does it fall on?
First hotel in the monitoring list = your hotel
Calculated from the lowest price visible on Booking at the time of the run; the prices are not necessarily for the same room type, and occupancy and booking pace are not included. Action signals are for manual reference only; they do not change prices automatically and are not a best price or a revenue guarantee.
| Stay date | Your price | Price rank | Valid competitors | Market range low | Competitor median | Market range high | Difference from median | Gap from median (%) | Market position | Action signal | Basis |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-06 | 2,100 | 1 | 4 | 2,643 | 2,725 | 2,808 | -625 | -22.9% | Below market | 🟢 Consider raising | Your hotel is 20.5% below Q1, 4 valid competitors |
| 2026-10-07 | 2,795 | 3 | 5 | 2,735 | 2,845 | 2,955 | -50 | -1.8% | Near market | 🟡 Keep watching | Your hotel is 1.8% below the market median, 5 valid competitors |
| 2026-10-08 | 3,330 | 6 | 5 | 2,800 | 2,910 | 3,020 | 420 | 14.4% | Above market | 🔵 Consider lowering | Your hotel is 10.3% above Q3, 5 valid competitors |
| 2026-10-09 | 2,595 | 1 | 5 | 3,165 | 3,275 | 3,385 | -680 | -20.8% | Below market | 🟢 Consider raising | Your hotel is 18.0% below Q1, 5 valid competitors |
| 2026-10-10 | 3,290 | 3 | 5 | 3,230 | 3,340 | 3,450 | -50 | -1.5% | Near market | 🟡 Keep watching | Your hotel is 1.5% below the market median, 5 valid competitors |
Some columns excerpted; the actual report also has your hotel, your room type, lowest competitor price, highest competitor price and notes columns. This sheet is produced only when market data is obtained.
Market dynamics
Question it answers: Which stay dates are warming or cooling, what is the market range each day, and where do you stand against all competitors and core competitors?
Market dynamics and competitor behavior analysis
Report time: 10-06 11:04
7-day window: 09-29 11:04 to 10-06 11:04 | 30-day window: 09-06 11:04 to 10-06 11:04 | Other columns are descriptive statistics; the recommended selling range is this fetch's competitor Q1–Q3 rounded inward, does not use the price guardrail, and is not a demand forecast, a best price or an automatic price change
Market cooling ranking Top 5
| Rank | Stay date | Curr. | Earliest median | Latest median | Change amount | Change % | Valid runs | Competitor range | Comparison start | Comparison end |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-10-06 | TWD | 3,003.0 | 2,725.0 | -278.0 | -9.3% | 7 | 4–5 | 09-30 11:03 | 10-06 11:03 |
| 2 | 2026-12-23 | TWD | 3,068.0 | 2,790.0 | -278.0 | -9.1% | 7 | 4–5 | 09-30 11:03 | 10-06 11:03 |
| 3 | 2026-11-14 | TWD | 3,563.0 | 3,285.0 | -278.0 | -7.8% | 7 | 4–5 | 09-30 11:03 | 10-06 11:03 |
Stay-date data status
| Stay date | Data status | Recommended min | Recommended max | Latest valid run competitor median (market range middle price) | Latest run change amount | Latest run change % | Market range low (Q1) | Market range high (Q3) |
|---|---|---|---|---|---|---|---|---|
| 2026-10-06 | Cooling ranking | 2,643 | 2,807 | 2,725.0 | -138.0 | -4.8% | 2,642.5 | 2,807.5 |
| 2026-10-07 | Valid but not in top 5 | 2,735 | 2,955 | 2,845.0 | -43.0 | -1.5% | 2,735.0 | 2,955.0 |
| 2026-10-08 | Valid but not in top 5 | 2,800 | 3,020 | 2,910.0 | -43.0 | -1.5% | 2,800.0 | 3,020.0 |
| 2026-10-09 | Valid but not in top 5 | 3,165 | 3,385 | 3,275.0 | -83.0 | -2.5% | 3,165.0 | 3,385.0 |
| 2026-10-10 | Valid but not in top 5 | 3,230 | 3,450 | 3,340.0 | -43.0 | -1.3% | 3,230.0 | 3,450.0 |
All/core competitor comparison (latest observed run)
Core competitor list: 河畔商旅, 晴嶼旅宿, 森光飯店
| Stay date | Your price | Valid hotels (all) | Median (all) | Position (all) | Valid hotels (core) | Median (core) | Position (core) |
|---|---|---|---|---|---|---|---|
| 2026-10-06 | 2,100 | 4 | 2,725.0 | Below market | 3 | 2,670.0 | Below market |
| 2026-10-07 | 2,795 | 5 | 2,845.0 | Near market | 3 | 2,735.0 | Above market |
| 2026-10-08 | 3,330 | 5 | 2,910.0 | Above market | 3 | 2,800.0 | Above market |
| 2026-10-09 | 2,595 | 5 | 3,275.0 | Below market | 3 | 3,165.0 | Below market |
| 2026-10-10 | 3,290 | 5 | 3,340.0 | Near market | 3 | 3,230.0 | Above market |
Three of the six sections are excerpted; the others are Market warming ranking Top 5, Guardrail check of your current prices, and Competitor behavior analysis (last 30 days). The recommended selling range is a rule-based reference from the competitor price distribution: the minimum is this fetch's competitor Q1 rounded up and the maximum is Q3 rounded down. It is not a price that suits every room type.
Changes
Who went up or down since the last run, and the direction over the last 7 and 30 days.
Price changes
Question it answers: Since the last run, which hotel, which date and which room type went up or down, and by how much?
| Hotel name | Stay date | Room type | Old price | New price | Price rise/drop | Difference |
|---|---|---|---|---|---|---|
| 曙光旅店 | 2026-10-06 | 標準雙人房 | 2,161 | 2,100 | Price drop | 61 |
| 河畔商旅 | 2026-10-06 | 標準雙人房 | 2,643 | 2,560 | Price drop | 83 |
| 晴嶼旅宿 | 2026-10-06 | 標準雙人房 | 2,753 | 2,670 | Price drop | 83 |
| 曙光旅店 | 2026-10-07 | 標準雙人房 | 2,856 | 2,795 | Price drop | 61 |
| 森光飯店 | 2026-10-07 | 標準雙人房 | 2,888 | 2,845 | Price drop | 43 |
| 雲岸旅店 | 2026-10-08 | 標準雙人房 | 3,173 | 3,130 | Price drop | 43 |
Shaded row = your hotel
When nothing changed, it only says “No price changes in this run.” The difference is an absolute value; rises are in red and drops in blue. Price rises and drops are calculated only for the same room type; when the room type isn't shown, rises and drops need a manual check.
Price trend summary
Question it answers: Over the last 7 and 30 days, which way has each hotel's lowest price moved, and who hit a new low?
Booking competitor price trend summary
Base date: 2026-10-06 | Red = price rise or lowest price in the whole sheet; blue = price drop
| Hotel name | Current lowest price | 7-day change | 30-day change | 7-day low | 30-day low | Valid stay dates | Interpretation | 7-day comparison dates | 30-day low stay date |
|---|---|---|---|---|---|---|---|---|---|
| 曙光旅店 | 2,100 | -1.2% | 12.7% | No | No | 100 | Price drop | 2026-09-30 → 2026-10-06 | |
| 河畔商旅 | 2,560 | -8.0% | -5.3% | Yes | Yes | 100 | Price drop | 2026-09-30 → 2026-10-06 | 2026-10-06 |
| 晴嶼旅宿 | 2,670 | -7.7% | -5.1% | Yes | Yes | 100 | Price drop | 2026-09-30 → 2026-10-06 | 2026-10-06 |
| 森光飯店 | 2,780 | -7.4% | -4.9% | Yes | Yes | 100 | Price drop | 2026-09-30 → 2026-10-06 | 2026-10-06 |
| 星灣旅館 | 2,890 | -7.2% | -4.7% | Yes | Yes | 100 | Price drop | 2026-09-30 → 2026-10-06 | 2026-10-06 |
| 雲岸旅店 | 3,000 | 0.6% | 14.3% | No | No | 100 | Price rise | 2026-09-30 → 2026-10-06 |
Shaded row = your hotel
For each hotel, it takes “the stay date with the lowest current price” and compares it with the first price observed for that same stay date within the window, so different hotels may be compared on different dates.
Details and decisions
The room terms behind each price, the dates to look at first this time, and whether this run's fetch was complete.
Room and price details
Question it answers: What room type, breakfast, cancellation, payment and tax terms does this price come with, and can it be compared?
| Hotel name | Stay date | Room type | Breakfast | Cancellation policy | Payment | Price | Tax and fee status | Tax and fee notes | Offer name | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| 曙光旅店 | 2026-10-06 | 標準雙人房 | 不含早餐 | Free cancellation | Pay at the property | 2,100 | Included | Success | ||
| 河畔商旅 | 2026-10-06 | 標準雙人房 | 不含早餐 | Free cancellation | Pay at the property | 2,560 | Included | Success | ||
| 晴嶼旅宿 | 2026-10-06 | 標準雙人房 | 不含早餐 | Free cancellation | Pay at the property | 2,670 | Included | Success | ||
| 森光飯店 | 2026-10-06 | 標準雙人房 | 不含早餐 | Free cancellation | Pay at the property | 2,780 | Included | Success | ||
| 星灣旅館 | 2026-10-06 | 標準雙人房 | 不含早餐 | Free cancellation | Pay at the property | 2,890 | Included | Success |
Shaded row = your hotel
One row per “hotel × stay date.” When the room type changes, the status column says “Room type change: old → new”; when rate terms such as breakfast or cancellation change, it says “Rate terms change: old → new.” For rows without a price, columns such as room type show “Not shown” and the price is left blank. The breakfast, cancellation, payment and tax values are demo values.
Revenue decision summary
Question it answers: Which “hotel × stay date” pairs should you review manually first this time, and why?
This sheet lists the hotels and stay dates in this run that are worth a manual review; it is only a reference for your own judgment.
| Priority | Stay date | Hotel name | Event type | Reason to check | Current price | Previous price | Competitor median | Amount difference | Percentage difference |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-10-27 | 曙光旅店 | Market deviation, Price changes | Your hotel is 21.3% below Q1, 5 valid competitors; priority check recommended. Price fell NT$61 (-2.8%) this run; manual check recommended | 2,100 | 2,161 | 2,780 | -61 | -2.82 |
| 2 | 2026-11-17 | 曙光旅店 | Market deviation, Price changes | Your hotel is 21.3% below Q1, 5 valid competitors; priority check recommended. Price fell NT$61 (-2.8%) this run; manual check recommended | 2,100 | 2,161 | 2,780 | -61 | -2.82 |
| 3 | 2026-12-08 | 曙光旅店 | Market deviation, Price changes | Your hotel is 21.3% below Q1, 5 valid competitors; priority check recommended. Price fell NT$61 (-2.8%) this run; manual check recommended | 2,100 | 2,161 | 2,780 | -61 | -2.82 |
| 4 | 2026-12-29 | 曙光旅店 | Market deviation, Price changes | Your hotel is 21.3% below Q1, 5 valid competitors; priority check recommended. Price fell NT$61 (-2.8%) this run; manual check recommended | 2,100 | 2,161 | 2,780 | -61 | -2.82 |
Sort order: Market deviation (largest gap first) → Price changes → Room type change, Rate terms change and 30-day low. When the same hotel has a price change on the same day, the amount and percentage differences use the previous price as the base. Some columns excerpted; the actual report also has 7-day and 30-day price trends, data status, and an “Exact price check” link to Booking.
Run summary
Question it answers: Was this fetch complete, and how are the failure reasons distributed?
| Item | Value |
|---|---|
| Report time | 2026-10-06 11:04:12 |
| Planned fetch entries | 600 |
| Prices found (entries) | 592 |
| No data/failed entries | 8 |
| Prices found | 592 |
| No data (normal) | 8 |
| CAPTCHA | 0 |
| Not on sale/No rooms | 0 |
| Data completeness | 592/600 (98.7%) |
| Hotels tracked this run | 6 |
| Dates tracked this run | 100 |
“Not on sale/No rooms” is the display name for “Other failures”; it may also be a fetch error and does not prove that no rooms are available.
Glossary
Question it answers: What does each term in the report mean, and how should you read it?
Report glossary
This sheet explains the report terms and how to read them. It is for manual review only; it does not change prices automatically and does not represent a best price or a revenue guarantee. “Not on sale/No rooms” is the display name of “Other failures”; it may also be a fetch error and does not prove that no rooms are available, so please check Logs.
| Sheet | Term / column | Plain explanation | How to read |
|---|---|---|---|
| Booking price comparison | Blank price | No usable price was obtained this time; this does not mean the hotel is necessarily sold out. | A blank only means the price was not fetched this time; check Booking manually before drawing any conclusion. |
| Price calendar | Not a pricing recommendation | This sheet only organizes the price relationships observed in this run, for manual review. | It is not an automatic pricing recommendation, nor does it represent a best price or a revenue guarantee. |
| Market price position | Action signal | A signal light derived from the market position, used only to order manual reviews; it is not an automatic price change instruction. | A lit signal means it is worth a look; whether to actually change the price is decided by a person. |
| Conditional price estimate | Data limits and intended use | Competitor data is the lowest price visible on Booking at that moment, and selling terms such as room type, breakfast and cancellation may differ; the recommended range is only a rule-based reference from the competitor price distribution, not a price that suits every room type. | It is not a demand forecast, it does not guarantee the best price or a profit, and it does not guarantee that costs are covered; it does not change prices automatically or write back to Booking or any other platform, and the actual selling price is still for you to decide. |
| Price guardrail | No recommended price | The price guardrail only checks whether a price falls within the range you set; it does not calculate or provide any recommended price or best price. | The guarded price only moves the price to a bound you set yourself; it does not mean the system recommends selling at that price. |
The actual report's glossary has over two hundred entries covering every sheet, program screen, notification and schedule; five entries are excerpted here.
See your own market first, then decide whether to subscribe
We'll provide 2 free reports first so you can evaluate it on your own market, with no payment up front.
RoomPrice Monitor currently monitors room prices only for hotels in Taiwan on Booking, in New Taiwan dollars (NT$). Thailand, Vietnam and other markets are planned, with no launch date yet.
- Message us on LINE or by EmailTell us your hotel, 3–5 competitor hotels you want to compare, and the stay-date range you'd like to see first
- We run 2 reports for youUsing your actual market data, with no payment up front
- About a 15-minute online walkthroughWe help you read the report; subscribe only if you find it useful
Scan with your phone to add our official LINE account
@463spxng