A Greenwolf Tech Labs site · Our Data Studio agency team, India and USAgreenwolftechlabs.com ↗

Industry guide

Hotel marketing dashboard: track net revenue by channel, not just clicks

A hotel marketing dashboard shows a hotel, or the agency that markets it, which channels produce booked room revenue and what each one costs once OTA commission and ad spend are taken off. This guide is for hotel marketing managers, revenue teams at small groups, and hospitality marketing agencies who have plenty of channel reports but still argue about whether direct bookings are growing. It covers the KPIs, the data sources, the GA4 booking engine problem, a worked net revenue example and a page layout for one or several properties.

Hotel marketing dashboard in Data Studio showing direct booking share and net revenue by channel
Industry guide6 min readUpdated November 18, 2026 · by Harsh Khubchandani

Quick answer

What should a hotel marketing dashboard include?

A hotel marketing dashboard should show room revenue and bookings by channel, direct booking share, cost of acquisition per channel including OTA commission and ad spend, website booking conversion rate, Google hotel ads and free booking link results, and RevPAR, ADR and occupancy for context. Bookings come from the booking engine and PMS, and marketing data from GA4 and ad platforms.

  • Compare channels on net room revenue after commission and ad spend, not on gross bookings.
  • Most booking engines sit on another domain, so GA4 needs cross-domain measurement to credit channels.
  • Separate Google free booking links from paid hotel ads with Hotel Center tracking parameters.
  • Keep guest names and emails out of the dashboard; aggregated counts by day and channel are enough.
01

What is a hotel marketing dashboard?

It is one live report that follows a guest from an ad, a search result, a metasearch listing or an email to a confirmed booking, and puts the cost of winning that booking next to its value. Channel reports stop at the click. A hotel marketing dashboard keeps going until the booking is in the property management system, because that is where the revenue is.

The pages ranking for this topic today are mostly reporting tool pages and KPI glossaries. They list occupancy, ADR and RevPAR, which belong in the report, and some list direct booking share. Few show how to join booking engine revenue to marketing spend, how to subtract OTA commission so channels can be compared fairly, or why GA4 so often credits bookings to the wrong source. Those three problems decide whether the dashboard is trusted.

In Data Studio (formerly Looker Studio), we build hotel marketing dashboards from native connectors for GA4, Google Ads and Search Console, partner connectors for Meta and Google Business Profile, and scheduled exports from the booking engine, PMS and OTA extranets landed in Google Sheets or BigQuery.

02

Which KPIs belong on a hotel marketing dashboard?

Group KPIs by stage: demand, website, booking, cost and property performance. Each stage has its own source, and a drop between two stages points to a different fix. A fall from website sessions to booking engine starts is a website or rate display problem. A fall from booking engine starts to confirmed bookings usually means price, payment or availability trouble inside the engine.

StageKPIUsual source
DemandImpressions, clicks and spend by campaign, including hotel adsGoogle Ads; Meta through a partner connector
DemandFree booking link clicksGoogle Hotel Center reports
DemandOrganic search clicks and queries, map actions and callsSearch Console; Google Business Profile through a partner connector
WebsiteSessions by channel, booking engine starts, booking conversion rateGA4 with cross-domain measurement
BookingRoom nights, bookings and room revenue by channel, lead time, cancellationsBooking engine and PMS exports, aggregated
CostAd spend, OTA commission, net revenue and cost of acquisition by channelCalculated in Sheets or BigQuery
PropertyOccupancy, ADR, RevPAR for context against marketing trendsPMS
03

Why does net revenue by channel matter more than bookings?

Because every channel takes a different share of the room rate. An OTA booking costs a commission. A direct booking from a paid search ad costs the ad spend that produced it. A direct booking from organic search or a returning guest may cost almost nothing. Gross bookings hide all of that, so a hotel marketing dashboard should report net room revenue per channel next to gross.

Commission rates are set in each hotel's contract. Booking.com does not publish one rate for everyone; Guesty's June 2025 guide to Booking.com fees puts the global average around 15%, with a range of 10% to 25% depending on market and property type. Use the actual rate from each contract in your calculation, held in a small rates table that the revenue team owns.

04

Worked example: net revenue and cost of acquisition by channel

