Monthly Channel Mix Performance Report

Track and analyze revenue performance across different booking channels (direct, OTAs, corporate, wholesalers) to optimize distribution strategy and maximize RevPAR. Monitor channel costs, booking patterns, and price parity to ensure optimal channel mix and profitability.

Report Objective

Monitor and optimize the distribution channel mix across properties to maximize revenue while managing costs. Track booking patterns, revenue contribution, and profitability by channel to inform pricing and inventory allocation decisions.

Channel Revenue Distribution

Stacked bar chart showing revenue contribution by channel

Questions to Consider:

DirectExpediaBooking.comCorporateTravel AgentWholesalerchannel$0$5,000,000$10,000,000$15,000,000sum(revenue)sum(revenue)How is Revenue Distributed Across Channels?Direct and OTA channels continue to be primary revenue drivers
  • Which channels are the top revenue contributors?

  • How has the channel mix changed from previous months?

  • Are there opportunities to optimize low-performing channels?

  • Are there consistent patterns in channel performance?

  • Which channels show the most growth potential?

  • How do seasonal factors impact channel performance?

Mar 2024Apr 2024May 2024booking_month$800,000$900,000$1,000,000sum(revenue) vs. channelsum(revenue)channelHow is Channel Revenue Trending Monthly?Monthly revenue trends show seasonal patterns across channels

Average Daily Rate (ADR) by Channel

Line chart comparing ADR trends across channels

Questions to Consider:

DirectExpediaBooking.comCorporateTravel AgentWholesalerchannel$0$1,000$2,000$3,000$4,000sum(adr)sum(adr)How Does ADR Compare Across Channels?Significant ADR variations observed between channels
  • Which channels command the highest ADR?

  • Are there opportunities to improve ADR in specific channels?

  • How does channel ADR align with our pricing strategy?

  • How is ADR trending across different channels?

  • Are we maintaining consistent price positioning?

  • What is the impact of promotions on channel ADR?

Mar 2024Apr 2024May 2024booking_month$240$260$280sum(adr) vs. channelsum(adr)channelWhat are the Monthly ADR Trends by Channel?Channel ADR shows distinct seasonal patterns

Channel Booking Lead Time and Patterns

Bar chart showing average booking windows by channel

Questions to Consider:

DirectExpediaBooking.comCorporateTravel AgentWholesalerchannel0200400600800sum(avg_lead_time_days)sum(avg_lead_time_days)How Do Booking Patterns Vary by Channel?Significant variations in lead time and cancellation rates across channels
  • Which channels have the longest/shortest booking windows?

  • How do cancellation rates correlate with booking lead times?

  • Are there opportunities to optimize inventory allocation based on booking patterns?

Focus Areas for Optimization