How to track the most booked hotels and experiences?

✅ Identify best-performing hotels and experiences
✅ Track top-selling destinations per TO or network
✅ Analyze product volume and seasonality over time
✅ Improve product visibility and prioritize bestsellers

🚀 Objective: Use KOOB exports and Excel tools to analyze booking volumes, highlight your best products, and adapt your strategy accordingly.

Export booking data from KOOB 📦

To identify your top products, extract data from KOOB using one of these options:

Option A – My Bookings → Bookings made directly by your internal team

Go to Bookings > My Bookings

Apply filters: Booking Period, Typology (Hotels or Experiences), Status

Click "Extract to CSV"

Option B – Clients' Bookings → Bookings made by Tour Operators via KOOB

Go to Bookings > Clients' Bookings

Apply filters: Booking Period, Product Type, TO Name, etc.

Click "Extract to CSV"

📌 Tip: Use My Bookings to evaluate internal usage and Clients’ Bookings to evaluate TO activity and product performance in distribution.

Key columns for product analysis 🔍

Once you open the CSV file in Excel, focus on these columns:

Column	Purpose
Hotel/Experience Name	Identify the products being booked
City / Country	Spot popular destinations
Status	Focus only on Confirmed bookings
Tour Operator Name	Understand which TOs push which products
Booking Date	Evaluate product performance over time
Selling Price TO	Measure revenue per product (optional)

💡 Example: You may find that “Avana Retreat” in Vietnam has 40 confirmed bookings over the last 3 months, while other hotels in the same area had fewer than 5.

Count your top booked products 📊

To find out which hotels or experiences are booked the most:

Filter your file by Status = Confirmed
Group by Hotel/Experience Name
Summarize the number of rows per product
Sort by descending order to find the top-performing ones

📌 You can also break this down by City or Country to see which destinations attract the most sales.

💡 Tip: Create a table that looks like this for better visibility:

Product Name	City	Confirmed Bookings
Avana Retreat	Mai Chau	40
City Food Tour	Hanoi	28
Mekong Sunset Cruise	Can Tho	23

Analyze seasonality and monthly trends 📅

To detect seasonal patterns:

Use the Booking Date column
Add a new column to tag each booking by month (e.g., Jan 2025, Feb 2025)
Count bookings per product, per month

📌 This helps anticipate peaks and adapt your allotments or pricing in advance.

💡 Example: If “Ricefield Cycling Tour” peaks in April and October, you can prioritize availability for those months in advance and promotion (early bird) for the low seaon.

Compare performance by TO or Network 🧩

Use the “Tour Operator Name” or “Network Name” columns to evaluate which TOs are selling which products:

Count the number of confirmed bookings per TO per product
Use pivot tables or grouped filters to compare easily

📌 Tip: If one TO consistently books the same 3 products, suggest others or offer training to promote more experiences.

💡 Example: You discover that “Easia Travel France” books 90% of their volume on just 5 experiences. You can propose new products to diversify their offer.

Strategic actions based on top products ✅

Once you've identified your most booked hotels and experiences, take action:

✅ Update descriptions, photos, and availability of top products
✅ Ensure top sellers are available in Free Sales if possible
✅ Promote underbooked products by repositioning them
✅ Share best-selling lists with your TOs to inspire sales
✅ Set dynamic margins or seasonal pricing to match demand

💡 Example: After identifying “Sunset Kayaking Experience” as a bestseller in Laos, you move it to the top of the catalog and unlock Free Sales. Bookings could increase by 20% the next quarter.

Takeaways

✅ Extract your booking data using KOOB’s My Bookings or Clients’ Bookings
✅ Focus on “Confirmed” status to track real sales volume
✅ Group bookings by product name to identify top performers
✅ Analyze trends by city, country, or TO
✅ Use monthly trends to improve pricing, planning, and availability
✅ Actively promote and optimize your most booked products

FAQ

Q: Can I see which product has the highest revenue?
💰 Yes. Use the “Selling Price TO” column and sum by product name.

Q: What if two products have similar booking volume but different revenue?
📊 Check the average selling price per product to evaluate profitability.

Q: How can I identify underperforming products?
📌 Filter for products with few or no confirmed bookings over the last 3 months.

Q: How do I share my top products with a TO?
🔗 Export the filtered Excel sheet and share your bestseller list by destination.

Q: Should I focus more on hotels or experiences?
🧭 Depends on your market. Use volume and margin data to decide where to invest.

Related articles

📌 Need help? Visit the KOOB Knowledge Base or contact KOOB Support 🚀