Overview
This guide explains how to create three dashboards in Klaviyo using Mews' Confirmed Room Night and Completed Room Night event metrics. These metrics give you granular, per-night visibility into booking performance and stay revenue — broken out by property, source, and resource type.
| Dashboard | Metric Used | What It Shows | Use Case |
|---|---|---|---|
| Historical Daily Room Revenue from Stays | Completed Room Night | Total room revenue per night (broken out by property, origin, and resource type) | View the revenue attributable to each night |
| ADR from Stays | Completed Room Night | Average nightly rate per night actually stayed (broken out by property, origin, and resource type) | View the average daily rate historically |
| ADR from New Bookings | Confirmed Room Night | Average nightly rate at time of booking (broken out by property, origin, and resource type) | View the average daily rate for new bookings to understand the impact of marketing efforts |
Prerequisites
- Your Mews integration must be connected to Klaviyo.
- You must have at least Editor-level access to the Klaviyo account.
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.
Add Card 1 — Historical Revenue from Stays
- Click Add Card > Create from Scratch > Line Graph
- Metric: Completed Room Night
- Aggregation: Sum → Revenue ($value)
- Group by: (none)
- Visualization: Line chart
- Card title: Total
2. Click Save Card.
Add Card 2 — Historical Revenue from Stays by Resource Type
Same process as above, except select Group by ResourceName.
- Metric: Completed Room Night
- Aggregation: Sum → Revenue ($value)
- Group by: ResourceName
Add Card 3 — Historical Revenue from Stays by Property Name
Same process as above, except select Group by PropertyName.
- Metric: Completed Room Night
- Aggregation: Sum → Revenue ($value)
- Group by: PropertyName
Add Card 4 — Historical Revenue from Stays by Origin
Same process as above, except select Group by Origin.
- Metric: Completed Room Night
- Aggregation: Sum → Revenue ($value)
- Group by: Origin
Set the time period as you like and the conversion metric to Completed Room Night. Click Save.
Dashboard 2: ADR from Stays
This dashboard shows the Average Daily Rate (ADR) for nights actually stayed — answering "how much are guests paying per room, per night?" At the end of these steps, your dashboard for average daily rate will look like this:
Steps
Add Card 1 — ADR from Stays
- Metric: Completed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: (none)
Add Card 2 — ADR from Stays by Property Name
- Metric: Completed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: PropertyName
- Card title: By Property
Add Card 3 — ADR from Stays by Origin
- Metric: Completed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: Origin
- Card title: By Origin
Add Card 4 — ADR from Stays by Resource Type
- Metric: Completed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: ResourceName
- Card title: By Resource Type
Set the time period as you like and the conversion metric to Completed Room Night. Click Save.
Dashboard 3: ADR from New Bookings
This dashboard shows the ADR for newly confirmed bookings — answering "what are guests willing to pay at the time they book?" Use this to measure the impact of campaigns and flows on booking value. 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).
Add Card 1 — ADR from from New Bookings
- Metric: Completed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: (none)
Add Card 2 — ADR by Resource Type
- Metric: Confirmed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: ResourceName
- Card title: By Resource Type
Add Card 3 — ADR by Origin
- Metric: Confirmed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: Origin
- Card title: By Origin
Add Card 4 — ADR by Property Name
- Metric: Confirmed Room Night
- Aggregation: Average → Revenue ($value)
- Group by: PropertyName
- Card title: By Property
Set the time period as you like and the conversion metric to Completed Room Night. Click Save.
Understanding the Metrics
| Property | What It Means |
|---|---|
| $value | The nightly room rate for that specific night |
| PropertyName | The name of the hotel property |
| Origin | Where the booking came from (e.g., Direct, TravelAgent, Hotels.com) |
| ResourceName | The room type or name (e.g., Executive Suite, Deluxe Queen) |
| StartDate | The calendar date the night begins |
> Note: Because each Mews reservation generates one Room Night event per night of the stay, you can filter or segment on any individual night — not just the overall reservation.