R

Case 19 · Development · 🇦🇪 Dubai · 🇦🇪 Dubai, UAE · 8 weeks

A real estate developer in Dubai: all marketing in one report

Real estate developer · 🇦🇪 Dubai, UAE

For a real estate developer in 🇦🇪 Dubai we built end-to-end analytics on BigQuery: spend, leads and deals from every channel in one report. Leads with no identified source fell from about 50% to 10%.


Stack

  • CRM
  • BigQuery
  • GA4
  • Looker Studio

Before → After

Before

Data in different systems

Leads sat in the CRM, spend in several ad accounts and the accounting system, and sources were identified imprecisely. There was no single report on the path from spend to a deal.

After

10% of leads with no identified source, down from about 50%

All marketing is in one report: spend by source, leads linked to each source, qualification, meetings and deals by the developer's projects.


The numbers in detail

What moved — Real estate developer


50% to 10%

Leads with no identified source

Mostly leads entered manually.

~1 month

To the first dashboard

The first monthly PDF report followed a month later.

2 views

Main and financial

The path to deals and the full marketing budget by project.


Section 01

The short version

  • A real estate developer in 🇦🇪 Dubai ran its marketing through several channels, while the data sat in the CRM, several ad accounts, GA4 and the accounting system.
  • We built end-to-end analytics on BigQuery with two views: the path from spend to a deal and the financial economics by project.
  • The result: all marketing in one place for the first time, and the share of leads with no identified source fell from about 50% to 10%.

Section 02

Why does this case matter?

The client had 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? No single report answered both: ad spend lived in some accounts, the rest of the marketing spend in the accounting system and leads in the CRM.


Section 03

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. There was no single report on the path from spend to a deal.


Section 04

What did we build?

At the core is a BigQuery warehouse. Contacts, leads and deals from the CRM, ad spend from the ad accounts and sessions from GA4 are synced into it. A website session is linked to the lead in the CRM. Two views sit on top.

  • The main view. The path from spend to sessions, leads, qualification, meetings and deals.
  • The financial view. Ad spend plus the full marketing budget, including events, PR, contractors and agency fees, split by the developer's projects.

The results live on a Looker Studio dashboard, and a PDF report goes out by email every month. The dashboard launched about a month after the start, and the first PDF report followed a month later.


Section 05

What is custom about it?

  • Several currencies in one report. Spend is converted to the 🇦🇪 UAE dirham.
  • Restored sources. Deals created without tracking tags got their sources back from indirect data, so nobody had to standardize UTM tags.
  • Real estate specifics. The deal cycle is long, and offline channels and events are part of the economics.
  • Speech analytics as a second stage. Calls are transcribed and scored against the script, and clients are qualified by need, urgency and budget. Brokers and end buyers are scored on different scales.

Section 06

What changed?

  • All marketing is in one place: 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%, mostly leads entered manually.
  • The monthly report is used to prepare reports for stakeholders, including financial reporting.
  • The traffic team uses it for reporting and ad optimization.

The client's reaction to the system has been very positive.


Section 07

What can you take from this?

  • Bring the full marketing budget into one view, not only ad spend.
  • If deals were created without tags, try to restore the source from indirect data.
  • In a long deal cycle, measure the path to meetings and deals, not just to leads.
  • Convert spend in different currencies to one.

Read the full write-up in the blog article.


Strategy session · 30 minutes

Want analytics like this? A free 30-minute strategy session.

We review your funnel, data sources and reports and show how to build the path from ad spend to a deal around your logic.