✅ Export all booking data (hotels & experiences) for analysis
✅ Track total revenue and number of confirmed bookings
✅ Analyze top-selling products and partner performance
✅ Identify seasonal trends and booking behaviors
🚀 Objective: Help TOs extract, analyze, and understand total bookings and revenue using KOOB’s export tools and Excel.
Access your total booking report 📦
To track your booking and revenue data in KOOB:
-
Go to Client Folders from the left-hand menu
-
Click “Extract to CSV” (top right)
-
Select a Booking Period to filter the data (e.g., Q1, summer months)
-
Open the file in Excel or Google Sheets for analysis
💡 Tip: Regular monthly exports help track trends and compare performance over time.
Key data fields to analyze 🔍
When you open the CSV, these are the most important fields for tracking total bookings and revenue:
| Column | Description |
|---|---|
| 📅 Booked On | Booking creation date |
| 📌 Status | Booking status (Confirmed, Canceled, etc.) |
| 🏨 Product Name | Name of the hotel or experience |
| 🌍 City / Country | Destination of the product |
| 👥 Number of Guests | Pax per booking |
| 💰 Total Price | Price charged to your client |
| 📝 Notes | Special requests (optional) |
| 🤝 Partner Name | DMC managing the product |
| 📆 Check-in / Start Date | Travel start date |
📌 Example: Sort by “Status” and filter only “Confirmed” to calculate your real revenue volume.
Analyze total revenue and booking volume 📊
Once the file is opened:
-
Filter by Status → Focus on “Confirmed” bookings
-
Use the “Total Price” column to measure sales
-
Use “Booking ID” or “Product Name” to count total bookings
💡 You can group bookings by month, destination, or supplier to monitor trends.
Compare monthly revenue over time 📆
To detect seasonality or compare performance:
-
Sort by Check-in Date (or Booked On)
-
Group rows by month to see booking flow
-
Use Excel’s Pivot Table feature:
-
Rows: Check-in Month
-
Values: Sum of Total Price or Count of Booking ID
-
📌 Example: You notice a sales dip in September vs. July. This insight helps plan targeted marketing campaigns or strategic promotions.
Identify top-selling products and partners 🏆
With a Pivot Table, you can identify:
-
Most booked hotels or experiences
-
Rows: Product Name
-
Values: Count of Booking ID
-
-
Top-performing DMCs
-
Rows: Partner Name
-
Values: Sum of Total Price
-
💡 Use this data for future negotiations, preferred partnerships, and supplier performance tracking.
Takeaways
✅ Use Client Folders > Extract to CSV to get all booking data
✅ Focus on the “Status” and “Total Price” columns for confirmed revenue
✅ Use Pivot Tables to group data by product, city, TO user, or travel month
✅ Compare booking and revenue trends across different months or years
✅ Identify your best-selling hotels, experiences, and most profitable DMCs
FAQ
How can I track revenue for confirmed bookings only?
💰 Filter your report by "Status = Confirmed" and sum the “Total Price” column.
Can I analyze revenue by destination?
🌍 Yes. Use the “City” or “Country” fields in a pivot table.
How do I compare performance over time?
📆 Group by “Check-in Date” or “Booked On” to compare month-over-month or yearly trends.
Can I extract only hotel or only experience bookings?
🎯 Use the “Typology” filter in KOOB before exporting.
What if I want to analyze guest volume?
👥 Use the “Number of Guests” column to calculate total travelers per month or per product.
Related articles
📌 Need help? Visit the KOOB Knowledge Base or contact KOOB Support 🚀