top of page
Search

Prospecting Tracker for Singapore Property Agents (2026)

Writer: Donny Lee
Donny Lee
2 days ago
11 min read

Property agent updating a prospect tracker

A prospecting tracker is a single record of every person you contact, what they need, what you did last and what you will do next. For a Singapore agent it can be as simple as one spreadsheet with about a dozen columns, reviewed for ten minutes every morning. If you are starting a property agent career, this habit will carry your pipeline more reliably than any app.

 

I am Donny Lee, a team leader at ERA Singapore. Donny Lee Advisory is a team in ERA’s Preeminent Group, and we work with Singapore Citizens and Permanent Residents. Below is the tracker I would hand a new agent, the weekly targets worth measuring, and the Singapore rules that shape how you record and contact prospects.



TL;DR

 

  • Track one row per prospect, with source, need, timeline, stage, last contact and a dated next action. Anything that does not help you decide the next move is clutter.

  • Count activity you control (conversations, appointments set, follow-ups done), not results you do not control.

  • Block a fixed prospecting hour on the same days every week, and review the tracker each morning for ten minutes.

  • Record consent and contact channel for every prospect, because the PDPA and the Do Not Call rules apply to your outreach.

  • A tracker works best with a mentor reviewing it with you each week.

 

Table of Contents

 

 

What is a prospecting tracker, and who needs one?

 

A prospect is someone who could plausibly become your client: a seller thinking of selling, a buyer starting to look, an owner with a tenancy ending, a friend who has said “maybe next year”. A tracker is where those people live, so that nobody depends on your memory.

 

Everyone in a property agent career benefits, but the need differs by stage:

 

  • Career switchers and fresh graduates have no pipeline yet. The tracker shows you what you did this week, which matters when results take weeks to arrive.

  • Part-time agents have limited hours. A tracker tells you exactly who to call in the one hour you have.

  • Newly licensed agents in their first two years build the habit that separates steady agents from those who work in bursts.

  • Experienced agents and team leaders use trackers to compare activity across a team and see where leads stall.

 

The same logic sits behind our guide to sales pipeline tracking. The pipeline tells you where deals stand. The prospecting tracker sits upstream of it and records the people before they become deals.

 

What should a prospecting tracker record for each lead?

 

Keep it lean. Fewer columns that you fill in every time beat thirty columns you abandon in week two. These twelve cover what a Singapore agent needs:

 

Field

Why it earns its place

Name

Identifies the person

Mobile and preferred channel (WhatsApp, call, email)

Lets you reach them the way they accept

Lead source

Referral, open house, roadshow, social media, walk-in, past client, enquiry from a portal

Client type

Buyer, seller, landlord, tenant

Property need

HDB, condo, landed, commercial; area or project; size

Timeline

Now, three months, six months or more

Budget or expected price range

Lets you send relevant options only

Stage

One of a small set (see below)

Last contact date and what was said

Makes your next message specific

Next action

A verb: call, send comparables, book viewing

Next action date

The column you sort by every morning

Consent and opt-out note

Protects you and respects the prospect

Two habits matter more than the columns. First, every active lead must always have a next action and a date. A lead with no date is a lead you have forgotten. Second, keep stage and follow-up status separate. A lead in the “viewing scheduled” stage might be waiting for the banker, for the owner, or for a slot. The stage tells you where they are; the next action tells you what to do.

 

How many stages should the pipeline have?

 

Six is enough: New, Contacted, Engaged, Appointment or viewing set, In negotiation, and Closed or Dormant. If you need a long list of stages, you are tracking things that belong in your notes. Add one rule: a Dormant lead is not deleted. It goes on a monthly check-in, so a prospect who said “not for another year” still hears from you.


Six stages of a property prospecting tracker

How do you set up a prospecting tracker in a spreadsheet?

 

Start with a spreadsheet. You can switch to an app later, and by then you will know exactly what you need from it.

 

  1. Create a Leads sheet with the twelve columns above. Freeze the top row so headers stay visible.

  2. Add dropdowns for lead source, client type, timeline and stage. Dropdowns keep spelling consistent, which makes counting possible later.

  3. Add conditional formatting on the next action date. Overdue dates turn red, today’s turn amber. Your morning starts with the red and amber rows.

  4. Create an Activity sheet with one line per day: conversations held, appointments set, follow-ups completed, new leads added.

  5. Create a simple Summary sheet that counts leads by stage and by source each month. After a quarter you will see which sources produce real conversations.

  6. Back it up and keep it in an account only you control, because it holds personal data.

 

