How to Use the Comparison Formula in Cloudbeds Insights

First, you need to set up a new report with Comparison Mode enabled.

1. Go to Menu > Reporting > Click Add Report.

2. In the "New Report" window, select a Report Type. For this example, choose Financial.
3. Enter a Report Name, like "Comparison".
4. Check the box to Enable comparison mode.
5. Click Create.

Next, define the time periods you want to compare. In this example, we will set up a year-over-year comparison.

1. In the report builder, click the Period Comparison Mode button
2. In the left-hand panel, find the Select Data Field and choose "Service Date" from the dropdown menu.
3. Under Compare Periods by, select Year(s).
   The system will default to three periods: "Last year," "This year," and "Next year."
4. Click Edit in the "Periods" section.

5. To create a clean year-over-year report, edit the period as follows:
   1. Edit "Last year" → change the date range to "This year", click Confirm.
   2. Edit the second period → change the date range to "Last year", click Confirm.
   3. Edit the third period → click Delete.

6. Click the main Apply button at the bottom.
7. Click Save.

Now, you can add a custom column that will calculate the difference between the two periods.

1. In the report builder, click the Period Comparison Mode button
2. Click the + Add button under "Periods" and select Comparative range.

3. In the "Add comparative range" window, name it YOY Change, set "Show range after" to This year, and click Confirm.

4. A new section called "YOY Change" will appear. Click + Add Column within this section.

5. In the "Add column" window, configure the following:
   • Column name: YOY Change
   • Format: Number
   • Metric A: set the Data field to Transaction Amount, the Metric to sum, and the Base range to This year.

6. Click the Add button and configure Metric B: set the Data field to Transaction Amount, the Metric to sum, and the Base range to Last year.
7. Use the buttons to create the expression "A - B" in the formula box.
8. Click Confirm.

9. Click Apply to preview the new "YOY Change" column, which shows the calculated difference between this year's and last year's transaction amounts.
10. Click Save to finalize your report.

If the Add Report option is not visible or you’re unable to create a report, it may be due to one of the following reasons:

• Cloudbeds Insights is not enabled for your account.
• Your user role does not have the required role permissions to access Insights.

To resolve this:

• Cloudbeds Insights is available with select packages. If you're not sure whether it's included in your plan, feel free to reach out to our team at customer_growth@cloudbeds.com
• Not a Cloudbeds customer yet? You can explore our Pricing Guide or schedule a demo to see how Cloudbeds Insights can support your business.
• Already a customer? Make sure your user role includes the Cloudbeds Insights Reports permission under Roles.

Yes. Even if your property doesn’t have a paid Insights license, you can still take advantage of the Comparison Formula through a selection of predefined Stock Reports.

While you won’t be able to build custom reports without Insights, the Comparison Formula will still appear in any supported stock reports.

The following reports will include the Comparison Formula functionality:

• Daily Pickup – located under Reporting > Cloudbeds Reports > Occupancy
• Pace with YOY Change – located under Reporting > Cloudbeds Reports > Occupancy
• Revenue Comparison by Source – YOY – located under Reporting > Cloudbeds Reports > Financial
• Revenue Comparison – YOY – located under Reporting > Cloudbeds Reports > Financial