How to build a real estate pipeline dashboard in Salesforce: for home-buying and wholesaling teams
In a lot of home-buying companies, the Monday meeting starts with the same questions. What's under contract? What's stuck? What closes this month? Then someone goes to find out. A Salesforce dashboard can answer those questions every time you open it, as long as it's built around the questions rather than around whatever reports already exist. This guide is for owners and ops leads at investor and wholesaling teams: what to put on the dashboard, how to build each part, and how to keep the numbers right.
Build one dashboard per audience, each answering a few questions. For the owner: leads and appointments by source this month, open deals by stage with days in stage, deals under contract by closing date, and booked revenue against the forecast. For acquisitions: today's follow-ups, offers waiting and leads with no next step. For the transaction coordinator: every file under contract by stage, and anything missing a date. Color the aging deals, and remember that a dashboard shows data as of its last refresh, so schedule a refresh before the meeting that uses it.
What should a pipeline dashboard answer?
Start with the questions, not the charts. For an investor team, the owner's questions are usually these:
- Where are this month's leads, and how many became appointments?
- Which deals are stuck, and for how long?
- What's under contract, and when does each one close?
- What did we book this month, and how close was the forecast?
- Who on the team needs help?
Every component on the dashboard should answer one of them. If a chart doesn't, take it off. A dashboard with 20 charts gets opened less often than one with six.
The components, and how to build each one
| Component | Answers | Build it from | Show it as |
|---|---|---|---|
| Lead funnel, this month | Where the leads are | Leads created this month, grouped by status, split by source | Funnel or bar chart |
| Appointments and contracts by source | Which marketing produces deals | Deals created this month, grouped by lead source, with campaign spend for cost per contract | Bar chart, with a table under it |
| Open deals by stage, with days in stage | What's stuck | Open deals grouped by stage, with days in the current stage | Stacked bar by aging band, or a colored table |
| Under contract, by closing date | What closes when | Deals under contract, grouped by expected closing week | Table |
| Booked revenue against forecast | Are we on track? | Deals by month: expected fee or profit at contract next to the actual figure at closing | Column chart |
| Offers waiting | What could become a contract | Offers sent with no answer, older than a few days | Table, oldest first |
| Activity by rep | Who needs help | Calls, conversations, appointments and offers by rep, this week | Table |
| Leads with no next step | What's quietly dying | Open leads without a future task (a cross filter) | One number, with a target of zero |
Each component is a report underneath. The exact report type, filter and grouping for most of these are in my 20 Salesforce report recipes for wholesalers, and the fields they rely on are in the CRM field kit.
How do you show days in stage?
Days in stage is the number that turns a pipeline chart into something you can act on. Two ways to get it:
- If your deals are Opportunities, Salesforce has a standard Stage Duration field that tracks how long each one has been in its current stage. Add it to the report and filter or color by it.
- If your deals live on a custom object, which is common in investor orgs that track properties and contracts their own way, stamp the date each stage started with a record-triggered Flow, and add a formula for the days since then.
Then color it. A simple rule to start with: green under 7 days, amber from 7 to 14, red over 14. Tune it per stage with your team, because a deal waiting on title moves at a different pace from a seller waiting on a second appointment. At Pezon Properties, a property tracker with days since the last update, where anything over 14 days flags in red, is the component leadership uses instead of asking "what's the status of..." every week.
The transaction pipeline: from contract to closing
Once a deal is under contract, the question changes from "what's stuck?" to "what's about to slip?". The transaction side needs its own view:
- Every file under contract by stage, such as inspection, title, clear to close and scheduled.
- Files missing a key date or detail: inspection deadline, closing date, title company.
- Closings in the next two weeks, soonest first.
- Hours from contract to the first call to the seller, by coordinator. It's one of my Monday 5 numbers, because deals where nobody calls the seller for days are where cancellations start.
- Cancellations this month, with the reason for each.
In the org I run, transaction coordination works from its own board and scorecard. How that side is set up is in transaction coordination in Salesforce.
Why one dashboard per role works better
An owner's weekly questions and a rep's daily ones are different, and putting them on one screen makes it worse for both.
| Dashboard | Who opens it, and when | What's on it |
|---|---|---|
| Owner | Owner and partners, weekly | The Monday 5, deals by stage with aging, under contract by closing date, booked against forecast |
| Acquisitions | Acquisitions manager and reps, daily | Today's follow-ups and appointments, offers waiting, leads with no next step, activity by rep |
| Transactions | Transaction coordinator, daily | Files by stage, missing dates, closings in the next two weeks, contract to first seller call |
| Dispositions | Dispositions manager, weekly | Deals ready to market, days to assign, projected against actual fee |
| Marketing | Whoever runs marketing, weekly | Leads, appointments and contracts by campaign, cost per appointment and per contract |
If you want each rep to see their own numbers on one shared dashboard, Salesforce has dynamic dashboards, but they're limited by edition: five on Enterprise, ten on Unlimited and Performance. A dashboard filter on owner often does the job just as well. Who owns which numbers is covered in wholesaling team roles.
Is a Salesforce dashboard live?
Not quite. A dashboard shows data as of its last refresh, and it says when that was. Anyone viewing it can click Refresh. Users with the Schedule Dashboards permission can schedule refreshes daily, weekly or monthly, and Salesforce emails the people you pick when the refresh is done. Schedule the owner's dashboard to refresh early on Monday, before the meeting.
Every dashboard also runs as someone. If it runs as a user who can't see every record it's meant to count, it undercounts, and nobody can tell from looking at it. That's one of the ten causes in why Salesforce numbers don't match.
How do you keep the numbers right?
- Every lead arrives on its own. Calls, forms, texts and lists should create records through your phone system, forms and integrations, not when someone remembers to type them in. See getting every lead source into Salesforce.
- Stages mean the same thing to everyone. Write down what "appointment", "under contract" and "closed" mean, and which date each report counts by.
- Required fields by stage. A deal can't move to under contract without a closing date, or to closed without the final fee.
- Money is checked against the books. Spend by campaign and profit on closed deals should match accounting every month. QuickBooks and Salesforce covers the connection.
Do you need Tableau?
Usually not at first. Salesforce dashboards handle the daily and weekly operating view well. Tableau, which has a native Salesforce connector, makes more sense when leadership wants multi-year trends, market overlays, or data from systems outside Salesforce in one place. Get the Salesforce dashboards right first. Tableau on top of numbers nobody trusts only makes them look better.
Questions
How do I build a pipeline dashboard in Salesforce?
Decide the few questions it should answer, build one report per question, add each report to the dashboard as a component, set it to run as a user who can see every record it counts, and schedule a refresh before the meeting that uses it.
What should a real estate investor's pipeline dashboard include?
Leads and appointments by source this month, open deals by stage with days in stage, deals under contract by closing date, booked revenue against the forecast, offers waiting and open leads with no next step.
Do Salesforce dashboards update in real time?
No. A dashboard shows data as of its last refresh. Viewers can click Refresh, and users with the Schedule Dashboards permission can schedule refreshes daily, weekly or monthly.
How do I track days in stage in Salesforce?
On Opportunities, use the standard Stage Duration field, which tracks how long each one has been in its current stage. On a custom deal object, stamp the date each stage started with a Flow and use a formula for the days since then.
Can each rep see only their own numbers on a Salesforce dashboard?
Yes, with dynamic dashboards, which are limited by edition: five on Enterprise and ten on Unlimited and Performance. A dashboard filter on owner is often a simpler way to do the same thing.
What is a transaction pipeline dashboard?
A view of deals under contract: every file by stage, files missing a key date, closings in the next two weeks, hours from contract to the first call to the seller, and cancellations with their reasons.
Do I need Tableau for real estate reporting?
Usually not at first. Salesforce dashboards cover the daily and weekly view. Tableau makes more sense for multi-year trends or for combining Salesforce with data from other systems.
Related guides
Sources
Checked in October 2026. Salesforce and vendor features change with each release, so check the linked page before you rely on a detail.
- Trailhead: Identify stuck sales deals. The Stage Duration field on Opportunities
- Salesforce: Tips for creating dashboards. Manual refresh, and scheduled refreshes daily, weekly or monthly
- Salesforce: Dynamic dashboards cheat sheet. Dynamic dashboard limits by edition, and the running user
Want a dashboard you'd actually open?
The fixed-price CRM Revenue Audit (USD 1,500) checks the reports you open every week against the data underneath, and defines your Monday 5 field by field for your org. It's for teams already on Salesforce. On another CRM? A move to Salesforce can build the dashboard in from the start.
Book a free callSee the Revenue AuditOr just ask one question about your setup: email · WhatsApp · LinkedIn
