In short
Every Monday, a real estate agency owner should check six numbers: new leads by source, average first-reply time, viewings booked and held, offers and deals, listings added and days on market, and overdue follow-ups. Start with a free spreadsheet. Move to a live dashboard when updating it by hand takes too long or the numbers arrive too late to act on.
In this guide
It's Monday morning. Your team is in the office, coffee in hand. You ask, "How was last week?" Everyone says, "Busy." But busy is not a number, and it doesn't tell you what to fix.
Most agency owners run on gut feeling. That works when you have three agents. It breaks when you have ten agents, four lead channels and a hundred open conversations.
A real estate dashboard fixes this. It is one page that shows the few numbers that matter, every week. This guide covers the six numbers to check each Monday, what each one tells you, and how to start with a free spreadsheet.
Why a Monday Dashboard Works
A weekly check is short enough to catch problems early. It is long enough to smooth out one slow day. And Monday is when your team plans the week, so the numbers turn straight into actions.
You don't need fancy software to start. You need the same six numbers, counted the same way, every week. After a month, you'll see patterns you could never see from memory.
The goal is not a pretty report. The goal is one question answered each Monday: where are we losing buyers and sellers, and who fixes it this week?
Why It Matters for Your Business
Leads are expensive. You pay for portal listings, signs, ads and your team's time. If you can't see which channel brings real deals, you keep paying for the ones that don't.
Past clients matter too. The National Association of Realtors found that its members typically earned 20% of their business from repeat clients and 21% from referrals from past clients and customers. For agents with 16 or more years of experience, referrals made up 28% of business. If referrals are missing from your lead count, you're blind to a large part of your pipeline.
The 6 Numbers to Check Every Monday
Here is what each number tells you, what bad looks like and what to do about it.
1. New leads by source
Count every new enquiry from last week. Split them by where they came from: portal, website, WhatsApp, walk-in and referral. Add a column for "other" so nothing gets lost.
Why it matters: This shows which channels bring people in. It also shows which ones you pay for but get little from.
What bad looks like: One channel suddenly drops, or a paid portal brings many leads but almost no viewings.
What to do: Check if a listing expired, a form broke or a phone number changed. Move budget toward channels that turn into viewings, not just clicks.
2. Average first-reply time
This is how long a new lead waits for the first real reply from a person or assistant. Track it for each channel.
Why it matters: A buyer who enquires about a home may be messaging other agencies at the same time. If you reply last, someone else may book the viewing first. We cover this in detail in our guide on how to reply to property enquiries fast.
What bad looks like: Replies that take hours, or evening and weekend leads that wait until the next working day.
What to do: Set a reply target for your team. Use saved replies for common questions. Consider an assistant that answers after hours and books viewings.
3. Viewings booked and viewings held
Count both. The gap between them matters as much as the totals.
Why it matters: Viewings are where interest turns into offers. A booked viewing that never happens wastes an agent's time and a seller's patience.
What bad looks like: Many no-shows, or leads that never reach a viewing at all.
What to do: Send a reminder the day before and a second one on the day. Confirm the address and a contact number. Call the leads who went quiet after the first reply.
4. Offers and deals
Count offers made, offers accepted and deals closed. Note which lead source each one came from.
Why it matters: This is the number that pays the bills. Linking it back to the source shows which channels really bring sales.
What bad looks like: Plenty of viewings but very few offers. That usually means a pricing problem, a weak listing or poor follow-up after the viewing.
What to do: Ask agents to call every buyer within a day of a viewing. Review listings with many viewings and no offers, and talk to those sellers about price.
5. Listings added and days on market
Count new listings won last week. For your current stock, track days on market, which means how long each property has been for sale.
Why it matters: New listings feed next month's sales. Days on market show which properties are stuck.
What bad looks like: Few new listings for several weeks, or a growing group of properties that have sat unsold for a long time.
What to do: Book valuation calls with past clients and local owners. For stuck listings, refresh the photos, rewrite the description and agree a price review with the seller.
6. Overdue follow-ups
Count every lead or client whose next contact date has passed with no contact.
Why it matters: Most deals need several conversations. A missed follow-up is often a lost buyer or seller, and you never find out.
What bad looks like: The number keeps growing each week, or one agent carries most of it.
What to do: Clear the list at the start of each week. Share the load if one agent is overloaded. Set reminders so a follow-up date is added after every call.
The Monday Dashboard at a Glance
| Metric | Why it matters | Warning sign |
|---|---|---|
| New leads by source | Shows which channels bring people in | A channel drops suddenly or brings no viewings |
| Average first-reply time | Slow replies can lose viewings | Leads wait hours, or overnight and weekends |
| Viewings booked and held | Viewings turn interest into offers | Many no-shows or few leads reach a viewing |
| Offers and deals | This is where the income comes from | Many viewings, very few offers |
| Listings added and days on market | Stock today is sales next month | Few new listings, or old stock piling up |
| Overdue follow-ups | Missed calls mean lost clients | The list grows every week |
For example, imagine a small agency with six agents. On Monday, the owner sees 40 new leads last week, but only 5 came through WhatsApp, down from about 15 the week before. A quick check shows the WhatsApp number on the website was changed by mistake. It takes ten minutes to fix. Without the weekly count, that leak could have lasted a month.
What You Should Do Now
You can start this week with a free spreadsheet, like Google Sheets.
- Create a sheet with one row per week and one column for each of the six numbers. Split the lead column by source.
- Pick one person to fill it in every Friday afternoon, so the numbers are ready on Monday.
- Agree on simple rules for counting. For example, a lead is any new person who enquires, and a viewing is held only if the buyer turns up.
- Add color to warning signs. Google's help page on conditional formatting in Google Sheets shows how to change a cell's color when it meets a rule. For example, turn overdue follow-ups red above a number you choose.
- Review the sheet for 15 minutes at your Monday meeting. End with one owner and one action for each warning sign.
- Compare four weeks at a time, not just last week, so one odd week doesn't fool you.
- 1Set upOne sheet, six columns, one row per week
- 2CollectOne person fills it in every Friday
- 3ColorWarning signs turn red automatically
- 4Review15 minutes on Monday, one owner per problem
Spreadsheet or Live Dashboard?
A spreadsheet is the right place to start. It is free and your team already knows how to use it. But it has limits as you grow.
Spreadsheet
- Someone copies numbers in by hand
- You see last week on Monday
- Easy to miss a lead or count it twice
- One view for everyone
Live dashboard
- Numbers update from your website, WhatsApp and CRM
- You see today, any time
- Every lead is logged once, with its source
- Each agent sees their own follow-ups
A live dashboard pays off when three things happen. Filling in the sheet takes someone more than an hour a week. The numbers arrive too late to act on. Or agents argue about whose count is right. At that point, the time saved and the leads you stop losing usually cover the cost.
How Bykorp Can Help
We build custom dashboards and internal tools for real estate agencies. We connect your website forms, WhatsApp, portals and CRM, so your Monday numbers fill in on their own. You and your team see the same live view.
- A one-page dashboard with your six Monday numbers, split by source and agent
- Alerts for slow replies and overdue follow-ups
- A simple setup your team can use from a phone
See how we work with agencies on our real estate page.
Key Takeaways
- Six numbers each Monday tell you more than a pile of reports.
- Track leads by source, including referrals and past clients.
- Watch first-reply time and overdue follow-ups, because that is where deals leak.
- Start with a free spreadsheet and simple counting rules.
- Move to a live dashboard when manual updates take too long or come too late.
Frequently Asked Questions
What should a real estate dashboard show?
A real estate dashboard should show new leads by source, average first-reply time, viewings booked and held, offers and deals, listings added with days on market, and overdue follow-ups. These six numbers show where leads come from, where they stall and which agent needs help. Anything more can live in a separate report.
How often should a real estate agency review its numbers?
A real estate agency should review its key numbers once a week, ideally at a Monday meeting. Weekly is often enough to catch problems before they cost you a month of leads. Look at the last four weeks together too, so one quiet or busy week does not mislead you.
Can I build a real estate dashboard in Google Sheets?
Google Sheets is a good free place to start a real estate dashboard. Use one row per week and one column per number. Conditional formatting can turn warning signs red automatically. The main limit is that someone must enter the numbers by hand, which gets slow as the agency grows.
Why should I track referrals as a lead source?
Referrals are a big share of many agents' business. The National Association of Realtors found its members typically earned 21% of their business from referrals by past clients and 20% from repeat clients. If you don't count referrals, you can't see how well you keep in touch with past clients.
When is a live dashboard worth paying for?
A live dashboard is worth paying for when updating the spreadsheet takes more than an hour a week, the numbers arrive too late to act on, or your team disagrees about the counts. A live view pulls data from your website, WhatsApp and CRM, so problems show up the same day.
Sources
- National Association of Realtors: Income Steady, Even as Market Slows: 2025 Member Trends
- Google Docs Editors Help: Use conditional formatting rules in Google Sheets
Want your Monday numbers on one page? Message the Bykorp team and we'll sketch a simple dashboard for your agency, free, within a day.
Written by the Bykorp TeamWe design websites, AI chatbots and custom dashboards for real estate agencies, restaurants and cafés.
Need help with custom dashboards & tools?
Lead, sales and booking dashboards, admin panels and client portals that put your numbers in one live view. Book a free discovery call, no pressure.