Marketing Cloud Lodging Reports

Marketing Cloud Lodging reports detail information about guest lodging activity at your resort.

Note: This report list is not inclusive. You may see more reports than those listed below in your Marketing Cloud account.

The Booking Window report shows the total number of reservations booked during a particular time frame. Bookings are grouped into the following windows:

  • Same Day as stay
  • 1–7 Days prior to stay
  • 8–14 Days prior to stay
  • 15–21 Days prior to stay
  • 22–28 Days prior to stay
  • 29–59 Days prior to stay
  • 60+ Days prior to stay

Use the following parameters to run the report and filter the report data:

  • Arrival Begin Date* – Enter the date from which report results begin.
  • Arrival End Date* – Enter the date on which report results end.
  • Include Guest Type* – Select a guest type by which to filter report results.
  • Exclude Guest Type* – Select a guest type to withhold from report results.
  • Destination – Select a destination for which you want report data.
  • Property – Specify the property or resort for which you want report data.
  • Group By* – Select a guest trait (e.g. City, Country, Metropolitan Statistical Area) to further analyze a particular segment's lodging trends.
  • Show All – Check the box to show all report results or uncheck the box to show only the top 15 results most relevant to your query.

* = required parameter

  • Bookings – Number of bookings
  • Room Nights – Number of room nights
  • % of Total Room Nights – Percentage of total room nights booked
  • Average Daily Rate – Average dollar amount spent per day

The High-End Booking Report lets you search the database for guests who booked a stay during a specified date range and have a minimum planned spend amount. You can filter results to include and/or exclude specific guest types. You can also filter results to only include specific properties.

Use the following parameters to run the report and filter the report data:

  • Booking Start Date* – Enter the date from which report results begin.
  • Booking End Date* – Enter the date on which report results end.
  • Show Wealth Append/Scans* – Add-on feature. For more information, contact Inntopia Partner Services or your Strategic Account Manager.
  • Planned Spend Amount* – Enter the minimum planned spend amount to include in report results. Planned spend is the total amount the guest already has booked on the upcoming reservation.
  • Destination/Resort* – Select a destination or resort for which you want report data.
  • Exclude Guest Types*– Select a guest type to withhold from report results.

* = required parameter

  • Arrive – Arrival Date
  • Depart – Departure Date
  • Booking Date – Booking Date
  • Resid – Reservation ID
  • Destination – Destination name (if configured)
  • Property – Property/hotel name within the broader destination (if configured)
  • Cust Key – Customer Key (a unique identifier assigned by Inntopia)
  • First Name – First name of the guest on the booking
  • Last Name – Last name of the guest on the booking
  • Address – Street address of the guest on the booking
  • City – City of the guest on the booking
  • ST – State of the guest on the booking
  • Zip – ZIP/Postal code
  • MSA – Metropolitan Statistical Area for the city and state displayed
  • Email Address – Email address of the guest on the booking
  • Phone Number – Phone number of the guest on the booking
  • Owner – Property-owner booked a stay (Y/N), if configured.
  • Adults (#) – Number of adults on the booking
  • Children (#) – Number of children on the booking
  • Visits (#) – Number of previous visits
  • LTS – Lifetime spend amount for the household
  • PS – Planned spend amount for the upcoming booking
  • RFM – RFM score assigned to the guest

The Lodging Year to Year report compares lodging metrics from a specified time period to that same time period beginning one year prior.

Use the following parameters to run the report and filter the report data:

  • Arrival Begin Date* – Enter the date from which report results begin.
  • Arrival End Date* – Enter the date on which report results end.
  • Include Guest Type* – Select a guest type by which to filter report results.
  • Exclude Guest Type* – Select a guest type to withhold from report results.
  • Destination – Select a destination for which you want report data.
  • Property – Specify the property or resort for which you want report data.
  • Group By* – Select a guest trait (e.g. City, Country, Metropolitan Statistical Area) to further analyze a particular segment's lodging trends.
  • Show All – Check the box to show all report results or uncheck the box to show only the top 15 results most relevant to your query.

  • Visits – Number of visits
  • Room Nights – Number of room nights booked
  • Avg LOS – Average Length of Stay (number of nights) 
  • % Total Nights – Percentage of total room nights booked
  • Lodging Spend – Total dollar amount spent during lodging stays
  • Avg Daily Rate – Average dollar amount spent per day

The Trailing 12 Month report compares monthly lodging statistics from two consecutive years and shows the percentage change between each set of months (e.g. September 2022 to September 2023).

Use the following parameters to run the report and filter the report data:

  • Month* – Select the month from which you want report data to begin.
  • Year* – Select the year from which you want report data to begin.
  • Include Guest Type* – Select a guest type by which to filter report results.
  • Exclude Guest Type* – Select a guest type to withhold from report results.
  • Market Segment – Select the market segment or segments for which you want report data.

  • Lodging Nights – Total number of lodging nights reserved
  • Lodging Spend – Total dollar amount spent
  • Average LOS – Average Length of Stay (number of nights)
  • Average Daily Rate – Average dollar amount spent per day
  • Average Lodging Spend – Average dollar amount spent per lodging stay
  • Repeat Rate – Percentage of lodging nights booked by repeat guests, or guests who previously stayed at the resort

 

Most Marketing Cloud reports require parameters to be defined before results are returned.

Note: To run some Marketing Cloud reports, you MUST make a selection for each parameter in linear order. Each parameter filter must to be opened, even to just select all or confirm the default option.

  1. From the navigation menu on the Marketing Cloud dashboard, click Reports. The Reports menu expands.

  2. From the Reports menu, select a report category. A list of reports available for that category appears.
  3. Select the report you want to run. The Report Viewer - <Report Name> screen appears showing the parameters available for the report you selected.
  4. Use the drop-down lists to select your report parameters. Depending on the type of report you select, the parameters will vary.

    Note: Parameters marked with an asterisk (*) are required to successfully run a report and vary depending on the report selected.

  5. Click Retrieve Report. The report results appear.

For instructions on exporting a report, click here.