Franchise operator dashboard playbook
A practical operating framework for the person responsible for performance across multiple franchise locations in a home-service network. Which KPIs to own, how to structure your review cadence, and how a franchise operator dashboard gives you a consistent view across every location you oversee.
Role playbook
The franchise operator's Monday morning problem
Picture the start of the week. You oversee six franchise locations across three markets. Each franchisee sends a weekly email with their own spreadsheet, formatted differently, using slightly different definitions of average ticket and booking rate. By the time you reconcile the numbers, Tuesday is gone. You cannot tell whether last week's revenue dip at the Phoenix location was a staffing issue, a slow demand period, or a CSR booking problem. You are flying blind on $8 million in annual revenue spread across six businesses you are responsible for. This playbook is built for that problem. It defines the KPIs you should own as a franchise operator, the review rhythm that keeps you current without micromanaging your franchisees, and the dashboard structure that replaces scattered spreadsheets with a single standardized view of every location.
What this playbook covers
- Portfolio-level KPIs that aggregate across all locations and per-location KPIs that let you spot outliers before they become problems.
- A clear split between the metrics the operator sets and monitors versus the metrics the franchisee manages day to day.
- A weekly and monthly review cadence that gives you an honest picture across locations without requiring a different report from every franchisee.
- The data sources and KPI definitions that need to be standardized before a franchise dashboard gives you trustworthy numbers.
Who owns which KPIs: operator vs. franchisee
| KPI | Operator sets or monitors | Franchisee manages daily | Reporting frequency |
|---|---|---|---|
| Total portfolio revenue (MTD, YTD) | Portfolio rollup and growth rate | Location-level bookings and invoicing | Daily (live) |
| Average ticket by location | Cross-location benchmark and floor | Job-type mix and upsell behavior | Weekly |
| Booking rate by location | Minimum acceptable rate and outlier flag | CSR coaching and staffing adjustments | Weekly |
| Gross margin and labor percentage | Portfolio floor and location outlier review | Tech productivity, parts cost, and job pricing | Monthly |
| Review rating and volume by location | Brand standard minimum rating | Technician follow-up and satisfaction programs | Weekly |
| Membership plan active count and renewal rate | Portfolio growth target and at-risk count | Renewal calls and CSR attach on new jobs | Monthly |
Portfolio KPIs a franchise operator should own
These are the signals that tell you whether a location is healthy, needs a conversation, or needs intervention. Status examples below reflect illustrative directional targets. Every franchise network has different baselines by trade, market, and season, so these should be calibrated against your own portfolio history.
- Portfolio revenue pace vs. goal (MTD)First signal of whether the month is healthy across the network.Good
- Current
- Live, all locations
- Target
- On pace or ahead by this date
- Average ticket variance (top vs. bottom location)A bottom-quartile location dragging on average ticket often signals a pricing or upsell coaching issue.Watch
- Current
- By location
- Target
- Outlier investigation threshold
- Booking rate, lowest-performing locationOne low-booking location can mask a healthy portfolio average. Surface the outlier.Poor
- Current
- Compared to portfolio median
- Target
- Flag if significantly below median
- Labor percentage (by location)High labor percentage often precedes margin compression; catch it in-month, not at close.Watch
- Current
- Actual vs. target
- Target
- Varies by trade and job mix
- Average review rating by locationA location sliding below standard is a customer-experience signal before it becomes a revenue problem.Good
- Current
- Live rolling average
- Target
- Above brand standard minimum
- Membership renewals at risk (next 30 days)Recurring revenue at risk that franchisees can recover with a proactive call program.Poor
- Current
- Count by location
- Target
- Zero unworked at-risk accounts
| Metric | Current | Target | Status |
|---|---|---|---|
| Portfolio revenue pace vs. goal (MTD)First signal of whether the month is healthy across the network. | Live, all locations | On pace or ahead by this date | Good |
| Average ticket variance (top vs. bottom location)A bottom-quartile location dragging on average ticket often signals a pricing or upsell coaching issue. | By location | Outlier investigation threshold | Watch |
| Booking rate, lowest-performing locationOne low-booking location can mask a healthy portfolio average. Surface the outlier. | Compared to portfolio median | Flag if significantly below median | Poor |
| Labor percentage (by location)High labor percentage often precedes margin compression; catch it in-month, not at close. | Actual vs. target | Varies by trade and job mix | Watch |
| Average review rating by locationA location sliding below standard is a customer-experience signal before it becomes a revenue problem. | Live rolling average | Above brand standard minimum | Good |
| Membership renewals at risk (next 30 days)Recurring revenue at risk that franchisees can recover with a proactive call program. | Count by location | Zero unworked at-risk accounts | Poor |
Warning
Before you build this: standardize your KPI definitions
A franchise operator dashboard only gives you trustworthy comparisons if every location is measuring the same thing the same way. If one franchisee counts a booked job when the customer says yes and another counts it when the tech rolls, your booking rate comparison is meaningless. Before connecting locations to a portfolio dashboard, align on the definitions that matter most: what counts as a booked job, how average ticket is calculated (parts included or excluded), and how revenue is attributed by job type. Datacube is designed to work from the data in your connected CRM or field-service software, so if those definitions are set consistently in your source system, the dashboard reflects them consistently across every location.
Your review cadence: daily, weekly, and monthly
01 Daily glance (5 minutes, any device)
Check portfolio revenue pace vs. goal and flag any location that looks significantly behind for the date. Note any location where booking rate or call volume has dropped sharply from the prior day. This is not a management call, it is a signal scan. If something looks off, you have the day to ask a question rather than discovering it at month-end.
02 Weekly portfolio review (30 minutes)
Pull a side-by-side comparison of all locations on revenue pace, average ticket, booking rate, and review rating for the week. Identify the top and bottom performer on each metric. The conversation with a lagging franchisee starts with a specific number from the dashboard, not a general impression. Where relevant, link any revenue shift to what was happening in marketing spend or lead volume that week.
03 Monthly close and trend review
Close the month with a full portfolio picture: revenue vs. goal, margin by location, membership growth or loss, and year-over-year comparison. This is also when you update location-level goals for the next month and reset any contests or leaderboards. Share the summary with franchisees in a format that shows their own numbers and their rank in the network. Peer comparison is one of the highest-leverage coaching inputs available to a franchise operator.
04 Quarterly business review with franchisees
Bring the trailing 90 days of data into a structured conversation with each location. Cover the three KPIs where they most outperformed the network and the two where they most underperformed. Agree on one or two specific targets for the next quarter. A dashboard that both you and the franchisee can open on the same screen removes the negotiation about whose numbers are right.
What a franchise operator portfolio dashboard looks like
A web-based view you can open before a franchisee call or share in a Monday morning review. It shows every location in one place so you are coaching from today's numbers, not last week's email.
Figures are illustrative. A datacube franchise operator dashboard is built around your locations, KPI definitions, and source systems.
Info
Quick example: how the math changes at the portfolio level
Consider a six-location HVAC franchise network averaging $380 average ticket across the portfolio. The top location averages $465; the bottom averages $285. If the bottom location brought its average ticket to just $340, closer to the network median, the revenue impact at similar job volume would be material. The point is not the specific number. It is that a portfolio dashboard makes the gap visible. Without a side-by-side view, the bottom location looks fine in isolation. With one, you have a coaching conversation grounded in a real number.
Goals, leaderboards, and network contests
Using peer comparison as a franchise management tool
Where portfolio visibility pays off for a franchise operator:
- A network leaderboard for average ticket or booking rate creates healthy competition without requiring a meeting to communicate the ranking.
- Location-level monthly goals that franchisees can track against daily remove the end-of-month surprise for both the operator and the franchisee.
- A time-based contest (first location to hit a quarterly revenue target) motivates the middle of the network, not just the habitual top performer.
- Sharing the top location's specific tactics, drawn from the data, gives the bottom performers a credible path forward instead of generic coaching.
Franchise operator dashboard FAQs
See your franchise portfolio on one live dashboard
Datacube builds custom portfolio dashboards for franchise operators in home services, consolidating each location's data into a standardized view you can use for daily oversight, franchisee coaching, and quarterly reviews. The build is done for you, typically in 4 to 6 weeks.
Keep exploring
Related
Go deeper
