This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Channel Performance Manager at Marriott. The commercial team needs a monthly breakdown of booking activity by distribution channel. This report will inform decisions about commission negotiations with OTA partners and investment in the direct booking platform. Your task is to parse each booking timestamp, extract the month as a YYYY-MM string, and then aggregate the number of bookings and total revenue for every month-channel combination.
You are a Channel Performance Manager at Marriott. The commercial team needs a monthly breakdown of booking activity by distribution channel. This report will inform decisions about commission negotiations with OTA partners and investment in the direct booking platform. Your task is to parse each booking timestamp, extract the month as a YYYY-MM string, and then aggregate the number of bookings and total revenue for every month-channel combination.