The common mistake is building a beautiful dashboard before there is data. Build the Leads and Activity sheets first, use them for a month, then add the summary. Our agent performance dashboard guide shows how to read these numbers once you have them.

 

When does a spreadsheet stop being enough?

 

You will feel it. Nothing reminds you if you do not open the file. Your WhatsApp history lives in your phone and your notes live in the sheet. If you edit on a phone and a laptop, you may end up with two versions. At that point, move to a CRM or an app that keeps conversations, reminders and consent in one place. If you join our team, we work with ERA’s own tools, Sales+ and GRABPro, and we take new agents through how to use them during onboarding.


When does a spreadsheet stop being enough?

Which activity targets should you track each week?

 

Track activity you control. You cannot control whether a seller signs this month, but you can control how many real conversations you have and how many follow-ups you complete.

 

Four measures are enough for most agents:

 

  • Conversations: two-way exchanges, not dials or unanswered messages. A voicemail is a dial, not a conversation.

  • Appointments set: viewings, listing discussions and consultations booked.

  • Follow-ups completed: how many next actions you did on their due date.

  • New leads added: how many fresh names entered the tracker.

 

Set your own starting numbers from the hours you actually have. A part-time agent with one evening a week should set smaller figures than a full-time agent, and both should keep them steady. Review monthly: if conversations are on target but appointments are low, work on how you ask for the meeting. If conversations are low, the issue is volume or the quality of your lead sources. Your mentor or team leader can look at the same numbers with you, which is faster than guessing alone.

 

I deliberately give no income targets here. Income depends on market conditions, your area and the number of clients you serve, and it is a result of activity rather than something you can schedule.

 

How do you plan a prospecting schedule that fits your week?

 

Most new agents prospect in bursts: hard when the pipeline is empty, then not at all when they are busy with a deal. Because a conversation can take weeks to become an appointment, bursts produce a busy month followed by a quiet one. A fixed rhythm smooths that out.

 

Time

Full-time agent

Part-time agent

Daily, 10 minutes (morning)

Sort tracker by next action date, list today’s contacts

Same, before leaving for your day job

Prospecting block

One fixed hour on most weekdays, before viewings begin

One or two fixed evening or weekend blocks

After each call or viewing

Update the row straight away

Update the row straight away

Weekly review, 30 minutes

Count the four measures, plan next week’s sources

Count the four measures, trim the list

Monthly review, 45 minutes

Compare sources, move cold leads to Dormant

Same

A few rules make the schedule survive real weeks:

 

  • Same slot, same days. A habit tied to a time survives a busy week; a habit tied to “when I have time” does not.

  • Small enough to keep during a good week. If you are closing a deal, you should still manage your block.

  • Update the row within a minute of each contact. The details you forget by evening are the details that make the next message personal.

  • Check enquiries once more in the evening. Many enquiries arrive after office hours, and a quick reply keeps the conversation alive.

 

If you are in your first three months, spend your blocks on the people who already know you: family, friends, former colleagues and past contacts, then widen into a farming area and open houses. Our 90-day plans by role set out what to focus on month by month, and our guide to real estate leads in Singapore covers where those leads come from.

 

How do you track prospecting while you are out in the field?

 

Field days break trackers. You are at a viewing, a roadshow or a client’s home, and the spreadsheet is on your laptop. Three practices help:

 

  • Use a mobile-friendly sheet or app so you can update a row from your phone in under a minute.

  • Use a short code for quick notes, such as “CB” for call back or “VS” for viewing set, and tidy it up at your evening check.

  • Label WhatsApp chats by stage if you use WhatsApp for client conversations, and copy the key facts into the tracker at the end of the day. A chat is not a record; your tracker is.

 

The discipline is to close the loop: before you drive to the next appointment, the row you just handled has a new next action and date.

 

What Singapore rules apply when you record and contact prospects?

 

A tracker holds personal data, and contacting prospects is regulated. Two layers apply.

 

CEA conduct rules. The Council for Estate Agencies (CEA) publishes a Professional Service Manual, and estate agents and salespersons must be fully conversant with CEA’s practice guidelines and comply with them. Your records should support the way you conduct estate agency work, so keep notes factual and professional, and never record anything you would be uncomfortable showing a client or regulator.

 

PDPA and the Do Not Call rules. Personal data protection and the Do Not Call Registry affect how you collect numbers and send messages. Practical habits that keep you on the right side:

 

  • Note where each contact came from and whether they agreed to be contacted.

  • Respect opt-outs immediately and mark the row so nobody contacts them again.

  • Do not send mass messages to people with no relationship with you.

  • Keep the tracker in your own secure file, and share only what your team’s rules allow.

 

