InSyncSystem

Owner's dashboard: what business numbers to check every day

Anton TysiachnikAnton Tysiachnik, founder of InSync AgencyUpdated: 7 November 20268 min read

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.

SourceWhat it providesHow it gets into the dashboard
CRMLeads, stages, deals, amounts, ownersBuilt-in reports, exports, or API
Messengers and AI salespersonConversations, time to first response, reasons for lost dealsVia CRM or a messaging integration
Ad accountsSpend, clicks, leads by campaignConnector to Meta Ads Manager and Google Ads
Website and GA4Traffic, form submissions, sources by UTMGA4 export, consistent UTM tags on links
Till, card processing, payment servicePayments, refunds, average order valueExport or API from the payment system
Online booking and calendarAppointments, open slots, cancellations, no-showsIntegration with the booking system
Google Business ProfileCalls, directions requests, map searchesProfile 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.

  1. "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.
  2. "Funnel": inquiries, qualified leads, sales, and stage-to-stage conversions over 7 and 30 days. This is the bottleneck zone.
  3. "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 task

What to check daily vs. weekly?

A daily snapshot is for reacting. Weekly and monthly views are for changing the process and the budgets.

PeriodMetricsWhat decisions they drive
Every dayInquiries, unhandled leads, response time, appointments, paymentsFollow up with silent clients, redistribute workload, fill gaps in the schedule
Every weekStage-to-stage conversions, reasons for lost deals, revenue by source, team workloadRewrite scripts and the offer, adjust shift schedules, reinforce the best-performing channel
Every monthAd spend as a share of revenue, average order value, repeat purchases, channel paybackBudgets, 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.

OptionWhen it fitsLimitations
Google SheetsOne owner, 5–8 numbers, data from one or two systemsManual work, formulas break easily, no role-based access control
Looker Studio or another BI toolYou need charts, multiple sources, and shared team accessDepends on connectors, you have to work around complex business logic
A custom dashboard or portalData from CRM, payments, and bookings together; you need permissions and notificationsRequires 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

  1. List the 5–7 decisions you make most often: who to follow up with, where to add budget, who to schedule for a shift.
  2. For each decision, pick the one number you can't make it without.
  3. Note the source for each number: CRM, ad account, GA4, the till, the booking system.
  4. Mark what's already available automatically and what's currently calculated by hand.
  5. Set a comparison baseline for each number, and the threshold where you step in.
  6. Build a draft in a spreadsheet and fill it in by hand for a week — this shows which lines you actually read.
  7. 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.

Tell us what you sell. We’ll show you where the clients are

Send your niche and task on Telegram: we’ll reply personally with a plan and a quote.

Read next