Setting up key hotel reports with Cloudbeds

Setting up key hotel reports with Cloudbeds

Estimated 4 minute read

Updated Mar 3, 2026, 12:00 AM EST

Table of contents

Overview
Prerequisites
Dashboard 1: Historical Daily Room Revenue from Stays
Dashboard 2: ADR from Stays
Dashboard 3: ADR from New Bookings
Understanding the Metrics

Overview

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

Dashboard	Metric	What It Shows	Use Case
Historical Daily Room Revenue from Stays	Completed Room Night	Total room revenue per night	View the revenue attributable to a given night
Average Daily Rate (ADR) from Stays	Completed Room Night	Average nightly rate for historical stays	View the average daily rate historically
ADR from New Bookings	Confirmed Room Night	Average nightly rate for new bookings	Compare average daily rates for new bookings alongside your marketing activity

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

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

Add Card 1 — Historical Revenue from Stays

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

Click Add card, then select Create from scratch.
Use the settings listed for the card and select Line graph.
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:

Click Add card, then select Create from scratch.
Use the settings listed for the card and select Line graph.
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

Property	What It Means
$value	The nightly room rate for that specific night
PropertyName	The name of the property/hotel
Source	Where the booking came from (e.g., Direct, Booking.com, Airbnb, Vrbo)
RoomTypeName	The room type or name (e.g., Deluxe Queen, Presidential Suite)
StartDate	The calendar date the night begins

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.

Was this article helpful?

YesNo

Use this form only for article feedback. Learn how to contact support.