How to measure DMC performance?

✅ Identify the most booked DMCs based on confirmed reservations
✅ Track response times, booking success rates, and cancellations
✅ Compare DMC performance over different time periods
✅ Improve partnerships by focusing on top-performing suppliers

🚀 Objective: Learn how to extract and analyze DMC performance data to optimize business decisions.

Extract booking data from KOOB 📦

To analyze DMC performance:

Go to Client Folders in the left-hand menu

Click Extract to CSV (top right corner)
Use the Booking Period filter to select a relevant timeframe

Open the file in Excel or Google Sheets for analysis

💡 Tip: Export monthly or quarterly data to monitor performance evolution over time.

Key data fields to analyze 🧩

Column	Description
🤝 Partner Name	The DMC handling the booking
📌 Status	Only include “Confirmed” bookings for accurate performance
📆 Booked On	Shows when the booking was created
📆 Start At / End At	Helps track peak demand periods
🔄 Updated At	Indicates when the booking was last modified
🎟 Allotments	Distinguish between Free Sale and On Request bookings
💰 Selling Price TO	Tracks revenue contribution per DMC

📌 Example: A TO wants to see which DMCs confirm the most bookings and generate the highest revenue.

💡 Tip: Filter by Status = Confirmed to focus on successful reservations.

Rank DMCs by booking volume 📊

To see which DMCs perform best:

Sort the file by Partner Name
Count the number of confirmed bookings per DMC using a pivot table
Compare booking volume across months or quarters

📌 Example: In Q1, DMC A registers 120 confirmed bookings while DMC B only reaches 45.

💡 Tip: A drop in booking volume may indicate delays, price issues, or reduced availability.

Measure success rate, cancellations, and response speed ⚙️

Evaluate your DMC partners by comparing:

Metric	Explanation
✔️ Success Rate	Confirmed Bookings ÷ Total Booking Requests
❌ Cancellation Rate	Canceled Bookings ÷ Total Bookings
⏱ Response Speed	Time from booking creation to confirmation or refusal

📌 Example:

DMC A confirms 90% of requests = Reliable
DMC B confirms only 60% = May face operational or pricing issues
DMC C cancels 30% of confirmed bookings = Unstable supply

💡 Tip: Use KOOB’s “Status” and “Updated At” columns to calculate response time and reliability.

Compare DMC revenue contributions 💰

To measure financial impact:

Group data by Partner Name
Sum the Selling Price TO column for each DMC
Rank by revenue contribution

📌 Example: DMC X generates $250,000 vs. DMC Y with $85,000 — valuable input for supplier prioritization.

💡 Tip: Favor high-revenue DMCs in marketing plans and future allocations.

Use data to negotiate and optimize partnerships 🤝

Once insights are gathered:

✅ Strengthen relationships with top-performing DMCs
✅ Negotiate better rates based on booking volume
✅ Flag and monitor underperforming DMCs
✅ Reduce cancellations by focusing on confirmed allotment partners

📌 Example: A TO renegotiates rates with a DMC that handled 70% of Southeast Asia bookings last quarter.

💡 Tip: If a DMC frequently refuses or cancels, consider proposing guaranteed allotments or switching partners.

Takeaways

✅ Extract and analyze DMC booking data to measure performance
✅ Compare confirmed bookings vs. total requests to track reliability
✅ Monitor cancellation rates to identify supplier issues
✅ Evaluate revenue contribution to optimize partnerships
✅ Use data for supplier negotiations to improve pricing and availability

FAQ

Q: Can I track DMC performance by country?
🌍 KOOB tracks by DMC name, but you can manually group DMCs by region in Excel.

Q: What if a DMC has a high cancellation rate?
❌ Investigate the reason—availability issues, pricing problems, or internal management concerns.

Q: How can I improve response times from DMCs?
📬 Use KOOB’s chat system to follow up quickly or escalate via your DMC channel.

Q: Can I track DMC success rate over time?
📈 Yes. Compare the number of confirmed bookings to total requests for different periods.

Q: What if my top-performing DMC starts declining?
🔍 Monitor response delays or pricing updates. It may be time to renegotiate or review contract terms.

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