How are Market Values Populated in Report Builder

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 insights by comparing your listings to your competitive set. This article explains how these market values are populated and introduces a new feature that allows mapping Market Dashboards (MD) and Compsets to specific groups or cities.


How Market Values Are Derived in Report Builder for a listing level report (Header row is 'Listings')

For Market Values in Report Builder, when a listing level report is being created, we use the selection you have done on Neighborhood Data tab as the 'market'. In Neighborhood Data tab, this could be one of the below: 

  1. Default Nearby Listings Set (System-Defined) - By default, PriceLabs uses the Nearby Listings Set defined in the Neighborhood Data (ND) section. This is automatically populated with listings geographically close to your property. The system calculates market metrics like occupancy, ADR, and RevPAR based on the performance of these nearby listing.



Info
Please note that changing the bedroom count for 'Nearby Listings' does not change the market definition in Report Builder reports, we continue to use the default selection of BR count independent of the selection here.
  1. Custom Market Dashboard Compset (User-Defined) - You can create and manage your own Compsets by navigating to Market Dashboards. When a Compset is defined for a listing in ND, the Report Builder uses this data as the source for market values. This flexibility ensures that your market insights are based on the most relevant competitive landscape for your property.



Market definition for Groups, Cities, and More

When creating aggregated reports in PriceLabs Report Builder (e.g., at Group, Subgroup, City, or Bedroom Count levels), you can define the "market" values in two ways:

  1. Aggregate of Listings' Markets (Default): Market values are determined by averaging the market data of each individual listing in the selected category (e.g., Group or City).

  2. Manually Defined Market: You can specify market values directly. To do this:

    • Go to the "Define Source for Market Values" section on the Report Builder homepage.
    • Select a specific category (Group, Subgroup, City, or Bedroom Count).
    • Use this defined source (Market Dashboard Compset) for market data when generating your report.

For example: 

  • If a Group is mapped to a particular Compset, the market values in reports will automatically reflect the data from that Compset for all reports with Header row as Group.
  • If no mapping exists, the system will default to aggregate of listings' market as the market and average market values to come up with final market values for the Group.

Case Use Example

Scenario: You have created groups based on Bedroom Count (BR Count) and City:

  • Chicago 2BR

  • Chicago 3BR

  • Milwaukee 1BR

  • Milwaukee 4BR

You also created two MDs for Chicago and Milwaukee, with compsets:

  • 2BRChicago, 3BRChicago

  • 1BRMilwaukee, 4BRMilwaukee

Steps to Map Chicago 2BR Group to the Relevant Compset:

  1. Navigate to Report Builder and select Define Source for Market Values.
  2. From the left-hand menu, choose Group.
  3. All groups in the account will appear, with the default Mapped Dataset displayed as Aggregate of Listings in the Group.
  4. Use the dropdown to change the dataset for the Chicago 2BR group:
    1. Select Chicago-MD from the dropdown for the Market Dataset.
    2. Then, for the Market Dashboard Compset, select 2BRChicago.
  5. Repeat this process for all other groups (e.g., Milwaukee 1BR, Milwaukee 4BR & Chicago 3BR).

Outcome:

Now, when creating a report with the header row as Group, metrics like Market Occupancy, Market ADR, and others will reflect data from the assigned MD compsets for each group.

Conclusion

The combination of default Nearby Listings Sets, user-defined Compsets, and the new mapping feature makes PriceLabs’ Report Builder a powerful tool for benchmarking against the market. By understanding how market values are populated, you can create reports that provide actionable insights and help optimize performance.

For questions or support, feel free to reach out to support@pricelabs.co!


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

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

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

    • Market Dashboard in Action: Real-Life Applications and Case Studies

      This page delves into the Market Dashboard, highlighting key metrics and trends to provide a clearer understanding of each chart and its use cases. Listing Map and Comp Sets Location The map will show the approximate location of the active listings ...

    • Market Dashboards - Amenities

      Market Dashboards are fully automated personalized dashboards that can help you track your location’s STR booking data through easy to digest graphs and insights. New user accounts with listings imported in PriceLabs will be credited with 1 free ...

    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.