A real estate developer in 🇦🇪 Dubai ran its marketing through about ten channels at once. Advertising on several social networks and search engines, display placements, events and PR, contractors and agencies. Leads landed in the CRM, while spend lived in different ad accounts and in the accounting system. There was no function that could pull it all into one picture.
Management asked two questions. Where do all the leads come from, and how do they move through the funnel by source? And what financial return does each investment deliver? We built end-to-end analytics for the developer on BigQuery. Below we explain how it works and what it changed.
In this article
Section 01
Where did the project start?
The CRM had basic analytics on a preset list of sources. It identified them imprecisely, and the ad campaigns behind website leads often went unidentified altogether.
The data was scattered.
- Leads and deals lived in the CRM.
- Ad spend sat in several ad accounts across different platforms.
- Website sessions were in GA4.
- The rest of the marketing spend, from events to contractors, was tracked in the accounting system.
No single report showed the path from spend to a deal.
Section 02
What did we build?
At the core is a data warehouse on BigQuery. Contacts, leads and deals from the CRM, ad spend from the ad accounts and sessions from GA4 are synced into it.
Two views are built on this data.
The main view. The path from spend to sessions, leads, qualification, meetings and deals. It shows which sources deliver not just leads but qualified clients and deals.
The financial view. Ad spend plus the full marketing budget: events, PR, contractors and agency fees. Everything is broken down by the developer's projects, so the economics of each one are visible.
A website session is linked to the lead in the CRM. The results are viewed on a dashboard, and a PDF report goes out by email once a month. The dashboard went live about a month after the start, and the first PDF report followed a month later.
Section 03
What is custom about it?
Several currencies in one report. Spend is incurred in different currencies, and the report converts everything to a single one, the 🇦🇪 UAE dirham.
Restored sources for older deals. Some deals had been created without tracking tags. We restored their sources from indirect data, so the attribution works without anyone having to standardize UTM tags for our analytics.
Real estate specifics. The deal cycle is long, and offline channels and events are part of the economics alongside online advertising.
A second stage with speech analytics. The first part of it is done and the dashboard is built. The system transcribes calls, scores them against the script and qualifies a client by need, urgency and budget. Calls from brokers and from end buyers are scored on different scales, target calls are separated from non-target ones and missed calls are monitored.
Section 04
What changed for the client?
- All marketing is in one place for the first time: spend by source, leads linked to each source, cost per lead, qualified and lost leads, and sales.
- The share of leads with an unidentified source fell from about 50% to 10%. Most of those are leads entered manually.
- The monthly report is used to prepare reports for stakeholders, including financial reporting.
- The traffic team uses the end-to-end analytics report for reporting and ad optimization.
The client's reaction to the system has been very positive.
Section 05
What can you take from this?
- Bring the full marketing budget into one view, including events and contractors, not just ad spend. Otherwise the economics of a channel look better than they are.
- If deals were created without tags, the source can often be restored from indirect data. You do not need to redo all of your tagging.
- In a long deal cycle, measure the path to meetings and deals, not just to leads.
- Convert spend in different currencies to one. Then the report can go to management without manual recalculation.
Section 06
Want the same analytics for your business?
We will show how to bring all of a developer's marketing into one report. Contact us and we will review your funnel.
Section 07
FAQ
How long does it take to build analytics like this?
We built the dashboard in about a month, and the first monthly PDF report went out a month after that. Speech analytics was added as the next stage.
Can the sources of older deals without tags be restored?
Often, yes. We restore them from indirect data, so you do not need to redo your tagging.
What does the financial view include?
Ad spend and the rest of the marketing budget, for example events, PR, contractors and agency fees, all broken down by project.
Does this work with any CRM?
Yes. The logic is not tied to a specific system. Only the data sources and the funnel specifics change.
For your team
Stop hiring agencies and freelancers
Hire not agencies and freelancers — but Marketing AI Agents for the AI Search.
- Per-engine citation map across 6 AI engines
- Content + schema work that earns the citation
- Honest 30-min strategy call before you commit
Cited across
- ChatGPT
- Gemini
- Google AIO
- Google AI Mode
- Perplexity
- Copilot