How to compare booking growth over different periods?

✅ Compare bookings and revenue month over month or year over year
✅ Identify growth trends in hotel, experience, or trip sales
✅ Visualize high and low performing periods
✅ Support commercial strategies with historical data

🚀 Objective: Use KOOB data exports to track business growth over time and make better sales and distribution decisions.

Export booking data by period 📦

To compare different time periods, start by extracting structured data from KOOB:

Option A – My Bookings

Go to Bookings > My Bookings

Apply filters (Booking Date or Check-in Date)
Select the typology (Hotel, Experience, or both)

Click Extract to CSV

Option B – Clients' Bookings

Go to Bookings > Clients' Bookings

Filter by TO, booking period, product type, or destination

Click Extract to CSV

💡 Use "Clients’ Bookings" to compare TO behavior and revenue by period. Use "My Bookings" to compare supplier usage and margin evolution.

Use booking or check-in date to compare periods 📊

Once your data is open in Excel or Google Sheets, focus on the following columns:

📅 Booking Date → For sales trend comparisons
📅 Check-in / Check-out Date → For travel demand tracking
📌 Status → Filter only “Confirmed” for accurate comparisons
💰 Selling Price TO → Total revenue
💸 Margin DMC → Your profit
👥 Number of Guests → Pax trends

💡 Example: Compare Q1 vs. Q2 by filtering booking dates between Jan–Mar and Apr–Jun. Sum the confirmed revenue and count the number of bookings.

Compare month-over-month or year-over-year growth 📆

Using the Check-in Date column:

Create a Pivot Table
Use Check-in Date as the row
Group by month or year
Add the following values:
- Count of Booking ID (volume)
- Sum of Selling Price TO (revenue)
- Sum of Margin DMC (profit)

💡 Tip: Right-click the date column in the Pivot Table → Group → select Months or Years

Visualize booking growth in charts 📈

To easily communicate your growth insights:

Insert a line chart or column chart from your Pivot Table
X-axis → Travel Month
Y-axis → Revenue or Booking Count
Add data labels to view month-over-month differences
Highlight peak and low seasons for decision-making

Break down growth by product or TO 🧭

Use your Pivot Table to explore where your growth is coming from:

Tour Operator Name in Rows
Check-in Month in Columns
Values → Sum of Selling Price TO

Or alternatively:

Hotel / Experience Name in Rows
Compare revenue performance by product

💡 Example: You find that bookings for “Bamboo Journey Laos” doubled in Q2 vs Q1, while another hotel dropped — a good lead for commercial reactivation.

Takeaways

✅ Use KOOB’s exports to compare booking performance across periods
✅ Filter by Booking or Check-in Date for sales or travel trend analysis
✅ Focus on confirmed bookings to get reliable insights
✅ Use Pivot Tables grouped by month or year to structure data
✅ Combine charts and breakdowns to support commercial decisions

FAQ

How can I compare booking volume across different months?
📆 Group your Pivot Table rows by Check-in Date and count Booking IDs for each month.

How do I measure revenue growth over time?
📈 Use the "Selling Price TO" column, grouped by Booking or Travel Month, and compare totals between periods.

Can I compare performance per TO between quarters?
📊 Yes. Use a Pivot Table with “Tour Operator Name” and group by Check-in or Booking Month to compare.

How do I detect if a drop in revenue comes from specific products?
🔍 Group your data by product name and compare revenue per month or quarter.

Can I visualize growth in Excel?
📉 Yes! Create a line or bar chart from your Pivot Table to track trends over time.

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