Hello There!

Lorem ipsum dolor sit amet, consectetur adipiscing elit,

How to Build a Hospitality Marketing Dashboard That Actually Drives Decisions

The Lobby > Analytics & Integrations > How to Build a Hospitality Marketing Dashboard That Actually Drives Decisions
Hospitality-Marketing-Dashboard

How to Build a Hospitality Marketing Dashboard That Actually Drives Decisions

Most hospitality marketing dashboards are vanity displays. They show sessions, impressions, and follower counts — metrics that look impressive in a monthly report but do not tell you whether to increase your Google Ads budget, fix your booking engine, or send another email campaign. A useful dashboard does one thing: it answers the question “what should I do next?”

This guide covers the structure of a hospitality marketing dashboard that actually drives decisions, the metrics that belong in it, and how to build it in Looker Studio (formerly Google Data Studio) — free.

The 3-Layer Dashboard Principle

A hospitality marketing dashboard should have three distinct layers, each answering a different question:

Layer 1 — Revenue and Bookings: Did we hit our direct booking targets? This layer shows direct booking revenue, booking count, average booking value, and RevPAR from direct channels. It answers the board-level question.

Layer 2 — Channel Performance: Which channels are driving those bookings and at what cost? This layer shows sessions, conversions, and cost per booking by channel (organic search, paid search, email, social, direct). It answers the marketing management question.

Layer 3 — On-Site Behaviour: How are guests interacting with the website and where are they dropping off? This layer shows booking engine start rate, completion rate by device, top-converting landing pages, and funnel drop-off points. It answers the optimisation question.

→ Example: A 40-room independent hotel uses this three-layer structure to run their weekly 20-minute marketing review. Layer 1 tells them if they are on target. Layer 2 tells them which channel to focus on. Layer 3 tells them what to fix on the website. Three layers, one dashboard, one clear weekly action.

Layer 1: Revenue and Booking Metrics

  • Direct booking revenue (month-to-date vs. same period last year)
  • Direct booking count (month-to-date vs. target)
  • Average booking value (trend line, 13-week rolling)
  • Direct booking share (% of total bookings that are direct, vs. OTA)
  • Lead time distribution (bookings made 0–7 days, 8–30 days, 31–90 days, 90+ days out)

Data source: your PMS or booking engine. Most systems can export this data in CSV for manual Looker Studio upload, or connect via API for live data.

Layer 2: Channel Performance Metrics

  • Sessions by channel (organic, paid, email, social, direct, referral)
  • Booking engine starts by channel (which channels drive the highest intent visitors?)
  • Bookings by channel (GA4 conversion attribution, data-driven model)
  • Cost per booking by paid channel (Google Ads spend / bookings from Google Ads)
  • Email click-to-booking rate (clicks from email campaigns / email-attributed bookings)
  • Organic search keyword rankings for your top 10 target terms (imported from Search Console)

Data sources: GA4 (sessions, conversions), Google Ads (spend), Google Search Console (rankings), email platform (MailChimp, Klaviyo, etc.).

Layer 3: On-Site Behaviour Metrics

  • Booking engine start rate (booking_engine_start events / sessions) — target 5–10%
  • Booking engine completion rate (booking_complete / booking_engine_start) — target 20–35%
  • Mobile vs. desktop completion rate gap — if mobile is more than 10 percentage points below desktop, there is a mobile UX problem
  • Top 10 landing pages by booking conversion rate (which pages most often start a journey that ends in a booking?)
  • Funnel drop-off by step (where are guests abandoning the booking engine?)

Building Your Dashboard in Looker Studio

Step 1: Connect Your Data Sources

  1. Go to lookerstudio.google.com and click “Create → Report”
  2. Connect Google Analytics 4 as your first data source
  3. Connect Google Search Console as your second data source
  4. If running Google Ads, connect your Google Ads account as a third source
  5. For booking revenue data, create a Google Sheet with your PMS export and connect it as a fourth source

Step 2: Build Layer 1 — Revenue Page

Create a new page titled “Revenue Overview”. Add scorecard charts for direct booking revenue, booking count, and average booking value. Add a time series chart showing weekly direct booking revenue vs. the same period last year. Add a pie chart showing direct vs. OTA booking split.

Step 3: Build Layer 2 — Channel Performance Page

Create a new page titled “Channel Performance”. Add a bar chart of sessions by channel. Add a table showing channel, sessions, booking_engine_starts, booking_complete conversions, conversion rate, and cost per booking (where applicable). Add a line chart showing the trend of bookings by top 3 channels over 13 weeks.

Step 4: Build Layer 3 — On-Site Behaviour Page

Create a new page titled “Website Performance”. Add scorecards for booking engine start rate and completion rate. Add a funnel chart showing the booking engine steps with drop-off percentages. Add a table of top landing pages with sessions and booking conversion rates. Add a mobile vs. desktop comparison scorecard.

→ Example: A resort property built this Looker Studio dashboard and shared it with their general manager, revenue manager, and marketing agency via a view-only link. The weekly 20-minute review replaced a 2-hour monthly report meeting — and the team started making data-driven decisions every week instead of every month.

The 20-Minute Weekly Dashboard Review

  1. Check Layer 1 (5 minutes): Are we on track for monthly booking targets? Is direct booking share trending up or down vs. last year?
  2. Check Layer 2 (10 minutes): Which channel had the biggest positive or negative change this week? Is cost per booking within target? Did last week’s email campaign generate bookings?
  3. Check Layer 3 (5 minutes): Did the booking engine completion rate change? Is there a device gap? Which landing page had the best conversion rate this week?

Ready to replace your spreadsheet with a live dashboard that actually drives decisions?

The Lobby builds custom Looker Studio dashboards for independent hotels and restaurants.

Book a Free Dashboard Consultation


Related Reading

Leave a Reply

Your email address will not be published. Required fields are marked *