PS: Pulling STR Data into ProfitWizard

The Hook:

• Use this workflow to pull Smith Travel Research (STR) data into ProfitWizard pivot tables for ad-hoc analysis.
• STR data is available for both "Competitive Set" and "Competitive Property" metrics. This allows you to recreate STR reports and manipulate the data using Excel pivot features.

 

Prerequisites:

• Mode Requirement: You must select Actuals in the Mode field. STR data will not display for Budget or Forecast modes.
• Data Calculations: ProfitSage does not store Indexes or Percent Change. You must calculate these manually using Excel formulas after the data is pulled.
• Measure Mapping: You must use specific system measures to represent standard STR metrics:
  • Occupancy = % of Available Rooms
  • Rate = $ Per Occupied Room
  • RevPAR = $ Per Available Room

 

The Steps:

Phase 1: Configuring the Pivot Table

1. Open ProfitWizard (Excel Add-in).
2. Drag and drop the Sites field and select the specific properties (or "All Properties") to review.
3. Drag and drop the Period field and select the desired Months or Days.
4. Drag and drop the Mode field and strictly select Actual.
   • Note: Data will not populate if any other mode is selected.
5. Drag and drop the Measure/Value field and select the three required metrics:
   • % of Available Rooms
   • $ Per Occupied Room
   • $ Per Available Room

Phase 2: Selecting the Data Set (Comp Set vs. Comp Prop)

1. Locate the Key Stats dropdown in the Item list.
2. Select the desired data set:
   • Competitive Set: Displays the aggregated performance of the competitor set.
   • Competitive Prop: Displays the performance of your specific property as reported to STR.
3. Refresh the Pivot Table to generate the data.

 

The Result:

• Success: The Excel Pivot Table populates with the raw STR performance data, matching the "Report View" found in ProfitSage.

 

Troubleshooting:

• Data is blank: Ensure the Mode is set to Actual. Verify that the Item selected is strictly "Competitive Set" or "Competitive Prop" located under the Key Stats grouping.
• Missing Indexes: As noted in Prerequisites, ProfitSage does not import index values. You must add a calculated field or formula in Excel to derive these (e.g., Property Rate / Comp Set Rate * 100).