Here is an uncomfortable truth about most independent hotels: the marketing data exists, it is just scattered across nine browser tabs, three logins nobody remembers, and a spreadsheet your last revenue manager built before quitting. So nobody looks at any of it. Decisions get made on vibes, the OTA commission line keeps quietly fattening, and everyone agrees you should “do more marketing” without anyone able to say what is working.
A one-page dashboard fixes the looking problem. Not the doing problem, the looking problem, which turns out to be most of it. When the numbers that matter live on a single screen you actually open, you start noticing things weeks earlier. You catch the month your direct share slipped before it becomes a quarter. That is the whole pitch.
This post is the build guide. What to put on it, where each number comes from, how to wire it together without a data team, and the handful of mistakes that turn a useful dashboard into expensive wallpaper.
Why one page, and why most hotel “dashboards” fail
The reason hotel dashboards fail is almost never the tooling. It is scope creep. Someone discovers Looker Studio, gets excited, and builds a fourteen-tab monster with every metric the connectors will surrender. It is technically impressive and functionally dead, because no busy owner-operator is going to navigate a fourteen-tab report between a fire alarm and a walk-in guest.
The constraint is the feature. One page. If a metric does not change a decision you would actually make this month, it does not earn a spot. Page-two curiosity metrics are how you end up never opening page one.
The test for every tile on your dashboard: name the decision it changes. “If this number moves, I will do X.” If you cannot finish that sentence, the tile is trivia. Cut it.
There is a second failure mode, which is building a dashboard that only reports the past. RevPAR last month is history. A good dashboard mixes outcomes (what happened) with leading indicators (what is about to happen), so you have time to steer instead of just narrate the crash.
The metrics that actually matter
Here is the core set. A boutique property of 15 to 150 rooms genuinely does not need more than this. I have grouped them so the logic is obvious.
| Metric | What it tells you | Where it comes from |
|---|---|---|
| Direct booking share | How much business you own outright | Booking engine plus PMS |
| OTA-to-direct mix | Whether your dependence is creeping | PMS or channel manager |
| Cost per acquisition by channel | What each booking actually costs you | Ad spend divided by bookings |
| Metasearch ROAS | Whether Google Hotel Ads pays off | Metasearch or bid platform |
| Organic and AI-search visibility | Are you findable without paying | Search Console plus manual checks |
| Website conversion rate | Are lookers becoming bookers | GA4 plus booking engine |
| RevPAR | The bottom-line outcome | PMS |
Let me unpack the ones people get wrong.
Direct booking share and your OTA mix. This is the headline number for an independent. Not because OTAs are villains, they fill rooms you would not otherwise fill, and a healthy property keeps them in the mix on purpose. But OTA commissions run roughly 15 to 25 percent, and every point of business you shift back to direct is margin you keep. The dashboard job is to make the trend visible. If direct share drifts from, say, 40 percent down to 32 percent over two quarters, that is a slow leak you want to catch early, not discover at tax time. We get deep into the philosophy of this in a healthy OTA mix, and it is worth your time because the goal is balance, not some fantasy of going OTA-free.
Cost per acquisition by channel. The single most clarifying number on the whole page, and the one almost nobody calculates honestly. Take every channel, divide what you spent to get bookings by the number of bookings, and put them side by side. The OTA “free” booking is not free, it is the commission. Your metasearch CPA might quietly be lower than your effective OTA CPA, which changes where the next dollar goes. The numbers below are illustrative, not real benchmarks, but they show the shape of the insight:
- Direct (brand search plus email): low double-digit dollars per booking
- Metasearch: moderate, but you keep the guest relationship
- OTA: looks like zero spend, but the commission is your CPA
When you see those next to each other, the strategy writes itself.
Metasearch ROAS. If you are running Google Hotel Ads or other metasearch, this tile keeps you honest about whether the bidding is profitable. It is also where the sneakiest money lives, because a lot of properties bleed budget bidding against OTAs on their own name. If you have not read bidding on your own brand in Google Hotel Ads, that one pairs with this tile directly. And for the bigger picture of how the whole metasearch auction works for a small property, metasearch for independent hotels is the primer.
Organic and AI-search visibility. This is the leading indicator most hotel dashboards skip entirely, and it is increasingly the one that matters. Traditional organic still drives a chunk of direct demand. But search is fracturing toward AI answers, and people now ask an assistant “best boutique hotel near the river walk with a rooftop bar” and get a synthesized recommendation instead of ten blue links. That is answer-engine and generative-engine optimization, and the search interest is real, “aeo” runs around 27,100 US searches a month and “generative engine optimization” around 5,400, which tells you the industry is paying attention even if your competitors are not yet.
Where every number actually comes from
You can build this entire thing for free or close to it. Here is the plumbing.
Google Analytics 4 (free)
GA4 is your website behavior source: sessions, traffic by channel, and conversion events. Set up your booking engine’s “begin checkout” and “purchase” events properly, or GA4 reports lookers and never bookers. This is the one setup step people skip and then wonder why their conversion tile is blank.
Google Search Console (free)
Search Console is your organic visibility truth. Impressions, clicks, average position, and which queries you actually rank for. Crucially, it shows brand versus non-brand search, which feeds straight into understanding how much of your “organic” is just people who already knew your name. That distinction matters a lot, and it connects to the uncomfortable reality we cover in how OTAs hijack your search visibility by outbidding and outranking you on your own brand.
Your booking engine and PMS
This is where direct bookings, revenue, and your channel mix live. Most modern booking engines export a CSV or offer a Looker Studio connector. If yours is genuinely sealed shut, a weekly manual export into a Google Sheet is a perfectly respectable input, and that sheet becomes a dashboard data source. Do not let “we cannot auto-connect it” stop you, manual-once-a-week beats never.
Metasearch or bid management platform
Google Hotel Ads, your bid platform, or your channel manager will give you metasearch spend, bookings, and ROAS. Speaking of which, your distribution stack itself is an SEO asset or liability depending on setup, which is exactly the territory of channel manager SEO.
The glue: Looker Studio
Looker Studio (free) is the canvas. It connects natively to GA4 and Search Console, reads Google Sheets, and accepts CSV uploads. You drag the connected sources onto one page, build your tiles, and you are done. No code. For a property your size, this genuinely is the whole stack, and you do not need to buy a business-intelligence platform to do it.
The best dashboard is the one you open. A scrappy, slightly ugly one-pager you check every Monday beats a gorgeous enterprise build you log into twice a year and then abandon.
Building it, step by step
Here is the actual sequence. Block out two focused hours.
- List your decisions first, not your metrics. Write down the three or four decisions you make repeatedly: where to put the next ad dollar, whether to push a direct promo, whether to renegotiate an OTA contract, whether to invest in content. Your metrics are whatever inform those. Decisions first prevents the fourteen-tab monster.
- Connect your free sources. In Looker Studio, add GA4 and Search Console. Five minutes each. Confirm data is flowing before you build anything pretty.
- Get booking and channel data in. Connector if you have one, weekly Google Sheet export if you do not. Set a recurring calendar reminder for the manual export so it actually happens.
- Build the tiles, grouped. Top row: the outcomes (RevPAR, direct share, total bookings). Middle row: the channel economics (CPA by channel, OTA mix, metasearch ROAS). Bottom row: the leading indicators (organic clicks, conversion rate, AI-search presence). Outcomes up top because that is what you glance at first.
- Add trend, not just totals. Every key tile gets a comparison to the prior period. A number with no trend is a number you cannot act on. Month-over-month and year-over-year where seasonality matters.
- Set thresholds in plain language. A short text note like “Direct share healthy above 40 percent” turns a raw number into a judgment anyone on your team can read. Your front desk manager should be able to interpret the page without a finance degree.
That is it. Ugly is fine. Functional and opened-weekly is the goal.
The metric most hotels are still missing: AI-search visibility
One honest gap. Search Console will not tell you whether an AI assistant recommends your hotel when someone asks for a boutique stay in your area. As of now there is no clean automated feed for that, so you measure it the manual way, and it is worth fifteen minutes a month.
Pick five queries a real guest would ask an assistant. Think “best independent hotel in [your town] for a romantic weekend” or “boutique hotel near [local landmark] with free parking.” Run them through the major AI assistants. Log whether you appear, how you are described, and whether the facts are right. Track that as a simple monthly score on your dashboard, even if it is just “appeared in 2 of 5.”
This is the cheapest competitive edge available right now, because most of your competitors have not even thought to look. The hotels that show up in AI answers in two years are the ones paying attention to it this year. The search volume around this discipline, “ai seo” at roughly 8,100 monthly US searches and “aeo” at 27,100, tells you where attention is heading, and a tile on your dashboard keeps you ahead of it.
What to do once the dashboard exists
A dashboard is a thinking tool, not a trophy. The point is the decisions it triggers.
- Direct share slipping? Time to look at your rate parity, your direct-booking perks, and whether your own brand search is being intercepted.
- A channel’s CPA creeping up? Pause, investigate, reallocate. Do not let an underperforming channel coast on autopilot.
- Organic visibility flat or falling? Your content and local presence need attention. Your Google Business Profile is doing heavy lifting here, which is why local SEO and your Google Business Profile is foundational, not optional.
- AI-search presence at zero? You are invisible in the channel that is eating search. That is a content and structured-data project, and it is the highest-leverage thing a forward-looking independent can start now.
The dashboard does not do the marketing. It tells you, every single week, exactly where to point your limited time and budget so you stop guessing and start steering, clawing back margin and a healthier booking mix one decision at a time.
Get help building yours
If wiring GA4 events, untangling your booking engine export, and figuring out your true CPA by channel sounds like a weekend you would rather not lose, that is precisely the kind of unglamorous, high-leverage work we do for independent and boutique hotels. We will build the one-pager, connect the sources, and hand you a screen you will actually open on Mondays. See what that looks like and what it costs on our pricing page, or just book a call and we will sketch your dashboard live.