
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.

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.

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.

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.

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
