Setting Goals for Report Builder Reports

Overview

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

• 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 the % sign (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 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.
  
• 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

• Navigate back to the Report Builder page.
• Under Goals Setup, click Upload File and select your completed CSV.
  
  
  

Using Goals in Report Builder 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.

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

• Related Articles

• Getting Started with Report Builder

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

• Uploading & Using Monthly Goals in Report Builder

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

• Portfolio Analytics: Pacing Reports

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

• How are Market Values Populated in Report Builder

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

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