Setting Goals for Report Builder Reports

Setting Goals for Report Builder Reports

The 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.

How to Set Goals for your Listings

Setting goals is a straightforward process that helps you align your reporting with your business objectives. Follow these steps to define and track your targets effectively. You can also watch the video guide here.
  1. Download the CSV Template
    1. Navigate to the Report Builder section in the Portfolio Analytics menu.
    2. Under Goals Setup, select Download CSV to retrieve the required file format.
  2. Populate the Template
    1. Fill in the template with your target values for the specified metrics:
    2. Ensure data accuracy to avoid validation errors:
      1. Occupancy goal needs to be uploaded without the % sign (for e.g. for a goal of 83.3% add the goal as 83.3)
      2. Revenue, ADR and RevPAR goals need to be uploaded without currency sign (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.
      3. In cases involving large numbers, CSV files may automatically convert them into scientific notation. To retain the original format, ensure you select Don't convert as shown in the screenshot below.
  3. Upload the CSV
    1. Navigate back to the Report Builder page.
    2. Under Goals Setup, click Upload File and select your completed CSV.

Add Goal Metrics to Reports

While creating or editing a report, select the following metrics:
  1. Goal: Shows the uploaded target value.
  2. Goal Completion %: Indicates progress as a percentage.
  3. Goal Completion Difference: Highlights the gap between current performance and the target.

Additional Information

  1. We divide monthly goals equally across all days of the month. If a report spans multiple months, the system aggregates daily goals to calculate metrics for the selected date range.
  2. In case for any date for any row of the report the goal is not setup, the report will show N/A (Not applicable) for the corresponding column.

Validation Rules

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

    • Related Articles

    • Getting Started with Report Builder

      PriceLabs Report Builder is a free tool designed to enhance your reporting and data analysis capabilities within PriceLabs. With report builder, you can create, customize, and save reports that are tailored to your business and your regular ...

    • Portfolio Analytics: Pacing Reports

      This report is more future-focused to bring out actionable information to drive changes in revenue management strategies and is good to be reviewed periodically. The Pacing chart in Portfolio Analytics gives insights into your booking rate against a ...

    • How are Market Values Populated in Report Builder

      Understanding market performance is crucial for making informed revenue management decisions. In PriceLabs’ Report Builder, market values such as Market Occupancy, Market ADR, and Market RevPAR and other market metrics provide valuable insights by ...

    • Portfolio Analytics: KPIs & Historic Reports

      This report is more backward-focused and is not necessarily needed for daily decision-making. KPIs The first section of the report displays Key Performance Indicators (KPIs), allowing you to compare broad metrics across various dates to observe ...

    • Mastering Portfolio Analytics: Using Pacing Reports to Track and Adapt (A Compilation of Case Uses)

      Understanding key performance metrics is crucial for optimizing revenue management strategies when managing a portfolio of rental properties or hotels. Four essential metrics in this context are Listed Price, Occupancy, Average Daily Rate (ADR), and ...

    Sign up for training

    To help you get the most out of PriceLabs, we have training webinars in English, Spanish, Portuguese and French. Click here to Register.