We cover the detail in PDPA and cold calling for property agents in Singapore. If you work in a team, agree who owns each lead so two people do not contact the same prospect; our lead distribution rules explain the one-owner principle.

 

How do you review your tracker and know it is working?

 

The tracker is working when three things are true. Your next-action column has no red rows older than a day or two. Your Activity sheet shows steady numbers across weeks rather than spikes. And your monthly summary tells you which lead sources produce conversations.

 

Use the monthly review to ask four questions:

 

  1. Which source gave me the most real conversations, not just the most names?

  2. Where do leads stop moving: between Contacted and Engaged, or between Engaged and appointment?

  3. Which Dormant leads are due a check-in?

  4. What one change will I make next month?

 

Change one thing at a time, or you will not know what worked. Bring the numbers to your mentor so the conversation is about evidence rather than impressions.

 

What is our view on prospecting trackers?

 

We have seen that a tracker does not make an agent disciplined; it shows the discipline you already have, or the gap you need to close. That is why we pair new agents with structured mentorship and hands-on onboarding rather than leaving them with a template.   In the Preeminent Group, the tracker is a shared language. When a new agent and a team leader open the same numbers, the conversation moves from “how do you feel about this week?” to “which follow-ups were missed, and why?” That is faster to coach and fairer to the agent.   My advice is to start small, keep twelve columns, and protect your fixed hour. The agents who build that routine early find that the rest of the career, from the RES course to the first client, rests on something steady.   Donny Lee

 

How can ERA’s Preeminent Group help you build this habit?

 

If you are still deciding whether to become an agent, the RES course and registration route explains how to get licensed, and our RES course page sets out fees, with discounts through NTUC UTAP and SkillsFuture Credit. For the full path, see our guide on how to become a property agent in Singapore.

 

If you are already licensed, we run digital training via Zoom webinar, so you can learn prospecting routines around your schedule. Experienced agents considering a move can see how switching to ERA works.

 

[


Donny Lee Advisory

 

Our offer is structured mentorship, hands-on onboarding, ERA’s Sales+ and GRABPro apps, and a team culture built around steady activity. We work with Singapore Citizens and Permanent Residents.

 

FAQ

 

What is the simplest prospecting tracker to start with?

 

A spreadsheet with one row per prospect and about twelve columns: name, contact channel, source, client type, need, timeline, budget, stage, last contact, next action, next action date and consent note. Sort by next action date every morning. You can move to an app later when you outgrow it.

 

How often should I update my tracker?

 

Update each row right after a call, message or viewing, and do a short review every morning. Add a 30-minute weekly count of conversations, appointments and follow-ups, and a monthly review of lead sources. Frequent small updates take less time than catching up at the weekend.

 

Can a part-time agent keep a tracker without much time?

 

Yes. A part-time agent needs the tracker more, because the hours are limited. Keep the same columns, block one or two fixed sessions a week, and set smaller activity targets that you can sustain. Our guide to part-time property agents covers how to structure your week.

 

Do the PDPA and Do Not Call rules apply to my tracker?

 

They apply to how you collect, store and use personal data and how you contact people. Record the source and consent for each contact, honour opt-outs straight away and avoid mass messaging to people with no relationship with you. Our PDPA and cold calling guide goes through the practical steps.

 

Should I track income in my prospecting tracker?

 

No. A prospecting tracker is for activity and lead progress: conversations, appointments, follow-ups and stages. Keep any financial records separate, so the tracker stays quick to fill in and focused on the next action.

 

Speak with Donny about joining ERA

 

If you would like to talk through a property agent career, the RES route or moving your practice into the Preeminent Group, use the form on our Join ERA Singapore page and I will be glad to speak with you. You can also revisit the new agents page for the licensing steps first.

 

Sources

 

Recommended

 

 

This article provides general information for people exploring a real estate career in Singapore and is not legal, tax or financial advice. Rules, fees and requirements may change; always check the latest guidance from CEA, IRAS and other official sources. For personal career advice, speak with Donny Lee at ERA Singapore.

 
 
 

Comments


Contact Me For A Private One To One Discussion Now!

Message received. We will get in touch with you soon

Copyright © 2026 ERA Realty Network Pte Ltd . CEA Estate Agency Licence: L3002382K

Address: ERA APAC Centre 450 Lor 6 Toa Payoh, Singapore 319394

Preeminent Group . All Rights Reserved .

bottom of page