Most multi-location pet care owners run the business from a stack of per-site spreadsheets that never quite line up — different exports, different weeks, no single comparison. The executive scorecard is the antidote: one screen with the headline metric from every pillar — occupancy, yield, upsell, retention, collections and labor — for the whole portfolio, plus a one-row-per-location table so the strongest and weakest sites are obvious at a glance.
What this dashboard answers
The portfolio page carries six top-line cards — total revenue, occupancy rate, RevPAR, add-on attach rate, repeat-client rate and collection rate — computed across every site, above a hero table with one row per location and a column for each pillar's headline metric (revenue, occupancy, RevPAR, revenue per labor hour, attach rate, repeat rate, collection rate, labor cost ratio), with data-bar formatting so leaders and laggards jump out. The comparison page ranks every site on revenue, occupancy, RevPAR and repeat rate, so the gap between best and worst is instant.
The metrics that matter
The point of a scorecard isn't any single number — it's the connections between them and the spread across sites. The metrics are interlinked: occupancy drives RevPAR, attach rate and repeat rate drive revenue per available run, and labor cost ratio decides what survives to margin. Looked at per site in isolation, each looks fine; lined up side by side, the story emerges — the site with strong occupancy but weak RevPAR has a pricing or discounting problem, not a demand one. Rate-based metrics let a large site and a small one be compared fairly.
Why the data is trapped
Each location's numbers live in its own booking system instance — and across a franchise, possibly different systems entirely (Gingr at one, PetExec at another). There's no native cross-site roll-up, no common definition of occupancy or attach rate, and no single export that puts all sites on the same footing for the same period. Standardizing the metrics and aligning the sites into one comparable view is precisely the modeling step a scorecard requires and the booking tools don't provide.
How to read it
Read the six portfolio cards for the whole-business pulse, then go straight to the one-row-per-location table and scan the data bars for the outliers — the worst cell in each column is usually the most addressable opportunity you have. Use the ranked comparison charts to confirm which site leads and lags on each pillar, then open the matching detail report (occupancy, RevPAR, retention) for that site. The scorecard's job is to tell you which one report to open next. The sample uses entirely synthetic data, so there are no real financial records in what you see here.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Revenue | Revenue across all locations in the period. |
| Occupancy Rate | Occupied ÷ available run-nights — boarding capacity utilization across the portfolio. |
| RevPAR | Boarding revenue ÷ available run-nights — yield per available run across the portfolio. |
| Add-On Attach Rate | Stays with an add-on ÷ total stays — upsell penetration across the portfolio. |
| Repeat-Client Rate | Repeat clients ÷ active clients — the share of the book that returns, across the portfolio. |
| Collection Rate | Collected ÷ invoiced — the share of billed dollars collected across the portfolio. |
Used by: Multi-location and franchise owners and operators; regional managers
Frequently asked questions
What KPIs should a multi-location pet care owner track weekly?
The headline set spans every pillar: total revenue, occupancy rate (capacity), RevPAR (yield), add-on attach rate (upsell), repeat-client rate (retention), collection rate (cash) and labor cost ratio (cost). The executive scorecard puts all of them on one screen and lines every facility up on the same measures.
How do I compare facilities of different sizes fairly?
Use rate-based metrics — occupancy rate, RevPAR, attach rate, repeat rate, collection rate and labor cost ratio — rather than raw totals, so a large site and a small one sit on the same footing. The scorecard's one-row-per-location table is built around these ratios for exactly that reason, with revenue shown alongside as the scale.
Does this work if my locations use different booking systems?
Yes. Each site exports its own data — even from different systems like Gingr, PetExec, Revelation Pets, DaySmart Pet or Kennel Connection — and the template standardizes the metrics into one comparable scorecard. The sample uses synthetic per-site data so you can see the finished cross-site comparison before bringing your own.
Build this report on your own data
Clone this Pet care facilities template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →