Hotel Rate & Promo Data
Gain instant insights into competitive room rates and promotions — automate pricing decisions for maximum revenue impact
A saved example of what you can collect and monitor with Jsonify. Create your own version in Jsonify.
Build this in JsonifyYour original goal is prefilled.
Goal
i want to get real-time, granular competitive room rates, availability, and active promotional campaign data for comparable properties from all major Online Travel Agencies (OTAs) and strategic competitor hotel direct booking websites globally to inform dynamic revenue management and pricing decisions across our portfolio.
Source coverage
- expedia.co.uk
- booking.com
- hotels.com
- trivago.co.uk
- lastminute.com
- agoda.com
- opodo.co.uk
- kayak.co.uk
- tripadvisor.co.uk
- airbnb.co.uk
- hoteltonight.com
- skyscanner.net
Sample data
Illustrative sample data from the original configuration, not live or verified results.
| id | Source | Hotel | RoomType | Price | Availability | BreakfastIncluded | Cancellation | Promotion |
|---|---|---|---|---|---|---|---|---|
| 1 | https://www.expedia.com/hotels | The Grand London Hotel | Executive Double | 300.0 | 4 | Yes | Free cancellation | Member Deal: 10% off (code EXP10) |
| 2 | https://www.expedia.com/hotels | Hilton Garden Inn Manchester | Queen Room | 85.0 | 2 | Yes | Non-refundable | Up to 30% off select hotels (code CANDACE) |
| 3 | https://www.expedia.com/hotels | Sea View Resort Barcelona | Standard Twin | 120.0 | 6 | No | Non-refundable | Mastercard 12% off hotels |
| 4 | https://www.booking.com/hotels | The Grand London Hotel | Executive Double | 275.0 | 3 | Yes | Free cancellation | Non-refundable rate: 15% off |
| 5 | https://www.booking.com/hotels | Marriott Milan City | Standard Room | 150.0 | 5 | No | Free cancellation | Genius Member: 10% off |
| 6 | https://www.booking.com/hotels | City Inn Paris Gare | Double Room | 95.0 | 10 | Yes | Free cancellation | Prepaid rate: 10% off |
| 7 | https://www.hotels.com/hotels | Premier Inn London City | Standard Double | 20.0 | 2 | Yes | Non-refundable | New Year Deal: £20 double room |
| 8 | https://www.hotels.com/hotels | Hilton Sydney | Deluxe | 180.0 | 5 | Yes | Free cancellation | One Key Rewards: 10% off |
| 9 | https://www.hotels.com/hotels | City Lodge Cape Town | Twin Room | 60.0 | 8 | No | Free cancellation | Member Rate: 25% off |
| 10 | https://www.agoda.com/hotels | Mercure Singapore Orchard | Standard Double | 140.0 | 5 | Yes | Free cancellation | AgodaVIP: 10% off |
| 11 | https://www.agoda.com/hotels | Novotel Bangkok | Deluxe | 80.0 | 4 | No | Non-refundable | Best Price Guarantee |
| 12 | https://www.agoda.com/hotels | Bali Beach Resort | Suite | 180.0 | 2 | Yes | Free cancellation | App Exclusive: 8% off |
| 13 | https://www.airbnb.com/hotels | London Loft | Entire Apartment | 120.0 | 3 | No | Free cancellation | 20% off with code BHX |
| 14 | https://www.airbnb.com/hotels | Paris Studio Loft | Private Room | 60.0 | 7 | No | Flexible | £15 off first booking |
| 15 | https://www.airbnb.com/hotels | Tokyo Capsule | Shared Room | 20.0 | 15 | No | Strict | 15% off with code SPRING15 |
| 16 | https://www.hoteltonight.com/hotels | Hilton Kensington | King Room | 180.0 | 1 | Yes | Non-refundable | HotRate: 30% off |
| 17 | https://www.hoteltonight.com/hotels | Premier Inn Glasgow Central | Standard Double | 65.0 | 3 | Yes | Non-refundable | App Deal: 10% off |
| 18 | https://www.hoteltonight.com/hotels | Holiday Inn Manchester | Queen Room | 100.0 | 2 | No | Non-refundable | Mobile Exclusive: 15% off |
| 19 | https://www.lastminute.com/hotels | Premier Inn Newcastle | Standard Double | 80.0 | 5 | Yes | Non-refundable | 5% off on stays >£200 |
| 20 | https://www.lastminute.com/hotels | ibis London City | Classic Room | 120.0 | 4 | Yes | Free cancellation | £60 off holidays over £700 |
| 21 | https://www.lastminute.com/hotels | Holiday Inn Manchester | Double Room | 90.0 | 6 | Yes | Free cancellation | Download app: £20 off first booking |
| 22 | https://www.opodo.com/hotels | Resort Hotel Lisbon | Standard Room | 110.0 | 7 | Yes | Free cancellation | Flight+Hotel up to 40% off |
| 23 | https://www.opodo.com/hotels | London Airport Hotel | Economy Room | 70.0 | 3 | No | Non-refundable | Prime Member: up to 50% off |
| 24 | https://www.kayak.com/hotels | Hilton New York | King Room | 350.0 | 4 | Yes | Free cancellation | Up to 20% off (limited-time) |
| 25 | https://www.kayak.com/hotels | ibis London City | Standard Room | 90.0 | 5 | No | Non-refundable | App-exclusive 10% off |
| 26 | https://www.trivago.com/hotels | Park Inn Brussels | Standard Room | 110.0 | 6 | Yes | Free cancellation | Best price guarantee |
| 27 | https://www.trivago.com/hotels | Travelodge York | Single Room | 50.0 | 8 | No | Non-refundable | Lowest price on Trivago |
| 28 | https://www.tripadvisor.com/hotels | The Montague on The Gardens | Superior Double | 195.0 | 4 | Yes | Free cancellation | Exclusive Tripadvisor deal: 5% off |
| 29 | https://www.skyscanner.com/hotels | Radisson Blu Edinburgh | Deluxe Double | 150.0 | 2 | Yes | Free cancellation | Price Alert: 10% off |
| 30 | https://www.skyscanner.com/hotels | Sheraton Kyoto | Standard Double | 180.0 | 4 | Yes | Free cancellation | Best Price Sale: 5% off |
Insights and analytics
- Total Properties Tracked (metric)
- Average Room Rate (metric)
- Room Availability Distribution (donut)
- Price Trend Over Last 30 Days (line)
- Cumulative Promotional Campaigns (area)
- Top 5 Competitor Rates (bar)
- Best Value Properties (horizontal_bar)
- Current Promotions by OTA (table)
- Room Rates Comparison (table)
- Competitive Pricing Insights (insights)
- Market Demand Fluctuations (line)
- Source of Bookings Breakdown (pie)
Change notifications
- Price Change Detected — is now £120 (+£15) booking.com
- New Listing Appears — now available expedia.co.uk
- Availability Change — is now fully booked hotels.com
- Coverage Gap Found — missing from catalog trivago.co.uk
- Promotion Updated — now includes free breakfast agoda.com
Integrations and delivery
- api
- snowflake
- bigquery
- webhooks
Make this your own
Start with this goal in Jsonify, then choose the sources and data you need.
Build this in Jsonify