How to track total bookings and revenue?

✅ Export detailed booking reports with net costs, selling prices, and margins
✅ Monitor confirmed revenue and booking trends per TO or product
✅ Analyze the number of travelers and booking volumes over time
✅ Identify your top-selling partners, hotels, and experiences

🚀 Objective: Track your booking activity and margin performance over time to make better pricing, sales, and product decisions.

Accessing booking and revenue data 📊

To track your booking and revenue performance, start by extracting booking data from KOOB:

Option A — "My Bookings" section (DMC-originated bookings)

Go to Bookings > My Bookings

Use filters:

- Search (User name, Internal Booking Reference, ID, Hotel or Experience Name)
- Booking Period (when the booking was made)
- Travel Period (check-in/check-out)
- Typology (Hotels, Experiences)
- Period (Day, Week, Month)
- Booking Status (Confirmed, Sent, Cancelled, etc.)

Click "Extract to CSV" to download the report

📌 Use filters before exporting to focus on relevant time periods, product types, or booking statuses.

Option B — "Clients' Bookings" section (TO-originated bookings)

Go to Bookings > Clients' Bookings

Use filters:
- Booking Period (when the booking was made)
- Travel Period (check-in/check-out)
- Typology (Hotels, Experiences)
- Period (Day, Week, Month)
- Booking Status (Confirmed, Sent, Cancelled, etc.)
- Search by TO name, user, or reference

Click "Extract to CSV" for a complete export

💡 Tip: Use the Clients’ Bookings extract for margin analysis and TO invoicing, as it includes net cost, selling price, and applied margin.

Key data points to analyze 📈

Once your CSV file is opened in Excel or Google Sheets, focus on the following fields:

Field	Description
Booking ID	Unique booking reference
Booking Date	Date the reservation was created
Status	Confirmed, Canceled, Pending, etc.
Selling Price TO	Price charged to the Tour Operator
Price DMC	Your net cost as the DMC
Margin DMC	Profit margin generated on each booking
Provider	Indicates direct contract, KOOB, or Bedbank
Tour Operator Name	Name of the TO client
Hotel/Experience Name	Product booked
City / Country	Destination information
Number of Guests	Total pax per booking

📌 If you filter by Status = "Confirmed", you can analyze other columns to know which TOs bring the most revenue or which destinations are the most booked.

Analyzing booking revenue and performance over time 📈

To understand trends and make data-driven decisions:

Filter the data by "Booking Date" to analyze performance monthly or quarterly
Group data by TO, Provider, or Destination to compare revenue sources
Compare Selling Price TO and Price DMC to evaluate profitability
Track margins using the Margin DMC field for every confirmed booking

📌 Tip: If a TO consistently generates high margins but low volume, you may want to prioritize account development or adjust pricing strategies accordingly.

Tracking total guests and booking volume 👥

Understanding traveler volume helps you better manage operations and plan for high seasons:

Use "Number of Guests" to monitor pax volume over time
Separate "Number of Adults" vs "Number of Children" to identify family vs FIT trends
Filter "City" or "Hotel/Experience Name" to track product-specific performance

📌 Example: You notice a surge in group bookings for Hanoi in October. Use this insight to negotiate better allotments with hotels ahead of time.

Comparing TO performance and distribution results 🔍

You can identify your strongest TOs by analyzing booking quantity and revenue contribution:

Filter by "Tour Operator Name"
Count total confirmed bookings
Compare "Selling Price TO" to measure revenue
Analyze the "Margin DMC" field to identify the most profitable partnerships

📌 Tip: Use this data before contract renegotiations or quarterly business reviews to support your discussions with TOs.

Takeaways

✅ Use the Clients’ Bookings export to track total revenue and margin per TO.
✅ Focus on "Confirmed" bookings only to analyze real sales performance.
✅ Monitor Selling Price TO, Price DMC, and Margin DMC columns to understand profitability.
✅ Segment by Tour Operator, destination, or product type to identify trends.
✅ Track number of guests and booking duration to plan operations and forecasts.
✅ Prepare for TO negotiations or hotel partnerships using real extracted data.

FAQ

Q: Where can I track my margin per booking?
💰 In the exported file, use the “Margin DMC” column to see profit per reservation.

Q: Can I filter by destination or product?
📍 Yes, use “City”, “Hotel/Experience Name”, or “Country” fields to segment your data.

Q: How do I identify top-performing TOs?
📊 Group confirmed bookings by “Tour Operator Name” and compare total revenue and margin.

Q: Can I track seasonal performance?
📅 Sort or group your data by “Booking Date” or “Check-in Date” to see monthly or quarterly trends.

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