Setting up key hotel reports with Cloudbeds

Overview

This guide explains how to create 3 dashboards in Klaviyo using Cloudbeds' Confirmed Room Night and Completed Room Night event metrics.

Prerequisites

• Your Cloudbeds integration must be connected to Klaviyo. Learn how to connect Cloudbeds.
• You need permission to create and edit dashboards, such as the Owner, Admin, Manager, or Analyst role.
• Confirm that Confirmed Room Night and Completed Room Night are available in your account before creating these dashboards. Completed Room Night events sync after guests check out.

These dashboards report room-night events synced to Klaviyo. They exclude reservations with anonymized guests, no guest email, or a known masked email address from an online travel agency (OTA), as well as room nights with no nightly rate.

Dashboard 1: Historical Daily Room Revenue from Stays

This dashboard measures the historical daily room revenue — useful for evaluating the revenue attributable to each night. At the end of these steps, your dashboard for daily room revenue will look like this:

Steps

1. Log in to Klaviyo.
2. In the left-hand navigation, click Analytics, then click Dashboards.
3. Click Create Dashboard. Name it as you like (e.g., Historical Daily Room Revenue from Stays).
4. Click Create Dashboard.

Add Card 1 — Historical Revenue from Stays

1. Click Add card, then select Create from scratch.
   • Metric: Completed Room Night
   • Measurement: Value (the sum of the nightly room rates)
   • Group by: (none)
   • Visualization: Line graph
2. Click Add Card.

Add Card 2 — Historical Revenue from Stays by Room Type

Same process as above, except select Group by RoomTypeName.

• Metric: Completed Room Night
• Measurement: Value (the sum of the nightly room rates)
• Group by: RoomTypeName

Grouped line graphs show the top 5 values for the selected measurement and date range. To see all room types, properties, or booking sources, choose Table instead of Line graph.

Add Card 3 — Historical Revenue from Stays by Property Name

Same process as above, except select Group by PropertyName.

• Metric: Completed Room Night
• Measurement: Value (the sum of the nightly room rates)
• Group by: PropertyName

Add Card 4 — Historical Revenue from Stays by Source

Same process as above, except select Group by Source.

• Metric: Completed Room Night
• Measurement: Value (the sum of the nightly room rates)
• Group by: Source

Open Time period, choose the date range you want to review, and click Apply.

For daily data points, choose a range of 30 days or less. Wider ranges can group points by week or month. Dashboard dates use your Klaviyo account’s timezone, so a stay night can appear on a different date if the property uses another timezone.

Each custom card uses the metric selected in that card. Changing the dashboard’s Conversion metric does not change these cards.

Dashboard 2: ADR from Stays

This dashboard measures the ADR from stays — useful for evaluating the average daily rate historically. At the end of these steps, your dashboard for average daily rate will look like this:

Steps

Same as above, create a new dashboard and name it as you like (e.g. ADR from Stays).

Use these steps for each card below:

1. Click Add card, then select Create from scratch.
2. Use the settings listed for the card and select Line graph.
3. Click Add Card to save the card to the dashboard.

Add Card 1 — ADR from Stays

• Metric: Completed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: (none)

Add Card 2 — ADR from Stays by Property Name

• Metric: Completed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: PropertyName

Add Card 3 — ADR from Stays by Source

• Metric: Completed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: Source

Add Card 4 — ADR from Stays by Room Type

• Metric: Completed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: RoomTypeName

Open Time period, choose the date range you want to review, and click Apply.

Dashboard 3: ADR from New Bookings

This dashboard measures the ADR for confirmed bookings, using the reservation’s creation time rather than the dates of the stay. It is useful for monitoring rates alongside your marketing campaigns and flows, but these cards do not isolate bookings attributed to those messages. At the end of these steps, your dashboard for average daily rate will look like this:

Steps

Same as above, create a new dashboard and name it as you like (e.g. ADR from New Bookings).

Use these steps for each card below:

1. Click Add card, then select Create from scratch.
2. Use the settings listed for the card and select Line graph.
3. Click Add Card to save the card to the dashboard.

Add Card 1 — ADR from New Bookings

• Metric: Confirmed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: (none)

Add Card 2 — ADR by Room Type

• Metric: Confirmed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: RoomTypeName

Add Card 3 — ADR by Source

• Metric: Confirmed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: Source

Add Card 4 — ADR by Property Name

• Metric: Confirmed Room Night
• Measurement: Average (the average nightly room rate)
• Group by: PropertyName

Open Time period, choose the date range you want to review, and click Apply.

Understanding the Metrics

Each room-night event represents 1 room for 1 night. For example, a confirmed reservation for 2 rooms over 2 nights generates 4 Confirmed Room Night events, then 4 Completed Room Night events after checkout. Completed Room Night events sync after checkout and are timestamped at 11:59 p.m. on each stay night in the property’s timezone. Confirmed Room Night events use the reservation’s creation time. Each event’s value is the nightly room rate, not the total reservation value.

Learn more about the room-night metrics and their properties in the Cloudbeds data reference.