Real estate marketing dashboard: reconcile the numbers before you explain them – guide by Suraj Karmakar

A real estate marketing dashboard is only useful if people trust the numbers on it. Most dashboards pull from Google Ads, Meta, GA4 and the CRM, and each shows a different lead count. Leaders see three numbers for the same thing and stop believing any of them. Reconcile the sources first, agree which number is the official one for each metric, then build a short dashboard around the decisions you actually make.

Why dashboards lose trust

Typical issues:

  • Meta shows 420 leads, the CRM shows 360, GA4 shows 310.
  • Cost per lead uses platform leads; cost per qualified lead uses CRM leads.
  • Time zones differ, so daily numbers never match.
  • Duplicates are counted in one place and merged in another.
  • Nobody explains the differences.

When a director asks "how many leads did we get?" and three people give three answers, the dashboard has failed.

Real estate marketing dashboard checklist: why dashboards lose trust
Why dashboards lose trust

Reconcile before you build

Step 1: Compare sources for the same period

Take one week. List leads from each platform, GA4 and the CRM, using the same time zone.

Step 2: Explain the gaps

Common causes:

  • Attribution windows: platforms may count leads from earlier ad views.
  • Duplicates: the CRM merges, platforms do not.
  • Consent and blockers: GA4 misses some visitors.
  • Integration errors: some leads never reach the CRM.
  • Spam: removed in the CRM, counted in platforms.

Step 3: Fix what is broken

Integration errors and missing UTMs should be fixed. Other gaps are normal and should be documented.

Step 4: Choose the official source per metric

  • Spend: ad platforms.
  • Leads: CRM, unique and valid.
  • Qualified leads, visits, sales: CRM.
  • On-site behaviour: GA4.

Write this on the dashboard, in a small definitions box that everyone can see. When someone asks why Meta shows more leads than the dashboard, the answer is already there.

Design around decisions

Ask: what decisions will this dashboard support?

  • Where to move budget.
  • Which campaigns to fix or pause.
  • Whether sales follow-up is on track.
  • Whether we are on target for visits and reservations.

Show only the metrics that help those decisions.

A simple dashboard layout

Top row: headline numbers

Spend, leads, qualified leads, cost per qualified lead, visits, reservations, each with change versus last period.

Funnel by channel

Leads, contact rate, qualification rate, visits and cost per qualified lead for each channel.

Campaign table

Same metrics by campaign, sortable.

Follow-up health

Median time to first contact, share of leads contacted within target, leads with no next action.

Notes

Known data issues and recent changes.

Real estate marketing dashboard step-by-step framework: a simple dashboard layout
A simple dashboard layout

Use one time zone and one date logic

Choose Dubai time. Decide whether leads are counted by created date or by ad click date. Use the same logic everywhere.

Keep it current and owned

Name an owner for the dashboard. Check data freshness daily or weekly. When a source breaks, show a warning rather than wrong numbers.

Tools

Looker Studio, Power BI, CRM reporting or a well-built spreadsheet can all work. The tool matters less than clean data and clear definitions. Connectors like Windsor.ai or native integrations can pull platform data automatically. More on tracking basics in real estate lead source tracking.

Real estate marketing dashboard key takeaway: tools
Tools

Explain changes in plain words

A dashboard shows what happened; people still need to know why. Add a short commentary each week: two or three sentences on the main changes and what is being done. Numbers without explanation lead to guesswork.

Different views for different people

Leadership needs the headline numbers and trend. Marketing needs campaign and creative detail. Sales managers need follow-up health by adviser. Rather than one crowded dashboard, create a few focused views from the same data. Everyone sees consistent numbers, but only the detail relevant to their decisions.

Show trends, not just totals

A single week's numbers can mislead. Show each key metric as a short trend line over the last eight to twelve weeks. Trends make it obvious whether a change is a one-off or a real shift, and they help leaders avoid overreacting to a single bad week. Add markers for major events, such as a launch or a tracking fix, so the trend can be read in context.

Set alerts for broken data

Dashboards fail silently when a data source stops updating. Set simple alerts: if leads from a campaign drop to zero for a day, or if spend appears without leads, notify the owner. Catching a broken integration on day one protects both the leads and the credibility of the dashboard.

Common dashboard mistakes

  • Showing every available metric.
  • Mixing platform and CRM leads without labels.
  • No reconciliation.
  • No owner.
  • No commentary.
Real estate marketing dashboard checklist: common dashboard mistakes
Common dashboard mistakes

An illustrative example

Not a client result: a developer's dashboard shows different lead counts from each source. After a reconciliation exercise, the team discovers a form integration that drops leads from one landing page. Fixing it closes most of the gap, and the dashboard adopts CRM leads as the official count, with platform numbers shown separately for optimisation.

Frequently asked questions

Why do Meta leads and CRM leads never match exactly?

Different attribution, duplicate handling, spam filtering and time zones. Small gaps are normal; large or growing gaps need investigation.

Which number should I report to leadership?

Use CRM numbers for leads and outcomes, and platform numbers for spend, with definitions shown on the dashboard.

Next step

Reconcile first, then explain. See my approach to real estate tracking and attribution in Dubai, read about real estate developer marketing reports, or ask me to build your dashboard.

Explore the wider framework: CRM and tracking for Dubai real estate.

What does this look like in your team?

If your team is working through a similar challenge, get in touch to discuss where a focused review could help.

Discuss your real estate campaign