Take a hypothetical hotel with $100,000 of room revenue in one month. These figures are illustrative, not benchmarks. Direct website bookings bring $40,000, supported by $3,000 of Google Ads spend including hotel ads and $1,000 on Meta. OTAs bring $60,000 at an assumed 15% commission.

Distribution cost is $4,000 on the direct side and $9,000 on the OTA side, $13,000 in total, or 13% of room revenue. Direct costs $10 for every $100 of room revenue and OTAs cost $15. Net room revenue is $36,000 direct and $51,000 from OTAs.

Now suppose the hotel adds $1,000 of search spend and moves $10,000 of revenue from OTAs to direct. Direct revenue becomes $50,000 at $5,000 of spend, OTA revenue becomes $50,000 at $7,500 commission, and total distribution cost falls to $12,500, or 12.5%. The hotel spent more on ads and kept $500 more. A report showing only ad spend would call that month worse. A hotel marketing dashboard built on net revenue shows it was better.

In Data Studio, cost of acquisition is a calculated field, (SUM(ad_spend) + SUM(commission)) / SUM(room_revenue), on a daily table where revenue, spend and commission share the same date, property and channel keys. Build that table outside a blend. Data Studio blends join at most 5 sources with equality joins only, and a hotel with ads, OTAs, GA4 and a booking engine reaches that quickly.

05

How do you fix GA4 tracking on a hotel booking engine?

Most hotel websites send guests to a booking engine on a different domain, run by the engine vendor. Without cross-domain measurement, GA4 treats the move from the hotel site to the engine as a new visit. Google's own documentation says a single user visiting two root domains is identified as two users and two sessions instead of one, and on subdomains with a different cookie domain, self-referrals can appear and misattribute traffic.

The result is familiar to every hotel marketer: bookings in GA4 credited to the hotel's own domain or to direct traffic, and paid campaigns that look as if they produce nothing. Cross-domain measurement fixes this by passing the visitor's IDs between domains in the _gl URL parameter, so the guest stays one person from ad to confirmation.

Three checks cover most cases. Add the booking engine domain to the cross-domain list in the GA4 tag settings. Confirm with the engine vendor that your GA4 tag fires on the booking pages and that a purchase event with value and currency fires on confirmation. Then add the engine domain to the unwanted referrals list if self-referrals still appear. Test with a real booking before trusting any channel figures.

  • Booking engine domain added to the GA4 cross-domain configuration.
  • GA4 tag present on every booking engine step, not only the confirmation page.
  • Purchase event sending booking value and currency, with no guest details in parameters.
  • A test booking traced from a tagged ad click to GA4 with the source intact.
06

How do you report Google free booking links and hotel ads separately?

Google shows paid hotel ads and unpaid free booking links in the same hotel booking module, so a hotel marketing dashboard has to split them or it will credit paid campaigns with free traffic. Google's Hotel Center help explains that clicks from ad campaigns include a campaign ID, while free booking link clicks do not, because they do not use the Google Ads tracking template.

Add Hotel Center landing page parameters such as CAMPAIGN-ID and IF-AD-CLICK to your landing page URLs, so the booking engine and GA4 can tell the two apart. Hotel Center also reports free booking link performance in its Reports section. Bring that into the dashboard through a scheduled export to Sheets, and show free booking links as their own channel next to paid hotel ads.

07

How should a hotel marketing dashboard be laid out?

Five or six pages cover most hotels. Each page answers one question, and the summary answers the one the general manager asks first. Put a date control and a property filter on every page so a group can compare hotels side by side, and show stay date and booking date as separate options because revenue teams think in stay dates and marketers in booking dates.

Agencies with several hotel clients should build this once as a master template with identical field names, then copy it per client and swap data sources. Our white-label reporting service does this under the agency's own brand.

  • Summary: room revenue, net revenue and cost of acquisition by channel, direct booking share against target.
  • Paid media: Google Ads including hotel ads, Meta, and free booking links as a separate unpaid line.
  • Website: GA4 sessions by channel, booking engine starts, booking conversion rate by landing page and device.
  • Search and local: Search Console queries, Google Business Profile calls and direction requests, review ratings.
  • Distribution: OTA bookings, commission, cancellations and lead time by channel.
  • Property context: occupancy, ADR and RevPAR from the PMS, aligned to the same dates.
