If you are running five or more locations and your marketing review consists of a monthly PDF from your agency, you are operating blind. Not because you lack data. Because you are looking at the wrong data in the wrong structure at the wrong frequency. Here is the operator dashboard that takes 20 minutes a week and tells you everything you need to know about the health of your marketing operation.
Why Weekly, Not Monthly
Marketing platforms optimize in real time. If a campaign starts underperforming in Week 1, the platform has already reallocated budget by Week 3 if you have not given it a strong enough signal to keep spending there. By the time you see the problem in a monthly report, three weeks of budget have been wasted on a underperforming campaign or market.
Weekly review is not about making more decisions. It is about making the same number of decisions faster, with better data. A weekly 20-minute review catches problems before they compound and lets you reallocate before the damage becomes material.
Most operators spend more time reviewing their restaurant reservation system each week than reviewing their marketing performance. That gap is where the money is.
— Lukasz Rogowski, RogoLookOS
The 3-Metric Dashboard
You do not need a Tableau dashboard or a BI tool. You need a spreadsheet with three columns of data per location, pulled weekly. That is the dashboard.
Qualified Lead Rate (Qlr) by Location
Form submissions that scheduled a consultation / Total form submissions. Track this as a percentage. Compare to last week and the same week last month. Qlr is your conversion signal — when it drops, CPL is about to rise because the platform is finding cheaper but less qualified inventory.
Cost Per Booked Consultation by Location
Ad spend for the week / Consultations booked. This is the number that connects marketing spend to revenue conversation. When this number exceeds your target, you have a problem that the monthly CPL average will not show you.
Revenue Per Lead by Location (90-Day Rolling)
Average new client revenue in a market / Total leads generated. Calculated on a 90-day rolling window so it is not distorted by single large transactions. This is the number that tells you where to put budget next quarter.
How to Build the Dashboard
Open a Google Sheet or Excel. Create one tab per location. In each tab, create three columns: Week, Qlr, Cost Per Booked Consultation. Add a fourth column for notes on what you observed or decided that week. That is the dashboard. It takes 15 minutes to set up and 20 minutes a week to maintain.
Weekly Dashboard Template — Per Location
What the Three Metrics Together Tell You
Qlr tells you if the traffic you are buying is turning into real leads. Cost per booked consultation tells you if the real leads are costing you too much. Revenue per lead tells you which markets deserve more budget when Qlr is good and cost per booked consultation is within range.
The three metrics together give you a complete picture: quality of traffic, cost of conversion, and value of outcome. Any one metric alone is misleading. Qlr can be 40% in a market where the revenue per lead is $200, making it a worse market than one with a 20% Qlr and a $900 revenue per lead. Cost per booked consultation can look stable while Qlr is declining — that is the warning signal.
What to Do With the Dashboard Each Week
Monday morning: pull the numbers from your ad platforms and your CRM for the prior week. Fill in the spreadsheet. Identify any location where Qlr dropped more than 5 percentage points week-over-week, or where cost per booked consultation exceeded your target by more than 20%. Flag those locations.
For flagged locations: open a quick call with whoever is running your paid ads. Present the numbers. Ask for a specific explanation and a specific recommendation for the next week's campaign adjustments. Write the recommendation in the notes column. Follow up the next Monday to see if the adjustment moved the numbers.
Once a month: pull the 90-day rolling revenue per lead numbers and update your budget allocation plan for the next quarter. Markets where revenue per lead is significantly above average should get more budget. Markets where it is below average should get a strategic review — not a budget cut, but a review of whether the market's customer profile is different enough to require a different approach.
The dashboard is not the point. The point is that you are making one decision a week that is informed by actual data rather than the last agency call you had. The spreadsheet is the mechanism. The decision is the value.
— Lukasz Rogowski, RogoLookOS
The One Number That Tells You to Stop Reading This Post
If your current agency or marketing team produces a monthly report and that report does not include cost per booked consultation broken out by location, stop reading and forward this post to them. Ask them to build this dashboard and share it with you weekly. If they cannot or will not produce this within two weeks, you have your answer about who is actually running your marketing versus who is just running campaigns.