✅ Export client folder data into Excel CSV for analysis
✅ Filter reports by booking period, traveler details, or providers
✅ Analyze booking trends, hotel performance, and sales insights
✅ Monitor popular destinations and seasonal booking trends
🚀 Objective: Learn how to easily extract, filter, and analyze client folder reports to enhance decision-making and performance monitoring.
Extracting client folder data 📥
You can extract data for both hotels and experiences directly from the Client Folders view.
Steps to extract your booking report:
-
Go to Client Folders in the left menu
-
Click on “Extract to CSV” in the top-right corner
-
Open the file in Excel or Google Sheets
📌 Example: Need to analyze Q1 performance for Southeast Asia? Use the “Booked on” filter to select January–March and focus on countries like Thailand or Vietnam.
💡 Tip: Extract reports every month and name them clearly (e.g., Hotel_Bookings_Feb2025.csv) to track progress over time.
Understanding your report structure 📑
Extracted KOOB hotel booking reports include essential data fields to help manage bookings effectively:
Key Data Fields:
| Data Field | Description |
|---|---|
| 📅 Created By | The TO user who created the booking |
| 📂 Folder Name | Name of the Client Folder linked to the booking |
| 🔖 Folder Reference | Custom reference used to group bookings under the same client folder |
| 📌 Status | Sent, Confirmed, Refused, Canceled, Pending |
| 📆 Start Date (Folder) | Start date of the trip |
| 📆 End Date (Folder) | End date of the trip |
| 👤 Main Guest Name | Lead traveler name |
| 🏨 Provider | DMC or bedbank handling the booking |
| 👥 Number of Guests | Total number of travelers |
| 🔢 Number of Bookings | Count of individual bookings within a Client Folder |
| 🔄 Updated At | Most recent update timestamp |
| 👶 Number of Children | Number of children in the booking |
| 🧑 Number of Adults | Number of adults in the booking |
| 🏨 Hotel/Experience Name | Product name (hotel or activity) |
| 🌍 City | Destination city of the product |
| 📅 Booked On | Date the booking was created |
| 📅 Start At | Check-in / Experience start date |
| 📅 End At | Check-out / Experience end date |
| 🤝 Partner Name | DMC partner managing the booking |
| 🔍 Internal Reference | KOOB system reference |
| 🔖 Reference Code | External supplier reference code |
| 🛏 Room Name(s) | Hotel room category (if hotel) |
| 🛌 Room Information | Bed type, setup or configuration |
| 🏷 Promotions / Supplements | Extra services, discounts, or required supplements |
| 🏢 Tour Operator Name | Your TO account name |
| 🌐 Network Name | Division within your TO company |
| 📝 Notes | Internal notes or special client requests |
| 🎟 Allotments | Whether booking used a contracted allotment |
| 💰 Total Price | Final selling price (including extras, taxes) |
📌 Example: Sort by 🌍 City and 🏨 Hotel/Experience Name to see which products are top sellers in each destination.
💡 Tip: Add color codes in Excel to highlight high-margin products or filter by 👥 Number of Guests to analyze group trends.
Analyzing extracted data 📊
Utilize your extracted reports to gain valuable insights:
Performance by TO User/Admin
-
Identify top-performing team members by bookings created.
-
Monitor modifications and oversee administrative control.
Booking Trends & Seasonality
-
Track monthly or quarterly booking volumes.
-
Highlight peak and low travel seasons.
-
Year-over-year performance comparisons.
📌 Example: Identify July and December booking peaks to enhance seasonal promotions.
💡 Tip: Visualize booking trends easily using Excel charts.
Demographic Insights (Adults & Children)
-
Differentiate family travel from solo bookings.
-
Pinpoint popular experiences by demographic groups.
📌 Example: If bookings frequently include children, consider enhancing family-focused travel offerings.
💡 Tip: Sort data by adult and child traveler counts to identify trends in group vs. individual travel.
Hotel & Supplier Performance
-
Determine hotels with the highest/lowest booking frequencies.
-
Compare booked nights per destination.
-
Evaluate usage of direct DMC contracts versus bedbanks.
📌 Example: High cancellation rates at certain hotels may prompt a review of supplier contracts.
💡 Tip: Filter data to separate bookings by supplier type (DMC vs. bedbank).
Revenue & Pricing Analysis
-
Calculate average booking prices per destination.
-
Review revenue generated by provider or package type.
📌 Example: Japan itineraries generating higher revenue compared to Thailand might redirect marketing strategies.
💡 Tip: Use Excel’s SUM function to aggregate revenue by provider or package.
Takeaways
✅ Easily export reports to CSV for instant data analysis.
✅ Comprehensive and customizable filters enhance business intelligence.
✅ Centralized tracking across hotels, experiences, and destinations.
✅ Monitor seasonal and demand trends for better forecasting.
✅ Evaluate supplier performance to optimize partnerships.
FAQ
Q : Can I filter reports by specific date ranges?
🟢 Yes, KOOB allows filtering by customized booking periods, ideal for seasonal trend analysis.
Q : Are reports compatible with Excel analysis tools?
🟢 Absolutely! Reports export as CSV files, fully compatible with Excel's pivot tables and chart tools.
Q : How frequently should I analyze booking reports?
📅 Regular monthly or quarterly analysis is recommended, aligning with business review cycles and travel seasons.
Q : Can I identify top-performing destinations easily?
🟢 Yes, simply use Excel sorting or pivot tables to highlight top-selling destinations quickly.
Related Articles
- How to extract booking reports and data?
- How to track total bookings and revenue?
- How to compare booking growth over different periods?
- How to analyze confirmed vs. canceled bookings?
- How to identify top-selling destinations ?
- How to measure DMC performance?
- How to track the most booked hotels and experiences?
- How to analyze customer behavior and repeat clients?
- How to monitor seasonal trends and peak travel periods ?
Need help? Visit the KOOB Knowledge Base or contact KOOB Support 🚀