08

What mistakes make hotel marketing reports misleading?

Most misleading hotel reports are not wrong in any single number. They leave out the cost side or trust GA4 attribution that was never set up for the booking engine. These are the problems we look for first.

  • Reporting gross bookings by channel with no commission or ad cost, so OTAs and paid search look free.
  • Trusting GA4 channel figures without cross-domain measurement on the booking engine.
  • Counting cancelled bookings as revenue, especially on OTA channels with flexible rates.
  • Mixing stay date and booking date in one chart, so a strong booking month looks like a weak revenue month.
  • Crediting free booking link clicks to paid hotel ads campaigns.
  • Sending guest names or emails into GA4 or the dashboard, which adds privacy risk and no insight.
09

Should a hotel build its own marketing dashboard or hire help?

Build it yourself if you run one property, your booking engine already reports revenue by source, and you are happy to update a monthly sheet of OTA revenue and commission by hand. A one-page summary with net revenue by channel will already beat most generic templates.

Bring in help when you run several properties, report for many hotel clients as an agency, need booking engine, PMS and OTA data joined automatically every day, or need the GA4 cross-domain setup checked end to end. Groups with many properties often want the data in BigQuery so history and multi-property comparisons stay fast.

We are not the right fit if you want a revenue management system or a rate shopping tool. Those are specialist hospitality products. We build custom Data Studio dashboards that the hotel or agency owns, on top of the systems you already use.

10

How Greenwolf Tech Labs builds hotel marketing dashboards

We start with a free review of your channels, booking engine and PMS exports, OTA reports and current GA4 setup. Then we agree definitions such as net revenue and direct share, build the data layer in Sheets or BigQuery, design the pages above in Data Studio, and reconcile revenue totals against the PMS before handover.

Our team has delivered 100+ projects for 200+ clients and has built Data Studio dashboards for retail, logistics and multi-channel marketing, including online versus in-store sales and spend, leads and return across Google Ads, Meta, LinkedIn, GA4 and Search Console. We quote a fixed price after the review, and everything we build sits in accounts you own.

FAQ

Frequently asked questions

What KPIs should a hotel marketing team track?

Track room revenue and bookings by channel, direct booking share, cost of acquisition including OTA commission and ad spend, and website booking conversion rate. Add RevPAR, ADR and occupancy from the PMS for context. Net room revenue per channel is the figure that shows where to spend.

How do I increase direct bookings and prove it in a report?

Report direct booking share and net revenue per channel every month against a target, using booking engine and PMS data rather than GA4 alone. When paid search or metasearch spend rises, the dashboard should show whether OTA revenue and commission fell at the same time.

Why does GA4 show my hotel bookings as direct or self-referral traffic?

Usually because the booking engine is on another domain and cross-domain measurement is not configured. GA4 then starts a new session on the engine and loses the original source. Add the engine domain to cross-domain settings and test with a real booking.

Can Data Studio connect to a hotel PMS or booking engine?

There is no native Data Studio connector for most hotel systems. The usual route is a scheduled export or API pull into Google Sheets or BigQuery, summarised by day, property and channel. Data Studio then reads that table alongside GA4 and ad data.

How do I track Google free booking links?

Use Hotel Center landing page parameters such as CAMPAIGN-ID and IF-AD-CLICK so free booking link clicks and paid hotel ads clicks arrive with different values. Hotel Center also reports free booking link performance in its Reports section, which can be exported into the dashboard.

Can one hotel marketing dashboard cover a group of properties?

Yes. Add a property field to every source and a property filter to every page, and keep totals per hotel as well as group-wide. This shows which properties win direct bookings and which depend on OTAs.

Do hotel managers need a Data Studio Pro licence to view the dashboard?

No. Data Studio is free for creators and viewers. Data Studio Pro costs $9 per user per project per month and only applies to creators, editors and managers in Pro workspaces, so viewers never need one.

Reviewed by Team Greenwolf Tech Labs · 18 Nov 2026

Get started

Tell us what your reporting has to do

Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.

  • Free 30-minute reporting review
  • Fixed quote before any work starts
  • Everything built and owned in your Google account

Prefer email? info@greenwolftechlabs.com

Get a free proposal

Two lines is enough to start.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.

Ask us anything

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.