What a marketing dashboard should answer, and for whom
A familiar picture: Meta Ads shows one set of numbers, Instagram another, the Telegram channel a third, and managers log enquiries in a chat or a notebook. Each report is right in its own way, but together they do not answer the main question: how much money came from marketing, and how much did we spend to get it? A dashboard puts that answer in one place. It does not replace a detailed report or explain causes. It shows that it is time to investigate, and where to look.
An owner needs revenue and payback. A marketing manager needs channels and budget. A media buyer needs campaigns and ads. The sales team needs the flow and quality of leads. One screen for everyone turns into a warehouse of charts where nobody finds their own numbers. Start with the screen for the person who decides where the budget goes, and add other levels later.
Metrics for the first screen
Ask one question of every number: what will I do if it changes? If there is no answer, it does not belong on the first screen. For most businesses this set is enough:
- Leads and enquiries from Instagram, Telegram, calls and the website
- Sales and revenue that can be traced to marketing
- Number of new customers
- Cost per lead and cost per customer
- Conversion from lead to payment
- Ad spend, planned versus actual
- Return on marketing investment
One set does not fit every business
An online shop cares more about orders, average order value and repeat purchases, including those coming through Uzum or its own site. A clinic looks at bookings and the patients who actually showed up. A developer tracks enquiries, visits to the sales office and deals. A B2B company watches qualified leads and the value of deals in progress.
Pick the metrics closest to money. Reach and likes can live on a second level. And show every figure next to the plan and the previous period: two hundred leads means nothing without something to compare it to.
Where the data comes from and why it does not match
The data sits in many places: Meta Ads and Google Ads accounts, website analytics, the CRM, the till or terminal, payments through Click and Payme, and a budget spreadsheet. Ad platforms know about clicks, the CRM knows about sales, and without a link between them you are looking at two different pictures.
The link comes from simple habits: UTM tags in ad links, separate phone numbers or promo codes for different channels, and a required source field on every customer card. In Uzbekistan many enquiries arrive in Instagram DMs and Telegram, and customers often pay in cash at a meeting. So the manager must record where the person came from while the conversation is still fresh. Treat OLX and marketplaces as separate sources too, or they will vanish into an Other row.
Tools and update rhythm
A small business can start with Google Sheets and exports from the CRM and ad accounts. If you have many channels and want automatic collection, a BI service with connectors makes sense. Still, a spreadsheet updated every week beats a complex system that was never finished.
Agree who looks at the dashboard and when. Operational numbers such as leads and spend can refresh daily. Conversion and channel comparison work weekly, while cost per customer and payback are fine monthly. Always show the last update date on the screen.
Layout, ownership and common mistakes
Put the most important figure top left, make the main numbers large, and use colour only as a signal of deviation from plan. Show trends as lines and channel comparisons as bars or a table. Give the dashboard an owner who checks that data has loaded, fixes errors and explains deviations. Without one, the screen goes stale and people stop trusting it.
The same few things usually break a dashboard:
- dozens of metrics with no priority
- numbers without a plan or previous period
- clicks and reach instead of leads and revenue
- sources that do not agree with each other
- a screen nobody opens
How to tell it is working
Decisions in meetings are made while looking at it, and people notice deviations and ask questions on their own. If it is opened once a quarter, it either shows the wrong things or is too complicated.
If you want a screen built around your business, connecting ads, CRM and payments, markdev can help with end-to-end analytics and reporting. Tell us about your task and we will work out where to begin together.
FAQ
How many metrics should the first screen have?
As many as you need to make decisions, usually between six and ten. For each one ask what you would do if it changed. If there is no answer, remove it.
Can I build a marketing dashboard in Google Sheets?
Yes, it is a sound start for a small business. The data must refresh on a schedule and someone must own the sheet. Add automation when the number of channels grows.
How do I count leads from Instagram DMs and Telegram?
Enter them in the CRM and make the source field mandatory. Use tags in ad links, and where a tag is impossible, ask the customer how they heard about you.
How often should a marketing dashboard be updated?
Spend and leads are handy daily, conversion and channels weekly, cost per customer and payback monthly. Show the update date on the screen itself.
Let’s look at your task for free
Leave your contact — in a 15-minute call we’ll show where leads get lost and what to fix first.