Overview

The Monthly Goals setup feature in Report Builder enables users to set monthly goals (or targets) for key metrics like Total Revenue, Rental Revenue, ADR, RevPAR, and Occupancy. This functionality allows users to track progress towards their goals with metrics that can be directly added to custom reports generated in Report Builder.

The feature supports:

• Uploading a CSV file with monthly goals for each of listings added to a user's account.
• Three new metrics: Goal, Goal Completion %, and Goal Completion Difference for each of Occupancy, Total Revenue, Rental Revenue, ADR, RevPAR.
• Conditional Formatting on Goal completion % and Goal Completion Difference to easily get a view of the current state of these metrics against the set targets

Key Metrics Explained

1. Goal: The target value for a particular metric  (Total Revenue, Rental Revenue, Occupancy, ADR or RevPAR uploaded by the user.
2. Goal Completion %: Defined as (Current Value of the metric / Goal Value) × 100 %
3. Goal Completion Difference: Defined as (Current Value - Goal Value)

How It Works

Users upload their monthly goals in a predefined CSV format. The system distributes monthly goals equally across days of each month to enable calculation for custom date ranges. If goals for a month are not set, the report will display "N/A" for Goal-related metrics for any row in the report that has a date for which goal is not set.

Steps to Upload Monthly Goals

1. Download the CSV Template

• Navigate to the Report Builder section in the Portfolio Analytics menu.
• Under Goals setup Goals, select Download CSV to retrieve the required file format.

2. Populate the Template

• Fill in the template with your target values for the specified metrics. Ensure data accuracy to avoid validation errors.
  
• Occupancy goal needs to be uploaded without % (for e.g. for a goal of 83.3% add the goal as 83.3)
  
• Revenue, ADR and RevPAR goals need to be uploaded without currency (for e.g.  for a goal of $40,000 add the goal as 40000). We use the listing currency added to the PL account to populate currency on the report.

• Navigate back to the Upload Monthly Goals section.
• Click Upload File and select your completed CSV.

Using Monthly Goals in Reports

Add Goal Metrics to Reports

• While creating or editing a report, select the following metrics:
  
  • Goal: Shows the uploaded target value.
  • Goal Completion %: Indicates progress as a percentage.
  • Goal Completion Difference: Highlights the gap between current performance and the target.
•  Add specific Goal metrics from the corresponding metrics under the 'Value' section e.g. Total Revenue Goal can be found under  Revenue Metrics - >Total Revenue** section under 'Values'
  

Validation Rules

When uploading the CSV:

• Ensure the Month is added as the name of the month in English - January, February and so on
• All numeric values must be positive.
  
• There is no need to add currency, currency will be added from listing's currency by default.
  
• Remove % from Occupancy Goal  i.e. for an Occupancy goal of 89.8% enter 89.8 in the upload
• Any empty fields for metrics in a row will result in those fields being treated as missing.
• For duplicate entries we will consider the row that is at the bottom and ignore the other row
  
• Invalid months in the CSV will trigger an error.