Owner's dashboard: what business numbers to check every day
An owner needs just 6–10 numbers in one window: new inquiries, unhandled leads, time to first response, today's appointments, payments and average order value, ad spend. The data comes from the CRM, conversations, ad accounts, website analytics, and the payment system — not something you piece together by hand at the end of the week. Below is a list of metrics, a map of data sources, and a checklist for designing your own daily dashboard.
What numbers do you need to see every day?
The point of a dashboard is simple: spend five minutes in the morning spotting where the system is losing money, then make one decision for the day. A short set of numbers is enough for that.
- New inquiries in the last 24 hours, broken down by source: ads, search, maps, referrals, repeat customers.
- Unhandled leads: how many are sitting without a reply and how much time has passed since the inquiry.
- Average time to first response by channel: website, Instagram, WhatsApp, phone.
- Today's appointments and meetings, plus cancellations and no-shows.
- Payments for the day: total amount, count, average order value.
- Inquiry-to-sale conversion over the last 7 and 30 days.
- Ad spend for the day and its share of revenue.
- Total value of deals in progress: how much money is stuck at the "waiting for a decision" stage.
Check every line this way: if a bad value doesn't tell you what to do about it, drop that line from the dashboard. Response time is usually the first one to fail — there's a detailed guide on it at lead response speed.
Where do you get the data for a dashboard?
A dashboard doesn't create numbers — it collects them. Start by mapping things out: which system knows the metric you need, and how to pull it from there.
| Source | What it provides | How it gets into the dashboard |
|---|---|---|
| CRM | Leads, stages, deals, amounts, owners | Built-in reports, exports, or API |
| Messengers and AI salesperson | Conversations, time to first response, reasons for lost deals | Via CRM or a messaging integration |
| Ad accounts | Spend, clicks, leads by campaign | Connector to Meta Ads Manager and Google Ads |
| Website and GA4 | Traffic, form submissions, sources by UTM | GA4 export, consistent UTM tags on links |
| Till, card processing, payment service | Payments, refunds, average order value | Export or API from the payment system |
| Online booking and calendar | Appointments, open slots, cancellations, no-shows | Integration with the booking system |
| Google Business Profile | Calls, directions requests, map searches | Profile statistics |
The main requirement for your sources: one shared reference for names and consistent link tagging, or the numbers won't line up. UTM rules are covered in the official Google help center. If leads still live in chats and a notebook, start not with a dashboard but with a CRM for small business. Delivering the morning summary is easiest through a Telegram bot.
How do you lay out a dashboard on a single screen?
Split the screen into three zones and don't mix them together.
- "Right now": inquiries for the day, unhandled ones, response time, today's appointments, payments for the day. This is the action zone — you work from it here and now.
- "Funnel": inquiries, qualified leads, sales, and stage-to-stage conversions over 7 and 30 days. This is the bottleneck zone.
- "Money": revenue, average order value, ad spend, ad spend as a share of revenue, total value of deals in progress. This is the zone for budget and pricing decisions.
Every number needs a basis for comparison: yesterday, the same day a week ago, or the monthly plan. Without a comparison, a number tells you nothing. Reserve color for deviations only, or people quickly stop reading the screen.
Want this system for your business? Describe the task and we’ll send a plan and quote before we start.
Discuss my taskWhat to check daily vs. weekly?
A daily snapshot is for reacting. Weekly and monthly views are for changing the process and the budgets.
| Period | Metrics | What decisions they drive |
|---|---|---|
| Every day | Inquiries, unhandled leads, response time, appointments, payments | Follow up with silent clients, redistribute workload, fill gaps in the schedule |
| Every week | Stage-to-stage conversions, reasons for lost deals, revenue by source, team workload | Rewrite scripts and the offer, adjust shift schedules, reinforce the best-performing channel |
| Every month | Ad spend as a share of revenue, average order value, repeat purchases, channel payback | Budgets, prices, assortment, hiring |
If the daily report arrives on its own and takes a minute to read, people read it. The moment it requires opening five different dashboards, it dies within the first week.
What to build it on: a spreadsheet, BI, or a custom portal?
The tool is chosen to fit the data volume and the number of people reading it — not the other way around.
| Option | When it fits | Limitations |
|---|---|---|
| Google Sheets | One owner, 5–8 numbers, data from one or two systems | Manual work, formulas break easily, no role-based access control |
| Looker Studio or another BI tool | You need charts, multiple sources, and shared team access | Depends on connectors, you have to work around complex business logic |
| A custom dashboard or portal | Data from CRM, payments, and bookings together; you need permissions and notifications | Requires development and support, the quote is scoped to the task |
A custom portal makes sense when the numbers aren't just for you — managers, partners, franchisees, or clients need them too. What to build into that kind of portal is covered in the guide on a client portal.
Which metrics just get in the way?
Extra lines dilute attention, and the owner stops noticing the real failures. Remove from the main screen:
- likes, reach, and followers that aren't tied to inquiries;
- cost per click and CTR looked at apart from leads and sales;
- "industry average" figures nobody has actually verified;
- twenty metrics in small print crammed onto one screen;
- numbers someone calculates by hand once a week, because they're always late.
Working rule: one metric should drive one decision. Send everything else to the dashboard's second tier, which you check when reviewing the week.
Checklist: design your dashboard in one evening
- List the 5–7 decisions you make most often: who to follow up with, where to add budget, who to schedule for a shift.
- For each decision, pick the one number you can't make it without.
- Note the source for each number: CRM, ad account, GA4, the till, the booking system.
- Mark what's already available automatically and what's currently calculated by hand.
- Set a comparison baseline for each number, and the threshold where you step in.
- Build a draft in a spreadsheet and fill it in by hand for a week — this shows which lines you actually read.
- Automate only what survives that week, and set up the morning summary in Telegram.
This order protects you from building a beautiful dashboard that nobody looks at. Decisions first, then numbers, and only then integrations.
How InSync does this
We build the dashboard as part of the sales system. First we look at where inquiries come in and where they get lost, then connect the CRM, conversations, booking, and payments, and only then put a screen of numbers on top. AI handles up to 90% of the routine work: collecting data, writing summaries, drafting reports. There's no need for calls — the work happens in chat, and reports land in Telegram on their own, without being asked for.
In one of our car-import projects, leads from Facebook flow straight into the CRM and a Telegram bot, managers have 675 leads in progress, and you can see movement on each one without manual exports. The full scope of our work is laid out in the InSync services block: websites, CRM and automation, platforms and portals, AI salesperson. Quotes for websites, CRM, platforms, and dashboards are scoped to the task before work begins — there's no free trial or work-before-payment option. You can see how we build the system on the homepage.
If you need traffic alongside the dashboard, that's handled by separate brand divisions: ads are run by insync.com.ua, SEO and GEO are run by geo.insync.com.ua. To get started, send Anton your task on Telegram — you'll get a plan and a quote before anything starts.
FAQ
How many metrics should be on an owner's dashboard?
6–10 numbers are enough for the main screen. There's one selection criterion: a metric should change a specific decision, otherwise it belongs on the report's second tier. The shorter the screen, the better the chance it gets opened every day.
Do you need a dashboard if you don't have many leads yet?
Yes, but in a simple form. With a small flow, a CRM and a daily Telegram summary are enough: inquiries, unhandled leads, appointments, and payments. A separate portal with charts makes sense once data comes from several systems or several people need to view it.
Can you build a dashboard in Google Sheets?
That's a fine option to start with, especially when data sits in just one or two systems. The downsides show up later: some numbers have to be entered by hand, formulas break, and there's no access separation. Once more than two people are maintaining the spreadsheet, it's time to move to BI or a custom portal.
How is an owner's dashboard different from an agency report?
A channel report shows what happened inside ads or search. An owner's dashboard covers the whole path: inquiry, response speed, sale, money. That's why it reveals the case where leads are coming in but sales aren't — and the problem isn't traffic.
How much does it cost to build a dashboard, and how long does it take?
We quote websites, CRM, platforms, and dashboards per task before work starts — there's no fixed price list here. The timeline depends on how many systems need to be connected and what state the data is in. There's no free trial or work-before-payment option.
Which data should you connect first?
Start with the CRM and conversations: that's where inquiries, unhandled leads, and time to first response come from. Add payments as the second step, ad spend as the third. That order shows you fastest exactly where the money is being lost.