Industry guide
Real estate marketing dashboard: tie every lead source to a closing
A real estate marketing dashboard shows, in one place, what each lead source costs and how many of its leads become appointments, listings and closings. This guide is for brokerages, team leaders and the agencies that market them. It covers the KPIs worth tracking, the systems the data comes from, how to attribute a search that runs for weeks, and how our team builds the report in Data Studio.

Quick answer
What should a real estate marketing dashboard track?
A real estate marketing dashboard should track spend, leads, appointments, signed listings or buyer agreements, and closings for every lead source, including referrals and past clients. The key figures are cost per lead, cost per appointment and cost per closing, plus speed to lead, so you can see which channels produce commission rather than just enquiries.
- Measure each lead source to closing, not to form fill, because closings pay commission.
- Referrals and past clients drive much of real estate business, so track them as sources.
- A long search means monthly reports need cohort views by lead month.
- The CRM is the source of truth for stages; ad platforms only supply cost.
What should a real estate marketing dashboard show?
A real estate marketing dashboard should answer one question first: which sources produce closings, and at what cost. Everything else on the report supports that answer.
Most brokerages already have the parts. Ad platforms report spend and clicks, portals send enquiries, the website collects valuation requests, and the CRM holds every contact and deal stage. What is usually missing is the join between them. Without it, a Meta campaign looks good because it produced 200 leads, while nobody can say whether any of them listed or bought.
We lay the report out in four pages. An overview for the broker or owner with spend, leads, appointments and closings by month. A source page that compares channels on cost per stage. An agent page with speed to lead and conversion by agent. A listings page that shows enquiries and views per property, which agents can share with sellers during a listing review.
- Overview: spend, leads, appointments, agreements and closings, with month-on-month change.
- Sources: cost per lead, per appointment and per closing for each channel and campaign.
- Agents: speed to lead, contact rate and appointment rate by agent and by source.
- Listings: enquiries, viewings booked and days on market for each active listing.
Which real estate marketing KPIs matter most?
The KPIs that matter are the ones that sit closest to commission. Clicks and impressions belong on a channel manager's working view, not on the owner's page.
Cost per closing is the most honest number, but it arrives late, so pair it with leading indicators that move within days. Speed to lead is the most actionable of these: if half of a source's leads wait a day for a first call, the source is not the problem.
| KPI | How it is calculated | Where the data lives | Why it matters |
|---|---|---|---|
| Cost per lead | Spend divided by new leads from that source | Ad platforms plus CRM | Shows channel efficiency at the top of the funnel |
| Speed to lead | Time from lead creation to first logged call or email | CRM activity log | The fastest lever an office controls |
| Appointment rate | Appointments held divided by leads | CRM stages | Separates real prospects from portal browsers |
| Cost per appointment | Spend divided by appointments held | Ad platforms plus CRM | A better early signal than cost per lead |
| Listing or agreement rate | Signed listings or buyer agreements divided by appointments | CRM or transaction system | Shows agent and pitch quality |
| Cost per closing | Spend divided by closed deals from that source | Ad platforms plus transaction records | The figure that decides budget |
| Referral and repeat share | Closings from referrals and past clients divided by all closings | CRM source field | Shows the value of sphere and follow-up marketing |
Why do referrals and long searches break most real estate reports?
Real estate is a referral business with a long buying cycle, and most marketing reports are built for neither. Generic agency templates count a lead in the month it arrives and credit the last click, which undercounts both.
The numbers explain why. In the National Association of Realtors' 2025 Profile of Home Buyers and Sellers, 43% of buyers used an agent they found through a referral and 18% used an agent they had worked with before. Among sellers, 66% found their agent through a referral or had used them in the past. The same report puts the median home search at 10 weeks, and 88% of buyers purchased through an agent or broker.
Two design choices follow. First, referral, past client and sphere of influence must be real values in the CRM source field, captured at intake, or the dashboard will credit whatever ad the person clicked last. Second, the report needs a cohort view: leads grouped by the month they arrived, with their later appointments and closings shown against that month. A campaign that ran in March is judged on what its March leads did by June, not on closings that happened to land in March.
Which data sources feed a real estate dashboard in Data Studio?
A typical brokerage dashboard draws on four to eight sources. Some connect natively to Data Studio, some need a partner connector, and the CRM usually needs an export or a warehouse in between.
Google Ads, GA4, Search Console, YouTube and Google Sheets all have native connectors. Meta, LinkedIn and most CRMs need a partner connector from vendors such as Supermetrics, Windsor.ai or Porter Metrics, or a scheduled export into Sheets or BigQuery. Portal enquiries often arrive by email and land in the CRM, so the CRM record is where we read them, not the portal's own report.
Blends in Data Studio are limited to 5 data sources with equality joins, which a brokerage with ads, GA4, a CRM, call tracking and a transaction system already reaches. When the model grows past that, we move the joins into BigQuery and give Data Studio one clean table per page. That also keeps GA4 out of API quota trouble when the whole office opens the report on Monday morning.
- Paid media: Google Ads, Meta, Microsoft Ads, YouTube.
- Website: GA4 events for valuation requests, viewing bookings and contact forms.
- Portals and listing sites: enquiry counts by listing, usually via the CRM.
- CRM: lead source, owner, stage dates, appointments and deal value.
- Call tracking: calls by number and campaign, if the office uses tracked numbers.
- Transaction or back-office system: closing date, price and commission.
How do you track a real estate lead from click to closing?
You track a lead to closing by carrying one source value from the first touch into the CRM, then reading stage dates from the CRM rather than from the ad platforms. The process below is the order we build it in.
Most of the effort is in step two. Brokerages often have the same source spelled six ways, or a source field that agents overwrite when they update a contact. A mapping table in Sheets or BigQuery, maintained by one person, fixes the spelling. A locked original source field, separate from the latest source, fixes the overwriting.
- 1. Tag every paid link with UTM parameters and pass them into the website form and the CRM.
- 2. Standardize the CRM source field, including referral, past client, sign call, open house and each portal.
- 3. Record stage dates: lead created, first contact, appointment held, agreement signed, closed.
- 4. Join CRM leads to spend by source and month, in a blend if small or in BigQuery if not.
- 5. Build the cohort view by lead month, and the speed to lead view by agent.
- 6. Reconcile closings and commission against the transaction records before launch.
A worked example: cost per closing by source
The example below uses illustrative numbers for a single quarter at a mid-size office, to show how the ranking of channels changes as you move down the funnel. It is not client data.
On cost per lead, the portal and Meta look like the winners. On cost per closing, paid search leads at $1,500 against $3,000 for Meta, because 20% of its leads book an appointment compared with 5% of Meta's. Referrals cost nothing in media but would vanish from a spend-only report, even though they produce the most closings. That last row is the case for putting sphere and past-client marketing on the same page as paid media.
| Source | Spend | Leads | Appointments | Closings | Cost per lead | Cost per closing |
|---|---|---|---|---|---|---|
| Google Ads search | $9,000 | 150 | 30 | 6 | $60 | $1,500 |
| Meta lead ads | $6,000 | 300 | 15 | 2 | $20 | $3,000 |
| Portal subscription | $4,500 | 180 | 18 | 2 | $25 | $2,250 |
| Referral and past client | $0 media | 40 | 28 | 9 | n/a | n/a |
Data Studio, CRM reports or a real estate dashboard app?
Choose based on how many systems you need to join. If all your leads and spend already live in one CRM that reports well, its built-in reports may be enough. If they span ads, GA4, portals, the CRM and a transaction system, a Data Studio dashboard joins them in one place.
Data Studio is free for creators and viewers, so a large office can share the report with every agent without per-seat fees. Data Studio Pro costs $9 per user per project per month for editors in team workspaces, and viewers never need a licence. Running costs come from partner connectors and BigQuery, not the reporting tool. Dashboard apps built for real estate are faster to start but tend to report only on the data inside their own platform.
| Option | Best for | Limitation |
|---|---|---|
| CRM built-in reports | Offices running everything inside one CRM | Rarely shows ad spend or cost per closing |
| Real estate dashboard app | Agent leaderboards and activity tracking | Usually limited to its own data and integrations |
| Data Studio dashboard | Joining ads, GA4, CRM and transactions in one view | Needs data modelling once sources pass 5 or volumes grow |
What mistakes do brokerages make with marketing dashboards?
The common mistakes all come from measuring what is easy to connect instead of what pays. Each one makes a cheap channel look better than it is.
When should you not build one? If the office closes only a handful of deals a month from two sources, a monthly spreadsheet review is cheaper and just as useful. A dashboard pays off when there are several paid channels, several agents and enough volume that a shift in budget changes the result.
- Judging channels on cost per lead alone, which rewards cheap, low-intent leads.
- Leaving referral and past client out of the source list, which hides the biggest channel.
- Letting agents overwrite the original lead source when they update a contact.
- Counting closings in the month they close instead of against the lead's month.
- Building one report for everyone, so the owner sees clicks and agents see spend.
How Greenwolf Tech Labs builds real estate marketing dashboards
We start with a free review of your CRM export, ad accounts and current reports, then quote a fixed price for the build. The quote names every source, page and calculated field, and lists running costs such as partner connectors separately.
Our marketing dashboards in Data Studio combine spend, leads and return across Google Ads, Meta, LinkedIn, GA4 and Search Console, and for real estate we add the CRM stage model, the cohort view and the agent pages described above. Agencies that market brokerages can have the same report delivered under their own brand through our white-label service. Greenwolf Tech Labs has delivered 100+ projects for 200+ clients over 8+ years.
FAQ
Frequently asked questions
What KPIs should a real estate marketing dashboard include?
Include spend, leads, appointments, signed agreements and closings for every source, plus cost per lead, cost per appointment and cost per closing. Add speed to lead by agent and the share of closings from referrals and past clients. Those figures show which channels produce commission.
Can Data Studio connect to a real estate CRM?
Usually not natively. Most real estate CRMs reach Data Studio through a partner connector, a scheduled export to Google Sheets, or a pipeline into BigQuery. The right route depends on the CRM's API and how much history you need.
How do you track referral leads on a marketing dashboard?
Capture referral, past client and sphere of influence as fixed values in the CRM source field when the contact is created, and lock that original source so it is not overwritten. The dashboard then counts referral appointments and closings alongside paid channels, even though they carry no media spend.
Is a real estate marketing dashboard worth it for a small team?
Not always. A team closing a few deals a month from two or three sources can review a simple spreadsheet monthly. A dashboard earns its cost once there are several paid channels and agents, and budget decisions depend on comparing them.
How long does it take to build a real estate dashboard?
It depends mostly on the state of the CRM data. Clean source fields and stage dates make the build straightforward, while inconsistent sources and missing dates need a mapping and cleanup step first. We give a timeline with the fixed quote after reviewing a sample export.
Can a marketing agency white-label a real estate dashboard for its clients?
Yes. One Data Studio template can be copied for each brokerage client with its own data sources, branding and scheduled email delivery. Data Studio has no built-in client management, so the agency or its reporting partner runs that onboarding for each account.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.